public UserViewModel UserInfo(int id) { Member user = (from mem in db.Member where mem.Id == id select mem).Single(); Profile prof = (from pro in db.Profile where pro.Id == user.ProfileID select pro).Single(); Demographics demo = (from dem in db.Demographics where dem.Id == prof.DemographicsID select dem).Single(); var userv = Mapper.Map <UserViewModel>(user); userv.introduction = prof.introduction; userv.birthDate = demo.birthDate; userv.gender = demo.gender; userv.city = demo.city; userv.state = demo.state; userv.country = demo.country; userv.Id = user.Id; if (prof.Interests == null) { prof.Interests = new List <Interest>(); } if (prof.Friends == null) { prof.Friends = new List <Friend>(); } db.SaveChanges(); userv.Interests = prof.Interests; userv.Friends = prof.Friends; return(userv); }
public List <UserViewModel> UserViewList() { var memList = db.Member.ToList(); List <UserViewModel> userList = new List <UserViewModel>(); for (int i = 0; i < memList.Count; i++) { Member memb = memList.ElementAt(i); Profile prof = (from pro in db.Profile where pro.Id == memb.ProfileID select pro).Single(); Demographics demo = (from dem in db.Demographics where dem.Id == prof.DemographicsID select dem).Single(); var userv = Mapper.Map <UserViewModel>(memb); userv.introduction = prof.introduction; userv.birthDate = demo.birthDate; userv.gender = demo.gender; userv.city = demo.city; userv.state = demo.state; userv.country = demo.country; userv.Id = memb.Id; userList.Add(userv); } return(userList); }
public UserViewModel createUser(Member mem, Profile pro, Demographics dem) { Member newMem = mem; Profile newProf = pro; Demographics newDemo = dem; newMem.dateJoined = DateTime.Now; newMem.lastLogin = DateTime.Now; db.Demographics.Add(newDemo); db.SaveChanges(); db.Member.Add(newMem); db.SaveChanges(); newProf.assocDemographics = newDemo; newProf.DemographicsID = newDemo.Id; newProf.assocMember = newMem; db.Profile.Add(newProf); db.SaveChanges(); db.SaveChanges(); newMem.assocProfile = newProf; newMem.ProfileID = newProf.Id; db.SaveChanges(); var userv = Mapper.Map <UserViewModel>(newMem); userv.introduction = newProf.introduction; userv.birthDate = newDemo.birthDate; userv.gender = newDemo.gender; userv.city = newDemo.city; userv.state = newDemo.state; userv.country = newDemo.country; userv.Id = newMem.Id; return(userv); }
public UserViewModel createUser(Member mem, Profile pro, Demographics dem) { Member newMem = mem; Profile newProf = pro; Demographics newDemo = dem; newMem.dateJoined = DateTime.Now; newMem.lastLogin = DateTime.Now; db.Demographics.Add(newDemo); db.SaveChanges(); db.Member.Add(newMem); db.SaveChanges(); newProf.assocDemographics = newDemo; newProf.DemographicsID = newDemo.Id; newProf.assocMember = newMem; db.Profile.Add(newProf); db.SaveChanges(); db.SaveChanges(); newMem.assocProfile = newProf; newMem.ProfileID = newProf.Id; db.SaveChanges(); var userv = Mapper.Map<UserViewModel>(newMem); userv.introduction = newProf.introduction; userv.birthDate = newDemo.birthDate; userv.gender = newDemo.gender; userv.city = newDemo.city; userv.state = newDemo.state; userv.country = newDemo.country; userv.Id = newMem.Id; return userv; }