public IActionResult Index()
{
var Sittings = _services.GetListSitting();
ReportViewModel model = new ReportViewModel()
{
//for Sittings
AllSittings = Sittings,
SittingID = Sittings[0].SittingID
};
try
{
List <Sitting> s = _services.GetListSitting();
List <Reservation> Rs = _services.GetAllReservation();
int cs = 0;
foreach (Reservation r in Rs)
{
Table_Reservation td = _services.GetTable_ReservationById(r.ReservationID);
if (td != null)
{
Table t = _services.GetTableByID(td.TableID);
//area
if (t.Area == "Main Room")
{
model.MainRoom++;
}
if (t.Area == "Balcony")
{
model.Balcony++;
}
if (t.Area == "Outside")
{
model.OutSide++;
}
}
cs = cs + r.NumberOfGuests;
//source
if (r.Source == "WebSite")
{
model.Website++;
}
if (r.Source == "Mobile")
{
model.Mobile++;
}
if (r.Source == "Walk in")
{
model.InPErson++;
}
//sitting
if (r.SittingID == s[0].SittingID)
{
model.Breakfast++;
}
if (r.SittingID == s[1].SittingID)
{
model.Lunch++;
}
if (r.SittingID == s[2].SittingID)
{
model.Dinner++;
}
}
model.Reservations = Rs.Count();
model.Clients = cs;
return(View(model));
}
catch { return(RedirectToAction("Error", "Home")); }
}
