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