public ActionResult SalesReport() { var model = new SalesReportVM(); model.SetSalesTeam(repo); return(View(model)); }
public ActionResult SalesReport() { var model = new SalesReportVM(); model.Referrers = SitesManager.GetReferrers(); model.Sites = SitesManager.GetSites(); return(View(model)); }
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)); }
public ActionResult SalesReport(SalesReportVM model) { if (!ModelState.IsValid) { model.Referrers = SitesManager.GetReferrers(); model.Sites = SitesManager.GetSites(); return(View(model)); } List <KeyValuePair <string, List <ReferrerSalesInfoDT> > > data = new List <KeyValuePair <string, List <ReferrerSalesInfoDT> > >(); if (model.ReferrerId != 0) { if (model.SiteId != 0) { ReferrerDT referrer = SitesManager.GetReferrer(model.ReferrerId); List <ReferrerSalesInfoDT> referrerData = SitesManager.GetReferrerSiteSalesInfo(model.StartDate, model.EndDate, (DateGroupBy)Enum.Parse(typeof(DateGroupBy), model.GroupBy), model.ReferrerId, model.SiteId); data.Add(new KeyValuePair <string, List <ReferrerSalesInfoDT> >(referrer.Name + " - " + SitesManager.GetSite(model.SiteId).Name, referrerData)); } else { ReferrerDT referrer = SitesManager.GetReferrer(model.ReferrerId); List <ReferrerSalesInfoDT> referrerData = SitesManager.GetReferrerSiteSalesInfo(model.StartDate, model.EndDate, (DateGroupBy)Enum.Parse(typeof(DateGroupBy), model.GroupBy), model.ReferrerId, model.SiteId); data.Add(new KeyValuePair <string, List <ReferrerSalesInfoDT> >(referrer.Name + " - All Sites", referrerData)); foreach (var site in SitesManager.GetSites()) { referrerData = SitesManager.GetReferrerSiteSalesInfo(model.StartDate, model.EndDate, (DateGroupBy)Enum.Parse(typeof(DateGroupBy), model.GroupBy), model.ReferrerId, site.Id); data.Add(new KeyValuePair <string, List <ReferrerSalesInfoDT> >(referrer.Name + " - " + site.Name, referrerData)); } } } else { if (model.SiteId != 0) { string sitenName = SitesManager.GetSite(model.SiteId).Name; List <ReferrerSalesInfoDT> referrerData = SitesManager.GetReferrerSiteSalesInfo(model.StartDate, model.EndDate, (DateGroupBy)Enum.Parse(typeof(DateGroupBy), model.GroupBy), 0, model.SiteId); data.Add(new KeyValuePair <string, List <ReferrerSalesInfoDT> >("All Websites - " + sitenName, referrerData)); foreach (ReferrerDT referrer in SitesManager.GetReferrers()) { referrerData = SitesManager.GetReferrerSiteSalesInfo(model.StartDate, model.EndDate, (DateGroupBy)Enum.Parse(typeof(DateGroupBy), model.GroupBy), referrer.Id, model.SiteId); data.Add(new KeyValuePair <string, List <ReferrerSalesInfoDT> >(referrer.Name + " - " + sitenName, referrerData)); } } else { List <ReferrerSalesInfoDT> referrerData = SitesManager.GetReferrerSiteSalesInfo(model.StartDate, model.EndDate, (DateGroupBy)Enum.Parse(typeof(DateGroupBy), model.GroupBy), 0, model.SiteId); data.Add(new KeyValuePair <string, List <ReferrerSalesInfoDT> >("All Websites - All Sites", referrerData)); foreach (var site in SitesManager.GetSites()) { foreach (ReferrerDT referrer in SitesManager.GetReferrers()) { referrerData = SitesManager.GetReferrerSiteSalesInfo(model.StartDate, model.EndDate, (DateGroupBy)Enum.Parse(typeof(DateGroupBy), model.GroupBy), referrer.Id, site.Id); data.Add(new KeyValuePair <string, List <ReferrerSalesInfoDT> >(referrer.Name + " - " + site.Name, referrerData)); } } } } ViewBag.Data = data; model.Referrers = SitesManager.GetReferrers(); model.Sites = SitesManager.GetSites(); return(View(model)); }