private void Button_Click(object sender, RoutedEventArgs e) { string[] listInventory = new string[4]; int cntDoc = 0; for (int i = 0; i < inventoryClothList.Items.Count - 1; i++) { listInventory = db.ArrayItem(i, dt); cntDoc += int.Parse(listInventory[3]); } var select = db.kladCloth; int cntSkl = 0; foreach (kladCloth cloth in select) { cntSkl += cloth.count; } int diff = cntDoc - cntSkl; DateTime dat = DateTime.Parse(DateTime.Now.ToString("dd MMMM yyyy")); inventoryItog inventoryItog = new inventoryItog { date = dat, item = nameItem, difference = diff }; db.inventory.Add(inventoryItog); db.SaveChanges(); var select2 = db.inventory.Where(inv => inv.date == dat && inv.difference == diff && inv.item == nameItem); for (int i = 0; i < inventoryClothList.Items.Count - 1; i++) { listInventory = db.ArrayItem(i, dt); inventoryItem inventoryItm = new inventoryItem(); inventoryItm.articul = listInventory[0]; inventoryItm.length = double.Parse(listInventory[2]); inventoryItm.width = double.Parse(listInventory[3]); inventoryItm.Idinv = select2.FirstOrDefault().Id; inventoryItm.countToDoc = cntDoc; inventoryItm.countToSklad = cntSkl; db.inventoryItem.Add(inventoryItm); } db.SaveChanges(); clothSklad clothSkl = new clothSklad(IdUser); MessageBox.Show("Инвентаризация успешно сохранена"); clothSkl.Show(); this.Close(); }
private void Button_Click(object sender, RoutedEventArgs e) { string[] listFur = new string[4]; for (int i = 0; i < postFur.Items.Count - 1; i++) { listFur = db.ArrayItem(i, dt); string art = listFur[0]; double width = double.Parse(listFur[1]); double length = double.Parse(listFur[2]); double count = double.Parse(listFur[3]); var select = db.kladFurniture.Where(kladFur => kladFur.furniture == art && kladFur.length == length && kladFur.width == width); if (select.Count() != 0) { count += select.FirstOrDefault().count; int Id = select.FirstOrDefault().Id; kladFurniture update = db.kladFurniture.Find(Id); update.count = count; db.kladFurniture.Create(); db.SaveChanges(); } else { kladFurniture item = new kladFurniture(); item.furniture = art; item.length = length; item.width = width; item.count = count; var insert = db.kladFurniture.Add(item); db.SaveChanges(); } } MessageBox.Show("Товары успешно добавлены на склад"); furnitureSklad furnitureSklad = new furnitureSklad(IdUser); furnitureSklad.Show(); this.Close(); }
private void Button_Click(object sender, RoutedEventArgs e) { string[] listfur = new string[4]; for (int i = 0; i < dellist.Items.Count - 1; i++) { listfur = db.ArrayItem(i, dt); string art = listfur[0]; double width = double.Parse(listfur[1]); double length = double.Parse(listfur[2]); int count = int.Parse(listfur[3]); var select = db.kladFurniture.Where(kladFur => kladFur.furniture == art && kladFur.length == length && kladFur.width == width); if (select.Count() != 0) { int Id = select.FirstOrDefault().Id; kladFurniture klad = db.kladFurniture.Find(Id); if (klad.count >= count) { klad.count -= count; db.kladFurniture.Create(); db.SaveChanges(); MessageBox.Show("Списание товаров прошло успешно"); furnitureSklad furnitureSklad = new furnitureSklad(IdUser); furnitureSklad.Show(); this.Close(); } else { MessageBox.Show("Запрошенного количества нет на складе"); } } else { MessageBox.Show("Такого товара не существует"); } } }
private void Button_Click_1(object sender, RoutedEventArgs e) { string[] listcloth = new string[4]; for (int i = 0; i < postCloth.Items.Count - 1; i++) { listcloth = db.ArrayItem(i, dt); string art = listcloth[0]; double wdth = double.Parse(listcloth[1]); double lngth = double.Parse(listcloth[2]); int cnt = int.Parse(listcloth[3]); var select = db.kladCloth.Where(kc => kc.cloth == art && kc.width == wdth && kc.length == lngth); if (select.Count() != 0) { cnt += select.FirstOrDefault().count; int id = select.FirstOrDefault().Id; kladCloth update = db.kladCloth.Find(id); update.count = cnt; db.kladCloth.Create(); db.SaveChanges(); } else { kladCloth item = new kladCloth(); item.cloth = art; item.count = cnt; item.length = lngth; item.width = wdth; var insert = db.kladCloth.Add(item); db.SaveChanges(); } } MessageBox.Show("Товары успешно добавлены на склад"); clothSklad cs = new clothSklad(IdUser); cs.Show(); this.Close(); }
private void inpsave_Click(object sender, RoutedEventArgs e) { string[] list = new string[4]; for (int i = 0; i < listcloth.Items.Count - 1; i++) { list = db.ArrayItem(i, dt); string art = list[0]; double wdth = double.Parse(list[1]); double lngth = double.Parse(list[2]); int cnt = int.Parse(list[3]); var select = db.kladCloth.Where(kcl => kcl.cloth == art && kcl.width == wdth && kcl.length == lngth); if (select.Count() != 0) { if (select.FirstOrDefault().count >= cnt) { cnt = select.FirstOrDefault().count - cnt; kladCloth item = db.kladCloth.Find(select.FirstOrDefault().Id); item.count = cnt; db.kladCloth.Create(); db.SaveChanges(); MessageBox.Show("Данные успешно обновлены"); clothSklad cs = new clothSklad(IdUser); cs.Show(); this.Close(); } else { MessageBox.Show("Запрошенного количества товара нет на складе"); } } else { MessageBox.Show("Одного из товаров не существует"); } } }