} //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); } }