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