public IHttpActionResult GetSales(string user, string minDate, string maxDate) { ISaleInfoRepo saleRepo = Factory.GetSaleInfoRepo(); IUserRepo userRepo = Factory.GetUserRepo(); IEnumerable <SaleInfo> sales = saleRepo.GetBySearch(user, minDate, maxDate); SalesReportVM vm = new SalesReportVM(); vm.Users = userRepo.GetAll(); List <SalesReportData> salesReportData = new List <SalesReportData>(); foreach (var item in vm.Users) { SalesReportData data = new SalesReportData(); data.UserName = item.FirstName + " " + item.LastName; data.UserId = item.UserId; decimal userSales = 0; int userVehicles = 0; foreach (var sale in sales) { if (sale.UserId == item.UserId) { userSales += sale.SalePrice; userVehicles++; } } data.TotalSales = userSales; data.TotalVehicles = userVehicles; if (data.TotalVehicles > 0) { salesReportData.Add(data); } } vm.UserSales = salesReportData; IEnumerable <SalesReportData> results = salesReportData; if (salesReportData == null) { return(NotFound()); } return(Ok(results)); }
public ActionResult Sales() { ISaleInfoRepo saleRepo = Factory.GetSaleInfoRepo(); IUserRepo userRepo = Factory.GetUserRepo(); IEnumerable <SaleInfo> sales = saleRepo.GetAll(); SalesReportVM vm = new SalesReportVM(); vm.Users = userRepo.GetAll(); List <SalesReportData> salesReportData = new List <SalesReportData>(); foreach (var user in vm.Users) { SalesReportData data = new SalesReportData(); data.UserName = user.FirstName + " " + user.LastName; data.UserId = user.UserId; decimal userSales = 0; int userVehicles = 0; foreach (var sale in sales) { if (sale.UserId == user.UserId) { userSales += sale.SalePrice; userVehicles++; } } data.TotalSales = userSales; data.TotalVehicles = userVehicles; if (data.TotalVehicles > 0) { salesReportData.Add(data); } } vm.UserSales = salesReportData; return(View(vm)); }