public PersonEntity Create(PersonEntity entity) { using (IDatabaseProvider provider = ProviderFactory.GetProvider(_connectionStringName)) { return provider.Insert<PersonEntity>(entity); } }
public PersonEntity Update(PersonEntity entity) { using (IDatabaseProvider provider = ProviderFactory.GetProvider(_connectionStringName)) { PersonEntity entityToUpdate = Read(entity.Id); if (entityToUpdate == null) throw new DataAccessException("Item not found"); // This should not happen seeing that validation should check. entityToUpdate = UpdateProperties(entity, entityToUpdate); provider.Update<PersonEntity>(entityToUpdate); return entityToUpdate; } }
public static PersonEntity GetItemForInsert() { PersonEntity entity = new PersonEntity() { EntityId = ContactDetailsHelpers.CreateEntity().Id, OccupationNameId = ContactDetailsHelpers.CreateOccupationName().Id, TitleId = ContactDetailsHelpers.CreateTitle().Id, SurnamePrefix = "Von", Surname = "SurnamePerson1", MaidenNamePrefix = "", Nationality = "NL", PlaceOfBirth = "Sasol", DeletedDate = DateTime.MinValue }; return entity; }
public ContactDetail Post(ContactDetail request) { PersonRepository personRepository = GetPersonRepository(); EntityRepository entityRepository = GetEntityRepository(); PersonEntity personEntity = new PersonEntity(); EntityEntity entity = new EntityEntity(); //Create entity entity.Name = request.EntityName; entity.EntityTypeId = request.EntityTypeId; entity.DeletedDate = DateTime.MinValue; entity = entityRepository.Create(entity); personEntity.EntityId = entity.Id; personEntity.OccupationNameId = request.OccupationNameId; personEntity.TitleId = request.TitleId; personEntity.GenderTypeId = request.GenderTypeId; personEntity.SurnamePrefix = request.SurnamePrefix; personEntity.Surname = request.Surname; personEntity.MaidenNamePrefix = request.MaidenNamePrefix; personEntity.Nationality = request.Nationality; personEntity.DateOfBirth = request.DateOfBirth; personEntity.PlaceOfBirth = request.PlaceOfBirth; personEntity.DeletedDate = DateTime.MinValue; try { personEntity = personRepository.Create(personEntity); } catch (Exception ex) { Console.WriteLine(ex); } List<PersonEntity> personEntities = personRepository.Read(); return CreateGetContactDetails(entity, personEntities); }
private static void CreatePerson() { PersonRepository repository = new PersonRepository(ConfigSettings.MySqlDatabaseConnectionName); PersonEntity entity = new PersonEntity() { EntityId = _entityEntities[0].Id, OccupationNameId = _occupationNameEntities[0].Id, TitleId = _titleEntities[0].Id, GenderTypeId = _genderTypeEntities[0].Id, SurnamePrefix = "van", Surname = "Riebeeck", MaidenNamePrefix = string.Empty, Nationality = "nl", DateOfBirth = DateTime.UtcNow.AddYears(-34), PlaceOfBirth = "Houten", DeletedDate = DateTime.MinValue }; PersonEntity mEntity = new PersonEntity() { EntityId = _entityEntities[1].Id, OccupationNameId = _occupationNameEntities[1].Id, TitleId = _titleEntities[1].Id, GenderTypeId = _genderTypeEntities[1].Id, SurnamePrefix = string.Empty, Surname = "Stel", MaidenNamePrefix = "", Nationality = "BL", DateOfBirth = DateTime.UtcNow.AddYears(-37), PlaceOfBirth = "Zeist", DeletedDate = DateTime.MinValue }; entity = repository.Create(entity); mEntity = repository.Create(mEntity); _personEntities.Add(entity); _personEntities.Add(mEntity); }
public PersonEntity Delete(PersonEntity entity) { entity.DeletedDate = DateTime.UtcNow; return Update(entity); }
private PersonEntity UpdateProperties(PersonEntity entity, PersonEntity entityToUpdate) { entityToUpdate.EntityId = entity.EntityId; entityToUpdate.OccupationNameId = entity.OccupationNameId; entityToUpdate.TitleId = entity.TitleId; entityToUpdate.SurnamePrefix = entity.SurnamePrefix; entityToUpdate.Surname = entity.Surname; entityToUpdate.MaidenNamePrefix = entity.MaidenNamePrefix; entityToUpdate.Nationality = entity.Nationality; entityToUpdate.DateOfBirth = entity.DateOfBirth; entityToUpdate.PlaceOfBirth = entity.PlaceOfBirth; entityToUpdate.DeletedDate = entity.DeletedDate; return entityToUpdate; }