} //End Of Insert Function
public static void DeleteData(BuyItemClass sale)
{
string query = "Delete From BuyItemTable Where Name='" + sale.Name.ToUpper() + "' and Expiry='" + sale.Expiry.ToUpper() + "'";
try
{
DataTable _dTable = null;
_dTable = dbAccess.ReadDataFromDb(query);
}
catch (Exception ex)
{ throw ex; }
} //End Of delete Function
} //End Of delete Function
public static void InsertData(BuyItemClass stock)
{
string query = "INSERT INTO BuyItemTable (Name, Quantity, Expiry ) VALUES('" + stock.Name.ToUpper() + "','" + stock.Quantity.ToUpper() + "','" + stock.Expiry + "' );";
try
{
DataTable _dtable = null;
_dtable = dbAccess.ReadDataFromDb(query);
}
catch (Exception ex)
{ throw ex; }
} //End Of Insert Function
private void Edit_Click(object sender, EventArgs e)
{
BuyItemClass s = new BuyItemClass();
try
{
s.Name = Nametxt.Text.Trim();
s.Expiry = textBox10.Text;
QueryClass.DeleteData(s);
MessageBox.Show("Delete Successfully");
}
catch (Exception ex)
{
MessageBox.Show("Error", ex.Message);
}
}
private void SaveBtn_Click(object sender, EventArgs e)
{
BuyItemClass ss = new BuyItemClass();
try
{
ss.Name = Nametxt.Text.Trim();
ss.Quantity = Quantitytxt.Text.Trim();
ss.Expiry = textBox10.Text;
QueryClass.InsertData(ss);
MessageBox.Show("Add Successfully");
}
catch (Exception ex)
{
MessageBox.Show("Error", ex.Message);
}
}
