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