public static List <LaborModel> GetJobLabors(int jobID) { var db = new RoyalFinishingDataContext(); var list = db.Labors.Where(x => x.JobID == jobID).ToList(); var jobList = new List <LaborModel>(); foreach (var labor in list) { LaborModel newLabor = new LaborModel(); newLabor.EmployeeName = GetEmployee(labor.EmployeeID); newLabor.Date = labor.Date.Value; newLabor.Hours = labor.Hours; jobList.Add(newLabor); } return(jobList); }
public static List <LaborModel> GetEmployeeLabor(int employeeID, DateTime startDate, DateTime endDate) { var db = new RoyalFinishingDataContext(); var list = db.Labors.Where(x => x.EmployeeID == employeeID && startDate <= x.Date && x.Date <= endDate).ToList(); var laborList = new List <LaborModel>(); foreach (var labor in list) { LaborModel newLabor = new LaborModel(); newLabor.Date = labor.Date.Value; newLabor.Hours = labor.Hours; newLabor.JobName = GetJobName(labor.JobID); laborList.Add(newLabor); } return(laborList); }