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;
}
}
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 mtRefresh_Click(object sender, EventArgs e)
{
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.Refresh();
}
