public ActionResult Edit(RegistrationViewModel rvm) { Context context = new Context(); Person_Table pt = context.Person_Table.Where(u => u.Id == rvm.Id).FirstOrDefault(); Users_Table ut = pt.Users_Table.FirstOrDefault() == null ? new Users_Table() : pt.Users_Table.FirstOrDefault(); ut.Username = rvm.Username; ut.Password = rvm.Password; ut.Email = rvm.Email; pt.FirstName = rvm.FirstName; pt.LastName = rvm.LastName; pt.Gender = rvm.Gender; pt.Users_Table.Add(ut); context.SaveChanges(); return(RedirectToAction("GetList", "Registration")); }
public ActionResult Edit(int Id) { Context context = new Context(); Person_Table pt = context.Person_Table.Where(o => o.Id == Id).FirstOrDefault(); Users_Table ut = pt.Users_Table.FirstOrDefault() == null ? new Users_Table() : pt.Users_Table.FirstOrDefault(); RegistrationViewModel rvm = new RegistrationViewModel { Id = pt.Id, Email = ut.Email, FirstName = pt.FirstName, Gender = pt.Gender, LastName = pt.LastName, Username = ut.Username }; return(View(rvm)); }
public ActionResult GetList(PersonViewModel pvm) { PersonModel filter = pvm.FilterPerson; Person_Table pt = new Person_Table(); Context context = new Context(); var persons = context.Person_Table.Where(x => (filter.FirstName == null ? true : x.FirstName.Contains(filter.FirstName)) && (filter.LastName == null ? true : x.LastName.Contains(filter.LastName)) && (filter.Gender == null ? true : x.Gender == filter.Gender) && (filter.Username == null ? true : x.Users_Table.FirstOrDefault().Username.Contains(filter.Username))); PersonViewModel k = new PersonViewModel(); foreach (Person_Table person in persons) { PersonModel tmp = new PersonModel(person.Id, person.FirstName, person.LastName, person.Gender, person.Users_Table == null || person.Users_Table.Count == 0 ? "" : person.Users_Table.FirstOrDefault().Username); k.persons.Add(tmp); } return(View(k)); }