public ActionResult RosterAppIndex(FormCollection form) { User LoggedInUser = Session["LoggedUser"] as User; int _UserID = Convert.ToInt32(Session["LogedUserID"].ToString()); QueryBuilder qb = new QueryBuilder(); string query = qb.GetShiftIDFromUserLocation(LoggedInUser); DataTable dt = qb.GetValuesfromDB("select * from RosterApp where " + query); List <RosterApp> rosterapps = dt.ToList <RosterApp>(); List <RosterApplication> _RosterApplicationsList = new List <RosterApplication>(); List <Crew> Crews = db.Crews.ToList(); List <Section> Sections = db.Sections.ToList(); List <Emp> Emps = db.Emps.ToList(); List <Shift> shifts = db.Shifts.ToList(); List <RosterType> rts = db.RosterTypes.ToList(); foreach (var item in rosterapps) { try { RosterApplication _RosterApplication = new RosterApplication(); _RosterApplication.RotaApplD = item.RotaApplD; _RosterApplication.DateStarted = item.DateStarted; _RosterApplication.DateEnded = item.DateEnded; _RosterApplication.RosterCriteria = item.RosterCriteria; switch (item.RosterCriteria) { case "S": _RosterApplication.CriteriaData = shifts.First(aa => aa.ShiftID == item.CriteriaData).ShiftName; break; case "C": short CrewID = (short)item.CriteriaData; _RosterApplication.CriteriaData = Crews.Where(aa => aa.CrewID == CrewID).FirstOrDefault().CrewName; break; case "T": short SecID = (short)item.CriteriaData; _RosterApplication.CriteriaData = Sections.Where(aa => aa.SectionID == SecID).FirstOrDefault().SectionName; break; case "E": _RosterApplication.CriteriaData = Emps.Where(aa => aa.EmpID == item.CriteriaData).FirstOrDefault().EmpName; break; } _RosterApplication.WorkMin = item.WorkMin; _RosterApplication.DutyTime = item.DutyTime; _RosterApplication.RosterType = rts.First(aa => aa.ID == item.RotaTypeID).Name; _RosterApplication.Shift = shifts.First(aa => aa.ShiftID == item.ShiftID).ShiftName; _RosterApplicationsList.Add(_RosterApplication); } catch (Exception ex) { } } return(View(_RosterApplicationsList)); }
public ActionResult RosterAppIndex(FormCollection form) { User LoggedInUser = Session["LoggedUser"] as User; List <RosterApp> rosterapps = new List <RosterApp>(); int _UserID = Convert.ToInt32(Session["LogedUserID"].ToString()); rosterapps = db.RosterApps.Where(aa => aa.Status == true && aa.UserID == _UserID).ToList(); List <RosterApplication> _RosterApplicationsList = new List <RosterApplication>(); List <Crew> Crews = db.Crews.ToList(); List <Section> Sections = db.Sections.ToList(); List <Emp> Emps = db.Emps.ToList(); List <Shift> shifts = db.Shifts.ToList(); foreach (var item in rosterapps) { try { RosterApplication _RosterApplication = new RosterApplication(); _RosterApplication.Name = item.RosterName; _RosterApplication.RotaApplD = item.RotaAppID; _RosterApplication.DateStarted = item.DateStarted; _RosterApplication.DateEnded = item.DateEnded; _RosterApplication.RosterCriteria = item.RosterCriteria; switch (item.RosterCriteria) { case "S": _RosterApplication.CriteriaData = item.Shift.ShiftName; break; case "C": short CrewID = (short)item.CriteriaData; _RosterApplication.CriteriaData = Crews.Where(aa => aa.CrewID == CrewID).FirstOrDefault().CrewName; break; case "T": short SecID = (short)item.CriteriaData; _RosterApplication.CriteriaData = Sections.Where(aa => aa.SectionID == SecID).FirstOrDefault().SectionName; break; case "E": _RosterApplication.CriteriaData = Emps.Where(aa => aa.EmpID == item.CriteriaData).FirstOrDefault().EmpName; break; } _RosterApplication.WorkMin = item.WorkMin; _RosterApplication.DutyTime = item.DutyTime; _RosterApplication.RosterType = item.RosterType.Name; _RosterApplication.Shift = shifts.First(aa => aa.ShiftID == item.ShiftID).ShiftName; _RosterApplicationsList.Add(_RosterApplication); } catch (Exception ex) { } } return(View(_RosterApplicationsList)); }
public ActionResult RosterAppIndex(FormCollection form) { User LoggedInUser = Session["LoggedUser"] as User; List<RosterApp> rosterapps = new List<RosterApp>(); if (LoggedInUser.RoleID == 1) { rosterapps = db.RosterApps.Where(aa => aa.Status == true).ToList(); } else { int _UserID = Convert.ToInt32(Session["LogedUserID"].ToString()); rosterapps = db.RosterApps.Where(aa => aa.Status == true && aa.UserID == _UserID).ToList(); } List<RosterApplication> _RosterApplicationsList = new List<RosterApplication>(); List<Crew> Crews = db.Crews.ToList(); List<Section> Sections = db.Sections.ToList(); List<Emp> Emps = db.Emps.ToList(); List<Shift> shifts = db.Shifts.ToList(); foreach (var item in rosterapps) { try { RosterApplication _RosterApplication = new RosterApplication(); _RosterApplication.RotaApplD = item.RotaApplD; _RosterApplication.DateStarted = item.DateStarted; _RosterApplication.DateEnded = item.DateEnded; _RosterApplication.RosterCriteria = item.RosterCriteria; switch (item.RosterCriteria) { case "S": _RosterApplication.CriteriaData = item.Shift.ShiftName; break; case "C": short CrewID = (short)item.CriteriaData; _RosterApplication.CriteriaData = Crews.Where(aa => aa.CrewID == CrewID).FirstOrDefault().CrewName; break; case "T": short SecID = (short)item.CriteriaData; _RosterApplication.CriteriaData = Sections.Where(aa => aa.SectionID == SecID).FirstOrDefault().SectionName; break; case "E": _RosterApplication.CriteriaData = Emps.Where(aa => aa.EmpID == item.CriteriaData).FirstOrDefault().EmpName; break; } _RosterApplication.WorkMin = item.WorkMin; _RosterApplication.DutyTime = item.DutyTime; _RosterApplication.RosterType = item.RosterType.Name; _RosterApplication.Shift = shifts.First(aa => aa.ShiftID == item.ShiftID).ShiftName; _RosterApplicationsList.Add(_RosterApplication); } catch (Exception ex) { } } return View(_RosterApplicationsList); }