private void mtLogin_Click(object sender, EventArgs e)
{
c = new Connection();
dti = c.connect();
string query = "SELECT category.catName FROM category, employee WHERE employee.catID=category.catID AND employee.username=\"" + UsernameText.Text + "\"";
string query2 = "SELECT COUNT(category.catName) FROM category, employee WHERE employee.catID=category.catID AND employee.password=\"" + PasswordText.Text + "\"";
string result = dti.getOneField(query);
int result2 = int.Parse(dti.executeScalarQuery(query2));
if (dti.isConnectionExsist())
{
if (result == "storage_manager" && result2 == 1)
{
this.Hide();
sf = new Warehouse();
sf.ShowDialog();
}
else if (result == "order_manager" && result2 == 1)
{
of = new OrderForm();
this.Hide();
of.ShowDialog();
}
else
{
errorLabel.Visible = true;
}
}
else
{
MessageBox.Show("No Connection");
}
}
private void MtAdd_Click(object sender, EventArgs e)
{
aef = new AddEditForm();
aef.setFormText("Add New Item");
try{
if (aef.ShowDialog() == DialogResult.OK)
{
Connection c = new Connection();
DatabaseConnectionInterface dcf = c.connect();
string MaxQuery = "SELECT MAX(itemNumber) FROM warehouse";
int newItem = int.Parse(dcf.executeScalarQuery(MaxQuery)) + 1;
string InsertQuery = "INSERT INTO warehouse(itemNumber,itemName,itemPrice,itemQuantity,itemPic) VALUES(" + newItem + ",\"" + aef.getItemName() + "\"," + aef.getItemPrice() + "," + aef.getItemQuantity() + ",\"" + aef.getItempic() + "\")";
dcf.executeDMQuery(InsertQuery);
dcf.close();
data.Rows.Add(newItem, aef.getItemName(), aef.getItemPrice(), aef.getItemQuantity(), aef.getItempic());
data = dti.getToDataTable("SELECT * FROM warehouse");
deldata = dti.getToDataTable("SELECT itemName, itemPrice, itemQuantity FROM warehouse WHERE itemNumber NOT IN (SELECT DISTINCT itemID FROM orderitems)");
StorageGridView.DataSource = data;
StorageGridView.Refresh();
}
aef.Hide();
}
catch (Exception ee)
{
return;
}
}
