// GET: CheckInOut public ActionResult Index() { if (!Globals.IS_ADMIN) { return(RedirectToAction("Index", "Home")); } else if (!Globals.LOGIN_STATUS) { return(RedirectToAction("Login", "Home")); } else { CheckInOutVM model = new CheckInOutVM(); GetDAL get = new GetDAL(); get.OpenConnection(); model.LstAdminEvents = get.GetAdminEventsByUser(Globals.LOGGED_IN_USER.IntUserID); foreach (Event e in model.LstAdminEvents) { e.LstRehearsalParts = get.GetRehearsalPartsByEvent(e); foreach (RehearsalPart rp in e.LstRehearsalParts) { rp.LstMembers = get.GetUsersByRehearsalPart(rp); } e.MembersForToday = LstAllMembersForRehearsalParts(e, get); } get.CloseConnection(); return(View("Index", model)); } }
// GET: Callboard public ActionResult Index() { if (!Globals.LOGIN_STATUS) { return(RedirectToAction("Login", "Home")); } else { CallboardHomeVM model = new CallboardHomeVM(); model.CurrentUser = Globals.LOGGED_IN_USER; GetDAL get = new GetDAL(); get.OpenConnection(); model.LstAllCallboards = new List <Callboard>(); foreach (Event e in model.CurrentUser.LstEvents) { List <Callboard> callboards = get.GetCallboardsByEvent(e); model.LstAllCallboards.AddRange(callboards); } if (model.LstAllCallboards != null) { model.LstAllCallboards.Sort(); } model.LstAdminEvents = get.GetAdminEventsByUser(model.CurrentUser.IntUserID); get.CloseConnection(); return(View("CallboardHome", model)); } }
// GET: Admin public ActionResult Index() { if (Globals.IS_ADMIN) { AdminHomeVM model = new AdminHomeVM(); GetDAL get = new GetDAL(); get.OpenConnection(); model.LstAllGroups = get.GetAllGroups(); model.LstAllEvents = get.GetAllEvents(); model.LstAdminEvents = get.GetAdminEventsByUser(Globals.LOGGED_IN_USER.IntUserID); foreach (Event e in model.LstAdminEvents) { e.LstRehearsalParts = get.GetRehearsalPartsByEvent(e); foreach (RehearsalPart rp in e.LstRehearsalParts) { rp.LstMembers = get.GetUsersByRehearsalPart(rp); if (rp.DtmStartDateTime.Equals(DateTime.MinValue)) { rp.DtmStartDateTime = null; } if (rp.DtmEndDateTime.Equals(DateTime.MinValue)) { rp.DtmEndDateTime = null; } } } model.LstAllTypes = get.GetAllTypes(); model.LstAllUsersForAdminEvents = get.GetAllUsersForAdminEvents(model.LstAdminEvents); get.CloseConnection(); get.OpenConnection(); foreach (Users u in model.LstAllUsersForAdminEvents) { u.LstConflicts = get.GetConflictsByUser(u).OrderBy(x => x.DtmStartDateTime).ToList(); } get.CloseConnection(); return(View("AdminHome", model)); } else { return(RedirectToAction("Index", "Home")); } }
private static bool LoginUser(Users usr) { GetDAL getDAL = new GetDAL(); getDAL.OpenConnection(); usr.LstEvents = getDAL.GetEventsByUser(usr.IntUserID); usr.LstEventsIsAdmin = getDAL.GetAdminEventsByUser(usr.IntUserID); Globals.LOGIN_STATUS = true; Globals.LOGGED_IN_USER = usr; if (Globals.ADMINS.Contains(usr)) { Globals.IS_ADMIN = true; } getDAL.CloseConnection(); return(true); }
// GET: Tasks public ActionResult Index() { if (!Globals.LOGIN_STATUS) { return(RedirectToAction("Login", "Home")); } else { TasksHomeVM model = new TasksHomeVM(); model.CurrentUser = Globals.LOGGED_IN_USER; var taskEqualityComparer = new TaskEqualityComparer(); GetDAL get = new GetDAL(); get.OpenConnection(); model.TasksUnfinishedNotYetDueForUser = get.GetUnfinishedTasksDueAfter(model.CurrentUser, DateTime.Now); model.FinishedTasks = get.GetFinishedTasks(model.CurrentUser); IEnumerable <Task> difference = get.GetTasksByAssignedToUser(model.CurrentUser).Except(model.TasksUnfinishedNotYetDueForUser, taskEqualityComparer).Except(model.FinishedTasks, taskEqualityComparer); model.TasksOverDueForUser = difference.ToList(); model.TasksAssignedByUser = get.GetTasksByAssignedByUser(model.CurrentUser); model.LstAllEvents = get.GetAllEvents(); model.LstAdminEvents = get.GetAdminEventsByUser(model.CurrentUser.IntUserID); if (model.LstAdminEvents.Any()) { model.LstAllUsersForAdminEvents = get.GetAllUsersForAdminEvents(model.LstAdminEvents); } get.CloseConnection(); return(View("TasksHome", model)); } }
// GET: Schedule public ActionResult Index() { if (!Globals.LOGIN_STATUS) { return(RedirectToAction("Login", "Home")); } else { ScheduleHomeVM model = new ScheduleHomeVM(); GetDAL get = new GetDAL(); get.OpenConnection(); model.LstUpcomingRehearsals = get.GetUpcomingRehearsalsByUser(Globals.LOGGED_IN_USER); foreach (var r in model.LstUpcomingRehearsals) { r.LstRehearsalParts = get.GetRehearsalPartsByRehearsal(r); foreach (RehearsalPart rp in r.LstRehearsalParts) { rp.LstMembers = get.GetUsersByRehearsalPart(rp); } } model.LstUserRehearsalParts = get.GetUpcomingRehearsalPartsByUser(Globals.LOGGED_IN_USER); model.LstUnscheduledRehearsalParts = model.LstUserRehearsalParts.Where(x => x.DtmStartDateTime.Equals(null)).ToList(); //foreach (var e in get.GetEventsByUser(Globals.LOGGED_IN_USER.IntUserID)) //{ // get.CloseConnection(); // get.OpenConnection(); // model.LstUserRehearsalParts = model.LstUserRehearsalParts.Concat(get.GetRehearsalPartsByEvent(e)).ToList(); //} //get.CloseConnection(); //get.OpenConnection(); //model.LstUpcomingRehearsalParts = get.GetUpcomingRehearsalPartsByUser(Globals.LOGGED_IN_USER); //model.LstUnscheduledRehearsalParts = model.LstUserRehearsalParts.Where(x => x.DtmStartDateTime.Equals(null)).ToList(); //model.LstUpcomingRehearsalParts = model.LstUpcomingRehearsalParts.Except(model.LstUnscheduledRehearsalParts.ToList()).ToList(); //model.LstUpcomingRehearsals = get.GetUpcomingRehearsalsByUser(Globals.LOGGED_IN_USER); //foreach (var r in model.LstUpcomingRehearsals) //{ // r.LstRehearsalParts = get.GetRehearsalPartsByRehearsal(r); //} //get.CloseConnection(); //get.OpenConnection(); model.LstAdminEvents = get.GetAdminEventsByUser(Globals.LOGGED_IN_USER.IntUserID); //foreach (RehearsalPart rp in model.LstUserRehearsalParts) //{ // rp.LstMembers = get.GetUsersByRehearsalPart(rp); //} //foreach (RehearsalPart rp in model.LstUpcomingRehearsalParts) //{ // rp.LstMembers = get.GetUsersByRehearsalPart(rp); //} get.CloseConnection(); return(View("ScheduleHome", model)); } }