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