public TitleEntity Create(TitleEntity entity)
{
using (IDatabaseProvider provider = ProviderFactory.GetProvider(_connectionStringName))
{
return provider.Insert<TitleEntity>(entity);
}
}
public static TitleEntity GetItemForInsert()
{
TitleEntity entity = new TitleEntity()
{
Description = "Dhr",
DeletedDate = DateTime.MinValue
};
return entity;
}
public TitleEntity Update(TitleEntity entity)
{
using (IDatabaseProvider provider = ProviderFactory.GetProvider(_connectionStringName))
{
TitleEntity 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<TitleEntity>(entityToUpdate);
return entityToUpdate;
}
}
private static void CreateTitles()
{
TitleRepository repository = new TitleRepository(ConfigSettings.MySqlDatabaseConnectionName);
TitleEntity entity = new TitleEntity()
{
Description = "Dhr",
DeletedDate = DateTime.MinValue
};
TitleEntity mEntity = new TitleEntity()
{
Description = "Mvr",
DeletedDate = DateTime.MinValue
};
entity = repository.Create(entity);
mEntity = repository.Create(mEntity);
_titleEntities.Add(entity);
_titleEntities.Add(mEntity);
}
public TitleEntity Delete(TitleEntity entity)
{
entity.DeletedDate = DateTime.UtcNow;
return Update(entity);
}
private TitleEntity UpdateProperties(TitleEntity entity, TitleEntity entityToUpdate)
{
entityToUpdate.Description = entity.Description;
entityToUpdate.DeletedDate = entity.DeletedDate;
return entityToUpdate;
}