private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("please input a number");
return;
}
else if (change < 0)
{
MessageBox.Show("kulang pa po");
return;
}
string fooditem = "";
int quantity = 0, totalprice = 0;
string datenum = DateTime.Now.ToShortTimeString();
string datestring = DateTime.Now.ToShortDateString();
string date = datestring + " " + datenum;
for (int i = 0; i < listView1.Items.Count; i++)
{
string myConn = "Server=127.0.0.1;Database=munchlab;Uid=root;Pwd=root;";
MySqlConnection Conn = new MySqlConnection(myConn);
ordernum = listView1.Items[i].SubItems[0].Text;
quantity = Convert.ToInt32(listView1.Items[i].SubItems[1].Text);
totalprice = Convert.ToInt32(listView1.Items[i].SubItems[3].Text);
fooditem = listView1.Items[i].SubItems[2].Text;
MySqlCommand getUP = new MySqlCommand();
Conn.Open();
getUP.Connection = Conn;
getUP.CommandText = "select price from menu where fooditem=@fooditem";
getUP.Parameters.AddWithValue("@fooditem", fooditem);
MySqlDataReader rdr = getUP.ExecuteReader();
while (rdr.Read())
{
unitprice = rdr.GetString("price").ToString();
}
rdr.Close();
MySqlCommand insertSR = new MySqlCommand();
insertSR.Connection = Conn;
insertSR.CommandText = "insert into salesreport(transactionnum, quantity, totalprice, fooditem, date, crewlog, unitprice, ordernum)values(@transactionnum, @quantity, @totalprice, @fooditem, @date, @crewlog, @unitprice, @ordernum)";
insertSR.Parameters.AddWithValue("@totalprice", totalprice);
insertSR.Parameters.AddWithValue("@quantity", quantity);
insertSR.Parameters.AddWithValue("@fooditem", fooditem);
insertSR.Parameters.AddWithValue("@date", date);
insertSR.Parameters.AddWithValue("@transactionnum", transactionnum);
insertSR.Parameters.AddWithValue("@crewlog", crewname);
insertSR.Parameters.AddWithValue("@unitprice", unitprice);
insertSR.Parameters.AddWithValue("@ordernum", ordernum);
insertSR.ExecuteNonQuery();
}
transactionnum++;
string myConn2 = "Server=127.0.0.1;Database=munchlab;Uid=root;Pwd=root;";
MySqlConnection Conn2 = new MySqlConnection(myConn2);
MySqlCommand updateTN = new MySqlCommand();
updateTN.Connection = Conn2;
Conn2.Open();
updateTN.CommandText = "update transactionnumber set transactionnum=@transactionnum";
updateTN.Parameters.AddWithValue("@transactionnum", transactionnum);
updateTN.ExecuteNonQuery();
updateTN.CommandText = "TRUNCATE TABLE salesinvoice";
updateTN.ExecuteNonQuery();
MessageBox.Show("Transaction complete");
MENU men = new MENU();
this.Hide();
men.ShowDialog();
}