void GEtEmpData()
{
using (HRISEntities db = new HRISEntities())
{
var res = from a in db.t_EmpMaster
from b in db.t_Department
from c in db.t_DepartmentalSection
from d in db.t_Position
where a.Department == b.DeptCode && a.Department == c.DeptCode && a.Section == c.SectCode && a.Department == d.DeptCode && a.Position == d.Code && a.IsDeleted == false
orderby a.SerialID descending
select new { a.EmpPicture, a.EmpID, Fullname = (a.LastName + ", " + a.FirstName + " " + a.MiddleName.Substring(0, 1) + "."), b.DeptName, c.SectName, d.Description };
EmpName.ItemsSource = res.ToList();
}
}
private void getemployeelist()
{
using (HRISEntities db = new HRISEntities())
{
//var empdata = (from e in db.t_EmpMaster
// join d in db.t_Department on
// e.Department equals d.DeptCode
// join s in db.t_DepartmentalSection on
// e.Section equals s.SectCode
// join p in db.t_Position on
// e.Position equals p.Code
// where e.IsDeleted == false
// select new
// {
// newEmpID = e.EmpID,
// newFirstName = e.FirstName,
// newMiddleName = e.MiddleName,
// newLastName = e.LastName,
// newDeptName = d.DeptName,
// newSectName = s.SectName,
// newPosition = p.Description
// }).ToList();
//var query = db.t_EmpMaster.Join(db.t_Position,
//a => new { key1 = a.Department, key2 = a.Position },
//b => new { key1 = b.DeptCode, key2 = b.Code },
// (t1, t2) => new
//{
// t1.EmpID,
// t1.FirstName,
// t1.MiddleName,
// t1.LastName,
// t2.Description
//})
//;
var res = from a in db.t_EmpMaster
from b in db.t_Department
from c in db.t_DepartmentalSection
from d in db.t_Position
where a.Department == b.DeptCode && a.Department == c.DeptCode &&
a.Section == c.SectCode && a.Department == d.DeptCode &&
a.Position == d.Code && a.IsDeleted == false
orderby a.SerialID descending
select new { a.EmpID, a.FirstName, a.MiddleName, a.LastName, b.DeptName, c.SectName, d.Description, a.InitialEntryBy };
//SqlCommand cmd = new SqlCommand("SKPI_GetAllEmployees");
//cmd.CommandType = System.Data.CommandType.StoredProcedure;
gridEmployee.ItemsSource = //SqlHelper.ExecuteReader(ConfigurationManager.ConnectionStrings["HRIS"].ConnectionString, cmd); //
res.ToList();
//var results = (from e in db.t_EmpMaster
// join d in db.t_Department on e.Department equals d.DeptCode
// join s in db.t_DepartmentalSection on new { e.Section, d.DeptCode } equals new { s.SectCode, s.DeptCode }
// join p in db.t_Position on new { e.Position, e.Department } equals new { p.Code, p.DeptCode }
// select new
// {
// EmpID = e.EmpID,
// FirstName = e.FirstName,
// MiddleName = e.MiddleName,
// LastName = e.LastName,
// DeptName = d.DeptName,
// SectName = s.SectName,
// Position = p.Description
// });
//gridEmployee.ItemsSource = results.ToList();
}
}
