private void OrderGridView_MouseDoubleClick(object sender, MouseEventArgs e) { try{ if (MessageBox.Show("Are you sure to delete this order?", "Delete Order", MessageBoxButtons.YesNo) == DialogResult.Yes) { Connection c = new Connection(); dti = c.connect(); int index = OrderGridView.SelectedRows[0].Index; string orderNumber = "SELECT orderID FROM orders WHERE orderID=\"" + OrderGridView[0, index].Value.ToString() + "\""; int orderID = int.Parse(dti.getOneField(orderNumber)); string DeleteQuery = "DELETE FROM orders WHERE orderID=" + orderID; string Deletequery = "DELETE FROM orderitems WHERE orderID="+orderID; dti.executeDMQuery(DeleteQuery); dti.close(); for (int i = 0; i < data.Rows.Count; i = i + 1) { DataRow row = data.Rows[i]; if (int.Parse(row["orderID"].ToString()) == orderID) data.Rows.Remove(row); } OrderGridView.Rows.RemoveAt(index); OrderGridView.Refresh(); } } catch(Exception ee) { } }
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; } }
private void mtSend_Click(object sender, EventArgs e) { try{ if(OrderGridView.SelectedRows.Count>0){ if(MessageBox.Show("Are you sure to send out this order?", "Send Order", MessageBoxButtons.YesNo) == DialogResult.Yes) { Connection c = new Connection(); dti = c.connect(); int index = OrderGridView.SelectedRows[0].Index; string orderNumber = "SELECT orderID FROM orders WHERE orderID=\"" + OrderGridView[0, index].Value.ToString() + "\""; int orderID = int.Parse(dti.getOneField(orderNumber)); string sendQuery = "UPDATE orders SET shipped=1 WHERE orderID=\"" + OrderGridView[0, index].Value.ToString() + "\""; dti.executeDMQuery(sendQuery); for (int i = 0; i < data.Rows.Count; i = i + 1) { DataRow row = data.Rows[i]; if (int.Parse(row["orderID"].ToString()) == orderID) data.Rows.Remove(row); } OrderGridView.DataSource = data; OrderGridView.Refresh(); } } } catch(Exception ee) { } }
public DatabaseConnectionInterface connect() { DatabaseConnectionInterface dti = new DatabaseConnectionInterface(); dti.setConnectionServerData("localhost", "iroszeruzlet", "3306"); dti.setConnectionUserData("root", " "); dti.makeConnectionToDatabase(); dti.open(); return(dti); }
public Warehouse() { InitializeComponent(); c = new Connection(); dti = c.connect(); deletemode = false; 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.Columns["itemNumber"].Visible = false; StorageGridView.Columns["itemPic"].Visible = false; StorageGridView.Columns["itemName"].Width = 297; StorageGridView.Columns["itemName"].HeaderText = "Item Name"; StorageGridView.Columns["itemPrice"].HeaderText = "Item Price"; StorageGridView.Columns["itemQuantity"].HeaderText = "Quantity"; }
public OrderForm() { InitializeComponent(); try{ c = new Connection(); dti = c.connect(); data = dti.getToDataTable("SELECT orders.orderID, orders.buyer, orders.orderDate FROM orders, orderitems, warehouse WHERE warehouse.itemNumber=orderitems.itemID AND orders.orderID=orderitems.orderID AND orders.shipped=0 GROUP BY orders.orderDate"); OrderGridView.DataSource = data; OrderGridView.Columns["orderID"].Visible = false; OrderGridView.Columns["orderDate"].Width = 270; OrderGridView.Columns["orderDate"].HeaderText = "Order Date"; OrderGridView.Columns["buyer"].HeaderText = "Buyer Name"; OrderGridView.Refresh(); } catch(Exception ee) { } }
private void StorageGridView_MouseDoubleClick(object sender, MouseEventArgs e) { try{ if (!deletemode) { return; } if (StorageGridView.SelectedRows.Count > 0) { if (MessageBox.Show("Are you sure to delete this item?", "Delete Item", MessageBoxButtons.YesNo) == DialogResult.Yes) { Connection c = new Connection(); dti = c.connect(); int index = StorageGridView.SelectedRows[0].Index; string itemNumber = "SELECT itemNumber FROM warehouse WHERE itemName=\"" + StorageGridView[0, index].Value.ToString() + "\""; int itemID = int.Parse(dti.getOneField(itemNumber)); string DeleteQuery = "DELETE FROM warehouse WHERE itemNumber=" + itemID; dti.executeDMQuery(DeleteQuery); dti.close(); for (int i = 0; i < data.Rows.Count; i = i + 1) { DataRow row = data.Rows[i]; if (int.Parse(row["itemNumber"].ToString()) == itemID) { data.Rows.Remove(row); } } StorageGridView.Rows.RemoveAt(index); StorageGridView.Refresh(); } } } catch (Exception ee) { } }
private void MtModify_Click(object sender, EventArgs e) { try { aef = new AddEditForm(); aef.setFormText("Modify Item"); foreach (DataGridViewRow row in StorageGridView.SelectedRows) { aef.setItemname(row.Cells[1].Value.ToString().TrimEnd()); aef.setItemPrice(row.Cells[2].Value.ToString().TrimEnd()); aef.setItemQuantity(row.Cells[3].Value.ToString().TrimEnd()); aef.setItemPicture(row.Cells[4].Value.ToString().TrimEnd()); } aef.ShowDialog(); if (aef.DialogResult == DialogResult.OK) { Connection c = new Connection(); DatabaseConnectionInterface dci = c.connect(); string getitemID = "SELECT itemNumber FROM warehouse WHERE itemName=\"" + aef.getItemName() + "\""; int itemID = int.Parse(dci.getOneField(getitemID)); string UpdateItem = "UPDATE warehouse SET itemName=\"" + aef.getItemName() + "\", itemPrice=\"" + aef.getItemPrice() + "\", itemQuantity=\"" + aef.getItemQuantity() + "\", itemPic=\"" + aef.getItempic() + "\" WHERE itemNumber=" + itemID; dci.executeDMQuery(UpdateItem); dci.close(); DataRow[] row = data.Select("itemNumber=" + itemID); row[0]["itemName"] = aef.getItemName(); row[0]["itemPrice"] = aef.getItemPrice(); row[0]["itemQuantity"] = aef.getItemQuantity(); row[0]["itemPic"] = aef.getItempic(); StorageGridView.Refresh(); } } catch (Exception ee) { MessageBox.Show("Please select a row to modify!"); } }