public Grid GetNewGrid()
{
Grid grid = new Grid(_queryConfig);
grid.ZoneId = ZoneId;
grid.ZoneName = Zone;
int max = 1;
if (Grids.Count > 0)
{
max = Grids.Max(x => x.Id) + 1;
}
grid.Created();
return grid;
}
private void Lookup()
{
var sql = String.Format(SelectString, SelectArgValues);
var results = Database.QueryHelper.RunQuery(_connection, sql);
var v = _queries.SelectQueryFields.FirstOrDefault(x => x.Property == "ZoneId");
string zoneIdField = null;
if (v != null)
{
zoneIdField = v.Column;
}
if (results != null)
{
foreach (var row in results)
{
Grid g = new Grid(_queryConfig);
if (row.ContainsKey(zoneIdField) && results.First() == row)
{
ZoneId = Int32.Parse(row[zoneIdField].ToString());
}
g.SetProperties(Queries, row);
Grids.Add(g);
g.Created();
}
foreach (var grid in Grids)
{
sql = String.Format(grid.SelectString, grid.SelectArgValues);
results = Database.QueryHelper.RunQuery(_connection, sql);
foreach (var row in results)
{
var wp = new Waypoint(_queryConfig);
wp.SetProperties(grid.Queries, row);
wp.GridReference = grid;
grid.Waypoints.Add(wp);
wp.Created();
}
}
}
}