private void back_btn_Click(object sender, EventArgs e)
{
Close();
Admin_Homepage back = new Admin_Homepage();
back.Show();
}
private void login_btn_Click(object sender, EventArgs e)
{
if (invalid_pass)
{
status.Text = "Pass contains invalid characters";
return;
}
// get data from username and password fields and compare to those in the database.
string user = this.username.Text;
string pass = this.password.Text;
// connect to the database
string conn = "server=localhost;database=doctorsschedule;uid=root;";
MySqlConnection cnn = new MySqlConnection(conn);
string query = "SELECT first_name, last_name, type FROM users WHERE username='******' AND password='******' LIMIT 1";
MySqlCommand commandDatabase = new MySqlCommand(query, cnn);
commandDatabase.CommandTimeout = 60;
try
{
cnn.Open();
MySqlDataReader reader = commandDatabase.ExecuteReader();
if (reader.HasRows)
{
Teacher_Homepage main = new Teacher_Homepage();
Student_Homepage student_main;
Admin_Homepage admin_main;
char user_type = 'a';
string fname;
string lname;
// you have to run the method read before accessing results
while (reader.Read())
{
// Capitalizing the first character of the first name and last name
fname = capitalizeFirst(reader.GetString(0));
lname = capitalizeFirst(reader.GetString(1));
user_type = reader.GetChar(2);
// can i add a global class to save these. userdata.cs
userdata.username = fname + " " + lname;
userdata.first_name = fname;
userdata.last_name = lname;
}
userdata.f = this;
this.Hide();
this.username.Text = "";
this.password.Text = "";
switch (user_type)
{
case 'a':
student_main = new Student_Homepage();
student_main.Show();
break;
case 'b':
main = new Teacher_Homepage();
main.Show();
break;
// this should be changed later.
case 'c':
admin_main = new Admin_Homepage();
admin_main.Show();
break;
case 'd':
admin_main = new Admin_Homepage();
admin_main.Show();
break;
}
// show all the different forms based on the user type
}
else
{
this.status.Text = "Invalid Credentials";
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}