private void createButton_Click(object sender, EventArgs e)
{
if (orderGridView.Rows.Count <= 0)
{
MessageBox.Show("There are no orders to be made.");
}
else
{
try
{
DBConnect db = new DBConnect();
MySqlConnection con = db.connect();
MySqlCommand comm = new MySqlCommand("SELECT id, reportDate FROM dailysalesreport WHERE reportDate = CURDATE()", con);
MySqlDataAdapter adp = new MySqlDataAdapter(comm);
DataTable dt = new DataTable();
adp.Fill(dt);
//CREATES SALES REPORT FOR THE DAY IF DOES NOT EXISTS YET
if (dt.Rows.Count == 0)
{
con.Open();
MessageBox.Show("Sales Report for the day has been created!");
MySqlCommand comm2 = new MySqlCommand("INSERT INTO dailysalesreport (reportDate) VALUES (NOW())", con);
comm2.ExecuteNonQuery();
adp.Fill(dt);
con.Close();
DSR_ID = Int32.Parse(dt.Rows[0]["id"].ToString());
}
else
{
//GRABS THE ID OF CURRENT DSR
DSR_ID = Int32.Parse(dt.Rows[0]["id"].ToString());
}
//INSERTS ORDER RECEIPTS INTO CURRENT DSR
con.Open();
MySqlCommand comm3 = new MySqlCommand("INSERT INTO order_receipt (dailysalesreport_id, orderTime, totalPrice) " +
"VALUES (" + DSR_ID + ", CURRENT_TIME()," + totalPrice + ")", con);
comm3.ExecuteNonQuery();
//SELECTS BOTH THE ID'S OF ORDER_RECEIPTS AND MENUITEM
comm = new MySqlCommand("SELECT id FROM order_receipt ORDER BY id DESC", con);
adp = new MySqlDataAdapter(comm);
DataTable dt2 = new DataTable();
adp.Fill(dt2);
//GRABS THE ID'S OF CURRENT ORDER RECEIPT AND MENUITEMS
int orderID = Int32.Parse(dt2.Rows[0]["id"].ToString());
MySqlCommand command1;
MySqlCommand comm4;
int menuitemID;
//ADDS QUANTITY TO MENUITEM
foreach (DataGridViewRow row in orderGridView.Rows)
{
command1 = new MySqlCommand("SELECT id FROM menuitem WHERE name = '" + row.Cells[0].Value.ToString() + "'", con);
adp = new MySqlDataAdapter(command1);
DataTable dt3 = new DataTable();
adp.Fill(dt3);
menuitemID = Int32.Parse(dt3.Rows[0]["id"].ToString());
comm4 = new MySqlCommand("INSERT INTO order_menuitem (order_id, menuitem_id, quantity) " +
"VALUES (" + orderID + "," + menuitemID + "," + Int32.Parse(row.Cells[2].Value.ToString()) + ")", con);
comm4.ExecuteNonQuery();
}
//UPDATES DSR REVENUE
String updateRevenue = ("UPDATE dailysalesreport SET revenue = revenue + " + (totalPrice - totalCostPrice) + " WHERE reportDate = CURDATE()");
MySqlCommand updateRev = new MySqlCommand(updateRevenue, con);
updateRev.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
MessageBox.Show("Transaction has been recorded!");
orderGridView.Rows.Clear();
totalPrice = 0.00f;
totalCostPrice = 0.00f;
amountLabel.Text = "P" + totalPrice.ToString("0.00");
}
}
