private void nonWebBtn_Click(object sender, EventArgs e) { using (var db = new ComparerModel()) { var productA = new Product() { Id = 1, Name = "pienas", Price = 1.02f, Date = DateTime.Now, Accept = false }; var productB = new Product() { Id = 2, Name = "suris", Price = 2.54f, Date = DateTime.Now, Accept = false }; db.Products.Add(productA); db.Products.Add(productB); db.SaveChanges(); } }
public List <RecentProduct> PickRecentChanges(int amount) { using (var db = new ComparerModel()) { var wholeList = db.Price.ToList(); var recentList = wholeList.OrderByDescending(x => x.DateT); var productsWithRecentDifference = new List <RecentProduct>(); int i = 0; int pickedProducts = 0; var temp = new RecentProduct(); foreach (var product in recentList) { if (pickedProducts == amount) { break; } temp = new RecentProduct() { name = product.ProductID, shopName = product.ShopID, recentDate = product.DateT, recentPrice = product.PriceD }; i++; foreach (var product2 in recentList.Skip(i)) { if (product.ProductID == product2.ProductID && product.ShopID == product2.ShopID && product.PriceD != product2.PriceD) { temp.beforeDate = product2.DateT; temp.beforePrice = product2.PriceD; productsWithRecentDifference.Add(temp); pickedProducts++; break; } } } return(productsWithRecentDifference); } }