private void button1_Click(object sender, EventArgs e) { user = username_.Text; pass = password_.Text; try { string conn = "datasource=127.0.0.1;port=3306;username=root;password=lizzy2000;database=quicklaundry"; string query = "SELECT * FROM users WHERE username = '******' AND password= '******';"; MySqlConnection connect = new MySqlConnection(conn); MySqlCommand go = new MySqlCommand(query, connect); go.CommandTimeout = 60; MySqlDataReader reader; connect.Open(); reader = go.ExecuteReader(); if (reader.HasRows == true) { if (user == "admin") { admin only = new admin(); only.Show(); this.Hide(); } else { profile usernew = new profile(); usernew.Show(); this.Hide(); } username_.Text = ""; password_.Text = ""; connect.Close(); } else { MessageBox.Show("Username or password incorrect!", "Invalid Login"); } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } }
private void newlaundry__Click(object sender, EventArgs e) { decimal total = (250 * jeans_.Value) + (150 * wool_.Value) + (70 * nass_.Value) + (300 * towel_.Value) + (250 * bedsheet_.Value) + (50 * small_.Value) + (150 * native_.Value) + (100 * cotton_.Value); MessageBox.Show("Successfully added! Total amount is " + total, "Add New Laundry", MessageBoxButtons.OKCancel); string conn = "datasource=127.0.0.1;port=3306;username=root;password=lizzy2000;database=quicklaundry"; string query = "INSERT INTO newlaundry VALUES('" + login.user + "'," + jeans_.Value + "," + wool_.Value + "," + cotton_.Value + "," + native_.Value + "," + towel_.Value + "," + bedsheet_.Value + "," + nass_.Value + "," + small_.Value + ",'" + time_.Value + "','" + address_.Text + "'," + total + "); INSERT INTO laundry (username,bill) VALUES('" + login.user + "'," + total + ");"; MySqlConnection connect = new MySqlConnection(conn); MySqlCommand go = new MySqlCommand(query, connect); go.CommandTimeout = 60; MySqlDataReader reader; try { connect.Open(); reader = go.ExecuteReader(); connect.Close(); foreach (Form oForm in Application.OpenForms) { if (oForm is profile) { oForm.Hide(); break; } } } catch (Exception ex) { MessageBox.Show(ex.Message, "Error"); } profile newuserlog = new profile(); newuserlog.Show(); this.Close(); }