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();
}