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