public MvcHtmlString GetJourneysAndOvertimesForOneEmp(int eID = 0) { using (OvertimeController controller = new OvertimeController(repository)) { if (repository.Employees.Where(e => e.EmployeeID == eID).Count() != 0) { List <DateTime> journeyDates = new List <DateTime>(); List <DateTime> overtimeDates = new List <DateTime>(); journeyDates = SearchJourneyDataForOneEmp(eID); overtimeDates = controller.SearchOvertimeDataForOneEmp(eID); List <DateTime> overtimeAndJorneyDates = new List <DateTime>(); overtimeAndJorneyDates.AddRange(journeyDates); overtimeAndJorneyDates.AddRange(overtimeDates); overtimeAndJorneyDates.Sort(); return(CreateDatesToReclaimForDropdown(overtimeAndJorneyDates)); } else { return(new MvcHtmlString("")); } } }
public List <JourneysAndOvertimesModel> GetJourneysAndOvertimes(string searchString = "") { using (OvertimeController controller = new OvertimeController(repository)) { List <JourneysByEmployeeViewModel> selectedData = new List <JourneysByEmployeeViewModel>(); List <OvertimeByEmployeeModel> overtimeData = new List <OvertimeByEmployeeModel>(); List <JourneysAndOvertimesModel> overtimeAndJourneysData = new List <JourneysAndOvertimesModel>(); selectedData = SearchJourneyData(searchString); overtimeData = controller.SearchOvertimeData(searchString); foreach (var item in selectedData) { JourneysAndOvertimesModel model = new JourneysAndOvertimesModel(); model.Department = item.Department; model.EID = item.EID; model.EmployeeID = item.EmployeeID; model.FirstName = item.FirstName; model.Journeys = item.Journeys; model.LastName = item.LastName; /*-> improve this*/ model.Overtimes = (from e in overtimeData where e.EmployeeID == item.EmployeeID select e.Overtimes).FirstOrDefault(); overtimeAndJourneysData.Add(model); } return(overtimeAndJourneysData); } }
public MvcHtmlString GetJourneysAndOvertimesForOneEmpEdit(int eID, string from) { using (OvertimeController controller = new OvertimeController(repository)) { if (repository.Employees.Where(e => e.EmployeeID == eID).Count() != 0) { DateTime parseFrom; try { parseFrom = DateTime.ParseExact(from, "dd.MM.yyyy", null); } catch (SystemException) { return(new MvcHtmlString("")); } List <DateTime> journeyDates = new List <DateTime>(); List <DateTime> overtimeDates = new List <DateTime>(); journeyDates = SearchJourneyDataForOneEmp(eID); overtimeDates = controller.SearchOvertimeDataForOneEmp(eID); List <DateTime> overtimeAndJorneyDates = new List <DateTime>(); overtimeAndJorneyDates.AddRange(journeyDates); overtimeAndJorneyDates.AddRange(overtimeDates); DateTime reclaimDateOvertimes = repository.Overtimes .Where(o => o.EmployeeID == eID && o.ReclaimDate == parseFrom) .Select(o => o.Date).FirstOrDefault(); DateTime reclaimDateJourneys = repository.Journeys .Where(o => o.JourneyOf.EmployeeID == eID && o.ReclaimDate == parseFrom) .Select(o => o.Date).FirstOrDefault(); overtimeAndJorneyDates.Sort(); if (reclaimDateOvertimes != DateTime.MinValue) { overtimeAndJorneyDates.Insert(0, reclaimDateOvertimes); } if (reclaimDateJourneys != DateTime.MinValue) { overtimeAndJorneyDates.Insert(0, reclaimDateJourneys); } return(CreateDatesToReclaimForDropdown(overtimeAndJorneyDates)); } else { return(new MvcHtmlString("")); } } }