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