Example #1
0
        public ActionResult SalesReport()
        {
            var model = new SalesReportVM();

            model.SetSalesTeam(repo);

            return(View(model));
        }
Example #2
0
        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));
        }
Example #5
0
        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));
        }