public IActionResult AddPersonAddressAction(int idPersoana, string strada, int numar, string bloc, int etaj, int apartament, string localitate, string judet, DateTime dataInceput, DateTime dataSfarsit) { var person = _persons.GetById(idPersoana); if (dataSfarsit == DateTime.MinValue) { dataSfarsit = DateTime.MaxValue; } var personAddress = new PersonAddress { Strada = strada, Numar = numar, Bloc = bloc, Etaj = etaj, Apartament = apartament, Localitate = localitate, Judet = judet, DataInceput = dataInceput, DataSfarsit = dataSfarsit, Persoana = person }; _personAddress.Add(personAddress); return(RedirectToAction("Detail", new { id = idPersoana })); }
public void Register(Person p, PersonAddress pa) { PasswordHash phash = new PasswordHash(); KeyCode keycode = new KeyCode(); int key = keycode.GetKeyCode(); byte[] hash = phash.HashIt(p.PersonPlainPassword, key.ToString()); Person person = new Person(); person.PersonFirstName = p.PersonFirstName; person.PersonLastName = p.PersonLastName; person.Personpasskey = key; person.PersonUsername = p.PersonUsername; person.PersonPlainPassword = p.PersonPlainPassword; person.PersonUserPassword = hash; person.PersonEntryDate = DateTime.Now; communityAssistDb.People.Add(person); PersonAddress pAddress = new PersonAddress(); pAddress.Person = person; pAddress.Apartment = pa.Apartment; pAddress.Street = pa.Street; pAddress.City = pa.City; pAddress.State = pa.State; pAddress.Zip = pa.Zip; communityAssistDb.PersonAddresses.Add(pAddress); communityAssistDb.SaveChanges(); }
public ActionResult Create(Address address) { try { List <PersonAddress> personsAddress = JsonConvert.DeserializeObject <List <PersonAddress> >(System.IO.File.ReadAllText(path)); int personId = Convert.ToInt32(TempData.Peek("PersonId")); var result = personsAddress == null || personsAddress.Count == 0?null : personsAddress.Where(data => data.PersonId == personId).SingleOrDefault().Address.OrderByDescending(x => x.AddressId).FirstOrDefault(); address.AddressId = result != null ? result.AddressId + 1 : 1; if (personsAddress != null && personsAddress.Count != 0) { personsAddress.Where(data => data.PersonId == personId).Select(ab => ab.Address).SingleOrDefault().Add(address); } else { PersonAddress pa = new PersonAddress(); pa.PersonId = personId; pa.Address = new List <Address>(); pa.Address.Add(address); personsAddress = new List <PersonAddress>(); personsAddress.Add(pa); } SearlizeObject(personsAddress); return(RedirectToAction("Details", new { id = personId })); } catch { return(View()); } }
private List <PersonAddress> CreatePersonAddresses() { PersonAddress address1 = new PersonAddress() { address_id = "1", person_id = "1", created_at = DateTime.Now, updated_at = DateTime.Now, id = "1", started_at = DateTime.Now.AddDays(-52), ended_at = DateTime.Now.AddDays(-22) }; PersonAddress address2 = new PersonAddress() { address_id = "1", person_id = "1", created_at = DateTime.Now, updated_at = DateTime.Now, id = "2", started_at = DateTime.Now.AddDays(-21) }; List <PersonAddress> personAddresses = new List <PersonAddress>(); personAddresses.Add(address1); personAddresses.Add(address2); return(personAddresses); }
public int AddPersonAddress(PersonAddress data) { var res = _context.PersonAddress.Add(data); _context.SaveChanges(); return(res.Entity.Id); }
public ActionResult DeletePost(PersonAddressViewModel vm) { PersonAddress PersonAddress = _PersonAddressService.Find(vm.PersonAddressId); PersonAddress PP = new PersonAddress() { PersonAddressID = vm.PersonAddressId }; //_PersonProcessService.Delete(vm.PersonProcessId); db.PersonAddress.Attach(PP); PP.ObjectState = Model.ObjectState.Deleted; db.PersonAddress.Remove(PP); try { db.SaveChanges(); } catch (Exception ex) { string message = _exception.HandleException(ex); PrepareViewBag(); ModelState.AddModelError("", message); return(PartialView("EditSize", vm)); } return(Json(new { success = true })); }
public async Task <ActionResult <PersonAddress> > PostPersonAddress(PersonAddress personAddress) { _context.PersonAddress.Add(personAddress); await _context.SaveChangesAsync(); return(CreatedAtAction("GetPersonAddress", new { id = personAddress.Id }, personAddress)); }
public async Task <IHttpActionResult> PutPersonAddress(int id, PersonAddress personAddress) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != personAddress.Id) { return(BadRequest()); } db.Entry(personAddress).State = EntityState.Modified; try { await db.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PersonAddressExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
protected void btnEditSave_Click(object sender, EventArgs e) { Person person = new Person(Convert.ToInt32(hfEditPerson.Value)); PersonAddress address = person.Addresses.FindByType(Convert.ToInt32(hfEditType.Value)); PersonAddressCollection pac = new PersonAddressCollection(); // // Verify valid data. // if (address.AddressID == -1) { throw new System.Exception("Invalid address type during edit."); } // // Make sure this is the only person using this address, otherwise create a new one. // pac.LoadByAddressID(address.AddressID); if (pac.Count > 1) { person.Addresses.Remove(address); address = new PersonAddress(); address.PersonID = person.PersonID; address.Address = new Address(); address.AddressType = new Lookup(Convert.ToInt32(hfEditType.Value)); person.Addresses.Add(address); } // // Set the address information. // address.Address.StreetLine1 = tbEditStreetAddress1.Text.Trim(); address.Address.StreetLine2 = tbEditStreetAddress2.Text.Trim(); address.Address.City = tbEditCity.Text.Trim(); address.Address.State = tbEditState.Text.Trim(); address.Address.PostalCode = tbEditPostal.Text.Trim(); address.Address.Country = ddlEditCountry.SelectedValue; // // If this address is becoming primary (and wasn't already) make sure it is the // only one. // if (cbEditPrimary.Checked && address.Primary == false) { foreach (PersonAddress pa in person.Addresses) { pa.Primary = false; } } address.Primary = cbEditPrimary.Checked; // // Standardize and save. // address.Address.Standardize(); person.SaveAddresses(person.OrganizationID, CurrentUser.Identity.Name); LoadFamilyAddresses(family_id); cbSelectAll.Checked = false; }
private void ValidateAddress(PersonAddress address) { if (address != null) { address.AddressLine.Requires().IsNotNullOrEmpty(); } }
public async Task <IActionResult> Edit(long id, [Bind("PersonAddressId,PersonId,AddressLine1,AddressLine2,City,State,PostalCode")] PersonAddress personAddress) { if (id != personAddress.PersonAddressId) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(personAddress); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PersonAddressExists(personAddress.PersonAddressId)) { return(NotFound()); } else { throw; } } return(RedirectToAction("Details", "Clients", new { id = personAddress.PersonId }, null)); } ViewData["PersonId"] = new SelectList(_context.Persons, "PersonId", "FirstName", personAddress.PersonId); return(View(personAddress)); }
/// <summary> /// Create a new PersonAddress object. /// </summary> /// <param name="personID">Initial value of PersonID.</param> public static PersonAddress CreatePersonAddress(int personID) { PersonAddress personAddress = new PersonAddress(); personAddress.PersonID = personID; return(personAddress); }
static void Main(string[] args) { using (var dbContext = new Context.OneToOneReverseOnlyDbContext(EntityFrameworkDbRelationships.Bootstrap.DbConfiguration.ConnectionString)) { dbContext.Students.Add(new Person { PersonName = "Student No Address" } ); dbContext.SaveChanges(); var address = new PersonAddress { Address = "This is student address.", Person = new Person { PersonName = "Student With Address" } }; dbContext.StudentAddresses.Add(address); dbContext.SaveChanges(); } using (var dbContext = new Context.OneToOneReverseOnlyDbContext(EntityFrameworkDbRelationships.Bootstrap.DbConfiguration.ConnectionString)) { var studAddressList = dbContext.StudentAddresses.Include(a => a.Person).ToList(); foreach (var address in studAddressList) { Console.WriteLine("Student: {0}", address.Person.PersonName); Console.WriteLine(" Address: {0}", address.Address); } } }
public ActionResult Create(MenteeViewModel viewModel) { if (!ModelState.IsValid) { var errors = ModelState.Where(v => v.Value.Errors.Any()); return(View(viewModel)); } // New person that represents the mentee Person mentee = new Person(viewModel.Mentee); // Make sure we set the user as Mentee mentee.PersonTypeId = DomainHelper.GetIdByKeyValue(ref this._db, "PersonType", "Mentee"); mentee.StatusId = DomainHelper.GetIdByKeyValue(ref _db, "StatusCode", "Active"); this._db.People.Add(mentee); // Home Address Address homeAddr = new Address(viewModel.HomeAddress); PersonAddress p2a = new PersonAddress(mentee.id, homeAddr.id, DomainHelper.GetIdByKeyValue(ref _db, "AddressType", "Home")); this._db.Addresses.Add(homeAddr); this._db.PersonToAddress.Add(p2a); // Save changes this._db.SaveChanges(); return(RedirectToAction("Index")); }
public PersonAddress SavePersonAddress(PersonAddress address) { SqlServerConnection conn = new SqlServerConnection(); address.Id = conn.SqlServerUpdate("DECLARE @idnt INT=" + address.Id + ", @default BIT='" + address.Default + "', @person INT=" + address.Person.Id + ", @telephone NVARCHAR(250)='" + address.Telephone + "', @email NVARCHAR(250)='" + address.Email + "', @location NVARCHAR(250)='" + address.Location + "', @user INT=" + address.AddedBy.Id + ", @notes NVARCHAR(250)='" + address.Notes + "'; IF NOT EXISTS (SELECT pa_idnt FROM PersonAddress WHERE pa_idnt=@idnt) BEGIN INSERT INTO PersonAddress(pa_default, pa_person, pa_telephone, pa_email, pa_location, pa_added_by, pa_notes) output INSERTED.pa_idnt VALUES (@default, @person, @telephone, @email, @location, @user, @notes) END ELSE BEGIN UPDATE PersonAddress SET pa_default=@default, pa_person=@person, pa_telephone=@telephone, pa_email=@email, pa_location=@location, pa_notes=@notes output INSERTED.pa_idnt WHERE pa_idnt=@idnt END"); return(address); }
public virtual void UpdateAddress(PersonAddress address) { using (var scope = _session.BeginTransaction()) { _session.Update(address); scope.Commit(); } }
public static void InsertAddress(PersonAddress address) { using (var context = new MyDBEntities()) { context.PersonAddresses.Add(address); context.SaveChanges(); } }
public virtual void AddPersonAddress(PersonAddress personAddress) { if (PersonAddresses.Contains(personAddress)) { return; } PersonAddresses.Add(personAddress); personAddress.Person = this; }
public void btn_submit_Clicked() { // NEED TO DO VERIFICATION ON FORM. TRY CATCH ON REQUIRED EMPTY VARIABLES? if (string.IsNullOrEmpty(view.getMiddleName())) { personBuilder .WithNoMiddleName((Prefix)Enum.Parse(typeof(Prefix), view.getTitle()), view.getFirstName(), view.getLastName()); if (string.IsNullOrEmpty(view.getEmergency())) { personBuilder .WithPrimaryContactOnly(view.getPhone()); if (string.IsNullOrEmpty(view.getSecondLine()) && string.IsNullOrEmpty(view.getThirdLine())) { addressBuilder .OneLineAddress(view.getFirstLine(), view.getCity(), view.getCounty(), view.getPostcode()); } else if (string.IsNullOrEmpty(view.getThirdLine())) { addressBuilder .TwoLineAddress(view.getFirstLine(), view.getSecondLine(), view.getCity(), view.getCounty(), view.getPostcode()); } else { addressBuilder .ThreeLineAddress(view.getFirstLine(), view.getSecondLine(), view.getThirdLine(), view.getCity(), view.getCounty(), view.getPostcode()); } } else { personBuilder .WithAllContacts(view.getPhone(), view.getEmergency()); } } else { personBuilder .WithMiddleName((Prefix)Enum.Parse(typeof(Prefix), view.getTitle()), view.getFirstName(), view.getMiddleName(), view.getLastName()); } gp = personBuilder.Build(); address = addressBuilder.Build(); GP practice = new GP(); practice.GPPractice = view.getPracticeName(); MemberDB.InsertGP(gp); AddressDB.InsertAddress(address); GPDB.InsertGP(practice); ConfirmationForm cForm = new ConfirmationForm(); ConfirmationPresenter cPresenter = new ConfirmationPresenter(cForm); cForm.Show(); }
public static GeographyView BuildGeographyView(PersonAddress geog) { GeographyView view = BuildGeographyView(geog.Location); view.Id = geog.Id; view.Kind = Kinds.Member_Residence; view.Description = string.Format("{0}\n{1}\n{2}, {3}", geog.Person.FullName, geog.Street, geog.City, geog.Zip); view.InstanceId = geog.Person.Id; return(view); }
public async Task <IHttpActionResult> GetPersonAddress(int id) { PersonAddress personAddress = await db.PersonAddresses.FindAsync(id); if (personAddress == null) { return(NotFound()); } return(Ok(new PersonAddressDTO(personAddress))); }
public async Task <IActionResult> Create([Bind("PersonAddressId,PersonId,AddressLine1,AddressLine2,City,State,PostalCode")] PersonAddress personAddress) { if (ModelState.IsValid) { _context.Add(personAddress); await _context.SaveChangesAsync(); return(RedirectToAction("Details", "Clients", new { id = personAddress.PersonId }, null)); } ViewData["PersonId"] = new SelectList(_context.Persons, "PersonId", "FullName", personAddress.PersonId); return(View(personAddress)); }
/// <summary> /// Creates an MKPlacemark for an assignment /// </summary> public static MKPlacemark ToPlacemark(this Assignment assignment) { var address = new PersonAddress(); address.Street = assignment.JobNumberFormatted + " - " + assignment.Address; address.City = assignment.City; address.State = assignment.State; address.Country = string.Empty; address.Dictionary [new NSString("Assignment")] = assignment.WrapObject(); return(new MKPlacemark(new CLLocationCoordinate2D(assignment.Latitude, assignment.Longitude), address.Dictionary)); }
public async Task <IHttpActionResult> PostPersonAddress(PersonAddress personAddress) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } db.PersonAddresses.Add(personAddress); await db.SaveChangesAsync(); return(CreatedAtRoute("DefaultApi", new { id = personAddress.Id }, personAddress)); }
public IActionResult PostPersonAddress(PersonAddress data) { try { var res = _repository.AddPersonAddress(data); return(Ok(res)); } catch (Exception error) { return(BadRequest(error)); } }
public IActionResult PutPersonAddress(int id, [FromBody] PersonAddress data) { try { var res = _repository.UpdatePersonAddress(id, data); return(Ok(res)); } catch (Exception error) { return(BadRequest(error)); } }
private static PersonAddress PersonAddress(Person person, Guid addressType) { PersonAddress personAddress = person.Addresses.FindByType(addressType); if (personAddress == null) { personAddress = new PersonAddress(); personAddress.AddressType = new Lookup(addressType); personAddress.Address = new Address(); person.Addresses.Add(personAddress); } return(personAddress); }
public void EqualsFieldsTest() { var val1 = new PersonAddress() { Id = Guid.NewGuid(), City = _city.Name, Number = "NUMBERTESTE", Neighborhood = "BAIRRO DE TESTE", StreetName = "NOME DA RUA" }; var val2 = new PersonAddress() { Id = Guid.NewGuid(), City = _city.Name, Number = "NUMBERTESTE", Neighborhood = "BAIRRO DE TESTE", StreetName = "NOME DA RUA" }; Assert.Equal(val1, val2); }
public void EqualsPostalCodeTest() { var val1 = new PersonAddress() { Id = Guid.NewGuid(), PostalCode = "POSTAL CODE TESTE" }; var val2 = new PersonAddress() { Id = Guid.NewGuid(), PostalCode = "POSTAL CODE TESTE" }; Assert.Equal(val1, val2); }
private static List <PersonAddress> GetAddresses(this PersonDTO inputPerson) { var addresses = new List <PersonAddress>(); foreach (var address in inputPerson.ContactData.Addresses) { var addressType = AddressType.Other; switch (address.Location) { case "Home": addressType = AddressType.Home; break; case "Previous": addressType = AddressType.Previous; break; case "Work": addressType = AddressType.Work; break; case "Other": addressType = AddressType.Other; break; } var importAddress = new PersonAddress { PersonId = inputPerson.Id, Street1 = address.Street ?? string.Empty, // Null is not an acceptable value in this field. City = address.City ?? string.Empty, State = address.State ?? string.Empty, PostalCode = address.Zip ?? string.Empty, // Null is not an acceptable value in this field. AddressType = addressType }; /* * Shaun Cummings - 10/14/20 * * Addresses cannot be added to this collection unless they have a value in Street1 and PostalCode or else they will * create a NullReference exception in Slingshot.Core\Utilities\ImportPackage.cs at line 367 (this is due to using the * .Equals() method directly on the property, which assumes the property is not null). * * */ addresses.Add(importAddress); } return(addresses); }
protected void btnSubmit_Click(object sender, EventArgs e) { try { CommunityAssistEntities cae = new CommunityAssistEntities(); Person p = new Person(); p.FirstName = txtFirstname.Text; p.LastName = txtLastName.Text; cae.People.Add(p); PersonAddress pa = new PersonAddress(); pa.Person = p; pa.Street = txtAddress.Text; pa.City = txtCity.Text; pa.State = txtState.Text; pa.Zip = txtZipCode.Text; cae.PersonAddresses.Add(pa); PersonContact pc = new PersonContact(); pc.Person = p; pc.ContactInfo = txtEmail.Text; pc.ContactTypeKey = 6; cae.PersonContacts.Add(pc); PersonContact phone = new PersonContact(); phone.Person = p; phone.ContactInfo = txtHomePhone.Text; phone.ContactTypeKey = 1; cae.PersonContacts.Add(phone); Donation d = new Donation(); d.DonationDate = DateTime.Now; d.Person = p; d.DonationAmount = decimal.Parse(txtDonation.Text); cae.Donations.Add(d); cae.SaveChanges(); txtError.Text = "Donation Submitted"; } catch (Exception ex) { txtError.Text = ex.Message; } }
public static void AddAddresses(Person person, ICollection<AddressPersonRel> list) { foreach (var item in list) { var addr = new PersonAddress() { Street = item.Address.Address1, Street2 = item.Address.Address2, City = item.Address.City, StateId = item.Address.StateId, County = item.Address.County, ZipCode = $"{item.Address.Zip5}-{item.Address.Zip4}", Country = item.Address.Country, Latitude = item.Address.Latitude, Longitude = item.Address.Longitude, DateCreated = item.DateCreated, DateUpdated = item.DateModified //todo: need primarystatus here }; person.PersonAddresses.Add(addr); person.LogEntries.Add(new PersonLogEntry() { Note = $"Added address" }); } }
protected int GetPersonIdFromInputData() { string sFirstName = tbFirstName.Text; string sLastName = tbLastName.Text; string sEmail = tbEmail.Text; string sAddress = tbAddress1.Text; string sCity = tbCity.Text; string sState = tbState.Text; string sZip = tbZip.Text; string sPhone = tbPhone.Text; PersonCollection personCollection = new PersonCollection(); personCollection.LoadByEmail(sEmail); int iFoundPersonId = -1; foreach (Person person in personCollection) { PersonPhone phoneSearch = new PersonPhone(person.PersonID, FormatPhone(sPhone)); if ((phoneSearch.PersonID == person.PersonID) && (person.LastName.ToLower() == sLastName.ToLower())) { this.currentAddress = person.Addresses.FindByType(41); if(this.currentAddress.Address.PostalCode.Substring(0,5) == sZip ) { iFoundPersonId = person.PersonID; } } } if (iFoundPersonId > 0) { //person in the db //easy ride... } else { //create the family for the person Family family = new Family(); family.OrganizationID = CurrentArenaContext.Organization.OrganizationID; family.FamilyName = sLastName + " Family"; //add person to the family FamilyMember familyMember = new FamilyMember(); family.FamilyMembers.Add(familyMember); // // Ensure some of the basics are set correctly. // if ((familyMember.Campus == null || familyMember.Campus.CampusId == -1) && NewPersonCampusSetting != -1) familyMember.Campus = new Campus(NewPersonCampusSetting); if (familyMember.MemberStatus == null || familyMember.MemberStatus.LookupID == -1) familyMember.MemberStatus = new Lookup(NewPersonStatusSetting); if (familyMember.RecordStatus == Arena.Enums.RecordStatus.Undefined) familyMember.RecordStatus = Arena.Enums.RecordStatus.Pending; //add person to the db familyMember.FirstName = sFirstName; familyMember.FirstName = sFirstName; familyMember.LastName = sLastName; familyMember.FamilyRole = new Lookup(new Guid("e410e1a6-8715-4bfb-bf03-1cd18051f815")); familyMember.Gender = Arena.Enums.Gender.Unknown; familyMember.MaritalStatus = new Lookup(new Guid("9C000CF2-677B-4725-981E-BD555FDAFB30")); //add email to db and person to email PersonEmail personEmail = new PersonEmail(); personEmail.Email = sEmail; personEmail.Active = true; familyMember.Emails.Add(personEmail); //add address to db and person to address PersonAddress personAddress = new PersonAddress(); personAddress.Address.StreetLine1 = sAddress; personAddress.Address.City = sCity; personAddress.Address.State = sState; personAddress.Address.PostalCode = sZip; personAddress.AddressType = new Lookup(41); personAddress.Address.Standardize(); this.currentAddress = personAddress; familyMember.Addresses.Add(personAddress); //add phone to db and person to phone PersonPhone personPhone = new PersonPhone(); personPhone.PhoneType = new Lookup(new Guid("f2a0fba2-d5ab-421f-a5ab-0c67db6fd72e")); familyMember.Phones.Add(personPhone); personPhone.Number = FormatPhone(sPhone); //Save All family.Save(ModuleUserName); familyMember.Save(CurrentOrganization.OrganizationID, ModuleUserName, true); familyMember.SaveEmails(CurrentPortal.OrganizationID, ModuleUserName); familyMember.SaveAddresses(CurrentPortal.OrganizationID, ModuleUserName); familyMember.SavePhones(CurrentPortal.OrganizationID, ModuleUserName); familyMember.Save(CurrentUser.Identity.Name); iFoundPersonId = familyMember.PersonID; } return iFoundPersonId; }
/// <summary> /// Create a new PersonAddress object. /// </summary> /// <param name="personID">Initial value of PersonID.</param> public static PersonAddress CreatePersonAddress(int personID) { PersonAddress personAddress = new PersonAddress(); personAddress.PersonID = personID; return personAddress; }
/// <summary> /// There are no comments for PersonAddress in the schema. /// </summary> public void AddToPersonAddress(PersonAddress personAddress) { base.AddObject("PersonAddress", personAddress); }