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("Одного из товаров не существует");
}
}
}
