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);
}
