public object createcontact(Registration Lvm)
{
if (Lvm != null)
{
try
{
EmployeeEntities db = new EmployeeEntities();
t_Users tm = new t_Users();
tm.EMail = Lvm.EMail;
tm.Password = Lvm.Password;
tm.IsActive = true;
tm.CreatedDate = DateTime.Now;
db.t_Users.Add(tm);
db.SaveChanges();
int?id = (
from p in db.t_Users
orderby p.UserId descending
select p.UserId
).Take(1).SingleOrDefault();
t_User_PersonalDetails tps = new t_User_PersonalDetails();
tps.UserId = (int)id;
tps.FName = Lvm.FName;
tps.LName = Lvm.LName;
tps.Gender = Lvm.Gender;
tps.Phone = Lvm.Phone;
tps.DOB = Lvm.DOB;
tps.Address = Lvm.Address;
tps.CreatedDate = DateTime.Now;
db.t_User_PersonalDetails.Add(tps);
db.SaveChanges();
return(new Response
{
Status = "Success", Message = "SuccessFully Saved."
});
}
catch (Exception)
{
throw;
}
}
else
{
return(new Response
{
Status = "Error", Message = "Invalid Data."
});
}
}
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();
}
