public static LoginModel GetAccountInfo(long _userID = 0)
{
IDataReader dr = null;
try
{
wlSQL objWLSql = new wlSQL();
objWLSql.AddParameter("@UserID", DbType.Int64, ParameterDirection.Input, 0, _userID);
dr = objWLSql.Execute("p_Users_sel_AccountInfo");
}
catch (Exception ex)
{
throw wlLogging.HandleEx(ex);
}
return(Util.ContructList <LoginModel>(dr).FirstOrDefault());
}
//Authentication
public static Users ValidateUser(string userName, string password)
{
IDataReader dr = null;
try
{
wlSQL objWLSql = new wlSQL();
objWLSql.AddParameter("@UserName", DbType.String, ParameterDirection.Input, 0, userName);
objWLSql.AddParameter("@Password", DbType.String, ParameterDirection.Input, 0, password);
dr = objWLSql.Execute("p_Users_sel_byUserIDAndPassword");
}
catch (Exception ex)
{
wlLogging.HandleEx(ex);
}
return(Util.ContructList <Users>(dr).FirstOrDefault());
}