public List <FW_Department1> GetJobCostingDepartments() { var dc = new EmployeeDbModelEntities(); var depts = dc.FW_Department1.Where(x => x.pSelect == true || x.DEPARTMENTID <= 1).ToList(); return(depts); }
public FsEmployeeByNickName(string nickName, int dID) { EmployeeNumber = 0; var dc = new EmployeeDbModelEntities(); var emps = dc.FW_Employees.Where(x => x.NickName == nickName.Trim() && x.dID == dID).OrderBy(x => x.dID).ToArray(); if (emps.Count() > 0) { EmployeeNumber = emps[0].EmployeeNumber; } }
private static DateTime GetStartWorkingDate(int employeeID) { DateTime startWorkingDate = DateTime.Today; var dc1 = new EmployeeDbModelEntities(); var ewhs = from c in dc1.FW_Employee_WorkingHistory where c.EmployeeNumber == employeeID group c.StartWorkingDate by c.EmployeeNumber into g select new { EmployeeID = g.Key, StartWorkingDate = g.Min() }; foreach (var row in ewhs) { startWorkingDate = Convert.ToDateTime(row.StartWorkingDate); } return(startWorkingDate); }
public Probation(int employeeID) { var dc = new EmployeeDbModelEntities(); _ee = dc.FW_Employees.SingleOrDefault(c => c.EmployeeNumber == employeeID); }