public bool addData(CommonClass custom) { t_Users tu = new t_Users(); tu.EMail = custom.EMail; tu.Password = custom.Password; tu.IsActive = true; tu.CreatedDate = DateTime.Now; db.t_Users.Add(tu); db.SaveChanges(); int?id = (from s in db.t_Users orderby s.UserId descending select s.UserId).Take(1).SingleOrDefault(); t_User_PersonalDetails tp = new t_User_PersonalDetails(); tp.Address = custom.Address; tp.DOB = custom.DOB; tp.FName = custom.FName; tp.LName = custom.LName; tp.Phone = custom.Phone; tp.UserId = (int)id; tp.CreatedDate = DateTime.Now; db.t_User_PersonalDetails.Add(tp); db.SaveChanges(); return(true); }
public IEnumerable <CommonClass1> Edit(int id) { t_User_PersonalDetails t = db.t_User_PersonalDetails.Find(id); List <CommonClass1> Listr = new List <CommonClass1>(); int uid = t.UserId; t_Users k = db.t_Users.Find(uid); int uid1 = k.UserId; var JoinResult = (from p in db.t_Users join s in db.t_User_PersonalDetails on p.UserId equals t.UserId where p.UserId == uid1 select new { UserPersonalId = t.UserPersonalId__UserPersonalId__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) { CommonClass1 c = new CommonClass1(); c.UserPersonalId = item.UserPersonalId; c.EMail = item.EMail; c.Gender = item.Gender; c.FName = item.FName; c.LName = item.LName; c.Phone = item.Phone; c.DOB = item.DOB; Listr.Add(c); } return(Listr); //db.t_User_PersonalDetails.ToList(); }