protected AppUser ValidateLogin(string username, string passwd)
{
List <String> list = GetSystemDriverList();
DBManager db = new MySQLDBManager(Config.DB_SERVER, Config.DB_NAME, Config.DB_USER, Config.DB_PASSWORD, Config.DB_CHAR_ENC);
OdbcDataReader reader = null;
try
{
reader = db.Query("SELECT u.*, b.branch_name as branch_name FROM user u, branch b WHERE u.username='******' AND u.branch_id=b.branch_id");
while (reader.Read())
{
AppUser user = AppUser.CreateForm(reader);
if (user._encodedPassword == null)
{
return(null);
}
if (user._encodedPassword.Equals(AppUser.GetMD5Encoded(passwd)))
{
return(user);
}
}
return(null);
}
catch (Exception e) { Console.WriteLine(e.StackTrace); return(null); }
finally { db.Close(reader); }
}