private void addProductBTN_Click(object sender, EventArgs e)
{
Clear();
using (addProductForm addP = new addProductForm()) {
addP.ShowDialog();
addP.addProductClick += new EventHandler(addP_addProductClick);
pCodeTB.Text = addP.getpCodes;
pNameTB.Text = addP.getpNames;
priceTB.Text = addP.getpPrice;
dbQuantity = Convert.ToInt32(addP.getpQuantity);
if (addP.getpQuantity != "" && addP.getpQuantity != null)
{
AvaliableQuantity = int.Parse(addP.getpQuantity);
}
}
}
public void getProduct(out addProductForm[] Cat_Array)
{
dataGridView3.Rows.Clear();
sqlCommandAB brandSql = new sqlCommandAB();
DataTable DT = brandSql.QueryDT("SELECT * FROM Product");
int rowCount = DT.Rows.Count;
Cat_Array = new addProductForm[rowCount];
string[] row;
for (int j = 0; j < rowCount; j++)
{
string brandName = brandSql.getSingleString("SELECT brandName FROM Brand WHERE brandID = '" + Convert.ToInt32(DT.Rows[j]["brandID"]) + "'");
row = new string[] { (string)DT.Rows[j]["pCode"], (string)DT.Rows[j]["pName"], (string)DT.Rows[j]["categoryName"], brandName, DT.Rows[j]["pSellingPrice"].ToString() };
dataGridView3.Rows.Add(row);
loadData();
}
}
