// This method gets called by the runtime. Use this method to configure the HTTP request pipeline. public void Configure(IApplicationBuilder app, IWebHostEnvironment env, ParkingSiteDbContext context) { if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } app.UseRouting(); app.UseEndpoints(endpoints => { endpoints.MapControllers(); }); // context.SeedDataContext(); app.Run(async(context) => { await context.Response.WriteAsync("Hi There"); } ); }
public static void SeedDataContext(this ParkingSiteDbContext context) { string[] valueLines = System.IO.File.ReadAllLines(@"e:\Value1.CSV"); var parkingSites = new List <ParkingSite>(); foreach (var line in valueLines) { var column = line.Split(','); int i = -1; Int32.TryParse(column[5], out i); ParkingSite p = new ParkingSite { Parm1 = column[1], Parm2 = column[2], Parm3 = column[3], API = column[4], NumberOfSpaces = i }; parkingSites.Add(p); } context.AddRange(parkingSites); context.SaveChanges(); var siteLines = System.IO.File.ReadAllLines(@"e:\Key1.CSV"); var siteAreaKeys = new List <SiteArea>(); foreach (var line in siteLines) { int areaId; var column = line.Split(','); var parkingArea = new ParkingArea { AreaName = column[1] }; context.Add(parkingArea); context.SaveChanges(); var area = context.ParkingAreas.Where(pa => pa.AreaName == parkingArea.AreaName).FirstOrDefault(); if (area != null) { areaId = area.Id; } else { areaId = 0; }; var sites = column[3].Split(' '); foreach (var site in sites) { int i = Int32.Parse(site); string[] siteLine = valueLines[i - 1].Split(','); string sitesId = siteLine[1]; var aSite = context.ParkingSite.Where(s => s.Parm1 == sitesId).FirstOrDefault(); if (aSite != null && areaId != 0) { var siteArea = new SiteArea(); siteArea.AreaId = areaId; siteArea.SiteId = aSite.Id; context.Add(siteArea); context.SaveChanges(); } int z = 0; } } // context.AddRange(parkingAreas); // context.SaveChanges(); int y = 0; }