public void UpdateBeer(BeerData beerData, BeerBarcode beerBarData, double productArticle) //Info passed back to Form1 where it is linked to the textboxes { //LINQ query to the database where the products in the update textboxes are populated back to the DB using (var context = new GroceryTestDBEntities()) { var query = from s in context.BeerDatas where s.Article == productArticle select s; var query1 = from s in context.BeerBarcodes where s.Article == productArticle select s; var beerProducts = query.FirstOrDefault(); var beerProductswithBarcode = query1.FirstOrDefault(); beerProducts.Article = beerData.Article; beerProducts.Article_Description = beerData.Article_Description; beerProductswithBarcode.Article = beerBarData.Article; beerProductswithBarcode.Barcode = beerBarData.Barcode; beerProducts.Storage_Bin = beerData.Storage_Bin; beerProducts.Department = beerData.Department; beerProducts.Sub_Department = beerData.Sub_Department; context.SaveChanges(); } }
public IHttpActionResult PartialUpdate(int id, BeerPartialData data) { if (data is null || !ModelState.IsValid) { return(BadRequest("Data is required !")); } Beer originalData = BeerService.Instance.GetOne(id); if (originalData is null) { return(BadRequest("An error occurred during the request")); } BeerData updateData = new BeerData() { Name = data.Name ?? originalData.Name, Color = data.Color ?? originalData.Color, Degree = data.Degree ?? originalData.Degree, IdBrewery = data.IdBrewery ?? originalData.Brewery.Id, IdBrand = data.IdBrand ?? originalData.Brand?.Id }; bool isUpdated = BeerService.Instance.Update(id, updateData); if (isUpdated) { return(Json(BeerService.Instance.GetOne(id))); } else { return(BadRequest("An error occurred during the request")); } }
public IHttpActionResult Insert(BeerData data) { if (data is null || !ModelState.IsValid) { return(BadRequest("Data is required !")); } int newId = BeerService.Instance.Add(data); return(Json(BeerService.Instance.GetOne(newId))); }
public bool Update(int id, BeerData beerData) { bool isUpdated = beerRepository.Update(id, new Demo_API_BeerAPI.DAL.Entities.BeerEntity() { Name = beerData.Name, Color = beerData.Color, Degree = beerData.Degree, IdBrewery = beerData.IdBrewery, IdBrand = beerData.IdBrand }); return(isUpdated); }
public int Add(BeerData beerData) { int newId = beerRepository.Insert(new Demo_API_BeerAPI.DAL.Entities.BeerEntity() { Name = beerData.Name, Color = beerData.Color, Degree = beerData.Degree, IdBrewery = beerData.IdBrewery, IdBrand = beerData.IdBrand }); return(newId); }
private DynamicParameters GetParameters(BeerData data, int page) { var queryParameters = new DynamicParameters(); queryParameters.Add("@Id", data.Id); queryParameters.Add("@Name", data.Name); queryParameters.Add("@NameDisplay", data.NameDisplay); queryParameters.Add("@Abv", data.Abv); queryParameters.Add("@CreateDate", DateTime.Now); queryParameters.Add("@UpdateDate", DateTime.Now); queryParameters.Add("@IsOrganic", data.IsOrganic); queryParameters.Add("@IsRetired", data.IsRetired); queryParameters.Add("@BeerLabelsId", data.Labels.Id); queryParameters.Add("@BeerStylesId", data.Style.Id); queryParameters.Add("@Page", page); return(queryParameters); }
public IHttpActionResult FullUpdate(int id, BeerData data) { if (data is null || !ModelState.IsValid) { return(BadRequest("Data is required !")); } bool isUpdated = BeerService.Instance.Update(id, data); if (isUpdated) { return(Json(BeerService.Instance.GetOne(id))); } else { return(BadRequest("An error occurred during the request")); } }
public IHttpActionResult UpdateBeer(BeerData beer) { if (!ModelState.IsValid) { return(BadRequest("Not a valid model")); } var status = GetJsonData.UpdateBeerRating(beer); if (status) { return(Ok()); } else { return(BadRequest("Invalid data.")); } }
public IHttpActionResult PostNewBeer(BeerData beer) { if (!ModelState.IsValid) { return(BadRequest("Invalid data.")); } var status = GetJsonData.PostNewBeer(beer); if (status) { return(Ok()); } else { return(BadRequest("Invalid data.")); } }
private void UpdateBeerProduct() { // Update the products in the DB based off what is entered into the update textboxes BeerData beerProducts = new BeerData(); BeerBarcode beerProductsWithBarcode = new BeerBarcode(); double article = Convert.ToDouble(txtUpdateArticle.Text); beerProducts.Article = Convert.ToDouble(txtUpdateArticle.Text); beerProducts.Article_Description = txtUpdateDesc.Text; beerProductsWithBarcode.Article = Convert.ToDouble(txtUpdateArticle.Text); beerProductsWithBarcode.Barcode = Convert.ToDouble(txtUpdateBarcode.Text); beerProducts.Storage_Bin = txtUpdateStorage.Text; beerProducts.Department = txtUpdateDept.Text; beerProducts.Sub_Department = txtUpdateSubDept.Text; myLinqUpdateCalls.UpdateBeer(beerProducts, beerProductsWithBarcode, article); ClearAddTextBoxes(); ClearUpdateTextBoxes(); RefreshDGV(); }
public async Task InsertBeerAsync(BeerData data, int page) { using (var connection = new SqlConnection(this.config["DBConnectionString"])) { connection.Open(); using (var transaction = connection.BeginTransaction()) { try { var result = await connection.QueryAsync <BeerCategory>("InsertBeerData", this.GetParameters(data, page), commandType : CommandType.StoredProcedure, transaction : transaction); transaction.Commit(); } catch (Exception ex) { transaction.Rollback(); throw ex; } } } }
private void AddBeerProduct() { // Adds products to the DB based off what is entered into the text boxes using (var context = new GroceryTestDBEntities()) { var products = new BeerData(); var productbarcode = new BeerBarcode(); products.Article = Convert.ToDouble(txtAddArticle.Text); products.Article_Description = txtAddDesc.Text; productbarcode.Article = Convert.ToDouble(txtAddArticle.Text); productbarcode.Barcode = Convert.ToDouble(txtAddBarcode.Text); products.Storage_Bin = txtAddStorage.Text; products.Department = txtAddDept.Text; products.Sub_Department = txtAddSubDept.Text; MessageBox.Show(products.Article_Description + " was added to the Database."); context.BeerDatas.Add(products); context.BeerBarcodes.Add(productbarcode); context.SaveChanges(); ClearAddTextBoxes(); } }