private static void InsertUsers(Data.ProductsShopContext context)
{
string userJason = File.ReadAllText(@"F:\SoftUni\Databases Advanced - Entity Framework\10.JSON Processing\01.Products-Shop\Import\users.json");
List <User> users = JsonConvert.DeserializeObject <List <User> >(userJason);
foreach (var us in users)
{
context.Users.AddOrUpdate(u => new { u.FirstName, u.LastName }, us);
}
context.SaveChanges();
}
private static void InsertProducts(Data.ProductsShopContext context)
{
string productJson = File.ReadAllText(@"F:\SoftUni\Databases Advanced - Entity Framework\10.JSON Processing\01.Products-Shop\Import\products.json");
List <Product> products = JsonConvert.DeserializeObject <List <Product> >(productJson);
int num = 0;
int userCount = context.Users.Count();
foreach (var p in products)
{
p.SellerId = (num % userCount) + 1;
num++;
if (num % 3 != 0)
{
p.BuyerId = (num * 2 % userCount) + 1;
}
context.Products.AddOrUpdate(pr => new { pr.Price, pr.Name }, p);
}
context.SaveChanges();
}
private static void InsertCategories(Data.ProductsShopContext context)
{
string categoryJson = File.ReadAllText(@"F:\SoftUni\Databases Advanced - Entity Framework\10.JSON Processing\01.Products-Shop\Import\categories.json");
List <Category> categories = JsonConvert.DeserializeObject <List <Category> >(categoryJson);
int num1 = 1;
int num2 = 18;
foreach (var cat in categories)
{
var products = context.Products.Where(p => p.Id >= num1 && p.Id <= num2);
foreach (var p in products)
{
cat.Products.Add(p);
}
context.Categories.AddOrUpdate(c => c.Name, cat);
num1 += 18;
num2 += 18;
}
context.SaveChanges();
}
