private static void ensureBaseUsers(
WebStoreContext context)
{
var userStore = new UserStore <User>(context);
var userManager = new UserManager <User>(
userStore,
new OptionsManager <IdentityOptions>(
new OptionsFactory <IdentityOptions>(
new IConfigureOptions <IdentityOptions>[] { },
new IPostConfigureOptions <IdentityOptions>[] { })),
new PasswordHasher <User>(),
new IUserValidator <User>[] { },
new IPasswordValidator <User>[] { },
new UpperInvariantLookupNormalizer(),
new IdentityErrorDescriber(),
null,
null);
if (userStore
.FindByEmailAsync("*****@*****.**", CancellationToken.None)
.Result == null)
{
var user = new User()
{
UserName = "******",
Email = "*****@*****.**"
};
var result = userManager.CreateAsync(user, "Pa$$w0rd").Result;
if (result == IdentityResult.Success)
{
_ = userManager
.AddToRoleAsync(user, "Administrators")
.Result;
}
}
if (userStore
.FindByEmailAsync("*****@*****.**", CancellationToken.None)
.Result == null)
{
var user = new User()
{
UserName = "******",
Email = "*****@*****.**"
};
var result = userManager.CreateAsync(user, "Pa$$w0rd").Result;
if (result == IdentityResult.Success)
{
_ = userManager
.AddToRoleAsync(user, "Users")
.Result;
}
}
}
public static void Initialize(WebStoreContext webStoreContext)
{
webStoreContext.Database.EnsureCreated();
if (webStoreContext.Products.Any())
{
return;
}
InitCategories(webStoreContext);
InitBrands(webStoreContext);
InitProducts(webStoreContext);
}
public static async Task InitializeBaseAsync(WebStoreContext context)
{
//context.Database.EnsureCreated();
//await context.Database.EnsureCreatedAsync();
//await context.Database.MigrateAsync(); // Автоматическое создание и миграция базы до последней версии
//IEnumerable<PropertyInfo> dbSetProperties =
// context.GetType()
// .GetProperties()
// .Where(p => p.PropertyType.Name.StartsWith("DbSet"));
List <string> dbSetProperties = new List <string>()
{
"Brands", "Categories", "Products"
};
foreach (string tableName in dbSetProperties)
{
switch (tableName)
{
case "Products":
if (!context.Products.Any())
{
await FillTable <Product>(context, WebStore.Data.TestData.Products, tableName);
}
break;
case "Categories":
if (!context.Categories.Any())
{
await FillTable <Category>(context, WebStore.Data.TestData.Categories, tableName);
}
break;
case "Brands":
if (!context.Brands.Any())
{
await FillTable <Brand>(context, WebStore.Data.TestData.Brands, tableName);
}
break;
}
}
}
// privates
private static void ensureBaseRoles(
WebStoreContext context)
{
var roleStore = new RoleStore <IdentityRole>(context);
var roleManager = new RoleManager <IdentityRole>(
roleStore,
new IRoleValidator <IdentityRole>[] { },
new UpperInvariantLookupNormalizer(),
new IdentityErrorDescriber(),
null);
if (!roleManager.RoleExistsAsync("Users").Result)
{
_ = roleManager.CreateAsync(new IdentityRole("Users")).Result;
}
if (!roleManager.RoleExistsAsync("Administrators").Result)
{
_ = roleManager.CreateAsync(new IdentityRole("Administrators")).Result;
}
}
private static async Task FillTable <T>(WebStoreContext context, IEnumerable <T> entList, string tableName)
{
bool commitNeed = true;
using (var trans = await context.Database.BeginTransactionAsync())
{
switch (tableName)
{
case "Products":
context.Products.AddRange((IEnumerable <Product>)entList);
break;
case "Categories":
context.Categories.AddRange((IEnumerable <Category>)entList);
break;
case "Brands":
context.Brands.AddRange((IEnumerable <Brand>)entList);
break;
default:
commitNeed = false;
break;
}
if (commitNeed)
{
await context.Database.ExecuteSqlRawAsync(String.Format("SET IDENTITY_INSERT [dbo].[{0}] ON", tableName));
await context.SaveChangesAsync();
await context.Database.ExecuteSqlRawAsync(String.Format("SET IDENTITY_INSERT [dbo].[{0}] OFF", tableName));
trans.Commit();
}
}
}
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())
{
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Sections ON");
foreach (var section in _sections)
{
context.Sections.Add(section);
}
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())
{
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Brands ON");
foreach (var brand in _brands)
{
context.Brands.Add(brand);
}
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())
{
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Products ON");
foreach (var product in _products)
{
context.Products.Add(product);
}
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Products OFF");
trans.Commit();
}
}
public static void Initializre(WebStoreContext context)
{
context.Database.Migrate();
if (context.Products.Any())
{
return;
}
//Заполнение БД
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 = 5,
Name = "Ronhill",
Order = 3,
},
new Brand
{
Id = 6,
Name = "Boudestijn",
Order = 4,
},
new Brand
{
Id = 7,
Name = "Rösch creative culture",
Order = 5,
}
};
using (var trans = context.Database.BeginTransaction())
{
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Brands ON");
foreach (var brand in _brands)
{
context.Brands.Add(brand);
}
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Brands OFF");
trans.Commit();
}
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 = 9,
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())
{
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Sections ON");
foreach (var section in _sections)
{
context.Sections.Add(section);
}
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Sections OFF");
trans.Commit();
}
var _products = new List <Product>
{
new Product
{
Id = 1,
Name = "Easy Polo Black Edition",
Order = 0,
Price = 15,
BrandId = 1,
SectionId = 24,
ImageUrl = "product12.jpg"
},
new Product
{
Id = 2,
Name = "Easy Polo Black Edition",
Order = 1,
Price = 20,
BrandId = 1,
SectionId = 24,
ImageUrl = "product11.jpg"
},
new Product
{
Id = 3,
Name = "Easy Polo Black Edition",
Order = 2,
Price = 25,
BrandId = 2,
SectionId = 2,
ImageUrl = "product10.jpg"
},
new Product
{
Id = 4,
Name = "Easy Polo Black Edition",
Order = 3,
Price = 30,
BrandId = 2,
SectionId = 2,
ImageUrl = "product9.jpg"
},
new Product
{
Id = 5,
Name = "Easy Polo Black Edition",
Order = 4,
Price = 35,
BrandId = 2,
SectionId = 4,
ImageUrl = "product8.jpg"
},
new Product
{
Id = 6,
Name = "Easy Polo Black Edition",
Order = 5,
Price = 40,
BrandId = 2,
SectionId = 4,
ImageUrl = "product1.jpg",
StatusHome = true
},
new Product
{
Id = 7,
Name = "Easy Polo Black Edition",
Order = 6,
Price = 40,
BrandId = 2,
SectionId = 4,
ImageUrl = "product2.jpg",
StatusHome = true
},
new Product
{
Id = 8,
Name = "Easy Polo Black Edition",
Order = 7,
Price = 40,
BrandId = 2,
SectionId = 4,
ImageUrl = "product3.jpg",
StatusHome = true
},
new Product
{
Id = 9,
Name = "Easy Polo Black Edition",
Order = 8,
Price = 40,
BrandId = 2,
SectionId = 4,
ImageUrl = "product4.jpg",
StatusNew = true
},
new Product
{
Id = 10,
Name = "Easy Polo Black Edition",
Order = 9,
Price = 40,
BrandId = 2,
SectionId = 4,
ImageUrl = "product5.jpg",
StatusSale = true
},
new Product
{
Id = 11,
Name = "Easy Polo Black Edition",
Order = 10,
Price = 40,
BrandId = 2,
SectionId = 4,
ImageUrl = "product6.jpg",
StatusHome = true
},
};
using (var trans = context.Database.BeginTransaction())
{
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Products ON");
foreach (var product in _products)
{
context.Products.Add(product);
}
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>
{
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())
{
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Sections ON");
foreach (var section in _sections)
{
context.Sections.Add(section);
}
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())
{
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Brands ON");
foreach (var brand in _brands)
{
context.Brands.Add(brand);
}
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())
{
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Products ON");
foreach (var product in _products)
{
context.Products.Add(product);
}
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Products OFF");
trans.Commit();
}
var _applicationUsers = new List <ApplicationUser>()
{
new ApplicationUser
{
Id = 1,
FirstName = "Иван",
SurName = "Иванов",
Patronomic = "Иванов",
Age = 22,
Male = true
},
new ApplicationUser
{
Id = 2,
FirstName = "Петр",
SurName = "Петров",
Patronomic = "Петрович",
Age = 27,
Male = true
},
new ApplicationUser
{
Id = 3,
FirstName = "Сидор",
SurName = "Сидоров",
Patronomic = "Сидорович",
Age = 12,
Male = true
}
};
using (var trans = context.Database.BeginTransaction())
{
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Users ON");
foreach (var user in _applicationUsers)
{
context.ApplicationUsers.Add(user);
}
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].Users OFF");
trans.Commit();
}
}
/// <summary>
/// Наполняет таблицы БД начальными данными
/// </summary>
/// <param name="webStoreContext"></param>
public static void Initialize(WebStoreContext webStoreContext)
{
//проверяет, создана ли БД (если нет, то создает ее? непонятно зачем, если нужно апдейтить через миграции, а не так)
webStoreContext.Database.EnsureCreated();
//Проверяет - если есть хоть один элемент в таблице, то ничего не делаем
if (webStoreContext.Products.Any())
{
return;
}
//просто список с данными, которыми хотим напонить таблицу в базе
List <Section> 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 (IDbContextTransaction transaction = webStoreContext.Database.BeginTransaction())
{
//переносим данные из List в Context-таблицу
foreach (Section section in sections)
{
webStoreContext.Sections.Add(section);
}
//следующие команды нужны для того, чтобы можно было сохранить в полях Id таблицы БД свои значения
webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] ON"); //отключаем проверку внешних ключей
webStoreContext.SaveChanges(); //сохраняем изменения, сделанные в Context, в БД
webStoreContext.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Sections] OFF");
//сохраняем данные о проведенных изменениях?
transaction.Commit();
}
List <Brand> 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 (Brand 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();
}
List <Product> 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 transaction = webStoreContext.Database.BeginTransaction())
{
foreach (Product 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();
}
}
public static void Initialize(WebStoreContext context)
{
context.Database.EnsureCreated();
// Look for any products.
if (context.Products.Any())
{
return; // DB had already been seeded
}
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 = 1,
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 trans = context.Database.BeginTransaction())
{
foreach (var section in categories)
{
context.Categories.Add(section);
}
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Categories] ON");
context.SaveChanges();
context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[Categories] 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 22",
Price = 1025,
ImageUrl = "product1.jpg",
Order = 0,
CategoryId = 2,
BrandId = 1,
Description = "Description"
},
new Product()
{
Id = 2,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product2.jpg",
Order = 1,
CategoryId = 2,
BrandId = 1
},
new Product()
{
Id = 3,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product3.jpg",
Order = 2,
CategoryId = 2,
BrandId = 1
},
new Product()
{
Id = 4,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product4.jpg",
Order = 3,
CategoryId = 2,
BrandId = 1
},
new Product()
{
Id = 5,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product5.jpg",
Order = 4,
CategoryId = 2,
BrandId = 2
},
new Product()
{
Id = 6,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product6.jpg",
Order = 5,
CategoryId = 2,
BrandId = 2
},
new Product()
{
Id = 7,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product7.jpg",
Order = 6,
CategoryId = 2,
BrandId = 2
},
new Product()
{
Id = 8,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product8.jpg",
Order = 7,
CategoryId = 25,
BrandId = 2
},
new Product()
{
Id = 9,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product9.jpg",
Order = 8,
CategoryId = 25,
BrandId = 2
},
new Product()
{
Id = 10,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product10.jpg",
Order = 9,
CategoryId = 25,
BrandId = 3
},
new Product()
{
Id = 11,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product11.jpg",
Order = 10,
CategoryId = 25,
BrandId = 3
},
new Product()
{
Id = 12,
Name = "Easy Polo Black Edition",
Price = 1025,
ImageUrl = "product12.jpg",
Order = 11,
CategoryId = 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 static void InitializeUsers(
WebStoreContext context)
{
ensureBaseRoles(context);
ensureBaseUsers(context);
}
public static void Initialize(
WebStoreContext context)
{
context.Database.EnsureCreated();
// categories
if (!context.Categories.Any())
{
var categories = new List <Category>
{
new Category {
Id = 1, Name = "Sportswear 2", 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 = 1, 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 trans = context.Database.BeginTransaction();
foreach (var section in categories)
{
context.Categories.Add(section);
}
context.Database.ExecuteSqlRaw(
"SET IDENTITY_INSERT [dbo].[Categories] ON");
context.SaveChanges();
context.Database.ExecuteSqlRaw(
"SET IDENTITY_INSERT [dbo].[Categories] OFF");
trans.Commit();
}
// brands
if (!context.Brands.Any())
{
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.ExecuteSqlRaw(
"SET IDENTITY_INSERT [dbo].[Brands] ON");
context.SaveChanges();
context.Database.ExecuteSqlRaw(
"SET IDENTITY_INSERT [dbo].[Brands] OFF");
trans.Commit();
}
// products
if (!context.Products.Any())
{
var products = new List <Product>
{
new Product()
{
Id = 1, Name = "Pixel Infrared Thermal Imager", Price = 1025, ImageUrl = "product1.jpg", Order = 0, CategoryId = 2, BrandId = 1
},
new Product()
{
Id = 2, Name = "Mini Electric Welding Machine", Price = 1025, ImageUrl = "product2.jpg", Order = 1, CategoryId = 2, BrandId = 1
},
new Product()
{
Id = 3, Name = "Digital Microscope", Price = 1025, ImageUrl = "product3.jpg", Order = 2, CategoryId = 2, BrandId = 1
},
new Product()
{
Id = 4, Name = "USB Digital Storage Oscilloscope", Price = 1025, ImageUrl = "product4.jpg", Order = 3, CategoryId = 2, BrandId = 1
},
new Product()
{
Id = 5, Name = "Intelligent 2 in 1 Digital", Price = 1025, ImageUrl = "product5.jpg", Order = 4, CategoryId = 2, BrandId = 2
},
new Product()
{
Id = 6, Name = "Spindle Motor", Price = 1025, ImageUrl = "product6.jpg", Order = 5, CategoryId = 2, BrandId = 2
},
new Product()
{
Id = 7, Name = "Digits LED Display", Price = 1025, ImageUrl = "product7.jpg", Order = 6, CategoryId = 2, BrandId = 2
},
new Product()
{
Id = 8, Name = "Digital Oscilloscope", Price = 1025, ImageUrl = "product8.jpg", Order = 7, CategoryId = 25, BrandId = 2
},
new Product()
{
Id = 9, Name = "HD Intelligent Graphical Digital Oscilloscope Multimeter", Price = 1025, ImageUrl = "product9.jpg", Order = 8, CategoryId = 25, BrandId = 2
},
new Product()
{
Id = 10, Name = "Cordless Brushless", Price = 1025, ImageUrl = "product10.jpg", Order = 9, CategoryId = 25, BrandId = 3
},
new Product()
{
Id = 11, Name = "Smart Laser Engraver DIY", Price = 1025, ImageUrl = "product11.jpg", Order = 10, CategoryId = 25, BrandId = 3
},
new Product()
{
Id = 12, Name = "Intelligent Solar Pure Sine Wave Inverter", Price = 1025, ImageUrl = "product12.jpg", Order = 11, CategoryId = 25, BrandId = 3
}
};
using var trans = context.Database.BeginTransaction();
foreach (var product in products)
{
context.Products.Add(product);
}
context.Database.ExecuteSqlRaw(
"SET IDENTITY_INSERT [dbo].[Products] ON");
context.SaveChanges();
context.Database.ExecuteSqlRaw(
"SET IDENTITY_INSERT [dbo].[Products] OFF");
trans.Commit();
}
}
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();
}
}
public ProductData(WebStoreContext context)
{
_context = context;
}
