public ActionResult AgeSales(ReportLocal model) { var identity = (System.Web.HttpContext.Current.User as MyIdentity.MyPrincipal).Identity as MyIdentity; List <ReportLocalResult> resultArray = new List <ReportLocalResult>(); foreach (var tmp in db.PR_SalesAge(model.RestaurantId)) { ReportLocalResult resultTmp = new ReportLocalResult { AgeRange = tmp.AgeRange, Gender = (tmp.Gender == "M") ? "Male" : "Female", TotalResult = (decimal)tmp.Total_Sales }; resultArray.Add(resultTmp); } var newModel = new ReportLocal { Restaurants = new SelectList(db.PR_LocalRestaurantInfo(identity.User.IdCard).ToList(), "IdLocal", "Name"), RestaurantId = model.RestaurantId, Result = resultArray }; return(View(newModel)); }
public ActionResult DaySales(ReportLocal model) { var identity = (System.Web.HttpContext.Current.User as MyIdentity.MyPrincipal).Identity as MyIdentity; List <ReportLocalResult> resultArray = new List <ReportLocalResult>(); foreach (var tmp in db.PR_BestSalesDaysReport(model.RestaurantId, DateTime.Parse(model.DateStart), DateTime.Parse(model.DateEnd).AddDays(1), model.Top)) { ReportLocalResult resultTmp = new ReportLocalResult { LocalResult = db.Local.Find(tmp.LocalId), DayResult = (DateTime)tmp.Day, TotalResult = (decimal)tmp.Total }; resultArray.Add(resultTmp); } var newModel = new ReportLocal { Restaurants = new SelectList(db.PR_RestaurantInfo(identity.User.IdCard).ToList(), "IdRestaurant", "Name"), RestaurantId = model.RestaurantId, DateStart = model.DateStart, DateEnd = model.DateEnd, Top = model.Top, Result = resultArray }; return(View(newModel)); }
public ActionResult SalesDish(ReportLocal model) { var identity = (System.Web.HttpContext.Current.User as MyIdentity.MyPrincipal).Identity as MyIdentity; List <ReportLocalResult> resultArray = new List <ReportLocalResult>(); foreach (var tmp in db.PR_DishSalesReport(model.RestaurantId, DateTime.Parse(model.DateStart), DateTime.Parse(model.DateEnd).AddDays(1))) { ReportLocalResult resultTmp = new ReportLocalResult { DishResult = db.Dish.Find(tmp.ID), SalesResult = (int)tmp.Quantity, TotalResult = (decimal)tmp.Total }; resultArray.Add(resultTmp); } var newModel = new ReportLocal { Restaurants = new SelectList(db.PR_LocalRestaurantInfo(identity.User.IdCard).ToList(), "IdLocal", "Name"), RestaurantId = model.RestaurantId, DateStart = model.DateStart, DateEnd = model.DateEnd, Top = model.Top, Result = resultArray, Types = db.PR_DishTypes().ToList() }; return(View(newModel)); }