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