public static async Task AddTestData(ShopOnWheelsDbContext context)
{
await context.Database.ExecuteSqlCommandAsync($@"INSERT INTO `categories` (`Id`, `Name`, `IsDeleted`, `CreatedOn`, `ModifiedOn`) VALUES
('ath99ed6-0c-4d0e', 'milk products', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873'),
('btk94ed6-0c-4d0e', 'meat', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873'),
('atl96ed6-0c-450e', 'vegetables', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873'),
('ath99md6-0c-4d0e', 'fruits', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873'),
('ath9ved6-0c-5d0e', 'bakery', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873'),
('asd99ed6-1c-4d0e', 'drinks', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873'),
('csd34ed6-2c-4d0e', 'sweets', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873');" );
await context.Database.ExecuteSqlCommandAsync($@"INSERT INTO `products` (`Id`, `Name`, `IsDeleted`, `CreatedOn`, `ModifiedOn`, `Weight`, `Manufacturer`, `Price`, `IsCountable`, `CategoryId`, `Image`) VALUES
('mfkr74hf-3f-4d0e', 'milk', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873', '500', 'Prostokvashino', '12.50', b'1', 'ath99ed6-0c-4d0e', 'prostokvashino.jpg'),
('btk94ed6-2h-4d0e', 'cheese', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873', null, 'Romol', '45', b'0', 'ath99ed6-0c-4d0e', 'romol.jpg'),
('atlp6ed6-0c-450e', 'orange', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873', null, 'Nashe', '23', b'0', 'ath99md6-0c-4d0e', 'nash.jpg'),
('atl19md6-9c-4d0e', 'strawberry', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873', null, 'Nasha Fabrika', '78', b'0', 'ath99md6-0c-4d0e', 'strawberry.jpg'),
('ath6ved6-1j-5d0e', 'chiken', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873', '500', 'Dom', '85.52', b'1', 'btk94ed6-0c-4d0e', 'chicken.jpg'),
('az349ed6-d4-4d0e', 'bacon', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873', null, 'Dom Fab', '85.52', b'0', 'btk94ed6-0c-4d0e', 'bacon.jpg'),
('qbnk1ed0-b9-4d0e', 'water', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873', '500', 'Morshinska', '11', b'1', 'asd99ed6-1c-4d0e', 'water.jpg'),
('mfwv74hf-2f-4d0e', 'pepsi', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873', '500', 'PepsiCo', '14.50', b'1', 'asd99ed6-1c-4d0e', 'pepsi.jpg'),
('btl94ed6-2h-4d0e', 'oreo', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873', '100', 'Nabisco', '15', b'1', 'csd34ed6-2c-4d0e', 'oreo.jpg'),
('atr76ed6-0c-450e', 'chocolate', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873','95', 'Milka', '25', b'1', 'csd34ed6-2c-4d0e', 'milka.jpg'),
('atns9md6-9c-4d0e', 'bread', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873','450', '8 merchanised bakery', '16.75', b'1', 'ath9ved6-0c-5d0e', 'bread.jpg'),
('ath2fmd6-3j-5d0e', 'bagels', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873', null, '8 merchanised bakery', '25', b'0', 'ath9ved6-0c-5d0e', 'bagels.jpg'),
('azy99e7h-l4-4d0e', 'tomatoes', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873', null, 'Gifts of the nature', '45', b'0', 'atl96ed6-0c-450e', 'tomatoes.jpg'),
('qbd31emk-n9-4d0e', 'cabbages', b'0', '2018-05-13 18:25:38.242873', '2018-05-13 18:25:38.242873', '500', 'Gifts of the nature', '130', b'1', 'atl96ed6-0c-450e', 'cabbages.jpg');" );
}
public static async Task WarmUpContext(IServiceScope serviceScope)
{
ShopOnWheelsDbContext context = serviceScope.ServiceProvider.GetRequiredService <ShopOnWheelsDbContext>();
await context.ProductLists
.Include(pl => pl.Order)
.FirstOrDefaultAsync();
//await context.Users
// .Include(u => u.Orders)
// .FirstOrDefaultAsync();
}
public static async Task SeedRoles(ShopOnWheelsDbContext context)
{
var userRole = Roles.User;
var adminRole = Roles.Admin;
await context.AddRangeAsync(
new IdentityRole[] {
new IdentityRole {
Name = userRole, NormalizedName = userRole.ToUpper()
},
new IdentityRole {
Name = adminRole, NormalizedName = adminRole.ToUpper()
}
}
);
}
public static async Task EnsureDatabaseInitialized(IServiceScope serviceScope)
{
ShopOnWheelsDbContext context = serviceScope.ServiceProvider.GetRequiredService <ShopOnWheelsDbContext>();
bool isFirstLaunch = !(context.GetService <IDatabaseCreator>() as RelationalDatabaseCreator).Exists();
context.Database.Migrate();
if (isFirstLaunch)
{
await SeedRoles(context);
await SeedAdmin(serviceScope);
await AddTestData(context);
}
await context.SaveChangesAsync();
context.Dispose();
}
public ProductSearchQueryBuilder(ShopOnWheelsDbContext context)
{
_context = context;
}
public BoxStore(IMapper mapper, ShopOnWheelsDbContext context)
{
_context = context;
_mapper = mapper;
}
public OrderService(IMapper mapper, ShopOnWheelsDbContext context)
{
_context = context;
_mapper = mapper;
}
public OrderStore(IMapper mapper, ShopOnWheelsDbContext context, IOrderService orderService)
{
_context = context;
_mapper = mapper;
_orderService = orderService;
}
public ProductStore(IMapper mapper, ShopOnWheelsDbContext context)
{
_mapper = mapper;
_context = context;
}