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);
}