public bool VerifyAccess(String userid, String password) { String result = String.Empty; try { String ConnectionString = ApplicationCommon.GetAiesDbConnectionString(); String sqlcmd = "XRAI_SELECT_VERIFY_ACCESS"; SqlParameter[] paramCollection = new SqlParameter[2]; paramCollection[0] = new SqlParameter(); paramCollection[0].SqlDbType = SqlDbType.VarChar; paramCollection[0].ParameterName = "@UserId"; paramCollection[0].Value = userid; paramCollection[1] = new SqlParameter(); paramCollection[1].SqlDbType = SqlDbType.VarChar; paramCollection[1].ParameterName = "@Password"; paramCollection[1].Value = password; // result = base.ExecuteScalar(sqlcmd, paramCollection, ConnectionString); } catch (Exception ex) { } // result.Add(_resultitem); return(result == "Y"); }
public System.Data.DataSet SelectUserRole(String userId) { // String ConnectionString = ApplicationCommonController.GetASDConnectionString(); String ConnectionString = ApplicationCommon.GetAiesDbConnectionString(); const string sqlCommand = StoredProcedures.ProcedureName; DataSet dsDatabase = new DataSet(); DataTable dt = new DataTable(); SqlParameter[] paramCollection = new SqlParameter[1]; paramCollection[0] = new SqlParameter(); paramCollection[0].SqlDbType = SqlDbType.VarChar; paramCollection[0].ParameterName = "@USER_ID"; paramCollection[0].Value = userId; // dsDatabase = base.ExecuteQuery(sqlCommand, CommandType.StoredProcedure, paramCollection, ConnectionString); return(dsDatabase); }