public async Task <IActionResult> Edit(int id, [Bind("MainProductID,Name,SubCategoryID")] MainProduct mainProduct) { if (id != mainProduct.MainProductID) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(mainProduct); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!MainProductExists(mainProduct.MainProductID)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(mainProduct)); }
public bool Delete(int id) { var mainProduct = new MainProduct { Id = id }; return(_mainProductService.Delete(mainProduct)); }
public bool Add(string name) { var mainProduct = new MainProduct { Name = name }; return(_mainProductService.Add(mainProduct)); }
public int Delete(MainProduct entity) { var sqlCommand = string.Format(@"DELETE FROM [MainProduct] WHERE [Id] = @Id"); return(this._db.Execute(sqlCommand, new { entity.Id })); }
public int Add(MainProduct entity) { var sqlCommand = string.Format(@"INSERT INTO [MainProduct] ([Name]) VALUES (@Name)"); return(this._db.Execute(sqlCommand, new { entity.Name })); }
private void dataGrid_MainProduct_SelectionChanged(object sender, SelectionChangedEventArgs e) { MainProduct s = dataGrid_MainProd.SelectedItem as MainProduct; Product q = db.Product.FirstOrDefault(x => x.Id == s.Id); label_balance.Content = "На складе : " + Convert.ToString(q.Balance); label_Purchase.Content = "Цена закупки : " + Convert.ToString(q.PricePurchase); label_Sell.Content = "Цена продажи : " + Convert.ToString(q.SellPrice); }
public int Update(MainProduct entity) { var sqlCommand = string.Format(@"UPDATE [MainProduct] SET [Name] = @Name WHERE [Id] = @Id"); return(this._db.Execute(sqlCommand, new { entity.Name, entity.Id })); }
public async Task <IActionResult> Create([Bind("MainProductID,Name,SubCategoryID")] MainProduct mainProduct) { if (ModelState.IsValid) { _context.Add(mainProduct); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(mainProduct)); }
public IHttpActionResult PostMainProduct(ProductsList productsList) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } MainProduct mproductes = new MainProduct(); mproductes.Poid = productsList.Poid; mproductes.ProductName = productsList.ProductName; db.MainProducts.Add(mproductes); db.SaveChanges(); return(Ok(mproductes)); }
public bool Delete(MainProduct mainProduct) { var products = _productkRepository.FindByMainProjectId(mainProduct.Id); if (products.Any()) { foreach (var product in products) { var _pro = new Product { Id = product.Id }; _productkRepository.Delete(_pro); } } return(_mainProductRepository.Delete(mainProduct) > 0); }
private void buttonChangeProduct_Click(object sender, RoutedEventArgs e) { MyContext db = new MyContext(); if (dataGridGoods.SelectedItem != null) { ProductsViewModel s = dataGridGoods.SelectedItem as ProductsViewModel; var bd = db.Product.Include("MainProduct"); Product fnd = bd.Include("Secondary").FirstOrDefault(x => x.Id == s.Id); Products f = new Products(); f.textBox.Text = Convert.ToString(fnd.Balance); f.textBox1.Text = Convert.ToString(fnd.PricePurchase); f.textBox2.Text = Convert.ToString(fnd.SellPrice); f.textBox_Id.Text = Convert.ToString(fnd.Id); if (fnd.Secondary != null) { Secondary Secondarys = db.Secondaries.Find(s.Id); f.textBox_Type.Text = Secondarys.Type; f.textBox_Name.Text = Secondarys.Name; f.textBox_Charact.Text = Secondarys.Characteristics; f.TypeGoods.SelectedItem = "Дополнительный"; } else { MainProduct mainProduct = db.MainProducts.Find(s.Id); f.textBox_TypeProd.Text = mainProduct.Type; f.textBox_NameProd.Text = mainProduct.CodeName; f.textBox_Brand.Text = mainProduct.Brand; f.textBox_TireWidth.Text = Convert.ToString(mainProduct.TireWidth); f.textBox_SpeedNum.Text = Convert.ToString(mainProduct.SpeedNum); f.textBox_Diameter.Text = Convert.ToString(mainProduct.Diameter); f.textBox_Info.Text = mainProduct.Info; f.checkBox.IsChecked = mainProduct.Used; f.TypeGoods.SelectedItem = "Основной"; } f.Closing += addNoteWindow_Closing; f.ShowDialog(); } else { MessageBox.Show("Вы не выбрали товар для редактирования", "Ошибка"); } }
public ActionResult AddProduct(MainProduct objMP) { Prod = new clsProduct(); try { if (ModelState.IsValid) { if (Prod.AddProduct(objMP.Pid, objMP.ProductName, objMP.Price, objMP.Model, objMP.Color, objMP.Cid)) { return(RedirectToAction("ProductList", "Product")); } } } catch (Exception) { throw; } return(View()); }
private void buttonOK_Click(object sender, RoutedEventArgs e) { if (dataGrid_Secondaries.SelectedItem != null) { Secondary s = dataGrid_Secondaries.SelectedItem as Secondary; Id = s.Id; this.Close(); } else if (dataGrid_MainProd.SelectedItem != null) { MainProduct s = dataGrid_MainProd.SelectedItem as MainProduct; Id = s.Id; this.Close(); } else { MessageBox.Show("Вы ничего не выбрали"); } }
private void btnAddMain_Click(object sender, EventArgs e) { try { cmbMainProductSelect.Items.Clear(); MainProduct mp = new MainProduct(); mp.MainProductName = txtMainName.Text; mp.MainProductPrice = Convert.ToDecimal(txtMainPriceMasked.Text); MainProductRepository mpr = new MainProductRepository(); mpr.Add(mp); MessageBox.Show("Lütfen Yeni Kayıt Oluşturduğunuz Ürün İçin Gerekli İlk Stok Bilgilerini Giriniz."); foreach (var item in db.MainProducts) { cmbMainProductSelect.Items.Add(item.MainProductName); } } catch { MessageBox.Show("Lütfen Bilgileri Doğru Giriniz!"); } }
public bool Update(MainProduct mainProduct) { return(_mainProductService.Update(mainProduct)); }
public bool Add(MainProduct mainProduct) { return(_mainProductRepository.Add(mainProduct) > 0); }
private void button_Save_Click(object sender, RoutedEventArgs e) { try { MessageBoxResult res; res = MessageBox.Show("Вы уверены, что хотите сохранить товар?", "Предупреждение", MessageBoxButton.YesNo, MessageBoxImage.Question); if (res == MessageBoxResult.Yes) { if (textBox_Id.Text == "-1") { if (TypeGoods.SelectedItem == null) { MessageBox.Show("Вы ничего не выбрали!", "Предупреждение", MessageBoxButton.OK, MessageBoxImage.Question); } else if (TypeGoods.SelectedItem.ToString() == "Основной") { List <TextBox> s = MainProdGrid.Children.OfType <TextBox>().ToList(); foreach (TextBox q in s) { if (q.Text == "" || q.Text == "0") { MessageBox.Show("Не все поля заполнены"); return; } } MainProduct f = new MainProduct(); f.Type = textBox_TypeProd.Text; f.CodeName = textBox_NameProd.Text; f.Brand = textBox_Brand.Text; f.TireWidth = Convert.ToDouble(textBox_TireWidth.Text); f.Diameter = Convert.ToInt32(textBox_Diameter.Text); f.SpeedNum = Convert.ToInt32(textBox_SpeedNum.Text); f.Used = checkBox.IsChecked.Value; f.Info = textBox_Info.Text; Product god = new Product() { Balance = Convert.ToInt32(textBox.Text), PricePurchase = Convert.ToDouble(textBox1.Text), SellPrice = Convert.ToDouble(textBox2.Text), MainProduct = f }; db.Product.Add(god); db.SaveChanges(); this.Close(); MessageBox.Show("Товар успешно сохранен в базе."); } else if (TypeGoods.SelectedItem.ToString() == "Дополнительный") { List <TextBox> s = SecondaryGrid.Children.OfType <TextBox>().ToList(); foreach (TextBox q in s) { if (q.Text == "" || q.Text == "0") { MessageBox.Show("Не все поля заполнены"); return; } } Secondary access = new Secondary(); access.Type = textBox_Type.Text; access.Name = textBox_Name.Text; access.Characteristics = textBox_Charact.Text; Product god = new Product() { Secondary = access }; god.Balance = Convert.ToInt32(textBox.Text); god.PricePurchase = Convert.ToDouble(textBox1.Text); //Convert.ToInt32(textBox1.Text) god.SellPrice = Convert.ToDouble(textBox2.Text); //Convert.ToInt32(textBox2.Text) db.Product.Add(god); db.SaveChanges(); this.Close(); MessageBox.Show("Товар успешно сохранен в базе."); } } else { Product f = db.Product.Find(Convert.ToInt32(textBox_Id.Text)); if (TypeGoods.SelectedItem.ToString() == "Основной") { MainProduct mainProduct = db.MainProducts.Find(Convert.ToInt32(textBox_Id.Text)); mainProduct.Type = textBox_TypeProd.Text; mainProduct.CodeName = textBox_NameProd.Text; mainProduct.Brand = textBox_Brand.Text; mainProduct.TireWidth = Convert.ToDouble(textBox_TireWidth.Text); mainProduct.Diameter = Convert.ToInt32(textBox_Diameter.Text); mainProduct.SpeedNum = Convert.ToInt32(textBox_SpeedNum.Text); mainProduct.Used = checkBox.IsChecked.Value; mainProduct.Info = textBox_Info.Text; f.Balance = Convert.ToInt32(textBox.Text); f.PricePurchase = Convert.ToDouble(textBox1.Text); //Convert.ToInt32 f.SellPrice = Convert.ToDouble(textBox2.Text); //Convert.ToInt32 db.SaveChanges(); } else if (TypeGoods.SelectedItem.ToString() == "Дополнительный") { Secondary secondary = db.Secondaries.Find(Convert.ToInt32(textBox_Id.Text)); secondary.Type = textBox_Type.Text; secondary.Name = textBox_Name.Text; secondary.Characteristics = textBox_Charact.Text; f.Balance = Convert.ToInt32(textBox.Text); f.PricePurchase = Convert.ToDouble(textBox1.Text); f.SellPrice = Convert.ToDouble(textBox2.Text); db.SaveChanges(); } this.Close(); } } } catch { MessageBox.Show("Error"); } }
public bool Update(MainProduct mainProduct) { return(_mainProductRepository.Update(mainProduct) > 0); }