private void Hyni_button_Click_1(object sender, EventArgs e)
{
try
{
MySqlConnection conn = new MySqlConnection(connstr);
conn.Open();
//RoleID = '1'
string MesLog_query = "Select count(*) from Login where User_Name = '" + UsernametextBox.Text + "' and Pasword = '" + PasstextBox.Text + "' AND RoleID = 1 ";
MySqlCommand cmd = new MySqlCommand(MesLog_query, conn);
cmd.ExecuteReader();
conn.Close();
MySqlDataAdapter sda = new MySqlDataAdapter(cmd);
DataTable dt = new DataTable();
sda.Fill(dt);
if (Convert.ToInt32(dt.Rows[0][0]) == 1)
{
CookieClass.LoginID = UsernametextBox.Text;
MessageBox.Show("Vendosja e kredencialeve u krye me sukses!", " ", MessageBoxButtons.OK, MessageBoxIcon.Information);
MesuesMain m = new MesuesMain();
m.Show();
this.Hide();
}
else
{
label1.Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void Hyni_button_Click(object sender, EventArgs e)
{
//string query = "Select * from MESUES where Username = '******' and Password = '******' ";
//SqlConnection con = new SqlConnection(connectionsString);
//con.Open();
//sda = new SqlDataAdapter(query, con);
//sda.SelectCommand.ExecuteNonQuery();
//DataTable dt = new DataTable();
//sda.Fill(dt);
//if (dt.Rows[0][0].ToString == "1")
//{
PassPanel.BackColor = Color.FromArgb(100, 149, 237);
PasstextBox.ForeColor = Color.Black;
UsernamePanel.BackColor = Color.FromArgb(100, 149, 237);
UsernamePanel.ForeColor = Color.Black;
if (UsernametextBox.Text == "2030" && PasstextBox.Text == "1234")
{
MessageBox.Show("Vendosja e kredencialeve u krye me sukses!", " ", MessageBoxButtons.OK, MessageBoxIcon.Information);
// this.Hide();
// MesueseMain m = new MesueseMain();
// m.Show();
//}
//else
//{
// MessageBox.Show("Ju nuk u futet me sukses ne platforme! ");
//}
MesuesMain mm = new MesuesMain();
mm.Show();
this.Hide();
}
//con.Close();
else
{
MessageBox.Show("Vendosni sakte kredencialet!", " Mësuesi nuk ekziston ", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
