public DaoResponse<Category> Insert(Category entity)
{
using (var connection = _dbCommProvider.CreateDbConnection())
using (var command = _dbCommProvider.CreateDbCommand(connection, SqlQueries.InsertCategory, CreateCategoryParameter(entity)))
{
_dbCommProvider.ExecuteNonQuery(command);
}
return DaoResponse.QuerySuccessful(entity);
}
private Dictionary<string, QueryParameter> CreateCategoryParameter(Category entity)
{
return new Dictionary<string, QueryParameter>
{
{"?CategoryId", new QueryParameter {ParameterValue = entity.CategoryId}},
{"?Name", new QueryParameter {ParameterValue = entity.Name}},
{"?Color", new QueryParameter {ParameterValue = entity.Color}}
};
}
public void TestInsertCategoryDbAccess()
{
var dao = FactoryProvider.GetFactory<IDaoProviderFactory>(
TestDbDaoAssemblyName,
TestDbDaoNameSpace,
TestDbDaoClassName).CreateCategoryDao();
using (var scope = new TransactionScope())
{
var category = new Category
{
CategoryId = "KT",
Name = "Klassik Tanz",
Color = "#4533b4"
};
dao.Insert(category)
.OnFailure(response => Assert.Fail($"Insert does not work! {response.Exception}"));
// do not commit changes; only for testing
//scope.Complete();
}
}
private Category CreateCategoryObject(IDataReader dataReader)
{
var category = new Category
{
CategoryId = _dbCommProvider.CastDbObject<string>(dataReader, "CategoryId"),
Name = _dbCommProvider.CastDbObject<string>(dataReader, "Name"),
Color = _dbCommProvider.CastDbObject<string>(dataReader, "Color")
};
return category;
}
public DaoResponse<Category> Update(Category entity)
{
throw new NotImplementedException();
}