private void icon_delay_Tick(object sender, EventArgs e) { icon.Enabled = false; icon_delay.Stop(); this.Close(); Mainform frm = new Mainform(); frm.Show(); }
private void btnLogin_Click(object sender, EventArgs e) { if (txtUsername.Text != "" && txtPassword.Text != "") { try { conn.Open(); string sql = "SELECT * FROM user WHERE username = @user and password = @pass"; MySqlDataAdapter sda = new MySqlDataAdapter(sql, conn); sda.SelectCommand.Parameters.AddWithValue("@user", txtUsername.Text); sda.SelectCommand.Parameters.AddWithValue("@pass", txtPassword.Text); DataTable sdt = new DataTable(); sda.Fill(sdt); conn.Close(); if (sdt.Rows.Count > 0) { for (int samp = 0; samp < sdt.Rows.Count; samp++) { string name = txtUsername.Text; DataRow sdr = sdt.Rows[samp]; if (sdr["UserLevel"].ToString() == "Admin") { //MessageBox.Show("Welcome, " + sdt.Rows[0][1].ToString(), "Successfully Login!", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Hide(); //exequery("INSERT INTO userlog VALUES(default, '" + txtUsername.Text + "','Admin','" + lblTime.Text + "','" + lblDate.Text + "','IN')"); Mainform fr = new Mainform(); //FullName = sdt.Rows[0][4].ToString() + " " + sdt.Rows[0][5].ToString(); //Username = sdt.Rows[0][1].ToString(); //Userlevel = sdt.Rows[0][3].ToString(); //fr.Show(); Login_Notification notif = new Login_Notification(); notif.Show(); } else if (sdr["UserLevel"].ToString() == "Cashier") { this.Hide(); POS pos = new POS(); pos.Show(); } // MessageBox.Show("Welcome " + sdt.Rows[0][1].ToString(), "Successfully Login", MessageBoxButtons.OK, MessageBoxIcon.Information); // this.Hide(); // exequery("INSERT INTO userlog VALUES(default, '" + txtUsername.Text + "','Cashier','" + lblTime.Text + "','" + lblDate.Text + "','IN')"); // Mainform fr = new Mainform(); // FullName = sdt.Rows[0][4].ToString() + " " + sdt.Rows[0][5].ToString(); // Username = sdt.Rows[0][1].ToString(); // Userlevel = sdt.Rows[0][3].ToString(); // fr.Show(); //} //else if (sdr["UserLevel"].ToString() == "Manager") //{ // MessageBox.Show("Welcome " + sdt.Rows[0][1].ToString(), "Successfully Login", MessageBoxButtons.OK, MessageBoxIcon.Information); // this.Hide(); // exequery("INSERT INTO userlog VALUES(default, '" + txtUsername.Text + "','Manager','" + lblTime.Text + "','" + lblDate.Text + "','IN')"); // Mainform fr = new Mainform(); // FullName = sdt.Rows[0][4].ToString() + " " + sdt.Rows[0][5].ToString(); // Username = sdt.Rows[0][1].ToString(); // Userlevel = sdt.Rows[0][3].ToString(); // fr.Show(); //} } } else { alert.Show("Incorrect Username or Password.", alert.AlertType.warning); } } catch (Exception a) { MessageBox.Show(a.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Stop); } } else { alert.Show("Please fill up all fields.", alert.AlertType.warning); } }