public static OfficesAdminReportViewTable GetData(
OfficesAdminReportViewOptions options, int commandTimeout = -1)
{
var cmdText = SelectAllCommandText + options.BuildWhereClause();
var cmd = VoteDb.GetCommand(cmdText, commandTimeout);
return(FillTable(cmd, OfficesAdminReportViewTable.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(OfficesAdminReportViewOptions options,
int commandTimeout = -1)
{
var cmdText = "SELECT COUNT(*) FROM OfficesAdminReportView" +
options.BuildWhereClause();
var cmd = VoteDb.GetCommand(cmdText, commandTimeout);
var result = VoteDb.ExecuteScalar(cmd);
return(Convert.ToInt32(result));
}