private void btnRemove_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Are you Sure delete product details?", "Veryfy", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
Connector connector = new MYSQLDatabaseConnection();
/*catch update details into databaseColumn*/
DatabaseColumn DeleteDatabaseColumn = new DatabaseColumn();
DeleteDatabaseColumn.company_id = connector.SearchCompanyList(TempCompanyList, cmbCompanyName.SelectedItem.ToString()).company_id;
DeleteDatabaseColumn.category_id = connector.SearchCategoryList(TempCategoryList, cmbCategoryName.SelectedItem.ToString()).category_id;
DeleteDatabaseColumn.product_id = txtProductId.Text.ToString();
DeleteDatabaseColumn.product_name = txtProductName.Text;
DeleteDatabaseColumn.sell_price = txtSellPrice.Text;
DeleteDatabaseColumn.product_discount_price = txtDiscount.Text;
DeleteDatabaseColumn.minimum_quantity = txtMinimumQuantity.Text;
List <DatabaseColumn> TempListForDGV = new List <DatabaseColumn>();
TempListForDGV.Add(DeleteDatabaseColumn);
connector.establish();
connector.SetData(DeleteDatabaseColumn);
if (connector.RemoveProductDetails() == true)
{
CombineDataGridView combineDataGridView = new CombineDataGridView();
combineDataGridView.SetDataGridViewList(TempListForDGV, mDgv);
MessageBox.Show("Delete compliete");
txtDiscount.Clear();
txtMinimumQuantity.Clear();
txtProductId.Clear();
txtProductName.Clear();
txtSellPrice.Clear();
}
else
{
MessageBox.Show("Try again");
}
}
}