public static void ClearData(BEIdentityContext context) { context.Database.ExecuteSqlRaw("Delete from dbo.Suppliers"); context.Database.ExecuteSqlRaw("Delete from dbo.Orders"); context.Database.ExecuteSqlRaw("Delete from dbo.Categories"); ResetIdentity(context); }
public static void InitializeData(BEIdentityContext context) { //Ensure the database exists and is up to date context.Database.Migrate(); ClearData(context); SeedData(context); }
internal static void ResetIdentity(BEIdentityContext context) { var tables = new[] { "Suppliers", "Products", "Ratings", "Orders", "CartLines", "Payments", "Categories" }; foreach (var itm in tables) { var rawSqlString = $"DBCC CHECKIDENT (\"dbo.{itm}\", RESEED, 0);"; context.Database.ExecuteSqlRaw(rawSqlString); } }
internal static void SeedData(BEIdentityContext context) { try { if (!context.Categories.Any()) { context.Categories.AddRange(SampleData.GetAllCategories()); context.SaveChanges(); } if (!context.Suppliers.Any()) { var cat1 = context.Categories.FirstOrDefault(); var cat2 = context.Categories.Skip(1).FirstOrDefault(); context.Suppliers.AddRange(SampleData.GetSuppliers(new List <Category> { cat1, cat2 })); context.SaveChanges(); } if (!context.Orders.Any()) { var prod1 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.FirstOrDefault(); var prod2 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(1).FirstOrDefault(); context.Orders.AddRange(SampleData.GetAllOrders(new List <Product> { prod1, prod2 })); context.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex); } }
public ProductsController(IProductRepo repo, BEIdentityContext ctx) { _repo = repo; }
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, IServiceProvider services, IHostApplicationLifetime lifetime) { app.UseCors("AllowAll"); if (env.IsDevelopment()) { app.UseDeveloperExceptionPage(); } else { app.UseExceptionHandler("/Home/Error"); app.UseHsts(); } app.UseHttpsRedirection(); app.UseStaticFiles(); app.UseSession(); app.UseRouting(); app.UseAuthentication(); app.UseAuthorization(); app.UseEndpoints(endpoints => { endpoints.MapControllerRoute( name: "default", pattern: "{controller=Home}/{action=Index}/{id?}"); endpoints.MapRazorPages(); }); //For development app.UseSwagger(); app.UseSwaggerUI(options => { options.SwaggerEndpoint("/swagger/v1/swagger.json", "dbo API"); }); //For deployment if ((Configuration["INITDB"] ?? "false") == "true") { System.Console.WriteLine("Preparing Database..."); SeedData.SeedDataBase(services.GetRequiredService <BEIdentityContext>()); System.Console.WriteLine("Database Preparation Complete"); //Enable to deploy //lifetime.StopApplication(); } //To create default admin and user BEIdentityContext.CreateAdminAccount(app.ApplicationServices, Configuration).Wait(); BEIdentityContext.CreateUserAccount(app.ApplicationServices, Configuration).Wait(); //For development //app.UseSpa(spa => //{ // string strategy = Configuration // .GetValue<string>("DevTools:ConnectionStrategy"); // if (strategy == "proxy") // { // //spa.UseProxyToSpaDevelopmentServer("http://127.0.0.1:4200"); // spa.UseProxyToSpaDevelopmentServer("http://127.0.0.1:8100"); // //spa.UseProxyToSpaDevelopmentServer("http://192.168.2.4:8100"); // } // else if (strategy == "managed") // { // spa.Options.SourcePath = "../ClientApp"; // spa.UseAngularCliServer("start"); // } //}); }
public SupplierRepo(BEIdentityContext context) : base(context) { }
public static void SeedDataBase(BEIdentityContext context) { context.Database.Migrate(); try { if (!context.Categories.Any()) { context.Categories.AddRange(Data.GetAllCategories()); context.SaveChanges(); } if (!context.Suppliers.Any()) { var cat1 = context.Categories.FirstOrDefault(); var cat2 = context.Categories.Skip(1).FirstOrDefault(); var cat3 = context.Categories.Skip(2).FirstOrDefault(); var cat4 = context.Categories.Skip(3).FirstOrDefault(); var cat5 = context.Categories.Skip(4).FirstOrDefault(); context.Suppliers.AddRange( Data.GetSuppliers(new List <Category> { cat1, cat2, cat3, cat4, cat5 })); context.SaveChanges(); } if (!context.Orders.Any()) { var prod1 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.FirstOrDefault(); var prod2 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(1).FirstOrDefault(); //var prod3 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(2).FirstOrDefault(); //var prod4 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(3).FirstOrDefault(); //var prod5 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(4).FirstOrDefault(); var prod6 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(5).FirstOrDefault(); var prod7 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(6).FirstOrDefault(); var prod8 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(7).FirstOrDefault(); var prod9 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(8).FirstOrDefault(); var prod10 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(9).FirstOrDefault(); var prod11 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(10).FirstOrDefault(); //var prod12 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(11).FirstOrDefault(); //var prod13 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(12).FirstOrDefault(); var prod14 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(13).FirstOrDefault(); //var prod15 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(14).FirstOrDefault(); //var prod16 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(15).FirstOrDefault(); var prod17 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(16).FirstOrDefault(); //var prod18 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(17).FirstOrDefault(); var prod19 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(18).FirstOrDefault(); var prod20 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(19).FirstOrDefault(); var prod21 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(20).FirstOrDefault(); //var prod22 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(21).FirstOrDefault(); //var prod23 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(22).FirstOrDefault(); //var prod24 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(23).FirstOrDefault(); //var prod25 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(24).FirstOrDefault(); var prod26 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(25).FirstOrDefault(); var prod27 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(26).FirstOrDefault(); var prod28 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(27).FirstOrDefault(); var prod29 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(28).FirstOrDefault(); //var prod30 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(29).FirstOrDefault(); //var prod31 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(30).FirstOrDefault(); //var prod32 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(31).FirstOrDefault(); //var prod33 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(32).FirstOrDefault(); //var prod34 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(33).FirstOrDefault(); //var prod35 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(34).FirstOrDefault(); //var prod36 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(35).FirstOrDefault(); //var prod37 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(36).FirstOrDefault(); var prod38 = context.Suppliers .Include(c => c.Products).FirstOrDefault()? .Products.Skip(37).FirstOrDefault(); //var prod39 = context.Suppliers // .Include(c => c.Products).FirstOrDefault()? // .Products.Skip(38).FirstOrDefault(); context.Orders.AddRange(Data.GetAllOrders(new List <Product> { prod1, prod2, //prod3, //prod4, //prod5, prod6, prod7, prod8, prod9, prod10, prod11, //prod12, //prod13, prod14, //prod15, //prod16, prod17, //prod18, prod19, prod20, prod21, //prod22, //prod23, //prod24, //prod25, prod26, prod27, prod28, prod29, //prod30, //prod31, //prod32, //prod33, //prod34, //prod35, //prod36, //prod37, prod38, //prod39 })); context.SaveChanges(); } } catch (Exception ex) { Console.WriteLine(ex); } }
protected void ResetContext() { Context = new BEIdentityContextFactory().CreateDbContext(null); }
public static void DropAndCreateDatabase(BEIdentityContext context) { context.Database.EnsureDeleted(); context.Database.Migrate(); }
public OrderRepo(BEIdentityContext context) : base(context) { }
public CategoryRepo(BEIdentityContext context) : base(context) { }
public CartLineRepo(BEIdentityContext context, IProductRepo productRepo) : base(context) { _productRepo = productRepo; }
public ProductRepo(BEIdentityContext context) : base(context) { }
protected RepoBase(BEIdentityContext context) { Context = context; Table = Context.Set <T>(); }