/// <summary> /// Creates a person dependent /// </summary> /// <param name="newPerson">The person to create</param> /// <param name="emails">The email addresses</param> /// <returns></returns> private async Task <PersonDependent> CreatePersonDependentAsync(NewPersonDependent newPerson, List <EmailAddress> emails) { var countriesOfCitizenship = GetCitizenshipCountriesById(0, newPerson.CountriesOfCitizenship); var dependent = new PersonDependent { PersonId = newPerson.PersonId, DependentTypeId = newPerson.DependentTypeId, FirstName = newPerson.FirstName, LastName = newPerson.LastName, NameSuffix = newPerson.NameSuffix, PassportName = newPerson.PassportName, PreferredName = newPerson.PreferredName, GenderId = newPerson.GenderId, DateOfBirth = newPerson.DateOfBirth, PlaceOfBirthId = newPerson.PlaceOfBirthId, PlaceOfResidenceId = newPerson.PlaceOfResidenceId, BirthCountryReasonId = newPerson.BirthCountryReasonId, EmailAddresses = emails, CountriesOfCitizenship = countriesOfCitizenship, IsTravellingWithParticipant = newPerson.IsTravellingWithParticipant }; newPerson.Audit.SetHistory(dependent); this.Context.PersonDependents.Add(dependent); this.logger.Trace("Creating new person dependent {0}.", newPerson); return(dependent); }
private void SetDependentEmails(List <EmailAddress> emails, PersonDependent dependent) { Contract.Requires(emails != null, "The country ids must not be null."); Contract.Requires(dependent != null, "The dependent entity must not be null."); dependent.EmailAddresses.Clear(); emails.ForEach(x => { dependent.EmailAddresses.Add(x); }); }
public void TestGetDS2019FileName() { var instance = new PersonDependent { DependentId = Int32.MaxValue, SevisId = "N123456789" }; Assert.AreEqual(string.Format(PersonDependent.DS2019_FILE_NAME_FORMAT_STRING, instance.DependentId, instance.SevisId), instance.GetDS2019FileName()); }
public bool Insert(PersonDependent persondependent) { int autonumber = 0; PersonDependentDAC persondependentComponent = new PersonDependentDAC(); bool endedSuccessfuly = persondependentComponent.InsertNewPersonDependent(ref autonumber, persondependent.PersonId, persondependent.DependentName, persondependent.Gender, persondependent.Age, persondependent.DateOfBirth, persondependent.Relation, persondependent.DateModified); if (endedSuccessfuly) { persondependent.PersonDependentId = autonumber; } return(endedSuccessfuly); }
private void DoDelete(PersonDependent dependentToDelete) { if (dependentToDelete != null) { var email = dependentToDelete.EmailAddresses.FirstOrDefault(); if (email != null) { Context.EmailAddresses.Remove(email); } Context.PersonDependents.Remove(dependentToDelete); } }
public void TestCreateGetRelatedPersonByDependentFamilyMemberQuery_CheckProperties() { var spousePersonType = new DependentType { DependentTypeId = DependentType.Spouse.Id }; var gender = new Gender { GenderId = Gender.Female.Id, GenderName = Gender.Female.Value }; var person = new Person { PersonId = 10, GenderId = gender.GenderId, Gender = gender }; var dependent = new PersonDependent { DependentTypeId = spousePersonType.DependentTypeId, DependentId = 2, PersonId = person.PersonId, FirstName = "firstName", LastName = "lastName", NameSuffix = "III", GenderId = gender.GenderId, Person = person }; var status = new ParticipantStatus { ParticipantStatusId = 1, Status = "status" }; var participant = new Participant { Status = status, Person = person, }; context.ParticipantStatuses.Add(status); person.Participations.Add(participant); person.Family.Add(dependent); context.People.Add(person); context.PersonDependents.Add(dependent); context.DependentTypes.Add(spousePersonType); var result = PersonQueries.CreateGetRelatedPersonByDependentFamilyMemberQuery(context, dependent.DependentId).FirstOrDefault(); Assert.IsNotNull(result); Assert.AreEqual(person.PersonId, result.PersonId); }
private async Task <int?> GetParticipantIdAsync(PersonDependent personDependent) { int?participantId = null; var personId = personDependent.PersonId; var person = await Context.People.FindAsync(personId); if (person != null) { participantId = await GetParticipantIdAsync(person); } return(participantId); }
private int?GetParticipantId(PersonDependent personDependent) { int?participantId = null; var personId = personDependent.PersonId; var person = Context.People.Find(personId); if (person != null) { participantId = GetParticipantId(person); } return(participantId); }
public List <PersonDependent> GetAll() { PersonDependentDAC _personDependentComponent = new PersonDependentDAC(); IDataReader reader = _personDependentComponent.GetAllPersonDependent().CreateDataReader(); List <PersonDependent> _personDependentList = new List <PersonDependent>(); while (reader.Read()) { if (_personDependentList == null) { _personDependentList = new List <PersonDependent>(); } PersonDependent _personDependent = new PersonDependent(); if (reader["PersonDependentId"] != DBNull.Value) { _personDependent.PersonDependentId = Convert.ToInt32(reader["PersonDependentId"]); } if (reader["PersonId"] != DBNull.Value) { _personDependent.PersonId = Convert.ToInt32(reader["PersonId"]); } if (reader["DependentName"] != DBNull.Value) { _personDependent.DependentName = Convert.ToString(reader["DependentName"]); } if (reader["Gender"] != DBNull.Value) { _personDependent.Gender = Convert.ToString(reader["Gender"]); } if (reader["Age"] != DBNull.Value) { _personDependent.Age = Convert.ToInt32(reader["Age"]); } if (reader["DateOfBirth"] != DBNull.Value) { _personDependent.DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]); } if (reader["Relation"] != DBNull.Value) { _personDependent.Relation = Convert.ToString(reader["Relation"]); } if (reader["DateModified"] != DBNull.Value) { _personDependent.DateModified = Convert.ToDateTime(reader["DateModified"]); } _personDependent.NewRecord = false; _personDependentList.Add(_personDependent); } reader.Close(); return(_personDependentList); }
public PersonDependent GetByID(int _personDependentId) { PersonDependentDAC _personDependentComponent = new PersonDependentDAC(); IDataReader reader = _personDependentComponent.GetByIDPersonDependent(_personDependentId); PersonDependent _personDependent = null; while (reader.Read()) { _personDependent = new PersonDependent(); if (reader["PersonDependentId"] != DBNull.Value) { _personDependent.PersonDependentId = Convert.ToInt32(reader["PersonDependentId"]); } if (reader["PersonId"] != DBNull.Value) { _personDependent.PersonId = Convert.ToInt32(reader["PersonId"]); } if (reader["DependentName"] != DBNull.Value) { _personDependent.DependentName = Convert.ToString(reader["DependentName"]); } if (reader["Gender"] != DBNull.Value) { _personDependent.Gender = Convert.ToString(reader["Gender"]); } if (reader["Age"] != DBNull.Value) { _personDependent.Age = Convert.ToInt32(reader["Age"]); } if (reader["DateOfBirth"] != DBNull.Value) { _personDependent.DateOfBirth = Convert.ToDateTime(reader["DateOfBirth"]); } if (reader["Relation"] != DBNull.Value) { _personDependent.Relation = Convert.ToString(reader["Relation"]); } if (reader["DateModified"] != DBNull.Value) { _personDependent.DateModified = Convert.ToDateTime(reader["DateModified"]); } _personDependent.NewRecord = false; } reader.Close(); return(_personDependent); }
private void DoDependentUpdate(UpdatedPersonDependent updateDependent, PersonDependent dependent, List <EmailAddress> emails) { dependent.DependentTypeId = updateDependent.DependentTypeId; dependent.FirstName = updateDependent.FirstName; dependent.LastName = updateDependent.LastName; dependent.NameSuffix = updateDependent.NameSuffix; dependent.PassportName = updateDependent.PassportName; dependent.PreferredName = updateDependent.PreferredName; dependent.GenderId = updateDependent.GenderId; dependent.DateOfBirth = updateDependent.DateOfBirth; dependent.PlaceOfBirthId = updateDependent.PlaceOfBirthId; dependent.PlaceOfResidenceId = updateDependent.PlaceOfResidenceId; dependent.BirthCountryReasonId = updateDependent.BirthCountryReasonId; dependent.IsTravellingWithParticipant = updateDependent.IsTravellingWithParticipant; dependent.IsDeleted = updateDependent.IsDeleted; updateDependent.Audit.SetHistory(dependent); SetDependentCountriesOfCitizenship(updateDependent.CountriesOfCitizenship, dependent); SetDependentEmails(emails, dependent); }
public void TestCreateGetRelatedPersonByDependentFamilyMemberQuery_DepdendentDoesNotHaveFamily() { var spousePersonType = new DependentType { DependentTypeId = DependentType.Spouse.Id }; var dependent = new PersonDependent { DependentId = 10, DependentTypeId = spousePersonType.DependentTypeId, DependentType = spousePersonType }; context.PersonDependents.Add(dependent); context.DependentTypes.Add(spousePersonType); var result = PersonQueries.CreateGetRelatedPersonByDependentFamilyMemberQuery(context, dependent.DependentId).FirstOrDefault(); Assert.IsNull(result); }
public async Task TestProcessTransactionLog_TransactionLogHasNewParticipantAndNewDependent() { var expectedParticipantSevisId = "N0000158857"; var expectedDependentSevisId = "N0000158274"; var transactionXml = ECA.Business.Test.Properties.Resources.TransactionLogWithNewParticipantAndNewDependent; var batchXml = ECA.Business.Test.Properties.Resources.NewParticipantWithNewDependentBatchXml; var user = new User(1); var yesterday = DateTimeOffset.UtcNow.AddDays(-1.0); var otherUser = new User(user.Id + 1); var batchId = "----kynEn47azQ"; Participant participant = null; ParticipantPerson participantPerson = null; PersonDependent personDependent = null; Data.Person person = null; SevisBatchProcessing batch = null; ExchangeVisitorHistory history = null; var personId = 63280; var participantId = 59079; context.SetupActions.Add(() => { batch = new SevisBatchProcessing { BatchId = batchId, Id = 1, SendString = batchXml }; participant = new Participant { ParticipantId = participantId }; participantPerson = new ParticipantPerson { ParticipantId = participant.ParticipantId, Participant = participant, SevisBatchResult = "sevis batch result", }; participantPerson.History.CreatedBy = otherUser.Id; participantPerson.History.CreatedOn = yesterday; participantPerson.History.RevisedBy = otherUser.Id; participantPerson.History.RevisedOn = yesterday; participant.ParticipantPerson = participantPerson; person = new Data.Person { PersonId = personId }; participant.Person = person; participant.PersonId = person.PersonId; personDependent = new PersonDependent { DependentId = 6, Person = person, PersonId = person.PersonId }; person.Family.Add(personDependent); history = new ExchangeVisitorHistory { ParticipantId = participantId }; context.ExchangeVisitorHistories.Add(history); context.PersonDependents.Add(personDependent); context.Participants.Add(participant); context.ParticipantPersons.Add(participantPerson); context.People.Add(person); context.SevisBatchProcessings.Add(batch); }); Action tester = () => { Assert.AreEqual(expectedParticipantSevisId, participantPerson.SevisId); Assert.AreEqual(expectedDependentSevisId, personDependent.SevisId); }; context.Revert(); service.ProcessTransactionLog(user, batchId, transactionXml, fileProvider.Object); tester(); context.Revert(); await service.ProcessTransactionLogAsync(user, batchId, transactionXml, fileProvider.Object); tester(); }
public bool Update(PersonDependent persondependent, int old_personDependentId) { PersonDependentDAC persondependentComponent = new PersonDependentDAC(); return(persondependentComponent.UpdatePersonDependent(persondependent.PersonId, persondependent.DependentName, persondependent.Gender, persondependent.Age, persondependent.DateOfBirth, persondependent.Relation, persondependent.DateModified, old_personDependentId)); }
private void SetDependentCountriesOfCitizenship(List <CitizenCountryDTO> countriesOfCitizenship, PersonDependent dependent) { Contract.Requires(dependent != null, "The dependent entity must not be null."); dependent.CountriesOfCitizenship.Clear(); if (countriesOfCitizenship != null) { countriesOfCitizenship.ForEach(x => { dependent.CountriesOfCitizenship.Add(new PersonDependentCitizenCountry { DependentId = dependent.DependentId, LocationId = x.LocationId, IsPrimary = x.IsPrimary }); }); } }
public void TestCreateGetRelatedPersonByDependentFamilyMemberQuery_DependentDoesNotHaveParticipantFamilyMember() { var spousePersonType = new DependentType { DependentTypeId = DependentType.Spouse.Id }; var gender = new Gender { GenderId = Gender.Female.Id, GenderName = Gender.Female.Value }; var dependent = new PersonDependent { DependentId = 1, PersonId = 10, DependentTypeId = spousePersonType.DependentTypeId, FirstName = "firstName", LastName = "lastName", NameSuffix = "III", GenderId = gender.GenderId }; var person = new Person { PersonId = 1, Alias = "alias", FamilyName = "family", FirstName = "firstName", GivenName = "givenName", LastName = "lastName", MiddleName = "middleName", NamePrefix = "Mr.", NameSuffix = "III", Patronym = "patronym", Gender = new Gender { GenderId = Gender.Female.Id, GenderName = Gender.Female.Value } }; person.Family.Add(dependent); var status = new ParticipantStatus { ParticipantStatusId = 1, Status = "status" }; var participant = new Participant { Status = status, Person = person, }; context.ParticipantStatuses.Add(status); person.Participations.Add(participant); context.People.Add(person); context.PersonDependents.Add(dependent); context.Genders.Add(person.Gender); context.DependentTypes.Add(spousePersonType); var result = PersonQueries.CreateGetRelatedPersonByDependentFamilyMemberQuery(context, dependent.DependentId).FirstOrDefault(); Assert.IsNull(result); }