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!"); }
}
