public UsersController(WebStoryContext db)
{
_UserStore = new UserStore <User>(db)
{
AutoSaveChanges = true
}; //автоматически сохранять изменения
}
/// <summary> Инициализация БД </summary>
public static void Initialize(this WebStoryContext context)
{
context.Database.EnsureCreated(); //база есть
if (context.Products.Any())
{
return; //нет продуктов в БД
}
using (var transaction = context.Database.BeginTransaction())
{
foreach (var section in TestData.Sections)
{
context.Sections.Add(section);
}
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] ON");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] OFF");
transaction.Commit();
}
using (var transaction = context.Database.BeginTransaction())
{
foreach (var brand in TestData.Brands)
{
context.Brands.Add(brand);
}
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] ON");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] OFF");
transaction.Commit();
}
using (var transaction = context.Database.BeginTransaction())
{
foreach (var product in TestData.Products)
{
context.Products.Add(product);
}
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] ON");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] OFF");
transaction.Commit();
}
}
public SQLProductData(WebStoryContext db)
{
_db = db;
}
public RolesController(WebStoryContext db)
{
_RoleStore = new RoleStore <IdentityRole>(db);
}
public SQLOrdersService(WebStoryContext context, UserManager <User> userManager)
{
_context = context;
_userManager = userManager;
}
