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