public static DataTable getMaxUserID()
{
BaseClass = new MTutorDataAccessBase();
string sSQL = SQL_QUERY.get_max_memberID;
SqlParameter[] arrParams = new SqlParameter[0];
SqlCommand cmd;
//arrParams[0] = _dbHelper.getParameter("@id", DbType.Int64, EmpID);
cmd = BaseClass.getSQLCommand(sSQL, arrParams);
return(BaseClass.getQueryResultset(cmd).Tables[0]);
}
public static DataTable getUserProfile(string _userid)
{
BaseClass = new MTutorDataAccessBase();
string sSQL = SQL_QUERY.get_user_profile;
SqlParameter[] arrParams = new SqlParameter[1];
SqlCommand cmd;
arrParams[0] = BaseClass.getSQLParameter("@userID", DbType.String, _userid);
cmd = BaseClass.getSQLCommand(sSQL, arrParams);
return(BaseClass.getQueryResultset(cmd).Tables[0]);
}
public static DataTable isValidReferenceCode(string refCode)
{
BaseClass = new MTutorDataAccessBase();
string sSQL = SQL_QUERY.is_valid_reference_code;
SqlParameter[] sqlParams = new SqlParameter[1];
SqlCommand sqlCmnd;
sqlParams[0] = BaseClass.getSQLParameter("@refCode", DbType.String, refCode);
sqlCmnd = BaseClass.getSQLCommand(sSQL, sqlParams);
return(BaseClass.getQueryResultset(sqlCmnd).Tables[0]);
}
public static DataTable AuthenticateUser(string _userName, string _passWord)
{
BaseClass = new MTutorDataAccessBase();
string sSQL = SQL_QUERY.authentication;
SqlParameter[] arrParams = new SqlParameter[2];
SqlCommand cmd;
arrParams[0] = BaseClass.getSQLParameter("@userName", DbType.String, _userName);
arrParams[1] = BaseClass.getSQLParameter("@passWord", DbType.String, _passWord);
cmd = BaseClass.getSQLCommand(sSQL, arrParams);
return(BaseClass.getQueryResultset(cmd).Tables[0]);
}
