// GET: Reports
public ActionResult Index()
{
if (!Globals.LOGIN_STATUS)
{
return(RedirectToAction("Login", "Home"));
}
else
{
ReportsHomeVM model = new ReportsHomeVM();
GetDAL get = new GetDAL();
get.OpenConnection();
model.LstAllRehearsalParts = get.GetAllRehearsalParts();
model.LstAllEvents = get.GetEventsByUser(Globals.LOGGED_IN_USER.IntUserID);
model.LstAllRehearsals = new List <Rehearsal>();
foreach (Event e in model.LstAllEvents)
{
get.CloseConnection();
get.OpenConnection();
model.LstAllRehearsals.AddRange(get.GetRehearsalsByEvent(e));
}
get.CloseConnection();
foreach (Rehearsal r in model.LstAllRehearsals)
{
r.DateWithEvent = r.Event.StrName + " " + r.DtmStartDateTime;
}
return(View("ReportsHome", model));
}
}