private static void importUsers(ProjectsContext context)
        {
            string      jsonUsers = File.ReadAllText(@"..\..\Import\users.json");
            List <User> users     = JsonConvert.DeserializeObject <List <User> >(jsonUsers);

            context.Users.AddRange(users);
            context.SaveChanges();
        }
        private static void importCategories(ProjectsContext context)
        {
            string          jsonCategories = File.ReadAllText(@"..\..\Import\categories.json");
            List <Category> categories     = JsonConvert.DeserializeObject <List <Category> >(jsonCategories);

            context.Categories.AddRange(categories);

            context.SaveChanges();
        }
        private static void addCategoryForProducts(ProjectsContext context)
        {
            var randomizer = 2;

            foreach (var category in context.Categories)
            {
                foreach (var product in context.Products)
                {
                    if ((randomizer + 1) % 4 == 0)
                    {
                        product.Categories.Add(category);
                        randomizer++;
                    }
                    randomizer++;
                }
            }

            context.SaveChanges();
        }
        private static void importProducts(ProjectsContext context)
        {
            string         jsonProducts = File.ReadAllText(@"..\..\Import\products.json");
            List <Product> products     = JsonConvert.DeserializeObject <List <Product> >(jsonProducts);
            int            randomCount  = 1;

            Random rnd = new Random();

            foreach (var product in products)
            {
                product.SellerId = rnd.Next(1, 56);

                randomCount++;
                if (randomCount % 13 == 0)
                {
                    product.BuyerId = rnd.Next(1, 56);
                }
            }

            context.Products.AddRange(products);

            context.SaveChanges();
        }