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]); }