//Выбор заказов из базы для админа public IQueryable <Order> GetOrdersFromBase(FilterParametersForOrders parameters) { IQueryable <Order> orders = null; if (parameters.PhoneNumber != null) { orders = Context.Orders.Where(order => order.OrderDate >= parameters.From && order.OrderDate <= parameters.To && order.Phone == parameters.PhoneNumber); } else if (parameters.NewPostRef != null) { orders = Context.Orders.Where(order => order.OrderDate >= parameters.From && order.OrderDate <= parameters.To && order.NewPostRef == parameters.NewPostRef); } else if (parameters.PhoneNumber != null && parameters.NewPostRef != null) { orders = Context.Orders.Where(order => order.OrderDate >= parameters.From && order.OrderDate <= parameters.To && order.Phone == parameters.PhoneNumber && order.NewPostRef == parameters.NewPostRef); } else { orders = (from o in Context.Orders where (o.OrderDate >= parameters.From) select o); } return(orders); }
public ActionResult GetOrdersFromBase(FilterParametersForOrdersView obj) { if (obj.To == DateTime.MinValue) { obj.To = DateTime.Now.AddDays(1); //string DateString = obj.To.ToString(); //obj.To = DateTime.ParseExact(DateString,"ddmmyyyy",CultureInfo.InvariantCulture); //obj.To.ToString("yyyy/mm/dd"); } FilterParametersForOrders parameters = Mapper.Map <FilterParametersForOrders>(obj); IQueryable <Order> orders = orderrepo.GetOrdersFromBase(parameters); return(View("GetOrdersFromBase(ReturnResult)", orders)); }