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