private void timer1_Tick(object sender, EventArgs e)
{
timer1.Enabled = false;
timer2.Enabled = false;
if (connectable)
{
this.Hide();
Login login = new Login();
if (login.ShowDialog() == DialogResult.OK) Application.Run(new Login());
}
else
{
MessageBox.Show("Your connection to the Reporting system is inaccessible\nPlease relaunch the application.\nIf the problem persists, contact an administrator.", "Error");
Application.Exit();
}
}
private void button_login_Click(object sender, EventArgs e)
{
teachr = new Teacher();
string teacherid = textbox_teacherid.Text;
if (textbox_teacherid.Text == "ESYSTEM" && textbox_password.Text == "emailpassword")
{
this.Hide();
Email ema = new Email();
ema.ShowDialog();
logi = new Login();
logi.Show();
relaunched = true;
this.Close();
}
else
{
try
{
teacherid = CultureInfo.CurrentCulture.TextInfo.ToLower(teacherid);
MD5 md5 = new MD5CryptoServiceProvider();
md5.ComputeHash(ASCIIEncoding.ASCII.GetBytes(textbox_password.Text));
byte[] result = md5.Hash;
StringBuilder hashedpassword = new StringBuilder();
for (int i = 0; i < result.Length; i++)
hashedpassword.Append(result[i].ToString("x2"));
if (gl.oleconnection.State == ConnectionState.Closed) gl.oleconnection.Open();
OleDbCommand getteacherscommand = gl.oleconnection.CreateCommand();
getteacherscommand.CommandText = "SELECT * FROM `" + gl.tbl_teacherinfo + "` WHERE `" + gl.col_teacherid + "`=@tid AND `" + gl.col_password + "`=@pass";
getteacherscommand.Parameters.Add("tid", OleDbType.VarChar, 255).Value = teacherid;
getteacherscommand.Parameters.Add("pass", OleDbType.VarChar, 255).Value = hashedpassword.ToString();
getteacherscommand.CommandType = CommandType.Text;
OleDbDataReader getteacher = getteacherscommand.ExecuteReader();
while (getteacher.Read())
{
if (real == false)
{
if (teacherid.Contains(getteacher[gl.col_teacherid].ToString()))
{
if (hashedpassword.ToString() == getteacher[gl.col_password].ToString())
{
teachr.teacherfirstname = getteacher[gl.col_firstname].ToString();
teachr.teacherlastname = getteacher[gl.col_lastname].ToString();
teachr.teacherid = getteacher[gl.col_teacherid].ToString();
if (getteacher[gl.col_dean].ToString() == CultureInfo.CurrentCulture.TextInfo.ToLower(gl.glt_isdean) || getteacher[gl.col_dean].ToString() == CultureInfo.CurrentCulture.TextInfo.ToTitleCase(gl.glt_isdean))
teachr.admin = true;
real = true;
}
}
}
}
}
catch (Exception x) { MessageBox.Show(x.Message, "Error"); }
finally
{
if (gl.oleconnection.State == ConnectionState.Open) gl.oleconnection.Close();
if (real)
{
this.Hide();
teachr.ShowDialog();
logi = new Login();
logi.Show();
relaunched = true;
this.Close();
}
else
MessageBox.Show("Check your user information", "Incorrect teacher I.D or Password");
}
}
}
