GetCommuteStatisticsIndicators()
{
var query = new Queries.CommuteStatisticsIndicatorQuery();
using (DbConnection db = this.GetDbConnection()) {
return(new Repositories
.CommuteStatisticsIndicatorRepository(
db, new Queries.ISqlQuery[] { query })
.FindAll()
.ToArray());
}
}
private StatisticsResultContainer GetCommuteStatisticsResultContainer(
int statisticsId,
int[] years,
string type = "yht",
int gender = 0,
string group = null,
string work_filter = null,
string home_filter = null,
int?area_year = null,
bool debug = false)
{
var indicatorQuery = new Queries.CommuteStatisticsIndicatorQuery();
indicatorQuery.StatisticsId = statisticsId;
using (DbConnection db = this.GetDbConnection()) {
var indicator = new Repositories
.CommuteStatisticsIndicatorRepository(
db, new Queries.ISqlQuery[] { indicatorQuery })
.Single();
var queries = new List <Queries.CommuteStatisticsQuery>();
foreach (int year in years)
{
var query = new Queries.CommuteStatisticsQuery();
query.GroupByAreaTypeIdIs = group;
query.YearIs = year;
query.TableName = indicator.TableName;
query.GenderIs = gender;
if (work_filter != null && work_filter.Length == 0)
{
work_filter = null;
}
query.WorkFilterQueryString = work_filter;
if (home_filter != null && home_filter.Length == 0)
{
home_filter = null;
}
query.HomeFilterQueryString = home_filter;
if (area_year != null)
{
query.AreaYearIs = area_year;
}
query.Type = type;
queries.Add(query);
}
if (debug)
{
Util.DebugOutput debugOutput;
if (queries.Count > 0)
{
debugOutput = new Util.DebugOutput(queries);
}
else
{
throw new Exception("No statistics queries specified!");
}
return(new StatisticsResultContainer()
{
DebugString = debugOutput.ToString(),
Results = null
});
/* We could continue here and fill the actual results,
* but if there's an error we might rather just want
* to see the query */
}
IEnumerable <Models.StatisticsResult> results;
if (queries.Count > 0)
{
var repository =
new Repositories.NormalStatisticsRepository(
db, queries);
results = repository.FindAll();
}
else
{
throw new Exception("No statistics queries specified!");
}
/* Note: we are iterating the generator here, could be
* memory-inefficient */
return(new StatisticsResultContainer()
{
DebugString = null,
Results = results.ToList()
});
}
}
