public void UpdateDairy(DairyData dairyData, DairyBarcode dairyBarData, 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.DairyDatas
where s.Article == productArticle
select s;
var query1 = from s in context.DairyBarcodes
where s.Article == productArticle
select s;
var dairyProducts = query.FirstOrDefault();
var dairyProductsWithBarcode = query1.FirstOrDefault();
dairyProducts.Article = dairyData.Article;
dairyProducts.Article_Description = dairyData.Article_Description;
dairyProductsWithBarcode.Article = dairyBarData.Article;
dairyProductsWithBarcode.Barcode = dairyBarData.Barcode;
dairyProducts.Storage_Bin = dairyData.Storage_Bin;
dairyProducts.Department = dairyData.Department;
dairyProducts.Sub_Department = dairyData.Sub_Department;
context.SaveChanges();
}
}
private void UpdateDairyProduct()
{
// Update the products in the DB based off what is entered into the update textboxes
DairyData dairyProducts = new DairyData();
DairyBarcode dairyProductsWithBarcode = new DairyBarcode();
double article = Convert.ToDouble(txtUpdateArticle.Text);
dairyProducts.Article = Convert.ToDouble(txtUpdateArticle.Text);
dairyProducts.Article_Description = txtUpdateDesc.Text;
dairyProductsWithBarcode.Article = Convert.ToDouble(txtUpdateArticle.Text);
dairyProductsWithBarcode.Barcode = Convert.ToDouble(txtUpdateBarcode.Text);
dairyProducts.Storage_Bin = txtUpdateStorage.Text;
dairyProducts.Department = txtUpdateDept.Text;
dairyProducts.Sub_Department = txtUpdateSubDept.Text;
myLinqUpdateCalls.UpdateDairy(dairyProducts, dairyProductsWithBarcode, article);
ClearAddTextBoxes();
ClearUpdateTextBoxes();
RefreshDGV();
}
private void AddDairyProduct()
{
// Adds products to the DB based off what is entered into the text boxes
using (var context = new GroceryTestDBEntities())
{
var products = new DairyData();
var productbarcode = new DairyBarcode();
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.DairyDatas.Add(products);
context.DairyBarcodes.Add(productbarcode);
context.SaveChanges();
ClearAddTextBoxes();
}
}
