private void btnUpdateSupplier_Click(object sender, EventArgs e)
{
if (Validation.IsPresent(txtSupplier, "Supplier Name", lblSuppError))
{
updateSupplierName(lstSupplier.SelectedItem.ToString(), txtSupplier.Text);
gridProductSuppliers.DataSource = Products_SuppliersDB.GetProductsSuppliers();
ResetPrdSupplierPage();
ResetProductSupllierList();
ResetSupplierList();
List <int> suppupdated = SuppliersDB.GetSupplierIDs();
List <string> supplier = new List <string>();
foreach (var sup in suppupdated)
{
supplier.Add(SuppliersDB.GetSupplier(sup).SupName);
}
comboSupplier.DataSource = supplier;
List <int> prod = ProductsDB.GetProductID();
List <string> product = new List <string>();
foreach (var prd in prod)
{
product.Add(ProductsDB.GetProduct(prd).ProdName);
}
comboProduct.DataSource = null;
comboProduct.DataSource = product;
txtSupplier.Text = "";
lblSuppError.Text = "";
}
}
// Adding Supplier to supplier table
private void btnSaveAddSupp_Click(object sender, EventArgs e)
{
if (Validation.IsPresent(txtSupplier, "Supplier Name", lblSuppError))
{
Suppliers suppAdd = new Suppliers();
List <int> supp = SuppliersDB.GetSupplierIDs();
var newsuppindex = supp[supp.Count - 1] + 1;
suppAdd.SupplierID = newsuppindex;
suppAdd.SupName = txtSupplier.Text;
SuppliersDB.AddSupplier(suppAdd);
gridProductSuppliers.DataSource = Products_SuppliersDB.GetProductsSuppliers();
List <int> suppupdated = SuppliersDB.GetSupplierIDs();
List <string> supplier = new List <string>();
foreach (var sup in suppupdated)
{
supplier.Add(SuppliersDB.GetSupplier(sup).SupName);
}
comboSupplier.DataSource = null;
comboSupplier.DataSource = supplier;
List <int> prod = ProductsDB.GetProductID();
List <string> product = new List <string>();
foreach (var prd in prod)
{
product.Add(ProductsDB.GetProduct(prd).ProdName);
}
comboProduct.DataSource = null;
comboProduct.DataSource = product;
ResetSupplierList();
ResetPrdSupplierPage();
ResetProductSupllierList();
txtSupplier.Text = "";
lblSuppError.Text = "";
}
}
private void saveProdSup_Click(object sender, EventArgs e)
{
ResetPrdSupplierPage();
try
{
Products_Suppliers addPrdSupp = new Products_Suppliers();
List <int> prod = ProductsDB.GetProductID();
List <int> supp = SuppliersDB.GetSupplierIDs();
foreach (var item in prod)
{
if (comboProduct.SelectedItem.ToString() == ProductsDB.GetProduct(item).ProdName)
{
addPrdSupp.ProductId = item;
}
}
foreach (var item in supp)
{
if (comboSupplier.SelectedItem.ToString() == SuppliersDB.GetSupplier(item).SupName)
{
addPrdSupp.SupplierId = item;
}
}
Products_SuppliersDB.AddProdSupplier(addPrdSupp);
gridProductSuppliers.DataSource = null;
gridProductSuppliers.DataSource = Products_SuppliersDB.GetProductsSuppliers();
gridProductSuppliers.Columns[0].Visible = false;
gridProductSuppliers.Columns[1].HeaderText = "Product Supplier ID";
gridProductSuppliers.Columns[2].HeaderText = "Product Name";
gridProductSuppliers.Columns[3].HeaderText = "Supplier Name";
gridProductSuppliers.Columns[1].Width = 150;
gridProductSuppliers.Columns[2].Width = 300;
gridProductSuppliers.Columns[3].Width = 300;
ResetProductList();
ResetSupplierList();
ResetPrdSupplierPage();
ResetProductSupllierList();
}
catch
{
lblPckProdError.Text = "Same Product Supplier Already Exist";
}
}
public void updateSupplierName(string supplierName, string updatedsupplierName)
{
List <int> supp = SuppliersDB.GetSupplierIDs();
foreach (var item in supp)
{
if (supplierName == SuppliersDB.GetSupplier(item).SupName)
{
Suppliers updatedSupplier = new Suppliers();
updatedSupplier.SupplierID = item;
updatedSupplier.SupName = updatedsupplierName;
SuppliersDB.UpdateSupplier(item, updatedSupplier);
}
}
}
// Adding Product to Product list ** Need Validation of Data
private void btnAddSaveProd_Click(object sender, EventArgs e)
{
if (Validation.IsPresent(txtProductName, "Product Name", lblProdsError))
{
Products prodAdd = new Products();
prodAdd.ProdName = txtProductName.Text;
List <int> prod = ProductsDB.GetProductID();
List <string> product = new List <string>();
foreach (var prd in prod)
{
product.Add(ProductsDB.GetProduct(prd).ProdName);
}
comboProduct.DataSource = null;
comboProduct.DataSource = product;
List <int> suppupdated = SuppliersDB.GetSupplierIDs();
List <string> supplier = new List <string>();
foreach (var sup in suppupdated)
{
supplier.Add(SuppliersDB.GetSupplier(sup).SupName);
}
comboSupplier.DataSource = null;
comboSupplier.DataSource = supplier;
ProductsDB.AddProduct(prodAdd);
gridProductSuppliers.DataSource = Products_SuppliersDB.GetProductsSuppliers();
ResetProductList();
ResetPrdSupplierPage();
ResetProductSupllierList();
txtProductName.Text = "";
lblProdsError.Text = "";
}
}
public void ResetSupplierList()
{
lstSupplier.Items.Clear();
List <int> supp1 = SuppliersDB.GetSupplierIDs();
foreach (var supItem in supp1)
{
lstSupplier.Items.Add(SuppliersDB.GetSupplier(supItem).SupName);
}
btnAddSupplier.Visible = true;
btnAddSupplier.Enabled = true;
btnEditSupplier.Visible = true;
btnEditSupplier.Enabled = true;
lblSupplierName.Visible = false;
txtSupplier.Visible = false;
btnSaveAddSupp.Visible = false;
btnUpdateSupplier.Visible = false;
lstSupplier.Enabled = true;
}
