// gets the Product supplier combo ID
private int GetPSID(int prodID, int suppID)
{
int psID = -1;
try
{
using (TravelExpertDataDataContext dbContext = new TravelExpertDataDataContext())
{
// get values for supplier and product IDs to find the matching PSID.
int productID = Convert.ToInt32(cbProducts.SelectedValue);
int supplierID = Convert.ToInt32(cbSuppliers.SelectedValue);
// find the correct PS ID to add into the PPS table.
Products_Supplier psIDQuery = (from ps in dbContext.Products_Suppliers
where (ps.ProductId == productID &&
ps.SupplierId == supplierID)
select ps
).Single();
psID = psIDQuery.ProductSupplierId;
return(psID);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
return(psID);
}
}
/***************************************/
/* Product(s) of Supplier CRUD Buttons */
/***************************************/
private void btnAddProd_Click(object sender, EventArgs e)
{
// get the current product ID, Name and supplier ID, Name
int rowNum = Convert.ToInt32(dgvSupplier.CurrentCell.RowIndex);
int currentSupId = Convert.ToInt32(dgvSupplier["dataGridViewTextBoxColumn1", rowNum].Value);
string currentSupName = (dgvSupplier["dataGridViewTextBoxColumn2", rowNum].Value).ToString();
//string currentSupName = GetSupplierName(currentSupId);
// obtain current product ID form comboBox
int currentProdId = Convert.ToInt32(cbAddProd.SelectedValue);
// check if the current supplier already has current product in products_suppliers table
using (TravelExpertDataDataContext dbContext = new TravelExpertDataDataContext())
{
var CheckIfExists = (from ps in dbContext.Products_Suppliers
where ps.ProductId == currentProdId && ps.SupplierId == currentSupId
select ps).FirstOrDefault();
// if the record in the database already, refresh the 2 supplier list and return
if (CheckIfExists != null)
{
MessageBox.Show("The Supplier has this Product already, please check it again!");
RefreshPordOfSuppAndLists(currentSupId);
return;
}
}
// insert the new record to the database
try
{
using (TravelExpertDataDataContext dbContext = new TravelExpertDataDataContext())
{
Products_Supplier newProdSupp = new Products_Supplier
{
ProductId = currentProdId,
SupplierId = currentSupId
};
dbContext.Products_Suppliers.InsertOnSubmit(newProdSupp);
dbContext.SubmitChanges();
// refresh the product of supplier dataGridView and the two comboBoxes
RefreshPordOfSuppAndLists(currentSupId);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, ex.GetType().ToString());
}
}
// add a new Product_supplier relation to the database
private void btnAdd_Click(object sender, EventArgs e)
{
// if the current product ID is zero, give warning message and return
if (nProductID == 0)
{
MessageBox.Show("Please select a product from the list first!");
return;
}
// if the current supplier ID is zero, give warning message and return
if (nSupplierID == 0)
{
MessageBox.Show("Please select a supplier from the right-hand side list first!");
return;
}
// check if the record in the database already
var objCheckDup = (from ps in dbContext.Products_Suppliers
where ps.ProductId == nProductID && ps.SupplierId == nSupplierID
select ps).FirstOrDefault();
// if the record in the database already, refresh the 2 supplier list and return
if (objCheckDup != null)
{
MessageBox.Show("Someone has added this supplier already, please check it again!");
DisplaySupplierOnProduct(nProductID);
return;
}
// insert the new record to the database
Products_Supplier objProdSupp = new Products_Supplier
{
ProductId = nProductID,
SupplierId = nSupplierID
};
dbContext.Products_Suppliers.InsertOnSubmit(objProdSupp);
dbContext.SubmitChanges();
// refresh the 2 supplier list
DisplaySupplierOnProduct(nProductID);
}
private void detach_Products_Suppliers(Products_Supplier entity)
{
this.SendPropertyChanging();
entity.Supplier = null;
}
private void attach_Products_Suppliers(Products_Supplier entity)
{
this.SendPropertyChanging();
entity.Product = this;
}
partial void DeleteProducts_Supplier(Products_Supplier instance);
partial void UpdateProducts_Supplier(Products_Supplier instance);
partial void InsertProducts_Supplier(Products_Supplier instance);