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