public void DeleteCategory(int categoryId)
{
BeerCategory cate = this.SearchCategory(categoryId);
this.context.BeerCategory.Remove(cate);
this.context.SaveChanges();
}
private DynamicParameters GetParameters(BeerCategory category)
{
var queryParameters = new DynamicParameters();
queryParameters.Add("@Name", category.Name);
return(queryParameters);
}
public void EditCategory(BeerCategory category)
{
BeerCategory cate = this.SearchCategory(category.BeerCategoryId);
cate.Description = category.Description;
cate.ShortName = category.ShortName;
this.context.SaveChanges();
}
public BreweryDb(string key)
{
_key = key;
Adjunct = new Adjunct(_client, _baseAddress, _key);
Brewery = new Brewery(_client, _baseAddress, _key);
Yeast = new Yeast(_client, _baseAddress, _key);
Style = new Style(_client, _baseAddress, _key);
SocialSite = new SocialSite(_client, _baseAddress, _key);
Ingredient = new Ingredient(_client, _baseAddress, _key);
Hop = new Hop(_client, _baseAddress, _key);
BeerCategory = new BeerCategory(_client, _baseAddress, _key);
Beer = new Beer(_client, _baseAddress, _key);
Feature = new Feature(_client, _baseAddress, _key);
Fermentable = new Fermentable(_client, _baseAddress, _key);
}
public async Task <ICollection <BeerCategory> > InsertBeerCategoryAsync(BeerCategory category)
{
using (var connection = new SqlConnection(this.config["DBConnectionString"]))
{
connection.Open();
using (var transaction = connection.BeginTransaction())
{
try
{
var result = await connection.QueryAsync <BeerCategory>("InsertBeerCategories", this.GetParameters(category), commandType : CommandType.StoredProcedure, transaction : transaction);
transaction.Commit();
return((ICollection <BeerCategory>)result);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public async Task <ICollection <BeerCategory> > InsertBeerCategoryAsync(BeerCategory category)
{
return(await this.beerCategoryGateway.InsertBeerCategoryAsync(category));
}
public void EditBeer(BeerCategory category)
{
this.repo.EditCategory(category);
}
public void CreateBeer(BeerCategory category)
{
this.repo.CreateCategory(category);
}
public void CreateCategory(BeerCategory category)
{
category.BeerCategoryId = this.GetNextId("beercategory");
this.context.BeerCategory.Add(category);
this.context.SaveChanges();
}
