//update products of a specific package
private void btnUpdatPackageProduct_Click(object sender, EventArgs e)
{
string prodName = cmbProducts.Text;
string suppName = lstSuppliers.Text;
int getPkgId = 0;
if (lstSuppliers.Text == "")
{
MessageBox.Show("Please choose a Supplier");
}
else
{
if (pkgDataGrid.SelectedCells.Count > 0)
{
int selectedrowindex = pkgDataGrid.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = pkgDataGrid.Rows[selectedrowindex];
getPkgId = Convert.ToInt32(selectedRow.Cells["PackageId"].Value);
Package_AddProduct_DB pkgUpdateProductObj = new Package_AddProduct_DB();
if (pkgUpdateProductObj.Update_Package_Product(suppName, prodName, getPkgId, pkgUpdateSuppId))
{
MessageBox.Show("Packages products updated Successfully");
btnAddProduct.Enabled = true;
cmbProducts.Enabled = true;
btnClearproductForm.Enabled = true;
btnUpdatPackageProduct.Enabled = false;
btnDeletePkgProduct.Enabled = true;
btnPkgDelete.Enabled = true;
}
Load_PkgProducts();
cmbProducts.SelectedIndex = -1;
}
}
}
//Delete Package
private void btnPkgDelete_Click(object sender, EventArgs e)
{
int getPkgId = 0;
if (pkgDataGrid.SelectedCells.Count > 0)
{
int selectedrowindex = pkgDataGrid.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = pkgDataGrid.Rows[selectedrowindex];
getPkgId = Convert.ToInt32(selectedRow.Cells["PackageId"].Value);
Package_AddProduct_DB pkgDeleteObj = new Package_AddProduct_DB();
string message = "Do you want to delete this Record?";
string caption = "Delete Info";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(message, caption, buttons);
if (result == System.Windows.Forms.DialogResult.Yes)
{
pkgDeleteObj.Pkg_Products_Delete(getPkgId);
if (pkgDeleteObj.DeletePackage(getPkgId))
{
MessageBox.Show("Package Deleted");
}
PackageDB ObjDeletePkg = new PackageDB();
if (ObjDeletePkg.FillDataGrid())
{
pkgDataGrid.DataSource = ObjDeletePkg.dt;
}
Load_PkgProducts();
cmbProducts.SelectedIndex = -1;
}
}
}
//Add product to database on click
private void btnAddProduct_Click(object sender, EventArgs e)
{
if (cmbProducts.Text == "" || lstSuppliers.Text == "")
{
MessageBox.Show("Please choose a Product and a Supplier");
}
else
{
Package_AddProduct_DB addProdObj = new Package_AddProduct_DB();
int getPkgId = 0;
string prodName = Convert.ToString(cmbProducts.Text);
string supName = Convert.ToString(lstSuppliers.Text);
if (pkgDataGrid.SelectedCells.Count > 0)
{
int selectedrowindex = pkgDataGrid.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = pkgDataGrid.Rows[selectedrowindex];
getPkgId = Convert.ToInt32(selectedRow.Cells["PackageId"].Value);
}
if (addProdObj.AddPackageProduct(supName, prodName, getPkgId))
{
MessageBox.Show("Product added Successfully");
}
Load_PkgProducts();
ClearProductForm();
}
}
//On combo box selected index changed event populate data into list box
private void cmbProducts_SelectedIndexChanged(object sender, EventArgs e)
{
PackageDB supplierObj = new PackageDB();
int getPkgId = 0;
if (pkgDataGrid.SelectedCells.Count > 0)
{
int selectedrowindex = pkgDataGrid.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = pkgDataGrid.Rows[selectedrowindex];
getPkgId = Convert.ToInt32(selectedRow.Cells["PackageId"].Value);
Package_AddProduct_DB getSupIdobj = new Package_AddProduct_DB();
getSupIdobj.GetSupplierId(getPkgId);
pkgProductGrid.DataSource = getSupIdobj.getPackageProduct();
}
if (supplierObj.FetchSuppliers(Convert.ToString(cmbProducts.Text), getPkgId))
{
lstSuppliers.Items.Clear();
while (supplierObj.reader.Read())
{
lstSuppliers.Items.Add(supplierObj.reader.GetValue(0));
}
supplierObj.reader.Close();
}
}
//Save update package products on click
private void pkgSaveUpdate_Click(object sender, EventArgs e)
{
if (validaterClass.isProvided(txtPkgName, "Package Name can not be null") &&
(validaterClass.validateDate(Convert.ToDateTime(dtPkgStartDate.Text), Convert.ToDateTime(dtPkgEndDate.Text)) &&
(validaterClass.isProvided(txtPkgDesc, "Package Description can not be null")) &&
(validaterClass.isProvided(txtPkgBasePrice, "Package Base Price can not be null")) &&
(validaterClass.isNonNegativeDoub(txtPkgBasePrice, "Package Price must be a Positive Whole number")) &&
(validaterClass.isProvided(txtPkgComision, "Agency Comm can not be null")) &&
(validaterClass.isNonNegativeDoub(txtPkgComision, "Agency Comm must be a positive whole number") &&
(validaterClass.isValidateComm(txtPkgBasePrice, txtPkgComision)))))
{
int getPkgId = 0;
string pkgName = txtPkgName.Text;
DateTime pkgStrdDate = Convert.ToDateTime(dtPkgStartDate.Text);
DateTime pkgEndDate = Convert.ToDateTime(dtPkgEndDate.Text);
string description = txtPkgDesc.Text;
decimal basePrice = Convert.ToDecimal(txtPkgBasePrice.Text);
decimal agencyComm = Convert.ToDecimal(txtPkgComision.Text);
if (pkgDataGrid.SelectedCells.Count > 0)
{
int selectedrowindex = pkgDataGrid.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = pkgDataGrid.Rows[selectedrowindex];
getPkgId = Convert.ToInt32(selectedRow.Cells["PackageId"].Value);
}
Package_AddProduct_DB updatePackageObj = new Package_AddProduct_DB();
if (updatePackageObj.UpdatePackages(getPkgId, pkgName, pkgStrdDate, pkgEndDate, description, basePrice, agencyComm))
{
MessageBox.Show("Package Updated Successfully");
pkgDataGrid.Focus();
pkgDataGrid.Columns[0].Selected = true;
}
//format the form
Clear_Form();
btnSaveUpdate.Enabled = false;
btnAddPackage.Enabled = true;
btnPkgDelete.Enabled = true;
PackageDB productsObj = new PackageDB();
if (productsObj.FillDataGrid())
{
pkgDataGrid.DataSource = productsObj.dt;
}
Refresh_Products_Onupdate();
}
}
//Refresh product grid view on update
private void Refresh_Products_Onupdate()
{
int getPkgId;
if (pkgDataGrid.SelectedCells.Count > 0)
{
int selectedrowindex = pkgDataGrid.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = pkgDataGrid.Rows[selectedrowindex];
getPkgId = Convert.ToInt32(selectedRow.Cells["PackageId"].Value);
Package_AddProduct_DB getSupidobj = new Package_AddProduct_DB();
getSupidobj.GetSupplierId(getPkgId);
pkgProductGrid.DataSource = getSupidobj.getPackageProduct();
}
}
//On gridview click refresh the data
private void pkgDataGrid_Click(object sender, EventArgs e)
{
int getPkgId = 0;
if (pkgDataGrid.SelectedCells.Count > 0)
{
int selectedrowindex = pkgDataGrid.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = pkgDataGrid.Rows[selectedrowindex];
getPkgId = Convert.ToInt32(selectedRow.Cells["PackageId"].Value);
Package_AddProduct_DB getSupIdobj = new Package_AddProduct_DB();
getSupIdobj.GetSupplierId(getPkgId);
pkgProductGrid.DataSource = getSupIdobj.getPackageProduct();
}
}
//Delete product
private void btnDeletePkgProduct_Click(object sender, EventArgs e)
{
string pkgProdName = "";
string pkgSuppName = "";
int getPkgId = 0;
if (pkgDataGrid.SelectedCells.Count > 0)
{
int selectedrowindex = pkgDataGrid.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = pkgDataGrid.Rows[selectedrowindex];
getPkgId = Convert.ToInt32(selectedRow.Cells["PackageId"].Value);
}
if (pkgProductGrid.SelectedCells.Count > 0)
{
int selectedrowindex = pkgProductGrid.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = pkgProductGrid.Rows[selectedrowindex];
pkgProdName = Convert.ToString(selectedRow.Cells[0].Value);
pkgSuppName = Convert.ToString(selectedRow.Cells[1].Value);
cmbProducts.SelectedItem = pkgProdName;
lstSuppliers.SelectedItem = pkgSuppName;
Package_AddProduct_DB deletePackagesPordObj = new Package_AddProduct_DB();
string message = "Do you want to delete this Record?";
string caption = "Delete Info";
MessageBoxButtons buttons = MessageBoxButtons.YesNo;
DialogResult result;
// Displays the MessageBox.
result = MessageBox.Show(message, caption, buttons);
if (result == System.Windows.Forms.DialogResult.Yes)
{
if (deletePackagesPordObj.Delete_Package_Product(pkgSuppName, pkgProdName, getPkgId))
{
MessageBox.Show("Package product deleted successfully");
}
}
}
Load_PkgProducts();
ClearProductForm();
}
//update specific package products
private void btnUpdatSpecificPkg_Click(object sender, EventArgs e)
{
string pkgProdName = "";
string pkgSuppName = "";
pkgProductGrid.Refresh();
if (pkgProductGrid.SelectedCells.Count > 0)
{
int selectedrowindex = pkgProductGrid.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = pkgProductGrid.Rows[selectedrowindex];
pkgProdName = Convert.ToString(selectedRow.Cells[0].Value);
pkgSuppName = Convert.ToString(selectedRow.Cells[1].Value);
cmbProducts.SelectedItem = pkgProdName;
lstSuppliers.SelectedItem = pkgSuppName;
Package_AddProduct_DB updatePackagesPordObj = new Package_AddProduct_DB();
pkgUpdateSuppId = updatePackagesPordObj.Get_Package_Product_SupplierId(pkgProdName, pkgSuppName);
btnUpdatPackageProduct.Enabled = true;
btnAddProduct.Enabled = false;
cmbProducts.Enabled = false;
btnDeletePkgProduct.Enabled = false;
btnClearproductForm.Enabled = false;
btnPkgDelete.Enabled = false;
}
}
