public static void Update(FMFDbContext context) { // Delete the database before we initialize it. // This is common to do during development. context.Store1s.RemoveRange(context.Store1s); context.Store2s.RemoveRange(context.Store2s); context.Store3s.RemoveRange(context.Store3s); context.Products.RemoveRange(context.Products); context.SaveChanges(); System.Console.WriteLine("fetch"); // Fech til liste 1 string store1 = new WebClient().DownloadString("https://bhunter.online/api/PostAPI/GetPostModels"); List <Store1> store1Items = JsonConvert.DeserializeObject <List <Store1> >(store1); foreach (var item in store1Items) { context.Store2s.AddRange(new List <Store2> { new Store2(item.productModel.productName, item.Supplier, item.Price + 1, item.Weight, item.productModel.barScan, item.productModel.picture, item.productModel.Id) }); } foreach (var item in store1Items) { context.Store1s.AddRange(new List <Store1> { new Store1(item.productModel.productName, item.Supplier, item.Price, item.Weight, item.productModel.barScan, item.productModel.picture, item.productModel.Id) }); } System.Console.WriteLine("fetch 1 done"); // string store2 = new WebClient().DownloadString("https://bhunter.online/api/PostAPI/GetPostModels"); // List<Store2> store2Items = JsonConvert.DeserializeObject<List<Store2>>(store2); System.Console.WriteLine("fetch 2 done "); context.SaveChanges(); var storeTwo = context.Store2s.ToList(); var storeOne = context.Store1s.ToList(); var storeThree = context.Store3s.ToList(); var products = context.Products.ToList(); System.Console.WriteLine("loop 1 start"); context.SaveChanges(); // sammenligner store 1 og store 2 si pris. foreach (var item1 in storeOne) { foreach (var item2 in storeTwo) { if (item2.ProdId == item1.ProdId) { if (item1.Price <= item2.Price) { storeThree.AddRange(new List <Store3> { new Store3(item1.ProductName, item1.Supplier, item2.Price, item1.Weight, item1.Barcode, item1.Picture, item1.ProdId) }); } else { storeThree.AddRange(new List <Store3> { new Store3(item1.ProductName, item1.Supplier, item1.Price, item1.Weight, item1.Barcode, item1.Picture, item1.ProdId) }); } } } } System.Console.WriteLine("loop 1 done"); var count = 0; foreach (var item in storeThree) { count += 1; } context.Store2s.RemoveRange(context.Store2s); storeTwo.Clear(); foreach (var item in storeOne) { item.Price = item.Price + 2; } context.SaveChanges(); /* Slutt på blokken som må kjøres en gang om dagen. */ foreach (var item1 in storeThree) { foreach (var item2 in storeOne) { if (item2.Barcode == item1.Barcode) { if (item1.Price <= item2.Price) { storeTwo.AddRange(new List <Store2> { new Store2(item1.ProductName, item1.Supplier, item2.Price, item1.Weight, item1.Barcode, item1.Picture, item1.ProdId) }); } else { storeTwo.AddRange(new List <Store2> { new Store2(item1.ProductName, item1.Supplier, item1.Price, item1.Weight, item1.Barcode, item1.Picture, item1.ProdId) }); } } } } context.Store1s.RemoveRange(context.Store1s); context.Store3s.RemoveRange(context.Store3s); storeOne.Clear(); storeThree.Clear(); // /* stores in store 4, but add the real deal in store1 */ // // Fech til liste 1 // string store4 = new WebClient().DownloadString("https://bhunter.online/api/PostAPI/GetPostModels"); // List<Store1> store4Items = JsonConvert.DeserializeObject<List<Store1>>(store4); // foreach (var item in store4Items){ // context.Store1s.AddRange(new List<Store1>{ // new Store1(item.ProductName,item.Supplier, item.Price-2, item.Weight) // }); // } // // Fetch ---------------- context.SaveChanges(); // storeOne = context.Store1s.ToList(); // context.SaveChanges(); // foreach (var item1 in storeTwo){ // foreach (var item2 in storeOne){ // if (item2.ProductName == item1.ProductName && item2.Supplier == item1.Supplier){ // if (item1.Price <= item2.Price){ // storeThree.AddRange(new List<Store3>{ // new Store3(item1.ProductName, item1.Supplier, item2.Price, item1.Weight) // }); // }else{ // storeThree.AddRange(new List<Store3>{ // new Store3(item1.ProductName, item1.Supplier, item1.Price, item1.Weight) // }); // } // } // } // } // context.Store1s.RemoveRange(context.Store1s); // context.Store2s.RemoveRange(context.Store2s); // storeOne.Clear(); // storeTwo.Clear(); // string store5 = new WebClient().DownloadString("https://bhunter.online/api/PostAPI/GetPostModels"); // List<Store1> store5Items = JsonConvert.DeserializeObject<List<Store1>>(store5); // foreach (var item in store5Items){ // context.Store1s.AddRange(new List<Store1>{ // new Store1(item.ProductName,item.Supplier, item.Price-3, item.Weight) // }); // } // context.SaveChanges(); // storeOne = context.Store1s.ToList(); // context.SaveChanges(); // foreach (var item1 in storeThree){ // foreach (var item2 in storeOne){ // if (item2.ProductName == item1.ProductName && item2.Supplier == item1.Supplier){ // if (item1.Price <= item2.Price){ // context.Products.AddRange(new List<Product>{ // new Product(item1.ProductName, item1.Supplier, item2.Price, item1.Weight) // }); // }else{ // context.Products.AddRange(new List<Product>{ // new Product(item1.ProductName, item1.Supplier, item1.Price, item1.Weight) // }); // } // } // } // } // context.Store1s.RemoveRange(context.Store1s); // context.Store3s.RemoveRange(context.Store3s); // storeThree.Clear(); // storeOne.Clear(); // context.SaveChanges(); }
public ProfileController(FMFDbContext context) { _context = context; }
public OrderListController(FMFDbContext context) { _context = context; }
public Store2Controller(FMFDbContext context) { _context = context; }
public ProductController(FMFDbContext context) { _context = context; }