private void dataGridView1ReLoad() { double totalCost = 0; double totalProfit = 0; // Products = HelperProduct.LoadUsersFromFile(); Products = HelperProduct.LoadFromSql(); dataGridView1.Rows.Clear(); foreach (var item in Products) { dataGridView1.Rows.Add(item.setGridView1()); totalCost += (item.CountWarehouse + item.CountMarket) * item.Price; totalProfit += (item.CountWarehouse + item.CountMarket) * item.Price - (item.CountWarehouse + item.CountMarket) * item.PricePurchasing; } textBoxTotalCost.Text = totalCost.ToString() + " " + "руб."; textBoxTotalProfit.Text = totalProfit.ToString() + " " + "руб."; }
private void Cashier_Load(object sender, EventArgs e) { //Products = HelperProduct.LoadUsersFromFile(); Products = HelperProduct.LoadFromSql(); // for first creating file xml //Products.ForEach(it => { ProductSell pr = new ProductSell(); pr.Name = it.Name; pr.PriceSell = it.Price; pr.PriceBuy = it.PricePurchasing; pr.CountSell = 0; ProductsSell.Add(pr); }); //HelperProductSell.SaveFromFile(ProductsSell); //ProductsSell = HelperProductSell.LoadFromFile(); ProductsSell = HelperProductSell.LoadFromSql(); //int countEquals; foreach (Product product in Products) { // countEquals = 0; if (ProductsSell.Any(it => it.Name == product.Name)) { // countEquals++; continue; } HelperProductSell.InsertToSql(product); /*foreach (ProductSell productSell in ProductsSell) * { * if(product.Name == productSell.Name) * { * countEquals++; * } * }*/ /* if (countEquals == 0) * { * ProductSell prSell = new ProductSell(); * prSell.Name = product.Name; * prSell.PriceBuy = product.PricePurchasing; * prSell.PriceSell = product.Price; * prSell.CountSell = 0; * prSell.UoM = product.UoM; * ProductsSell.Add(prSell); * }*/ } // HelperProductSell.SaveFromFile(ProductsSell); ProductsSell = HelperProductSell.LoadFromSql(); }