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