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(); }