private List <Address> GetExistingAddresses(int personId) { List <Address> addressesToReturn = new List <Address>(); Person_Address xref = new Person_Address(_databaseSmoObjectsAndSettings); xref.PersonID = personId; BaseDataAccess <Person_Address> xrefDAO = new BaseDataAccess <Person_Address>(_databaseSmoObjectsAndSettings); //this get permutation will check the modified state of each property in the dto //if modified it is added to the exact criteria list in this case just the personID List <Person_Address> thisPersonsAddresses = xrefDAO.Get(xref, GetPermutations.ByExplicitCriteria); foreach (Person_Address person_address in thisPersonsAddresses) { Bo.Address address = new Bo.Address(_databaseSmoObjectsAndSettings); address.AddressID = person_address.AddressID; address.GetByPrimaryKey(); addressesToReturn.Add(address); } return(addressesToReturn); }
public ActionResult DeleteConfirmed(int id) { Person_Address person_Address = db.Person_Address.Find(id); db.Person_Address.Remove(person_Address); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "person_id,address_id,record_id")] Person_Address person_Address) { if (ModelState.IsValid) { db.Entry(person_Address).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.address_id = new SelectList(db.Addresses, "address_id", "address1", person_Address.address_id); ViewBag.person_id = new SelectList(db.Persons, "person_id", "first_name", person_Address.person_id); return(View(person_Address)); }
// GET: Person_Address/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Person_Address person_Address = db.Person_Address.Find(id); if (person_Address == null) { return(HttpNotFound()); } return(View(person_Address)); }
// GET: Person_Address/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } Person_Address person_Address = db.Person_Address.Find(id); if (person_Address == null) { return(HttpNotFound()); } ViewBag.address_id = new SelectList(db.Addresses, "address_id", "address1", person_Address.address_id); ViewBag.person_id = new SelectList(db.Persons, "person_id", "first_name", person_Address.person_id); return(View(person_Address)); }
public ActionResult Create([Bind(Include = "person_id,first_name,last_name,dob,single_married,spouse_id,primary_address,phone_number,address_id, address, primary_address, record_id")] Person person, MainViewModel mainViewModel, FormCollection fc) { MainViewModel model = new MainViewModel(); // ViewData["status"] = "create started!"; List <Address> al = mainViewModel.allAddresses; // PersonModel personModel = model; //List<Address> al = model.allAddresses; string selectedRadio = fc["primary"]; int radio = Convert.ToInt32(selectedRadio); //person.primary_address = al[radio].address1; //Person newPerson = new Person(); //newPerson.first_name = model.first_name; //newPerson.last_name = model.last_name; //newPerson.dob = model.dob; //newPerson.phone_number = model.phone_number; Person newPerson = new Person(); newPerson.first_name = fc["personModel.first_name"]; newPerson.last_name = fc["personModel.last_name"]; newPerson.dob = Convert.ToDateTime(fc["personModel.dob"]); newPerson.phone_number = fc["personModel.phone_number"]; newPerson.primary_address = al[radio].address1; if (newPerson.primary_address == null) { ViewBag.Message = "Please select primary address!"; return(PartialView("_AddPerson")); } if (ModelState.IsValid) { db.Persons.Add(newPerson); foreach (var a in al) { db.Addresses.Add(a); } for (int i = 0; i < al.Count(); i++) { var personAddress = new Person_Address(); personAddress.Person = newPerson; personAddress.Address = al[i]; db.Person_Address.Add(personAddress); } db.SaveChanges(); ModelState.Clear(); return(JavaScript("success()")); } //change to person if not working! return(View(model)); }
public ActionResult Add([Bind(Include = "person_id,first_name,last_name,dob,single_married,spouse_id,primary_address,phone_number,phone_number_2,address_id, address, primary_address, record_id")] Person person, MainViewModel mainViewModel, FormCollection fc) { //MainViewModel model = new MainViewModel(); List <Address> al = mainViewModel.allAddresses; PersonModel personModel = mainViewModel.personModel; //List<Address> al = model.allAddresses; string selectedRadio = fc["primary"]; int radio = Convert.ToInt32(selectedRadio); DateTime now = DateTime.Today; Person newPerson = new Person(); newPerson.first_name = personModel.first_name; newPerson.last_name = personModel.last_name; newPerson.dob = personModel.dob; int result = DateTime.Compare(now, newPerson.dob); if (result < 0) { ViewBag.Message = "Please select proper date!"; return(PartialView("_AddPerson", mainViewModel)); } newPerson.phone_number = personModel.phone_number; newPerson.phone_number_2 = personModel.phone_number_2; //Person newPerson = new Person(); //newPerson.first_name = fc["personModel.first_name"]; //newPerson.last_name = fc["personModel.last_name"]; //newPerson.dob = Convert.ToDateTime(fc["personModel.dob"]); //newPerson.phone_number = fc["personModel.phone_number"]; newPerson.primary_address = al[radio].address1; if (newPerson.primary_address == null) { ViewBag.Message = "Please select primary address!"; return(PartialView("_AddPerson", mainViewModel)); } if (ModelState.IsValid) { db.Persons.Add(newPerson); foreach (var a in al) { if (a.address1 != null) { db.Addresses.Add(a); } } for (int i = 0; i < al.Count(); i++) { if (al[i].address1 != null) { var personAddress = new Person_Address(); personAddress.Person = newPerson; personAddress.Address = al[i]; db.Person_Address.Add(personAddress); } } db.SaveChanges(); ModelState.Clear(); return(JavaScript("success()")); } //change to person if not working! return(PartialView("_AddPerson", mainViewModel)); }