public IEnumerable <EmpployeeMaster> GetPersonalDt() { EmployeeEntities db = new EmployeeEntities(); List <EmpployeeMaster> Listr = new List <EmpployeeMaster>(); var JoinResult = (from p in db.t_Users join t in db.t_User_PersonalDetails on p.UserId equals t.UserId select new { UserPersonalId = t.UserPersonalId, FName = t.FName, LName = t.LName, Gender = t.Gender, Phone = t.Phone, DOB = t.DOB, EMail = p.EMail, } ).ToList(); foreach (var item in JoinResult) { EmpployeeMaster cu = new EmpployeeMaster(); cu.UserPersonalId = item.UserPersonalId; cu.EMail = item.EMail; cu.Gender = item.Gender; cu.FName = item.FName; cu.LName = item.LName; cu.Phone = item.Phone; cu.DOB = item.DOB; Listr.Add(cu); } return(Listr); }
public IEnumerable <EmpployeeMaster> Edit(string id) { int pid = Convert.ToInt32(id); EmployeeEntities db = new EmployeeEntities(); t_User_PersonalDetails rg = db.t_User_PersonalDetails.Find(pid); List <EmpployeeMaster> Listr = new List <EmpployeeMaster>(); int uid = rg.UserId; t_Users rgt = db.t_Users.Find(uid); int uid1 = rgt.UserId; var JoinResult = (from p in db.t_Users join t in db.t_User_PersonalDetails on p.UserId equals t.UserId where p.UserId == uid1 select new { UserPersonalId = t.UserPersonalId, FName = t.FName, LName = t.LName, Gender = t.Gender, Phone = t.Phone, DOB = t.DOB, EMail = p.EMail, } ).ToList(); foreach (var item in JoinResult) { EmpployeeMaster cu = new EmpployeeMaster(); cu.UserPersonalId = item.UserPersonalId; cu.EMail = item.EMail; cu.Gender = item.Gender; cu.FName = item.FName; cu.LName = item.LName; cu.Phone = item.Phone; cu.DOB = item.DOB; Listr.Add(cu); } return(Listr); //db.t_User_PersonalDetails.ToList(); }