private void button1_Click(object sender, EventArgs e) { this.Hide(); MENU chk = new MENU(); chk.ShowDialog(); }
private void button3_Click(object sender, EventArgs e) { string usertype = ""; string user = textBox1.Text; string password = textBox2.Text; string userdb = "", passdb = ""; string fname = "", lname = ""; string date = DateTime.Now.ToShortDateString(); string timein = DateTime.Now.ToShortTimeString(); string myConn = "Server=127.0.0.1;Database=munchlab;Uid=root;Pwd=root;"; MySqlConnection Conn = new MySqlConnection(myConn); MySqlCommand checkUser = new MySqlCommand(); checkUser.Connection = Conn; Conn.Open(); checkUser.CommandText = "select * from users where username=@username"; checkUser.Parameters.AddWithValue("@username", user); MySqlDataReader getUser = checkUser.ExecuteReader(); if (getUser.Read()) { userdb = getUser.GetString(0); passdb = getUser.GetString(1); usertype = getUser.GetString(2); fname = getUser.GetString(3); lname = getUser.GetString(4); if (userdb == user && passdb == password) { getUser.Close(); checkUser.CommandText = "insert into loginhistory(date, timein, user, crewname)values(@date,@timein,@user,@crewname)"; checkUser.Parameters.AddWithValue("@date", date); checkUser.Parameters.AddWithValue("@timein", timein); checkUser.Parameters.AddWithValue("@user", user); checkUser.Parameters.AddWithValue("@crewname", fname + " " + lname); checkUser.ExecuteNonQuery(); if (usertype == "B") { this.Hide(); MENU M = new MENU(); M.ShowDialog(); } if (usertype == "A") { this.Hide(); ADMIN ad = new ADMIN(); ad.ShowDialog(); } } else { MessageBox.Show("Incorrect user or password!"); return; } } else { MessageBox.Show("Incorrect user or password!"); return; } }
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(); }