private void SaveEditRosterEntries(List<RosterAttributes> rosters, int _RotaAppID) { RosterApp rotaApp = db.RosterApps.First(aa=>aa.RotaApplD==_RotaAppID); Shift shift = db.Shifts.First(aa => aa.ShiftID == rotaApp.ShiftID); 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; db.RosterDetails.Add(rosterDetail); db.SaveChanges(); } } }
private void CreateRosterEntries(Shift _selectedShift, string criteria, int criteriaValue, DateTime startDate, int noOfDays, List<RosterAttributes> rosters, int _RotaAppID) { int _userID = Convert.ToInt32(Session["LogedUserID"].ToString()); foreach (var roster in rosters) { if (isRosterValueChanged(roster, _selectedShift)) { RosterDetail _RotaDetail = new RosterDetail(); _RotaDetail.CriteriaValueDate = criteria.ToString() + criteriaValue.ToString() + roster.DutyDate.ToString("yyMMdd"); _RotaDetail.CompanyID = _selectedShift.CompanyID; _RotaDetail.OpenShift = _selectedShift.OpenShift; _RotaDetail.UserID = _userID; _RotaDetail.RosterAppID = _RotaAppID; if (roster.WorkMin == 0) { _RotaDetail.DutyCode = "R"; } else { _RotaDetail.DutyCode = "D"; } if (roster.DutyTime == new TimeSpan(0, 0, 0)) { _RotaDetail.OpenShift = true; } else { _RotaDetail.OpenShift = false; } _RotaDetail.DutyTime = roster.DutyTime; _RotaDetail.WorkMin = (short)roster.WorkMin; _RotaDetail.RosterDate = roster.DutyDate; db.RosterDetails.Add(_RotaDetail); db.SaveChanges(); } } }