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