public static bool validateLogin(UserLog ul)
{
DBConnector dbcon = new DBConnector();
dbcon.openConnection();
//try {
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "SELECT * FROM user WHERE username='******' AND password=MD5('" + ul.getPassword() + "')";
cmd.Connection = dbcon.connection;
MySqlDataReader login = cmd.ExecuteReader();
if (login.Read())
{
LoginSession.setSession(login.GetString("iduser"));
//login.Close();
dbcon.closeConnection();
return true;
}
else
{
//login.Close();
dbcon.closeConnection();
return false;
}
//}
//catch (MySqlException e){
//int errorcode = e.Number;
//return false;
//}
}
public static bool isMaster(UserLog ul)
{
if (ul.getUsername() == "ozious" && ul.getPassword() == "123") {
return true;
}
else
{
return false;
}
}
public static string addUser(UserLog ul)
{
//Set employee_id for employee number
ul.setEmp_id(getEmployeeID(ul.getEmp_no()));
Console.Write("Emp id = "+ul.getEmp_id() + "\n");
//Check whether user exists
if (!(userExists(ul.getEmp_id())))
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "INSERT INTO user (username, password, employee_idemployee, system_status, access_level) VALUES (N'" + ul.getUsername() + "', MD5('" + ul.getPassword() + "'), " + ul.getEmp_id() + ", 1, 1)";
cmd.Connection = dbcon.connection;
cmd.Prepare();
cmd.ExecuteNonQuery();
dbcon.closeConnection();
return "success";
}
else
{
return "";
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return false;
//}
}
else
{
return "user exists";
}
}
public static string updateUser(UserLog ul)
{
//Set employee_id for employee number
ul.setEmp_id(getEmployeeID(ul.getEmp_no()));
//Check whether user exists
if (userExists(ul.getEmp_id()))
{
//try
//{
DBConnector dbcon = new DBConnector();
if (dbcon.openConnection())
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandText = "UPDATE user SET username=N'" + ul.getUsername() + "', password=MD5('" + ul.getPassword() + "') WHERE employee_idemployee="+ ul.getEmp_id();
cmd.Connection = dbcon.connection;
cmd.Prepare();
cmd.ExecuteNonQuery();
dbcon.closeConnection();
return "success";
}
else
{
return "";
}
//}
//catch (MySqlException e)
//{
//int errorcode = e.Number;
//return false;
//}
}
else
{
return "user does not exist";
}
}