public WebStoreContextInitializer(WebStoreContext db, UserManager <User> userManager,
RoleManager <IdentityRole> roleManager)
{
_db = db;
_userManager = userManager;
_roleManager = roleManager;
}
public WebStoreContextInitializer(
WebStoreContext db,
UserManager <User> UserManager,
RoleManager <IdentityRole> RoleManager)
{
_db = db;
_UserManager = UserManager;
_RoleManager = RoleManager;
}
public static void Initialize(WebStoreContext webStoreContext)
{
webStoreContext.Database.EnsureCreated();
if (webStoreContext.Products.Any())
{
return;
}
InitCategories(webStoreContext);
InitBrands(webStoreContext);
InitProducts(webStoreContext);
}
public static void Initialize(WebStoreContext context)
{
context.Database.EnsureCreated();
//Look for any products.
if (context.Products.Any())
{
return; // DB has been seeded
}
InMemoryProductData productData = new InMemoryProductData();
using (var trans = context.Database.BeginTransaction())
{
foreach (var section in productData.GetSections())
{
context.Sections.Add(section);
}
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] ON");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] OFF");
trans.Commit();
}
using (var trans = context.Database.BeginTransaction())
{
foreach (var brand in productData.GetBrands())
{
context.Brands.Add(brand);
}
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] ON");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] OFF");
trans.Commit();
}
using (var trans = context.Database.BeginTransaction())
{
foreach (var product in productData.GetProducts())
{
context.Products.Add(product);
}
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] ON");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] OFF");
trans.Commit();
}
}
public static void Initialize(WebStoreContext context)
{
context.Database.EnsureCreated();
if (context.Products.Any())
{
return;
}
var sections = new List <Section>();
using (var trans = context.Database.BeginTransaction())
{
foreach (var section in 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");
trans.Commit();
}
var brands = new List <Brand>();
using (var trans = context.Database.BeginTransaction())
{
foreach (var brand in 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");
trans.Commit();
}
var products = new List <Product>();
using (var trans = context.Database.BeginTransaction())
{
foreach (var product in 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");
trans.Commit();
}
}
public static void Initialize(WebStoreContext context)
{
context.Database.EnsureCreated();
if (context.Products.Any())
{
return;
}
contextInitializer = context;
AddSections();
AddBrands();
AddProducts();
}
internal static void Initialize(this WebStoreContext 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 WebStoreContextInitializer(WebStoreContext db, UserManager <User> userManager, RoleManager <IdentityRole> roleManager)
{
this.db = db;
this.userManager = userManager;
this.roleManager = roleManager;
}
public WebStoreDBInitializer(WebStoreContext db)
{
_db = db;
}
public static void Initialize(WebStoreContext context)
{
context.Database.EnsureCreated();
if (context.Products.Any())
{
return;
}
var sections = new List <Section>()
{
new Section()
{
Id = 1,
Name = "Sportswear",
Order = 0,
ParentId = null
},
new Section()
{
Id = 2,
Name = "Nike",
Order = 0,
ParentId = 1
},
new Section()
{
Id = 3,
Name = "Under Armour",
Order = 1,
ParentId = 1
},
new Section()
{
Id = 4,
Name = "Adidas",
Order = 2,
ParentId = 1
},
new Section()
{
Id = 5,
Name = "Puma",
Order = 3,
ParentId = 1
},
new Section()
{
Id = 6,
Name = "ASICS",
Order = 4,
ParentId = 1
},
new Section()
{
Id = 7,
Name = "Mens",
Order = 1,
ParentId = null
},
new Section()
{
Id = 8,
Name = "Fendi",
Order = 0,
ParentId = 7
},
new Section()
{
Id = 9,
Name = "Guess",
Order = 1,
ParentId = 7
},
new Section()
{
Id = 10,
Name = "Valentino",
Order = 2,
ParentId = 7
},
new Section()
{
Id = 11,
Name = "Dior",
Order = 3,
ParentId = 7
},
new Section()
{
Id = 12,
Name = "Versace",
Order = 4,
ParentId = 7
},
new Section()
{
Id = 13,
Name = "Armani",
Order = 5,
ParentId = 7
},
new Section()
{
Id = 14,
Name = "Prada",
Order = 6,
ParentId = 7
},
new Section()
{
Id = 15,
Name = "Dolce and Gabbana",
Order = 7,
ParentId = 7
},
new Section()
{
Id = 16,
Name = "Chanel",
Order = 8,
ParentId = 7
},
new Section()
{
Id = 17,
Name = "Gucci",
Order = 1,
ParentId = 7
},
new Section()
{
Id = 18,
Name = "Womens",
Order = 2,
ParentId = null
},
new Section()
{
Id = 19,
Name = "Fendi",
Order = 0,
ParentId = 18
},
new Section()
{
Id = 20,
Name = "Guess",
Order = 1,
ParentId = 18
},
new Section()
{
Id = 21,
Name = "Valentino",
Order = 2,
ParentId = 18
},
new Section()
{
Id = 22,
Name = "Dior",
Order = 3,
ParentId = 18
},
new Section()
{
Id = 23,
Name = "Versace",
Order = 4,
ParentId = 18
},
new Section()
{
Id = 24,
Name = "Kids",
Order = 3,
ParentId = null
},
new Section()
{
Id = 25,
Name = "Fashion",
Order = 4,
ParentId = null
},
new Section()
{
Id = 26,
Name = "Households",
Order = 5,
ParentId = null
},
new Section()
{
Id = 27,
Name = "Interiors",
Order = 6,
ParentId = null
},
new Section()
{
Id = 28,
Name = "Clothing",
Order = 7,
ParentId = null
},
new Section()
{
Id = 29,
Name = "Bags",
Order = 8,
ParentId = null
},
new Section()
{
Id = 30,
Name = "Shoes",
Order = 9,
ParentId = null
}
};
using (var trans = context.Database.BeginTransaction())
{
foreach (var section in 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");
trans.Commit();
}
var brands = new List <Brand>()
{
new Brand()
{
Id = 1,
Name = "Acne",
Order = 0
},
new Brand()
{
Id = 2,
Name = "Grüne Erde",
Order = 1
},
new Brand()
{
Id = 3,
Name = "Albiro",
Order = 2
},
new Brand()
{
Id = 4,
Name = "Ronhill",
Order = 3
},
new Brand()
{
Id = 5,
Name = "Oddmolly",
Order = 4
},
new Brand()
{
Id = 6,
Name = "Boudestijn",
Order = 5
},
new Brand()
{
Id = 7,
Name = "Rösch creative culture",
Order = 6
},
};
using (var trans = context.Database.BeginTransaction())
{
foreach (var brand in 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");
trans.Commit();
}
var products = new List <Product>()
{
new Product()
{
Id = 1,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product1.jpg",
Order = 0,
SectionId = 2,
BrandId = 1
},
new Product()
{
Id = 2,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product2.jpg",
Order = 1,
SectionId = 2,
BrandId = 1
},
new Product()
{
Id = 3,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product3.jpg",
Order = 2,
SectionId = 2,
BrandId = 1
},
new Product()
{
Id = 4,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product4.jpg",
Order = 3,
SectionId = 2,
BrandId = 1
},
new Product()
{
Id = 5,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product5.jpg",
Order = 4,
SectionId = 2,
BrandId = 2
},
new Product()
{
Id = 6,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product6.jpg",
Order = 5,
SectionId = 2,
BrandId = 2
},
new Product()
{
Id = 7,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product7.jpg",
Order = 6,
SectionId = 2,
BrandId = 2
},
new Product()
{
Id = 8,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product8.jpg",
Order = 7,
SectionId = 25,
BrandId = 2
},
new Product()
{
Id = 9,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product9.jpg",
Order = 8,
SectionId = 25,
BrandId = 2
},
new Product()
{
Id = 10,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product10.jpg",
Order = 9,
SectionId = 25,
BrandId = 3
},
new Product()
{
Id = 11,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product11.jpg",
Order = 10,
SectionId = 25,
BrandId = 3
},
new Product()
{
Id = 12,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product12.jpg",
Order = 11,
SectionId = 25,
BrandId = 3
},
};
using (var trans = context.Database.BeginTransaction())
{
foreach (var product in 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");
trans.Commit();
}
}
public WebStoreDBInitializer(WebStoreContext db, UserManager <User> um, RoleManager <IdentityRole> rm)
{
_db = db;
_um = um;
_rm = rm;
}
private static void InitProducts(WebStoreContext webStoreContext)
{
var products = new List <Product>
{
new Product
{
Id = 1,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product12.jpg",
Order = 0,
CategoryId = 2,
BrandId = 1
},
new Product
{
Id = 2,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product11.jpg",
Order = 1,
CategoryId = 2,
BrandId = 1
},
new Product
{
Id = 3,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product10.jpg",
Order = 2,
CategoryId = 2,
BrandId = 1
},
new Product
{
Id = 4,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product9.jpg",
Order = 3,
CategoryId = 2,
BrandId = 1,
IsNew = true
},
new Product
{
Id = 5,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product8.jpg",
Order = 4,
CategoryId = 2,
BrandId = 2,
IsSale = true
},
new Product
{
Id = 6,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product7.jpg",
Order = 5,
CategoryId = 2,
BrandId = 2
},
new Product
{
Id = 7,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product6.jpg",
Order = 6,
CategoryId = 2,
BrandId = 2
},
new Product
{
Id = 8,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product5.jpg",
Order = 7,
CategoryId = 25,
BrandId = 2
},
new Product
{
Id = 9,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product4.jpg",
Order = 8,
CategoryId = 25,
BrandId = 2
},
new Product
{
Id = 10,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product3.jpg",
Order = 9,
CategoryId = 25,
BrandId = 3
},
new Product
{
Id = 11,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product2.jpg",
Order = 10,
CategoryId = 25,
BrandId = 3
},
new Product
{
Id = 12,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product1.jpg",
Order = 11,
CategoryId = 25,
BrandId = 3
}
};
using (var transaction = webStoreContext.Database.BeginTransaction())
{
foreach (var product in products)
{
webStoreContext.Products.Add(product);
}
webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] ON");
webStoreContext.SaveChanges();
webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Products] OFF");
transaction.Commit();
}
}
private static void InitCategories(WebStoreContext webStoreContext)
{
var categories = new List <Category>
{
new Category
{
Id = 1,
Name = "Sportswear",
Order = 0,
ParentId = null
},
new Category
{
Id = 2,
Name = "Nike",
Order = 0,
ParentId = 1
},
new Category
{
Id = 3,
Name = "Under Armour",
Order = 1,
ParentId = 1
},
new Category
{
Id = 4,
Name = "Adidas",
Order = 2,
ParentId = 1
},
new Category
{
Id = 5,
Name = "Puma",
Order = 3,
ParentId = 1
},
new Category
{
Id = 6,
Name = "ASICS",
Order = 4,
ParentId = 1
},
new Category
{
Id = 7,
Name = "Mens",
Order = 1,
ParentId = null
},
new Category
{
Id = 8,
Name = "Fendi",
Order = 0,
ParentId = 7
},
new Category
{
Id = 9,
Name = "Guess",
Order = 1,
ParentId = 7
},
new Category
{
Id = 10,
Name = "Valentino",
Order = 2,
ParentId = 7
},
new Category
{
Id = 11,
Name = "Dior",
Order = 3,
ParentId = 7
},
new Category
{
Id = 12,
Name = "Versace",
Order = 4,
ParentId = 7
},
new Category
{
Id = 13,
Name = "Armani",
Order = 5,
ParentId = 7
},
new Category
{
Id = 14,
Name = "Prada",
Order = 6,
ParentId = 7
},
new Category
{
Id = 15,
Name = "Dolce and Gabbana",
Order = 7,
ParentId = 7
},
new Category
{
Id = 16,
Name = "Chanel",
Order = 8,
ParentId = 7
},
new Category
{
Id = 17,
Name = "Gucci",
Order = 8,
ParentId = 7
},
new Category
{
Id = 18,
Name = "Womens",
Order = 2,
ParentId = null
},
new Category
{
Id = 19,
Name = "Fendi",
Order = 0,
ParentId = 18
},
new Category
{
Id = 20,
Name = "Guess",
Order = 1,
ParentId = 18
},
new Category
{
Id = 21,
Name = "Valentino",
Order = 2,
ParentId = 18
},
new Category
{
Id = 22,
Name = "Dior",
Order = 3,
ParentId = 18
},
new Category
{
Id = 23,
Name = "Versace",
Order = 4,
ParentId = 18
},
new Category
{
Id = 24,
Name = "Kids",
Order = 3,
ParentId = null
},
new Category
{
Id = 25,
Name = "Fashion",
Order = 4,
ParentId = null
},
new Category
{
Id = 26,
Name = "Households",
Order = 5,
ParentId = null
},
new Category
{
Id = 27,
Name = "Interiors",
Order = 6,
ParentId = null
},
new Category
{
Id = 28,
Name = "Clothing",
Order = 7,
ParentId = null
},
new Category
{
Id = 29,
Name = "Bags",
Order = 8,
ParentId = null
},
new Category
{
Id = 30,
Name = "Shoes",
Order = 9,
ParentId = null
}
};
using (var transaction = webStoreContext.Database.BeginTransaction())
{
foreach (var category in categories)
{
webStoreContext.Categories.Add(category);
}
webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Categories] ON");
webStoreContext.SaveChanges();
webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Categories] OFF");
transaction.Commit();
}
}
private static void InitBrands(WebStoreContext webStoreContext)
{
var brands = new List <Brand>
{
new Brand
{
Id = 1,
Name = "Acne",
Order = 0
},
new Brand
{
Id = 2,
Name = "Grüne Erde",
Order = 1
},
new Brand
{
Id = 3,
Name = "Albiro",
Order = 2
},
new Brand
{
Id = 4,
Name = "Ronhill",
Order = 3
},
new Brand
{
Id = 5,
Name = "Oddmolly",
Order = 4
},
new Brand
{
Id = 6,
Name = "Boudestijn",
Order = 5
},
new Brand
{
Id = 7,
Name = "Rösch creative culture",
Order = 6
}
};
using (var transaction = webStoreContext.Database.BeginTransaction())
{
foreach (var brand in brands)
{
webStoreContext.Brands.Add(brand);
}
webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] ON");
webStoreContext.SaveChanges();
webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Brands] OFF");
transaction.Commit();
}
}
