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));
}
