public List <Models.PrintShipments> GetShipmentsMonth(DateTime date) { PlanShipments.Clear(); date = date.Date; try { using (DB.RegistrantCoreContext ef = new DB.RegistrantCoreContext()) { var temp = ef.Shipments.Where(x => x.IdTimeNavigation.DateTimePlanRegist.Value.Month == date.Month || x.IdTimeNavigation.DateTimeFactRegist.Value.Month == date.Month).OrderBy(x => x.IdTimeNavigation.DateTimePlanRegist); //var temp = ef.Shipments.Where(x => x.IdTimeNavigation.DateTimePlanRegist.Value.Month == date.Month); //var temp = ef.Shipments.Where(x => x.IdTimeNavigation.DateTimePlanRegist.Value.Month == date.Month && x.IdTimeNavigation.DateTimeFactRegist.Value.Month == date.Month); foreach (var item in temp) { Models.PrintShipments shipment = new Models.PrintShipments(item); PlanShipments.Add(shipment); } } } catch (Exception ex) { ((MainWindow)System.Windows.Application.Current.MainWindow).ContentErrorText.ShowAsync(); ((MainWindow)System.Windows.Application.Current.MainWindow).text_debuger.Text = ex.ToString(); } return(PlanShipments); }
//Получит список для печати СКЛАД public List <Models.PrintShipments> GetShipmentsDateSklad(DateTime date) { PlanShipments.Clear(); date = date.Date; try { using (DB.RegistrantCoreContext ef = new DB.RegistrantCoreContext()) { //var temp = ef.Shipments.Where(x => x.IdTimeNavigation.DateTimePlanRegist.Value.Date == date); на это выбивает null //var temp = ef.Shipments.Where(x => x.IdTimeNavigation.DateTimePlanRegist.HasValue ? x.IdTimeNavigation.DateTimePlanRegist.Value.Date == date : false || x.IdTimeNavigation.DateTimeFactRegist.HasValue ? x.IdTimeNavigation.DateTimeFactRegist.Value.Date == date : false); //var temp = ef.Shipments.Where(x => ((x.IdTimeNavigation.DateTimePlanRegist.Value.Date == date || x.IdTimeNavigation.DateTimeFactRegist.Value.Date == date) && x.Active != "0")).OrderBy(x => x.IdTimeNavigation.DateTimePlanRegist); var temp = ef.Shipments.Where(x => x.IdTimeNavigation.DateTimePlanRegist.Value.Date == date || x.IdTimeNavigation.DateTimeFactRegist.Value.Date == date).OrderBy(x => x.IdTimeNavigation.DateTimePlanRegist).OrderBy(x => x.IdTimeNavigation.DateTimeFactRegist); foreach (var item in temp) { Models.PrintShipments shipment = new Models.PrintShipments(item); PlanShipments.Add(shipment); } } } catch (Exception ex) { ((MainWindow)System.Windows.Application.Current.MainWindow).ContentErrorText.ShowAsync(); ((MainWindow)System.Windows.Application.Current.MainWindow).text_debuger.Text = ex.ToString(); } return(PlanShipments); }