SHOW:
|
|
- or go back to the newest paste.
| 1 | - | static void GetTotalIncome(int startYear, int endYear, string companyName) |
| 1 | + | static void GetTotalIncome(int startYear, int endYear, string companyName) |
| 2 | - | { |
| 2 | + | {
|
| 3 | - | NORTHWNDEntities db = new NORTHWNDEntities(); |
| 3 | + | NORTHWNDEntities db = new NORTHWNDEntities(); |
| 4 | - | |
| 4 | + | |
| 5 | - | using (db) |
| 5 | + | using (db) |
| 6 | - | { |
| 6 | + | {
|
| 7 | - | SqlParameter startYearParam = new SqlParameter("@startYear", startYear); |
| 7 | + | var income = db.usp_FindTotalIncome111(startYear, endYear, companyName); |
| 8 | - | SqlParameter endYearParam = new SqlParameter("@endYear", endYear); |
| 8 | + | Console.WriteLine("Total income is: {0}", income.FirstOrDefault());
|
| 9 | - | SqlParameter name = new SqlParameter("@companyName", companyName); |
| 9 | + | } |
| 10 | - | |
| 10 | + |
