public static WebShopDbContext InMemoryDatabase()
{
var dbOptions = new DbContextOptionsBuilder().UseInMemoryDatabase(Guid.NewGuid().ToString()).Options;
var db = new WebShopDbContext(dbOptions);
return(db);
}
private void CreateProductCategorySample(WebShopDbContext context)
{
if (context.ProductCategories.Count() == 0)
{
List <ProductCategory> listProductCategory = new List <ProductCategory>()
{
new ProductCategory()
{
Name = "Pháo khói màu", Alias = "phao-khoi-mau", Status = true, CreatedDate = DateTime.Now, HomeFlag = true, DisplayOrder = 1
},
new ProductCategory()
{
Name = "Pháo điện", Alias = "phao-dien", Status = true, CreatedDate = DateTime.Now, HomeFlag = true, DisplayOrder = 2
},
new ProductCategory()
{
Name = "Các loại pháo khác", Alias = "cac-loai-phao-khac", Status = true, CreatedDate = DateTime.Now, HomeFlag = true, DisplayOrder = 3
},
new ProductCategory()
{
Name = "Thiết bị sân khấu", Alias = "thiet-bi-san-khau", Status = true, CreatedDate = DateTime.Now, HomeFlag = true, DisplayOrder = 4
},
};
context.ProductCategories.AddRange(listProductCategory);
context.SaveChanges();
}
}
protected override void Seed(WebShopDbContext context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data.
//CreateProductCategorySample(context);
//var manager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(new WebShopDbContext()));
//var roleManager = new RoleManager<IdentityRole>(new RoleStore<IdentityRole>(new WebShopDbContext()));
//var user = new ApplicationUser()
//{
// UserName = "******",
// Email = "*****@*****.**",
// EmailConfirmed = true,
// BirthDay = DateTime.Now,
// FullName = "Sương Gió Hà Nội",
//};
//manager.Create(user, "123456$");
//if (!roleManager.Roles.Any())
//{
// roleManager.Create(new IdentityRole { Name = "Admin" });
// roleManager.Create(new IdentityRole { Name = "User" });
//}
//var adminUser = manager.FindByEmail("*****@*****.**");
//manager.AddToRoles(adminUser.Id, new string[] { "Admin", "User" });
}
public UnitOfWork(WebShopDbContext context)
{
_context = context;
Product = new ProductRepository(context);
Order = new OrderRepository(context);
ShoppingCart = context.ShoppingCartItems;
OrderDetail = new OrderDetailRepository(context);
}
public IndexModel(
UserManager <WebShopUser> userManager,
SignInManager <WebShopUser> signInManager,
WebShopDbContext context)
{
_userManager = userManager;
_signInManager = signInManager;
this.context = context;
}
protected void UsingDbContext(int?tenantId, Action <WebShopDbContext> action)
{
using (UsingTenantId(tenantId))
{
using (WebShopDbContext context = LocalIocManager.Resolve <WebShopDbContext>())
{
action(context);
context.SaveChanges();
}
}
}
public static void SeedHostDb(WebShopDbContext context)
{
context.SuppressAutoSetTenantId = true;
// Host seed
new InitialHostDbBuilder(context).Create();
// Default tenant seed (in host database).
new DefaultTenantBuilder(context).Create();
new TenantRoleAndUserBuilder(context, 1).Create();
}
protected async Task UsingDbContextAsync(int?tenantId, Func <WebShopDbContext, Task> action)
{
using (UsingTenantId(tenantId))
{
using (WebShopDbContext context = LocalIocManager.Resolve <WebShopDbContext>())
{
await action(context);
await context.SaveChangesAsync();
}
}
}
public RegisterModel(
UserManager <ApplicationUser> userManager,
SignInManager <ApplicationUser> signInManager,
ILogger <RegisterModel> logger,
IEmailSender emailSender,
WebShopDbContext _db)
{
_userManager = userManager;
_signInManager = signInManager;
_logger = logger;
_emailSender = emailSender;
db = _db;
}
protected T UsingDbContext <T>(int?tenantId, Func <WebShopDbContext, T> func)
{
T result;
using (UsingTenantId(tenantId))
{
using (WebShopDbContext context = LocalIocManager.Resolve <WebShopDbContext>())
{
result = func(context);
context.SaveChanges();
}
}
return(result);
}
protected async Task <T> UsingDbContextAsync <T>(int?tenantId, Func <WebShopDbContext, Task <T> > func)
{
T result;
using (UsingTenantId(tenantId))
{
using (WebShopDbContext context = LocalIocManager.Resolve <WebShopDbContext>())
{
result = await func(context);
await context.SaveChangesAsync();
}
}
return(result);
}
public WebShopDbContext Init()
{
return(dbContext ?? (dbContext = new WebShopDbContext()));
}
public ManageProductService(WebShopDbContext context)
{
_context = context;
}
public HomeController(ILogger <HomeController> logger, WebShopDbContext dbContext)
{
_logger = logger;
_dbContext = dbContext;
}
public PublicProductService(WebShopDbContext context)
{
_context = context;
}
public CustomerRepository(WebShopDbContext ctx)
{
_ctx = ctx;
}
public PurchaseController(WebShopDbContext _db, UserManager <ApplicationUser> _um, CartService _cService)
{
db = _db;
um = _um;
cService = _cService;
}
public OrderRepository(WebShopDbContext ctx)
{
_ctx = ctx;
}
public ItemService(WebShopDbContext dbContext)
{
this.context = dbContext;
}
public DefaultTenantBuilder(WebShopDbContext context)
{
_context = context;
}
public ItemsApiController(WebShopDbContext context)
{
_context = context;
}
public AdminController(WebShopDbContext context)
{
_context = context;
}
public CartController(WebShopDbContext _db, CartService _cService)
{
db = _db;
cService = _cService;
cart = cService.ReadCart();
}
public TenantRoleAndUserBuilder(WebShopDbContext context, int tenantId)
{
_context = context;
_tenantId = tenantId;
}
public DefaultEditionCreator(WebShopDbContext context)
{
_context = context;
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, UserManager <WebShopUser> userManager, RoleManager <IdentityRole <Guid> > roleManager, WebShopDbContext context)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Home/Error");
// The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseAuthentication();
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints =>
{
endpoints.MapControllers();
endpoints.MapRazorPages();
endpoints.MapControllerRoute(
name: "default",
pattern: "{controller=Home}/{action=Index}/{id?}");
});
//TODO: So ugly, debug thread issue with dbcontext error in SeedUsers
UserSeeder.SeedUsers(userManager, roleManager, context).Wait();
}
public TagsController(WebShopDbContext context)
{
_context = context;
}
public IsUserAdminService(WebShopDbContext dbContext, UserManager <AppUser> userManager, IHttpContextAccessor accessor)
{
_dbContext = dbContext;
_userManager = userManager;
_accessor = accessor;
}
public HomeController(WebShopDbContext _db)
{
db = _db;
}
public UserService(Dal.Context.WebShopDbContext dbContext)
{
this.context = dbContext;
}
