public bool AddSale(SaleProduct sale, string label) { try { var ctx = new ShopContext(); var temp = ctx.Label.Where(x => x.Name == label).FirstOrDefault(); sale.Label = temp; sale.Price = (sale.Price * sale.Count) - sale.Discount; ctx.SaleProduct.Add(sale); ctx.SaveChanges(); return true; } catch (Exception) { return false; } }
private void btnSale_Click(object sender, EventArgs e) { try { if (MessageBox.Show("Продать этот товар?", "Продать", MessageBoxButtons.YesNo, MessageBoxIcon.Question) != DialogResult.Yes) { return; } else { var prod = new ProductManager(); prod.AddSale(Convert.ToInt32(txtHiddenId.Text), Convert.ToInt32(txtСountProduct.Text)); var temp = new SaleProductManager(); var sale = new SaleProduct() { Name = txtNameProduct.Text.ToString(), Count = Convert.ToInt32(txtСountProduct.Text), Price = Convert.ToInt32(txtPriceProduct.Text), Discount = Convert.ToInt32(txtDiscount.Text), DateTimeSale = DateTime.Now }; temp.AddSale(sale, cmbLabel.Text.ToString()); dtGridProducts.DataSource = prod.GetAllProduct(); if (Convert.ToInt32(txtHiddenIndex.Text) < dtGridProducts.RowCount) { dtGridProducts.ClearSelection(); dtGridProducts.Rows[Convert.ToInt32(txtHiddenIndex.Text)].Selected = true; dtGridProducts.FirstDisplayedScrollingRowIndex = Convert.ToInt32(txtHiddenIndex.Text); dtGridProducts.Update(); } txtCountProductGrid.Text = prod.GetAllProductCount(prod.GetAllProduct()).ToString(); txtAllPriceGrid.Text = prod.GetAllProductPrice(prod.GetAllProduct()).ToString(); MessageBox.Show("Товар продан"); } } catch (Exception) { MessageBox.Show("Упс! Что-то пошло не так!"); } }