public static PoliticiansAdminReportViewTable GetData( PoliticiansAdminReportViewOptions options, int commandTimeout = -1) { var cmdText = SelectAllCommandText + options.BuildWhereClause(); var cmd = VoteDb.GetCommand(cmdText, commandTimeout); return(FillTable(cmd, PoliticiansAdminReportViewTable.ColumnSet.All)); }
// ReSharper disable MemberCanBePrivate.Global // ReSharper disable MemberCanBeProtected.Global // ReSharper disable UnusedMember.Global // ReSharper disable UnusedMethodReturnValue.Global // ReSharper disable UnusedAutoPropertyAccessor.Global public static int CountData(PoliticiansAdminReportViewOptions options, int commandTimeout = -1) { var cmdText = "SELECT COUNT(*) FROM PoliticiansAdminReportView" + options.BuildWhereClause(); var cmd = VoteDb.GetCommand(cmdText, commandTimeout); var result = VoteDb.ExecuteScalar(cmd); return(Convert.ToInt32(result)); }
// ReSharper disable MemberCanBePrivate.Global // ReSharper disable MemberCanBeProtected.Global // ReSharper disable UnusedMember.Global // ReSharper disable UnusedMethodReturnValue.Global // ReSharper disable UnusedAutoPropertyAccessor.Global public static int CountData( PoliticiansAdminReportViewOption option = PoliticiansAdminReportViewOption.None, OfficeClass officeClass = OfficeClass.All, string stateCode = "", string countyCode = "", string localCode = "", int commandTimeout = -1) { var options = new PoliticiansAdminReportViewOptions { Option = option, OfficeClass = officeClass, StateCode = stateCode, CountyCode = countyCode, LocalCode = localCode }; return(CountData(options, commandTimeout)); }