private VMRosterModel CalculateRosterFields(VMRosterApplication vm, int _RotaAppID)
{
VAT_Shift shift = DDService.GetShift().Where(aa => aa.PShiftID == vm.ShiftID).First();
VMRosterModel _objmodel = new VMRosterModel();
try
{
int endPoint = 0;
if (vm.RosterTypeID == 2)
{
endPoint = (vm.DateEnded.Value - vm.DateStarted.Value).Days + 1;
}
else if (vm.RosterTypeID == 3)
{
endPoint = 15;
}
else if (vm.RosterTypeID == 4)
{
endPoint = System.DateTime.DaysInMonth(vm.DateStarted.Value.Year, vm.DateEnded.Value.Month);
}
else if (vm.RosterTypeID == 4)
{
endPoint = 84;
}
_objmodel._RosterAttributes = new List <RosterAttributes>();
_objmodel.Criteria = ConvertCriteriaAbrvToFull("C");
_objmodel.RotaAppID = _RotaAppID;
_objmodel.CriteriaValue = vm.CrewID;
_objmodel.ShiftID = vm.ShiftID;
_objmodel.StartDate = vm.DateStarted.Value;
_objmodel.EndDate = vm.DateEnded.Value;
_objmodel.NoOfDays = endPoint;
_objmodel.CriteriaValueName = DDService.GetCrew().Where(aa => aa.PCrewID == vm.CrewID).First().CrewName;
_objmodel.ShiftName = shift.ShiftName;
DateTime _StartDate = vm.DateStarted.Value;
for (int i = 1; i <= endPoint; i++)
{
string _day = _StartDate.Date.ToString("dddd");
string _date = _StartDate.Date.ToString("dd-MMM-yyyy");
string shiftStartTimeString = GetShiftStartTimeString(_StartDate.DayOfWeek, vm);
TimeSpan shiftStartTime = ATAssistant.ConvertTime(shiftStartTimeString);
int workMin = GetWorkMinutesForSpecificDates(_StartDate, vm);
_objmodel._RosterAttributes.Add(new RosterAttributes {
ID = i, DateString = _date, Day = _day, DutyDate = _StartDate.Date, DutyTimeString = shiftStartTimeString, DutyTime = shiftStartTime, WorkMin = workMin
});
_StartDate = _StartDate.AddDays(1);
}
Expression <Func <RosterApplication, bool> > SpecificEntries = c => c.RotaAppID == _RotaAppID;
RosterApplication rosterApp = RosterApplicationService.GetIndexSpecific(SpecificEntries).First();
rosterApp.DateEnded = _StartDate.AddDays(-1);
RosterApplicationService.PostEdit(rosterApp);
return(_objmodel);
}
catch (Exception ex)
{
return(_objmodel);
}
}
private bool isRosterValueChanged(RosterAttributes roster, VAT_Shift _selectedShift)
{
DayOfWeek day = roster.DutyDate.DayOfWeek;
bool isChanged = roster.DutyTime == _selectedShift.StartTime ? false : true;
switch (day)
{
case DayOfWeek.Monday:
if (roster.WorkMin != _selectedShift.MonMin)
{
isChanged = true;
}
break;
case DayOfWeek.Tuesday:
if (roster.WorkMin != _selectedShift.TueMin)
{
isChanged = true;
}
break;
case DayOfWeek.Wednesday:
if (roster.WorkMin != _selectedShift.WedMin)
{
isChanged = true;
}
break;
case DayOfWeek.Thursday:
if (roster.WorkMin != _selectedShift.ThuMin)
{
isChanged = true;
}
break;
case DayOfWeek.Friday:
if (roster.WorkMin != _selectedShift.FriMin)
{
isChanged = true;
}
break;
case DayOfWeek.Saturday:
if (roster.WorkMin != _selectedShift.SatMin)
{
isChanged = true;
}
break;
case DayOfWeek.Sunday:
if (roster.WorkMin != _selectedShift.SunMin)
{
isChanged = true;
}
break;
}
return(isChanged);
}
private void SaveEditRosterEntries(List <RosterAttributes> rosters, int _RotaAppID)
{
RosterApplication rotaApp = RosterApplicationService.GetEdit(_RotaAppID);
VAT_Shift shift = DDService.GetShift().Where(aa => aa.PShiftID == rotaApp.ShiftID).First();
foreach (var roster in rosters)
{
//if (isRosterValueChanged(roster, shift))
{
RosterDetail rosterDetail = new RosterDetail();
rosterDetail.CriteriaValueDate = rotaApp.RosterCriteria.ToString() + rotaApp.CriteriaData.ToString() + roster.DutyDate.ToString("yyMMdd");
//rosterDetail.CompanyID = rotaApp.CompanyID;
rosterDetail.OpenShift = shift.OpenShift;
//rosterDetail.UserID = rotaApp.UserID;
rosterDetail.RosterAppID = _RotaAppID;
if (roster.WorkMin == 0)
{
rosterDetail.DutyCode = "R";
}
else
{
rosterDetail.DutyCode = "D";
}
if (roster.DutyTime == new TimeSpan(0, 0, 0))
{
rosterDetail.OpenShift = true;
}
else
{
rosterDetail.OpenShift = false;
}
rosterDetail.DutyTime = roster.DutyTime;
rosterDetail.WorkMin = (short)roster.WorkMin;
rosterDetail.RosterDate = roster.DutyDate;
RosterDetailService.PostCreate(rosterDetail);
}
}
}
public ActionResult Create2(VMRosterModel vm)
{
List <RosterAttributes> rosterAttributeList = new List <RosterAttributes>();
VAT_Shift _selectedShift = DDService.GetShift().Where(aa => aa.PShiftID == vm.ShiftID).First();
int _RotaAppID = Convert.ToInt32(Request.Form["RotaAppID"].ToString());
for (int i = 1; i <= vm.NoOfDays; i++)
{
rosterAttributeList.Add(new RosterAttributes()
{
DutyTime = ATAssistant.ConvertTime(Request.Form["DT-" + i.ToString()].ToString()),
DutyDate = Convert.ToDateTime(Request.Form["Date-" + i.ToString()]),
WorkMin = Convert.ToInt32(Request.Form["WM-" + i.ToString()])
});
}
VMLoggedUser LoggedInUser = Session["LoggedInUser"] as VMLoggedUser;
RosterService.PostCreate2(vm, rosterAttributeList);
ViewBag.ErrorList = "";
CreateHelper();
return(RedirectToAction("Index"));
}
private int CalculateShiftWorkMins(DateTime _StartDate, VAT_Shift shift)
{
int workMins = 0;
switch (_StartDate.DayOfWeek)
{
case DayOfWeek.Monday:
workMins = shift.MonMin;
break;
case DayOfWeek.Tuesday:
workMins = shift.TueMin;
break;
case DayOfWeek.Wednesday:
workMins = shift.WedMin;
break;
case DayOfWeek.Thursday:
workMins = shift.ThuMin;
break;
case DayOfWeek.Friday:
workMins = shift.FriMin;
break;
case DayOfWeek.Saturday:
workMins = shift.SatMin;
break;
case DayOfWeek.Sunday:
workMins = shift.SunMin;
break;
}
return(workMins);
}
private VMRosterModel CalculateRosterEditEntries(RosterApplication rosterApp, List <RosterDetail> rosterDetails)
{
VAT_Shift shift = DDService.GetShift().Where(aa => aa.PShiftID == rosterApp.ShiftID).First();
VMRosterModel _objmodel = new VMRosterModel();
int i = 1;
try
{
_objmodel._RosterAttributes = new List <RosterAttributes>();
DateTime _StartDate = (DateTime)rosterApp.DateStarted;
_objmodel.RotaAppID = rosterApp.RotaAppID;
_objmodel.ShiftName = shift.ShiftName;
switch (rosterApp.RosterCriteria)
{
case "S":
break;
case "C":
_objmodel.CriteriaValueName = DDService.GetCrew().Where(aa => aa.PCrewID == rosterApp.CriteriaData).First().CrewName;
break;
case "T":
break;
case "employee":
break;
}
while (_StartDate <= rosterApp.DateEnded)
{
string _day = _StartDate.Date.ToString("dddd");
string _date = _StartDate.Date.ToString("dd-MMM-yyyy");
string _DTime = "";
TimeSpan _DutyTime = new TimeSpan();
int _WorkMin = 0;
if (rosterDetails.Where(aa => aa.RosterDate == _StartDate).Count() > 0)
{
// from roster details
RosterDetail rotaDetail = rosterDetails.First(aa => aa.RosterDate == _StartDate);
_DTime = rotaDetail.DutyTime.Value.Hours.ToString("00") + rotaDetail.DutyTime.Value.Minutes.ToString("00");
_WorkMin = (int)rotaDetail.WorkMin;
_DutyTime = (TimeSpan)rotaDetail.DutyTime;
}
else
{
//from shift
_DTime = shift.StartTime.Hours.ToString("00") + shift.StartTime.Minutes.ToString("00");
_WorkMin = CalculateShiftWorkMins(_StartDate, shift);
_DutyTime = shift.StartTime;
}
_objmodel._RosterAttributes.Add(new RosterAttributes {
ID = i, DateString = _date, Day = _day, DutyDate = _StartDate.Date, DutyTimeString = _DTime, DutyTime = _DutyTime, WorkMin = _WorkMin
});
_StartDate = _StartDate.AddDays(1);
i++;
}
_objmodel.NoOfDays = i;
return(_objmodel);
}
catch (Exception ex)
{
return(_objmodel);
}
}
