/// <summary>
/// Queries the database for all hub data
/// </summary>
/// <returns></returns>
private DataTable GetHubData()
{
var db = new AccessDatabase(this.querySetup.DatabasePath);
var factory = new LocalityHubsQuerySQLFactory(this.querySetup);
var builder = new StandardQueryBuilder(factory);
var data = db.ExecuteQuery(builder.BuildSQL());
return(data);
}
private DataTable GetData(string locality)
{
var db = new AccessDatabase(querySetup.DatabasePath);
var factory = new VisitsByLocalityQuerySQLFactory(querySetup, locality);
var builder = new StandardQueryBuilder(factory);
Console.WriteLine("Retrieving data for {0}", locality);
var data = db.ExecuteQuery(builder.BuildSQL());
return(data);
}
/// <summary>
/// Querys the database
/// </summary>
/// <param name="locality"></param>
/// <returns></returns>
private DataTable GetData(string locality)
{
var db = new AccessDatabase(this.querySetup.DatabasePath);
var factory = new VisitsByLocalityQuerySQLFactory(this.querySetup, locality);
var builder = new StandardQueryBuilder(factory);
DataTable data = null;
try
{
data = db.ExecuteQuery(builder.BuildSQL());
}
catch (System.Data.OleDb.OleDbException ex)
{
throw new ArgumentException("Cannot open database. Please check that path is correct", ex);
}
return(data);
}