public EntityEntity Create(EntityEntity entity)
{
using (IDatabaseProvider provider = ProviderFactory.GetProvider(_connectionStringName))
{
return provider.Insert<EntityEntity>(entity);
}
}
public static EntityEntity GetItemForInsert()
{
EntityEntity entity = new EntityEntity()
{
Name = "Enitity1",
EntityTypeId = ContactDetailsHelpers.CreateEntityType().Id,
DeletedDate = DateTime.MinValue
};
return entity;
}
public EntityEntity Update(EntityEntity entity)
{
using (IDatabaseProvider provider = ProviderFactory.GetProvider(_connectionStringName))
{
EntityEntity 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<EntityEntity>(entityToUpdate);
return entityToUpdate;
}
}
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 CreateEntities()
{
EntityRepository repository = new EntityRepository(ConfigSettings.MySqlDatabaseConnectionName);
EntityEntity entity = new EntityEntity()
{
EntityTypeId = _entityTypeEntities[0].Id,
Name = "EntityType1",
DeletedDate = DateTime.MinValue
};
EntityEntity mEntity = new EntityEntity()
{
EntityTypeId = _entityTypeEntities[1].Id,
Name = "EntityType2",
DeletedDate = DateTime.MinValue
};
entity = repository.Create(entity);
mEntity = repository.Create(mEntity);
_entityEntities.Add(entity);
_entityEntities.Add(mEntity);
}
private static ContactDetail CreateGetContactDetails(EntityEntity entityEntity,
List<PersonEntity> personEntities)
{
ContactDetail contact = new ContactDetail
{
EntityId = entityEntity.Id
};
PersonEntity personEntity = null;
if (entityEntity != null)
{
contact.EntityName = entityEntity.Name;
contact.EntityTypeId = entityEntity.EntityTypeId;
personEntity = personEntities.FirstOrDefault(x => x.EntityId == entityEntity.Id);
}
if (personEntity != null)
{
contact.PersonId = personEntity.Id;
contact.OccupationNameId = personEntity.OccupationNameId;
contact.TitleId = personEntity.TitleId;
contact.GenderTypeId = personEntity.GenderTypeId;
contact.SurnamePrefix = personEntity.SurnamePrefix;
contact.Surname = personEntity.Surname;
contact.MaidenNamePrefix = personEntity.MaidenNamePrefix;
contact.Nationality = personEntity.Nationality;
contact.DateOfBirth = personEntity.DateOfBirth;
contact.PlaceOfBirth = personEntity.PlaceOfBirth;
}
return contact;
}
public EntityEntity Delete(EntityEntity entity)
{
entity.DeletedDate = DateTime.UtcNow;
return Update(entity);
}
private EntityEntity UpdateProperties(EntityEntity entity, EntityEntity entityToUpdate)
{
entityToUpdate.EntityTypeId = entity.EntityTypeId;
entityToUpdate.Name = entity.Name;
entityToUpdate.DeletedDate = entity.DeletedDate;
return entityToUpdate;
}