private void button1_Click(object sender, EventArgs e)
{
int currentid = Class1.currentid;
string query = "SELECT usertype FROM users WHERE userid='" + currentid + "';";
conn.Open();
MySqlCommand comm = new MySqlCommand(query, conn);
MySqlDataAdapter adp = new MySqlDataAdapter(comm);
conn.Close();
DataTable dt = new DataTable();
adp.Fill(dt);
if (dt.Rows.Count == 1)
{
string utype = dt.Rows[0][0].ToString();
if (utype == "Student")
{
Form10 home = new Form10(userid);
home.previousForm = this;
home.Show();
this.Hide();
}
else
{
Form2 home = new Form2();
home.previousForm = this;
home.Show();
this.Hide();
}
}
}
private void btnhome_Click(object sender, EventArgs e)
{
Form10 anotherform = new Form10(userid);
anotherform.previousForm = this;
anotherform.Show();
this.Close();
}
private void btnlogin_Click(object sender, EventArgs e)
{
string usr = txtuser.Text;
string psw = txtpass.Text;
string query = "SELECT * FROM users WHERE username='******'AND password='******';";
conn.Open();
MySqlCommand comm = new MySqlCommand(query, conn);
MySqlDataAdapter adp = new MySqlDataAdapter(comm);
conn.Close();
DataTable dt = new DataTable();
adp.Fill(dt);
if (dt.Rows.Count == 1)
{
string fn = dt.Rows[0][1].ToString();
string ln = dt.Rows[0][2].ToString();
string utype = dt.Rows[0][8].ToString();
int userid = int.Parse(dt.Rows[0][0].ToString());
Class1.currentid = int.Parse(dt.Rows[0][0].ToString());
MessageBox.Show("Welcome " + ln + ", " + fn + "!", "",
MessageBoxButtons.OK, MessageBoxIcon.Information);
if (utype == "Admin")
{
Form2 anotherform = new Form2();
anotherform.previousForm = this;
anotherform.types = dt.Rows[0][1].ToString();
anotherform.typesfn = dt.Rows[0][3].ToString();
anotherform.Show();
this.Hide();
}
if (utype == "Student")
{
Form10 form = new Form10(userid);
form.previousForm = this;
form.Show();
form.fn = dt.Rows[0][1].ToString();
form.ln = dt.Rows[0][3].ToString();
this.Hide();
}
}
else
{
if (usr == "")
{
MessageBox.Show("Username is empty.");
}
else if (psw == "")
{
MessageBox.Show("Password is empty.");
}
else if (psw == "" && usr == "")
{
MessageBox.Show("Enter your credentials.");
}
else
{
MessageBox.Show("Records not found.");
}
txtuser.Clear();
txtpass.Clear();
}
}