private static void ImportUsers(ProductsContext context) { string usersJson = File.ReadAllText("../../Import/users.json"); List <User> users = JsonConvert.DeserializeObject <List <User> >(usersJson); context.Users.AddRange(users); context.SaveChanges(); }
private static void ImportCatgories(ProductsContext context) { string categoriesJson = File.ReadAllText("../../Import/categories.json"); var categories = JsonConvert.DeserializeObject <List <Category> >(categoriesJson); int number = 0; int productCount = context.Products.Count(); foreach (var c in categories) { int categoryProductsCount = number % 3 + 1; for (int i = 0; i < number % categoryProductsCount; i++) { c.Products.Add(context.Products.Find((number % productCount) + 1)); } number++; } context.Categories.AddRange(categories); context.SaveChanges(); }
private static void ImportProducts(ProductsContext context) { string productsJson = File.ReadAllText("../../Import/products.json"); List <Product> products = JsonConvert.DeserializeObject <List <Product> >(productsJson); int number = 0; int totalUsers = context.Users.Count(); foreach (var p in products) { p.SellerId = number % totalUsers + 1; if (number % 3 != 0) { p.BuyerId = (number * 2 % totalUsers) + 1; } number++; } context.Products.AddRange(products); context.SaveChanges(); }