/// <summary>
/// Блоки сортировки и поиска данных по тексту
/// </summary>
private void NameTxt_TextChanged(object sender, TextChangedEventArgs e)
{
var name1 = AccountingForConsumablesEntities.GetContext().OrderedMaterial.Distinct().ToList();
var name = AccountingForConsumablesEntities.GetContext().OrderedMaterial.Select(s => s.MaterialCard.id).Distinct().ToArray();
for (int i = 0; i < name.Count(); i++)
{
int stdasd = name[i];
int tbs = AccountingForConsumablesEntities.GetContext().OrderedMaterial.Where(w => w.FK_MaterialCard == stdasd).Sum(s => s.OrderedQuantity);
OrderedMaterial tasd = name1.Where(s => s.FK_MaterialCard == stdasd).FirstOrDefault();
OrderedMaterial card = new OrderedMaterial()
{
FK_MaterialCard = tasd.FK_MaterialCard, MaterialCard = tasd.MaterialCard, counter = tbs, Order = tasd.Order
};
tbd.Add(card);
}
if (NameTxt.Text == "")
{
DGridConsumable.ItemsSource = tbd.ToList();
}
else if (ManufacturerCmb.SelectedIndex == 0)
{
DGridConsumable.ItemsSource = tbd.Where(w => w.MaterialCard.Materials.MaterialName.StartsWith(NameTxt.Text)).ToList();
}
else
{
DGridConsumable.ItemsSource = tbd.Where(w => w.MaterialCard.Materials.MaterialName.StartsWith(NameTxt.Text) && w.MaterialCard.Materials.Manufacturer.ManufacturerName == ManufacturerCmb.Text).ToList();
}
}
public ConsumPageAbout()
{
InitializeComponent();
ManufacturerLst = AccountingForConsumablesEntities.GetContext().Manufacturer.ToList();
ManufacturerLst.Insert(0, new Manufacturer {
ManufacturerName = "All"
});
ManufacturerCmb.ItemsSource = ManufacturerLst;
var name1 = AccountingForConsumablesEntities.GetContext().OrderedMaterial.Distinct().ToList();
var name = AccountingForConsumablesEntities.GetContext().OrderedMaterial.Select(s => s.MaterialCard.id).Distinct().ToArray();
for (int i = 0; i < name.Count(); i++)
{
int stdasd = name[i];
int tbs = AccountingForConsumablesEntities.GetContext().OrderedMaterial.Where(w => w.FK_MaterialCard == stdasd).Sum(s => s.OrderedQuantity);
OrderedMaterial tasd = name1.Where(s => s.FK_MaterialCard == stdasd).FirstOrDefault();
OrderedMaterial card = new OrderedMaterial()
{
FK_MaterialCard = tasd.FK_MaterialCard, MaterialCard = tasd.MaterialCard, counter = tbs, FK_Order = 1
};
tbd.Add(card);
}
DGridConsumable.ItemsSource = tbd;
}