//Выбор заказов из базы для админа
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));
}
