private void okClick(object sender, RoutedEventArgs e)
{
if (passwordBox.Password.Length == 0)
{
errormessage.Text = "Please enter your password.";
passwordBox.Focus();
}
if (employeeIDBox.Text.Length == 0)
{
errormessage.Text = "Please enter your Employee ID.";
employeeIDBox.Focus();
}
else
{
if (passwordBox.Password.Length == 0)
{
errormessage.Text = "Please enter your password.";
passwordBox.Focus();
}
else
{
Global.empId = employeeIDBox.Text; //get Id from form
string password = passwordBox.Password; //get password from form
String str = @"server=localhost;database=users;userid=root;password=;";
MySqlConnection con = null;
MySqlDataReader reader = null;
String pass = null;
try
{
con = new MySqlConnection(str);
con.Open(); //open the connection
MySqlCommand cmdOne = new MySqlCommand("SELECT Password, isAdmin, EmployeeId, UserName FROM employeetable WHERE EmployeeId=" + Global.empId, con);
cmdOne.ExecuteNonQuery();
reader = cmdOne.ExecuteReader();
while (reader.Read())
{
pass = reader.GetString(0);
bool admin = reader.GetBoolean(1);
Global.isadmin = admin;
String Id = reader.GetString(2);
String userName = reader.GetString(3);
Global.empName = userName;
if (pass == password && admin == true)
{
MessageBox.Show("Welcome " + userName + "!");
AdminWindow window = new AdminWindow();
Close();
window.setCreatingForm = this;
window.Show();
}
else if (pass != password)
{
errormessage.Text = "You have entered the wrong password, try again";
passwordBox.Focus();
}
else if (pass == password && admin == false)
{
MessageBox.Show("Welcome " + userName + "!");
UserWindow userWindow = new UserWindow();
Close();
userWindow.Show();
}
}
if (pass == null)
{
errormessage.Text = "Employee ID does not exist, try again";
}
}
catch (MySqlException err) //capture and display any MySql errors that will occur
{
// Exception is connecting to the database
//MessageBox.Show("Error: " + err.ToString());
MessageBox.Show("There is some error trying to connect to the database");
}
finally
{
if (con != null)
{
con.Close(); //safely close the connection
}
}
}
}
}
private void okClick(object sender, RoutedEventArgs e)
{
if (passwordBox.Password.Length == 0)
{
errormessage.Text = "Please enter your password.";
passwordBox.Focus();
}
if (employeeIDBox.Text.Length == 0)
{
errormessage.Text = "Please enter your Employee ID.";
employeeIDBox.Focus();
}
else
{
if (passwordBox.Password.Length == 0)
{
errormessage.Text = "Please enter your password.";
passwordBox.Focus();
}
else
{
Global.empId = employeeIDBox.Text; //get Id from form
string password = passwordBox.Password; //get password from form
String str = @"server=localhost;database=users;userid=root;password=;";
MySqlConnection con = null;
MySqlDataReader reader = null;
String pass = null;
try
{
con = new MySqlConnection(str);
con.Open(); //open the connection
MySqlCommand cmdOne = new MySqlCommand("SELECT Password, isAdmin, EmployeeId, UserName FROM employeetable WHERE EmployeeId=" + Global.empId, con);
cmdOne.ExecuteNonQuery();
reader = cmdOne.ExecuteReader();
while (reader.Read())
{
pass = reader.GetString(0);
bool admin = reader.GetBoolean(1);
Global.isadmin = admin;
String Id = reader.GetString(2);
String userName = reader.GetString(3);
Global.empName = userName;
if (pass == password && admin == true)
{
MessageBox.Show("Welcome " + userName + "!");
AdminWindow window = new AdminWindow();
Close();
window.setCreatingForm = this;
window.Show();
}
else if(pass != password)
{
errormessage.Text = "You have entered the wrong password, try again";
passwordBox.Focus();
}
else if (pass == password && admin == false)
{
MessageBox.Show("Welcome " + userName + "!");
UserWindow userWindow = new UserWindow();
Close();
userWindow.Show();
}
}
if (pass == null)
{
errormessage.Text = "Employee ID does not exist, try again";
}
}
catch (MySqlException err) //capture and display any MySql errors that will occur
{
// Exception is connecting to the database
//MessageBox.Show("Error: " + err.ToString());
MessageBox.Show("There is some error trying to connect to the database");
}
finally
{
if (con != null)
{
con.Close(); //safely close the connection
}
}
}
}
}
