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