public ActionResult TimeLaps([Bind(Include = "StartDate,EndDate")] TimeLap timeLap)
{
if (ModelState.IsValid)
{
if (timeLap.StartDate < timeLap.EndDate && timeLap.StartDate < DateTime.Now)
{
ViewBag.Error = false;
return(RedirectToAction("Statistic", timeLap));
}
ViewBag.Error = true;
return(View(timeLap));
}
return(View(timeLap));
}
public ActionResult Statistic(TimeLap timeLap)
{
timeLap.StartDate = timeLap.StartDate.AddDays(-1);
timeLap.EndDate = timeLap.EndDate.AddDays(1);
var test = db.Order.
Where(o => o.OrderTime > timeLap.StartDate).
Where(o => o.OrderTime < timeLap.EndDate).
GroupBy(t => t.Table).
Select(group => new Statistics {
PriceSum = group.Sum(o => o.Price),
TableId = group.Key
}).ToList();
return(View(test));
}
public ActionResult Statistic(TimeLap timeLap)
{
timeLap.StartDate = timeLap.StartDate.AddDays(-1);
timeLap.EndDate = timeLap.EndDate.AddDays(1);
var test = db.Order_Meal.
Where(o => o.IssueTime >= timeLap.StartDate).
Where(o => o.IssueTime <= timeLap.EndDate).
GroupBy(m => m.Meal.Name).
Select(group => new Statistics
{
MealName = group.Key,
MealCount = group.Count(m => m.Id != null)
}).ToList();
return(View(test));
}
