public void deletetransaction(CurrentTransaction_DB sDB) { string query = String.Format("delete from CurrentTransaction where item = '{0}'", sDB.Item); Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }
public void empty() { string query = "DELETE * FROM [CurrentTransaction]"; Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }
public void deleteproduct(Storage_DB sDB) { string query = String.Format("delete from StorageInfo where item = '{0}'", sDB.Item); Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }
public void addtransaction(CurrentTransaction_DB sDB) { string query = String.Format("Insert into CurrentTransaction Values('{0}','{1}',{2}, {3})", sDB.Item, sDB.Quantity, sDB.Price, sDB.PayPrice); Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }
public void addproduct(Storage_DB sDB) { string query = String.Format("Insert into StorageInfo Values('{0}','{1}','{2}', '{3}')", sDB.Item, sDB.Manufacturer, sDB.Quantity, sDB.Price); Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }
public void addtransaction(Transaction_DB sDB) { string query = String.Format("Insert into [Transaction] Values('{0}','{1}','{2}', '{3}')", sDB.CustomerName, sDB.Mobile, sDB.PurchaseDate, sDB.TotalBill); Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }
public void deleteuser(Credential_DB cDB) { string query = String.Format("delete from UserDetails where username = '******'", cDB.UserName); Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }
public void changemypassword(Credential_DB cDB) { string query = String.Format("UPDATE [UserDetails] SET [PASSWORD] = '{0}' WHERE [USERNAME] = '{1}' AND [USERTYPE] = '{2}' ", cDB.Password, cDB.UserName, cDB.UserType); Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }
public void createnewuser(Credential_DB cDB) { string query = String.Format("Insert into UserDetails Values('{0}','{1}','{2}', '{3}')", cDB.Name, cDB.UserName, cDB.Password, cDB.UserType); Business_Logic BL = new Business_Logic(); BL.NonQuery(query); }