public ActionResult getOrderTable(OrderViewSearchModel searchModel)
{
OrderTableViewModel table = new OrderTableViewModel()
{
OrderTable = orderBL.GetOrderData(searchModel)
};
return(View("_IndexOrderTable", table));
}
public IQueryable <OrderIndexViewModel> GetOrderData(OrderViewSearchModel searchModel)
{
IQueryable <Order> table = AdapterFJRepository.OrderRepository.GetAll();
if (searchModel.OrderId != null)
{
table = table.Where(p => p.OrderId.Equals(searchModel.OrderId));
}
if (string.IsNullOrEmpty(searchModel.CustomerName))
{
table = table.Where(p => p.CustomerName.Contains(searchModel.CustomerName));
}
if (searchModel.WineryId != 0)
{
table = table.Where(p => p.WineryId.Equals(searchModel.WineryId));
}
if (searchModel.ProductId != 0)
{
table = from n in table
where n.Order_Detail == AdapterFJRepository.Order_DetailRepository.GetAll(p => p.ProductId == searchModel.ProductId)
select n;
}
if (searchModel.OrderDate != null)
{
DateTime NextDate = searchModel.OrderDate.Value.AddDays(1);
table = table.Where(p => p.OrderDate >= searchModel.OrderDate && p.OrderDate < NextDate);
}
if (searchModel.RequiredDate != null)
{
DateTime NextDate = searchModel.RequiredDate.Value.AddDays(1);
table = table.Where(p => p.RequiredDate >= searchModel.RequiredDate && p.RequiredDate < NextDate);
}
if (searchModel.ShippedDate != null)
{
DateTime NextDate = searchModel.ShippedDate.Value.AddDays(1);
table = table.Where(p => p.ShippedDate >= searchModel.ShippedDate && p.ShippedDate < NextDate);
}
var Otable = table.Select(p => new OrderIndexViewModel
{
OrderId = p.OrderId.ToString(),
CustomerName = p.CustomerName,
Winery = p.Winery.WineryName,
OrderDate = p.OrderDate.ToString(),
RequiredDate = p.RequiredDate.ToString(),
ShippedDate = p.ShippedDate.ToString()
});
return(Otable.OrderByDescending(p => p.OrderDate));
}
