public Report3Window()
{
InitializeComponent();
comboBox.ItemsSource = BufferData.GetInstance().DestinationTable.Data.Select(x => x.Type);
comboBox.SelectedIndex = 0;
}
// 2) Отримати список матеріалів і їх кількість (по фасонам)
// із вказанням признака видачі та з підведенням підсумків по кожному
// з матеріалів і загального підсумка за певний день.
public static List <ExistMaterial> GetMaterialsResult(DateTime date, int idDestination, ref int total)
{
List <ExistMaterial> listMaterials = new List <ExistMaterial>();
List <Material> list = BufferData.GetInstance().MaterialTable.Data;
var list2 = BufferData.GetInstance().IssuedMaterialsTable.Data;
var fashionList = BufferData.GetInstance().FashionTable.Data;
foreach (var it in list)
{
int amount = GetTotalIssuedMaterial(it.IdMaterial, date, idDestination);
if (amount > 0)
{
string fashion = fashionList.Find(x => x.IdFashion == it.IdFashion).Name;
listMaterials.Add(new ExistMaterial
{
Id = it.IdMaterial,
Name = it.Name,
Amount = amount,
Fashion = fashion
});
}
}
foreach (var it in listMaterials)
{
total += it.Amount;
}
return(listMaterials);
}
public FashionEditWindow()
{
InitializeComponent();
bufferData = BufferData.GetInstance();
Fashion fashion = (Fashion)bufferData.CurrentRow;
string str = bufferData.NameOfAttribDictinionary["IdFashion"];
label1.Content = str;
str = bufferData.NameOfAttribDictinionary["Name"];
label2.Content = str;
str = bufferData.NameOfAttribDictinionary["Definition"];
label3.Content = str;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
oldId = fashion.IdFashion;
textBox1.Text = fashion.IdFashion.ToString();
textBox2.Text = fashion.Name;
textBox3.Text = fashion.Definition;
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
oldId = -1;
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
}
}
public MaterialTypeEditWindow()
{
InitializeComponent();
bufferData = BufferData.GetInstance();
MaterialType materialType = (MaterialType)bufferData.CurrentRow;
string str = bufferData.NameOfAttribDictinionary["IdMaterialType"];
label1.Content = str;
str = bufferData.NameOfAttribDictinionary["Name"];
label2.Content = str;
str = bufferData.NameOfAttribDictinionary["Definition"];
label3.Content = str;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
oldId = materialType.IdMaterialType;
textBox1.Text = materialType.IdMaterialType.ToString();
textBox2.Text = materialType.Name;
textBox3.Text = materialType.Definition;
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
oldId = -1;
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
}
}
private void Init()
{
if (SystemUser.GetInstance().UserType == SystemUser.UsersType.Client)
{
AddButton.Visibility = Visibility.Hidden;
UpdateButton.Visibility = Visibility.Hidden;
DeleteButton.Visibility = Visibility.Hidden;
}
if (SystemUser.GetInstance().UserType == SystemUser.UsersType.Admin)
{
AddOrderButton.Visibility = Visibility.Hidden;
}
// Buffer initializes
bufferData = BufferData.GetInstance();
// list of tables initializes
if (bufferData.Mode == BufferData.Modes.Structure)
{
StructureRadioButton1.IsChecked = true;
}
else
{
ViewRadioButton2.IsChecked = true;
}
tableListBox.ItemsSource = bufferData.TablesList;
depotDbConnector = DepotDbConnector.GetInstance();
string selectedTable = "state";
SelectTable(selectedTable);
}
public static void UpdateManufacturer(int oldId, string ids, string names, string countrys, string citys, string tels)
{
BufferData bufferData = BufferData.GetInstance();
int id = ValidateField.ValidateKey(ids, oldId, bufferData.DestinationTable.GetIdList());
string name = ValidateField.ValidateString(names);
string country = ValidateField.ValidateString(countrys);
string city = ValidateField.ValidateString(citys);
string tel = ValidateField.ValidateTelephone(tels);
string query;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
query = "Update manufacturer set id_manufacturer = " + id +
", name = '" + name +
"', country = '" + country +
"', city = '" + city +
"', telephone = '" + tel +
"' where id_manufacturer = " + oldId + ";";
DepotDbConnector.GetInstance().UpdateQuerry(query);
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
query = "Insert into manufacturer (id_manufacturer, name, country, city, telephone) values (" +
id + ", '" +
name + "', '" +
country + "', '" +
city + "', '" +
tel + "');";
DepotDbConnector.GetInstance().InsertQuerry(query);
}
}
public static void UpdateFashion(int oldId, string ids, string names, string defs)
{
BufferData bufferData = BufferData.GetInstance();
int id = ValidateField.ValidateKey(ids, oldId, bufferData.DestinationTable.GetIdList());
string name = ValidateField.ValidateString(names);
string def = ValidateField.ValidateString(defs);
string query;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
query = "Update fashion set id_fashion = " + id +
", name = '" + name + "', definition = '" + def +
"' where id_fashion = " + oldId + ";";
DepotDbConnector.GetInstance().UpdateQuerry(query);
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
query = "Insert into fashion (id_fashion, name, definition) values (" + id +
", '" + name + "', '" + def + "');";
DepotDbConnector.GetInstance().InsertQuerry(query);
}
}
public static void UpdateReceivedView(int oldId, string ids, string dates, string amounts, string mats)
{
BufferData buffer = BufferData.GetInstance();
string material = buffer.MaterialTable.Data.First(x => x.Name == mats).IdMaterial.ToString();
UpdateReceivedMaterial(oldId, ids, dates, amounts, material);
}
public static void UpdateReceivedMaterial(int oldId, string ids, string dates, string amounts, string idMats)
{
BufferData bufferData = BufferData.GetInstance();
int id = ValidateField.ValidateKey(ids, oldId, bufferData.DestinationTable.GetIdList());
string date = ValidateField.ValidateDate(dates);
int amount = ValidateField.ValidateNumber(amounts);
int idMat = ValidateField.ValidateNumber(idMats);
string query;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
query = "Update received_material set id_received_material = " + id +
", date_received = '" + date +
"', amount = '" + amount +
"', id_material = '" + idMat +
"' where id_received_material = " + oldId + ";";
DepotDbConnector.GetInstance().UpdateQuerry(query);
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
query = "Insert into received_material (id_received_material, date_received, amount, id_material) values (" +
id + ", '" +
date + "', '" +
amount + "', '" +
idMat + "');";
DepotDbConnector.GetInstance().InsertQuerry(query);
}
}
public DestinationEditWindow()
{
InitializeComponent();
bufferData = BufferData.GetInstance();
Destination destination = (Destination)bufferData.CurrentRow;
string str = bufferData.NameOfAttribDictinionary["IdDestination"];
label1.Content = str;
str = bufferData.NameOfAttribDictinionary["Type"];
label2.Content = str;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
oldId = destination.IdDestination;
textBox1.Text = destination.IdDestination.ToString();
textBox2.Text = destination.Type;
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
oldId = -1;
textBox1.Text = "";
textBox2.Text = "";
}
}
public StateEditWindow()
{
InitializeComponent();
bufferData = BufferData.GetInstance();
State state = (State)bufferData.CurrentRow;
string str = bufferData.NameOfAttribDictinionary["IdState"];
label1.Content = str;
str = bufferData.NameOfAttribDictinionary["Name"];
label2.Content = str;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
oldId = state.IdState;
textBox1.Text = state.IdState.ToString();
textBox2.Text = state.Name;
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
oldId = -1;
textBox1.Text = "";
textBox2.Text = "";
}
}
public static void OpenWindow()
{
BufferData bufferData = BufferData.GetInstance();
switch (bufferData.CurrentTableName)
{
case "destination":
DestinationEditWindow.GetInstance().Show();
break;
case "fashion":
FashionEditWindow.GetInstance().Show();
break;
case "manufacturer":
ManufacturerEditWindow.GetInstance().Show();
break;
case "material":
MaterialEditWindow.GetInstance().Show();
break;
case "material_type":
MaterialTypeEditWindow.GetInstance().Show();
break;
case "orders":
OrdersEditWindow.GetInstance().Show();
break;
case "received_material":
ReceivedMaterialEditWindow.GetInstance().Show();
break;
case "state":
StateEditWindow.GetInstance().Show();
break;
case "issued_materials":
IssuedMaterialsEditWindow.GetInstance().Show();
break;
case "issuedview":
IssuedViewEditWindow.GetInstance().Show();
break;
case "materialview":
MaterialViewEditWindow.GetInstance().Show();
break;
case "ordersview":
OrdersViewEditWindow.GetInstance().Show();
break;
case "receivedview":
ReceivedEditWindow.GetInstance().Show();
break;
}
}
public static void Delete(int id)
{
BufferData bufferData = BufferData.GetInstance();
//int id = ((ITableRow)bufferData.CurrentRow).GetId();
EditAdapter.Delete(bufferData.CurrentTableName, id,
((ITableRow)bufferData.CurrentRow).GetIdName());
}
public static void UpdateIssuedView(int oldId, string ids, string dates, string amounts, string mats, string dests)
{
BufferData buffer = BufferData.GetInstance();
int idMat = buffer.MaterialTable.Data.First(x => x.Name == mats).IdMaterial;
int idDest = buffer.DestinationTable.Data.First(x => x.Type == dests).IdDestination;
UpdateOrders(oldId, ids, dates, amounts, idMat.ToString(), idDest.ToString(), "1");
}
public static void UpdateOrdersView(int oldId, string ids, string dates, string amounts, string mats, string dests, string states)
{
BufferData buffer = BufferData.GetInstance();
string material = buffer.MaterialTable.Data.First(x => x.Name == mats).IdMaterial.ToString();
string dest = buffer.DestinationTable.Data.First(x => x.Type == dests).IdDestination.ToString();
string state = buffer.StateTable.Data.First(x => x.Name == states).IdState.ToString();
UpdateOrders(oldId, ids, dates, amounts, material, dest, state);
}
public MaterialEditWindow()
{
InitializeComponent();
bufferData = BufferData.GetInstance();
Material Material = (Material)bufferData.CurrentRow;
string str = bufferData.NameOfAttribDictinionary["IdMaterial"];
label1.Content = str;
str = bufferData.NameOfAttribDictinionary["Name"];
label2.Content = str;
str = bufferData.NameOfAttribDictinionary["DateProducing"];
label3.Content = str;
str = bufferData.NameOfAttribDictinionary["IdManufacturer"];
label4.Content = str;
str = bufferData.NameOfAttribDictinionary["IdMaterialType"];
label5.Content = str;
str = bufferData.NameOfAttribDictinionary["IdFashion"];
label6.Content = str;
var lst1 = bufferData.ManufacturerTable.GetIdList();
var lst2 = bufferData.MaterialTypeTable.GetIdList();
var lst3 = bufferData.FashionTable.GetIdList();
comboBox4.ItemsSource = lst1;
comboBox5.ItemsSource = lst2;
comboBox6.ItemsSource = lst3;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
oldId = Material.IdMaterial;
textBox1.Text = Material.IdMaterial.ToString();
textBox2.Text = Material.Name;
datePicker3.SelectedDate = DateTime.Parse(Material.DateProducing);
int index = lst1.FindIndex(x => x == Material.IdManufacturer);
comboBox4.SelectedIndex = index;
index = lst1.FindIndex(x => x == Material.IdMaterialType);
comboBox5.SelectedIndex = index;
index = lst1.FindIndex(x => x == Material.IdFashion);
comboBox6.SelectedIndex = index;
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
oldId = -1;
textBox1.Text = "";
textBox2.Text = "";
datePicker3.SelectedDate = DateTime.Now.Date;
comboBox4.SelectedIndex = 0;
comboBox5.SelectedIndex = 0;
comboBox6.SelectedIndex = 0;
}
}
public static void UpdateMaterialView(int oldId, string ids, string names, string dates, string manufacturers, string matTypes, string fashions)
{
BufferData buffer = BufferData.GetInstance();
string manufacturer = buffer.ManufacturerTable.Data.First(x => x.Name == manufacturers).IdManufacturer.ToString();
string matType = buffer.MaterialTypeTable.Data.First(x => x.Name == matTypes).IdMaterialType.ToString();
string fashion = buffer.FashionTable.Data.First(x => x.Name == fashions).IdFashion.ToString();
UpdateMaterial(oldId, ids, names, dates, manufacturer, matType, fashion);
}
public OrdersViewEditWindow()
{
InitializeComponent();
bufferData = BufferData.GetInstance();
OrdersView ordersView = (OrdersView)bufferData.CurrentRow;
string str = bufferData.NameOfAttribDictinionary["IdOrder"];
label1.Content = str;
str = bufferData.NameOfAttribDictinionary["Date"];
label2.Content = str;
str = bufferData.NameOfAttribDictinionary["AmountMaterial"];
label3.Content = str;
str = bufferData.NameOfAttribDictinionary["Material"];
label4.Content = str;
str = bufferData.NameOfAttribDictinionary["Destination"];
label5.Content = str;
str = bufferData.NameOfAttribDictinionary["Status"];
label6.Content = str;
var lst1 = new List <string>(bufferData.MaterialTable.Data.Select(x => x.Name));
var lst2 = new List <string>(bufferData.DestinationTable.Data.Select(x => x.Type));
var lst3 = new List <string>(bufferData.StateTable.Data.Select(x => x.Name));
comboBox4.ItemsSource = lst1;
comboBox5.ItemsSource = lst2;
comboBox6.ItemsSource = lst3;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
oldId = ordersView.IdOrder;
textBox1.Text = ordersView.IdOrder.ToString();
datePicker2.SelectedDate = DateTime.Parse(ordersView.Date);
textBox3.Text = ordersView.AmountMaterial.ToString();
int index = lst1.FindIndex(x => x == ordersView.Material);
comboBox4.SelectedIndex = index;
index = lst2.FindIndex(x => x == ordersView.Destination);
comboBox5.SelectedIndex = index;
index = lst3.FindIndex(x => x == ordersView.Status);
comboBox6.SelectedIndex = index;
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
oldId = -1;
textBox1.Text = "";
datePicker2.SelectedDate = DateTime.Now.Date;
textBox3.Text = "";
comboBox4.SelectedIndex = 0;
comboBox5.SelectedIndex = 0;
comboBox6.SelectedIndex = 0;
}
}
public static void Find()
{
BufferData bufferData = BufferData.GetInstance();
bufferData.EditMode = BufferData.EditModes.Find;
FindWindow w = FindWindow.GetInstance();
w.Show();
}
public static int GetTotalReceivedMaterial(int idMaterial)
{
int total = 0;
List <ReceivedMaterial> list = BufferData.GetInstance().ReceivedMaterialTable.Data;
foreach (var it in list)
{
if (it.IdMaterial == idMaterial)
{
total += it.Amount;
}
}
return(total);
}
public static int GetTotalIssuedMaterial(int idMaterial, DateTime date)
{
int total = 0;
List <IssuedMaterials> list = BufferData.GetInstance().IssuedMaterialsTable.Data;
foreach (var it in list)
{
if ((it.IdMaterial == idMaterial) && (it.GetDate() <= date))
{
total += it.AmountMaterial;
}
}
return(total);
}
public IssuedMaterialsEditWindow()
{
InitializeComponent();
bufferData = BufferData.GetInstance();
IssuedMaterials IssuedMaterials = (IssuedMaterials)bufferData.CurrentRow;
string str = bufferData.NameOfAttribDictinionary["IdIssuedMaterial"];
label1.Content = str;
str = bufferData.NameOfAttribDictinionary["Date"];
label2.Content = str;
str = bufferData.NameOfAttribDictinionary["AmountMaterial"];
label3.Content = str;
str = bufferData.NameOfAttribDictinionary["IdMaterial"];
label4.Content = str;
str = bufferData.NameOfAttribDictinionary["IdDestination"];
label5.Content = str;
var lst1 = bufferData.MaterialTable.GetIdList();
var lst2 = bufferData.DestinationTable.GetIdList();
comboBox4.ItemsSource = lst1;
comboBox5.ItemsSource = lst2;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
oldId = IssuedMaterials.IdIssuedMaterial;
textBox1.Text = IssuedMaterials.IdIssuedMaterial.ToString();
datePicker2.SelectedDate = DateTime.Parse(IssuedMaterials.Date);
textBox3.Text = IssuedMaterials.AmountMaterial.ToString();
int index = lst1.FindIndex(x => x == IssuedMaterials.IdMaterial);
comboBox4.SelectedIndex = index;
index = lst1.FindIndex(x => x == IssuedMaterials.IdDestination);
comboBox5.SelectedIndex = index;
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
oldId = -1;
textBox1.Text = "";
datePicker2.SelectedDate = DateTime.Now.Date;
textBox3.Text = "";
comboBox4.SelectedIndex = 0;
comboBox5.SelectedIndex = 0;
}
}
// Adds record to the table orders
public static bool AddOrder(string dates, string amounts, string mats, string dests,
string fashions, string types)
{
BufferData bufferData = BufferData.GetInstance();
int id = bufferData.OrdersViewTable.Data.Max(x => x.IdOrder) + 1;
string date = ValidateField.ValidateDate(dates);
int amount = ValidateField.ValidateNumber(amounts);
mats = ValidateField.ValidateString(mats);
dests = ValidateField.ValidateString(dests);
fashions = ValidateField.ValidateString(fashions);
types = ValidateField.ValidateString(types);
int idDest = bufferData.DestinationTable.Data.First(x => x.Type == dests).IdDestination;
int idState;
int idFashion = bufferData.FashionTable.Data.First(x => x.Name == fashions).IdFashion;
int idType = bufferData.MaterialTypeTable.Data.First(x => x.Name == types).IdMaterialType;
int idMat = bufferData.MaterialTable.Data.First(
x => x.Name == mats &&
x.IdFashion == idFashion &&
x.IdMaterialType == idType).IdMaterial;
if ((StockCalculate.GetTotalExistMaterial(idMat) - amount) >= 0)
{
idState = 1;
}
else
{
idState = 2;
}
string query;
query = "Insert into orders (id_order, date, amount_material, id_material, id_destination, id_state) values (" +
id + ", '" +
date + "', '" +
amount + "', '" +
idMat + "', '" +
idDest + "', '" +
idState + "');";
DepotDbConnector.GetInstance().InsertQuerry(query);
return((idState == 1) ? true : false);
}
public static void UpdateOrders(int oldId, string ids, string dates, string amounts, string idMats, string idDests, string idStates)
{
BufferData bufferData = BufferData.GetInstance();
int id = ValidateField.ValidateKey(ids, oldId, bufferData.DestinationTable.GetIdList());
string date = ValidateField.ValidateDate(dates);
int amount = ValidateField.ValidateNumber(amounts);
int idMat = ValidateField.ValidateNumber(idMats);
int idDest = ValidateField.ValidateNumber(idDests);
int idState = ValidateField.ValidateNumber(idStates);
if ((StockCalculate.GetTotalExistMaterial(idMat) - amount) >= 0)
{
idState = 1;
}
else
{
idState = 2;
}
string query;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
query = "Update orders set id_order = " + id +
", date = '" + date +
"', amount_material = '" + amount +
"', id_material = '" + idMat +
"', id_destination = '" + idDest +
"', id_state = '" + idState +
"' where id_order = " + oldId + ";";
DepotDbConnector.GetInstance().UpdateQuerry(query);
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
query = "Insert into orders (id_order, date, amount_material, id_material, id_destination, id_state) values (" +
id + ", '" +
date + "', '" +
amount + "', '" +
idMat + "', '" +
idDest + "', '" +
idState + "');";
DepotDbConnector.GetInstance().InsertQuerry(query);
}
}
public AddOrderWindow()
{
InitializeComponent();
bufferData = BufferData.GetInstance();
string str;
str = bufferData.NameOfAttribDictinionary["Date"];
label2.Content = str;
str = bufferData.NameOfAttribDictinionary["AmountMaterial"];
label3.Content = str;
str = bufferData.NameOfAttribDictinionary["Material"];
label4.Content = str;
str = bufferData.NameOfAttribDictinionary["Destination"];
label5.Content = str;
str = bufferData.NameOfAttribDictinionary["Fashion"];
label6.Content = str;
str = bufferData.NameOfAttribDictinionary["MaterialType"];
label7.Content = str;
var nameLst = new List <string>(bufferData.MaterialTable.Data.Select(x => x.Name));
var destLst = new List <string>(bufferData.DestinationTable.Data.Select(x => x.Type));
//var fashionLst = new List<string>(bufferData.FashionTable.Data.Select(x => x.Name));
//var typeLst = new List<string>(bufferData.MaterialTypeTable.Data.Select(x => x.Name));
comboBox4.ItemsSource = nameLst;
comboBox5.ItemsSource = destLst;
//comboBox6.ItemsSource = fashionLst;
//comboBox7.ItemsSource = typeLst;
comboBox4.SelectedIndex = 0;
string nameMaterial = comboBox4.SelectedItem.ToString();
var materialLst = bufferData.MaterialViewTable.Data.FindAll(x => x.Name == nameMaterial);
comboBox6.ItemsSource = materialLst.Select(x => x.Fashion);
comboBox7.ItemsSource = materialLst.Select(x => x.MaterialType);
datePicker2.SelectedDate = DateTime.Now.Date;
textBox3.Text = "";
//comboBox4.SelectedIndex = 0;
comboBox5.SelectedIndex = 0;
comboBox6.SelectedIndex = 0;
comboBox7.SelectedIndex = 0;
}
public static int GetTotalIssuedMaterial(int idMaterial, DateTime date, int idDestination)
{
int total = 0;
List <IssuedMaterials> list = BufferData.GetInstance().IssuedMaterialsTable.Data;
foreach (var it in list)
{
DateTime date2 = it.GetDate();
if ((it.IdMaterial == idMaterial) &&
(date2.Day == date.Day) &&
(date2.Month == date.Month) &&
(date2.Year == date.Year) &&
(it.IdDestination == idDestination))
{
total += it.AmountMaterial;
}
}
return(total);
}
private void ReportView()
{
DateTime date = dataPicker.SelectedDate ?? DateTime.Now;
string destination = comboBox.SelectedItem.ToString();
int idDest = BufferData.GetInstance().DestinationTable.Data.Find(x => x.Type == destination).IdDestination;
int total = 0;
var list = StockCalculate.GetMaterialsResult(date, idDest, ref total);
label3.Content = total;
ObservableCollection <ExistMaterial> collection = new ObservableCollection <ExistMaterial>(list);
ListCollectionView collection2 = new ListCollectionView(collection);
collection2.GroupDescriptions.Add(new PropertyGroupDescription("Fashion"));
dataGrid.ItemsSource = collection2;
}
// 4) Отримати список матеріалів, по заявкам на які були відмови.
public static List <ExistMaterial> GetNotEnoughMaterials(int monthNumber)
{
List <ExistMaterial> listMaterials = new List <ExistMaterial>();
List <Orders> list = BufferData.GetInstance().OrdersTable.Data;
List <Material> list2 = BufferData.GetInstance().MaterialTable.Data;
list = list.FindAll(x => x.IdState == 2 && x.GetMonth() == monthNumber);
foreach (var it in list)
{
listMaterials.Add(new ExistMaterial
{
Id = it.IdMaterial,
Name = list2.Find(x => x.IdMaterial == it.IdMaterial).Name
});
}
listMaterials = (listMaterials.GroupBy(x => x.Id).Select(group => group.First()).ToList <ExistMaterial>());
return(listMaterials);
}
// 0) Отримати список наявних на складі матеріалів.
public static List <ExistMaterial> GetExistMaterialTable()
{
List <ExistMaterial> listMaterials = new List <ExistMaterial>();
List <Material> list = BufferData.GetInstance().MaterialTable.Data;
foreach (var it in list)
{
if (GetTotalExistMaterial(it.IdMaterial) > 0)
{
listMaterials.Add(new ExistMaterial
{
Id = it.IdMaterial,
Name = it.Name,
Amount = GetTotalExistMaterial(it.IdMaterial)
});
}
}
return(listMaterials);
}
public ReceivedEditWindow()
{
InitializeComponent();
bufferData = BufferData.GetInstance();
ReceivedView receivedView = (ReceivedView)bufferData.CurrentRow;
string str = bufferData.NameOfAttribDictinionary["IdReceivedMaterial"];
label1.Content = str;
str = bufferData.NameOfAttribDictinionary["DateReceived"];
label2.Content = str;
str = bufferData.NameOfAttribDictinionary["Amount"];
label3.Content = str;
str = bufferData.NameOfAttribDictinionary["Material"];
label4.Content = str;
var lst1 = new List <string>(bufferData.MaterialTable.Data.Select(x => x.Name));
comboBox4.ItemsSource = lst1;
if (bufferData.EditMode == BufferData.EditModes.Update)
{
oldId = receivedView.IdReceivedMaterial;
textBox1.Text = receivedView.IdReceivedMaterial.ToString();
datePicker2.SelectedDate = DateTime.Parse(receivedView.DateReceived);
textBox3.Text = receivedView.Amount.ToString();
int index = lst1.FindIndex(x => x == receivedView.Material);
comboBox4.SelectedIndex = index;
}
if (bufferData.EditMode == BufferData.EditModes.Insert)
{
oldId = -1;
textBox1.Text = "";
datePicker2.SelectedDate = DateTime.Now.Date;
textBox3.Text = "";
comboBox4.SelectedIndex = 0;
}
}