public void Application_Start(object sender, StartupEventArgs args) { Context = new movement_of_goodsEntities(); LoginScreen ls = new LoginScreen(); ls.Show(); }
private void Button_Click_Search(object sender, RoutedEventArgs e) { string searchByIdOfOrder = код_заказаTextBox.Text; string searchByIdOfshipment = код_поставкиTextBox.Text; string searchByIdOfShipper = код_поставщикаTextBox.Text; string searchByNameOfShipper = наименование_поставщикаTextBox.Text; string searchByIdOfProduct = код_товараTextBox.Text; string searchByNameOfProduct = наименование_товараTextBox.Text; string searchByDeliveryDate = дата_поступленияDatePicker.Text; string searchByDateOfShipment = дата_выбытияDatePicker.Text; var warehousePosition = from warehousePositions in App.Context.склад select warehousePositions; warehousePosition = warehousePosition.Where(wh => wh.код_заказа.Contains(searchByIdOfOrder)); warehousePosition = warehousePosition.Where(wh => wh.код_поставки.Contains(searchByIdOfshipment)); warehousePosition = warehousePosition.Where(wh => wh.код_поставщика.Contains(searchByIdOfShipper)); warehousePosition = warehousePosition.Where(wh => wh.наименование_поставщика.Contains(searchByNameOfShipper)); warehousePosition = warehousePosition.Where(wh => wh.код_товара.Contains(searchByIdOfProduct)); warehousePosition = warehousePosition.Where(wh => wh.наименование_товара.Contains(searchByNameOfProduct)); WarehouseWindow.warehViewSource.Source = warehousePosition.ToList(); if (дата_поступленияDatePicker.Text.Length > 0) { using (var db = new movement_of_goodsEntities()) { var tempSearchByDeliveryDate = DateTime.Parse(searchByDeliveryDate); var filteredData = db.склад.Where(t => t.дата_поступления == tempSearchByDeliveryDate); WarehouseWindow.warehViewSource.Source = filteredData.ToList(); } } if (дата_выбытияDatePicker.Text.Length > 0) { using (var db = new movement_of_goodsEntities()) { var tempSearchByDateOfShipment = DateTime.Parse(searchByDateOfShipment); var filteredData = db.склад.Where(t => t.дата_выбытия == tempSearchByDateOfShipment); WarehouseWindow.warehViewSource.Source = filteredData.ToList(); } } }
private void Button_Click_Search(object sender, RoutedEventArgs e) { string searchByIdOfTTN = ттнTextBox.Text; string searchByIdOfOrder = код_заказаTextBox.Text; string searchByIdOfCounterparty = код_контрагентаTextBox.Text; string searchByNameOfCounterparty = наименование_контрагентаTextBox.Text; string searchByIdOfShipper = код_поставщикаTextBox.Text; string searchByNameOfShipper = наименование_поставщикаTextBox.Text; string searchByIdOfProduct = код_товараTextBox.Text; string searchByNameOfProduct = наименование_товараTextBox.Text; string searchByDeliveryDate = дата_заказаDatePicker.Text; var order = from orders in App.Context.заказы select orders; order = order.Where(ord => ord.ттн.Contains(searchByIdOfTTN)); order = order.Where(ord => ord.код_заказа.Contains(searchByIdOfOrder)); order = order.Where(ord => ord.код_контрагента.Contains(searchByIdOfCounterparty)); order = order.Where(ord => ord.наименование_контрагента.Contains(searchByNameOfCounterparty)); order = order.Where(ord => ord.код_поставщика.Contains(searchByIdOfShipper)); order = order.Where(ord => ord.наименование_поставщика.Contains(searchByNameOfShipper)); order = order.Where(ord => ord.код_товара.Contains(searchByIdOfProduct)); order = order.Where(ord => ord.наименование_товара.Contains(searchByNameOfProduct)); OrdersWIndow.ordViewSource.Source = order.ToList(); if (дата_заказаDatePicker.Text.Length > 0) { using (var db = new movement_of_goodsEntities()) { var tempSearchByDeliveryDate = DateTime.Parse(searchByDeliveryDate); var filteredData = db.заказы.Where(t => t.дата_заказа == tempSearchByDeliveryDate); OrdersWIndow.ordViewSource.Source = filteredData.ToList(); } } }