public void ExportLakes()
{
Console.WriteLine("Exporting Minnesota lakes...");
var minnesota = _troutDashContext.states.Single(s => s.short_name == "MN");
Console.WriteLine("Deleting Minnesota lakes...");
_troutDashContext.lakes.RemoveRange(minnesota.lakes);
_troutDashContext.SaveChanges();
Console.WriteLine("Deleted Minnesota lakes...");
_sequenceRestarter.RestartSequence("lake_gid_seq");
var lakes = _minnesotaContext.Lakes.ToList().Select(i => new lake
{
Geom = i.Geom_4326,
name = i.pw_pasin_n ?? "Unnamed",
source_id = i.dnr_hydro_.ToString(),
state = minnesota,
state_gid = minnesota.gid,
is_trout_lake = false
});
Console.WriteLine("Saving Minnesota lakes...");
_troutDashContext.lakes.AddRange(lakes);
_troutDashContext.SaveChanges();
Console.WriteLine("Saved Minnesota lakes.");
}
public void ExportRestrictionSections()
{
Console.WriteLine("Exporting Restriction Sections...");
var state = _troutDashContext2.states.First(s => s.short_name == "MN");
var preExistingSections = state.streams.SelectMany(s => s.restriction_section);
_troutDashContext2.restriction_section.RemoveRange(preExistingSections);
_troutDashContext2.SaveChanges();
_sequenceRestarter.RestartSequence("restriction_section_id_seq");
var restrictions = state.restrictions.ToDictionary(i => i.source_id);
state.streams.ToList()
.AsParallel()
.ForAll(stream => Stuff(stream, restrictions));
}
private void ExportRestrictionRoutes()
{
using (var context = new MinnesotaShapeDataContext())
using (var troutDashContext = new TroutDashPrototypeContext())
{
// clear out the old.
Console.WriteLine("Caching minnesota restriction routes...");
var minnesota = troutDashContext.states.Single(s => s.short_name == "MN");
var routes = minnesota.restrictions.SelectMany(i => i.restrictionRoutes);
troutDashContext.restriction_routes.RemoveRange(routes);
Console.WriteLine("Deleting minnesota restriction routes...");
troutDashContext.SaveChanges();
_sequenceRestarter.RestartSequence("restriction_route_id_seq");
var restrictions = troutDashContext.restrictions.ToDictionary(i => i.source_id);
var restrictionRoutes = context.strm_regsln3.ToList();
Console.WriteLine("Building minnesota restriction routes...");
foreach (var restrictionRoute in restrictionRoutes)
{
var route = new restriction_route();
route.Restriction = restrictions[restrictionRoute.new_reg.ToString()];
route.Geom = restrictionRoute.Geom_4326;
route.source_id = restrictionRoute.gid.ToString();
troutDashContext.restriction_routes.Add(route);
}
Console.WriteLine("Saving minnesota restriction routes...");
troutDashContext.SaveChanges(); // TODO: MOVE THIS.
Console.WriteLine("Saved minnesota restriction routes...");
}
using (var context = new MinnesotaShapeDataContext())
using (var troutDashContext = new TroutDashPrototypeContext())
{
var stuff =
troutDashContext.restrictions.SelectMany(r => r.restrictionRoutes).Select(i => i.gid).ToList();
}
}
