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 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);
}
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 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(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 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 FillGrid(DataGridView GV)
{
string query = "select * from StorageInfo";
Business_Logic BBL = new Business_Logic();
DataSet ds = BBL.Adapter(query);
GV.DataSource = ds.Tables[0];
}
public void FillGrid(DataGridView GV)
{
string query = "select * from [CurrentTransaction]";
Business_Logic BBL = new Business_Logic();
DataSet ds = BBL.Adapter(query);
GV.DataSource = ds.Tables[0];
}
public void fillcomboboxquantity(ComboBox CB, String item)
{
string query = String.Format("select quantity from StorageInfo where item= '{0}'", item);
Business_Logic BL = new Business_Logic();
OleDbDataReader rec = BL.SelectQuery(query);
while (rec.Read())
{
CB.Items.Add(rec[0].ToString());
}
}
public void updateFillGrid(DataGridView GV)
{
string query = "update values into table StorageInfo * from StorageInfo";
Business_Logic BBL = new Business_Logic();
OleDbDataAdapter adapter = new OleDbDataAdapter();
OleDbCommandBuilder build = new OleDbCommandBuilder(adapter);
DataSet ds = BBL.Adapter(query);
adapter.Update(ds);
GV.DataSource = ds.Tables[0];
}
public void fillcombobox(ComboBox CB)
{
string query = "select username from UserDetails where usertype= 'Staff'"; //direct query so , simply used.
Business_Logic BL = new Business_Logic();
OleDbDataReader rec = BL.SelectQuery(query); // datareader only fetches one record at a time, so loop used.
while (rec.Read())
{
CB.Items.Add(rec[0].ToString());
}
}
public void fillcombobox(ComboBox CB)
{
string query = "select item from StorageInfo";
Business_Logic BL = new Business_Logic();
OleDbDataReader rec = BL.SelectQuery(query);
while (rec.Read())
{
CB.Items.Add(rec[0].ToString());
}
}
public int getprice(string item)
{
string query = String.Format("select price from StorageInfo where item= '{0}'", item);
Business_Logic BL = new Business_Logic();
OleDbDataReader rec = BL.SelectQuery(query); // datareader only fetches one record at a time, so loop used.
while (rec.Read())
{
return(Convert.ToInt32(rec[0].ToString()));
}
return(0);
}
public int summer()
{
string query = "select SUM(PayPrice) from CurrentTransaction";
Business_Logic BL = new Business_Logic();
OleDbDataReader rec = BL.SelectQuery(query); // datareader only fetches one record at a time, so loop used.
while (rec.Read())
{
return(Convert.ToInt32(rec[0].ToString()));
}
return(0);
}
public bool Authenticate(Credential_DB cDB)
{
string query = String.Format("select * from UserDetails where name = '{0}' and username = '******' and password ='******' and usertype ='{3}'", cDB.Name, cDB.UserName, cDB.Password, cDB.UserType);
Business_Logic BL = new Business_Logic();
OleDbDataReader rec = BL.SelectQuery(query);
if (rec.Read())
{
return(true);
}
else
{
return(false);
}
}
public void searchFillGrid(DataGridView GV, Storage_DB sDB, String se)
{
if (se == "***All***")
{
string query = "select * from StorageInfo";
Business_Logic BBL = new Business_Logic();
DataSet ds = BBL.Adapter(query);
GV.DataSource = ds.Tables[0];
}
else
{
string query = String.Format("select * from StorageInfo where item = '{0}'", se);
Business_Logic BBL = new Business_Logic();
DataSet ds = BBL.Adapter(query);
GV.DataSource = ds.Tables[0];
}
}
