public static List <CashOrderViewModel> GetOrders(string searchCriteria)
{
List <CashOrderViewModel> model = new List <CashOrderViewModel>();
if (string.IsNullOrEmpty(searchCriteria))
{
return(model);
}
using (FreeMarketEntities db = new FreeMarketEntities())
{
List <FilterCashOrder_Result> orders = db.FilterCashOrder(searchCriteria).ToList();
if (orders == null)
{
return(model);
}
foreach (FilterCashOrder_Result result in orders)
{
CashOrderViewModel viewModel = new CashOrderViewModel();
viewModel.Order = new CashOrder
{
CashCustomerId = (int)result.CashCustomerId,
OrderId = (int)result.OrderId,
Total = (int)result.Total,
CustomerDeliveryAddress = result.DeliveryAddress,
CustomerEmail = result.Email,
CustomerName = result.Name,
CustomerPhone = result.PhoneNumber,
DatePlaced = result.DatePlaced
};
viewModel.OrderDetails = db.GetCashOrderDetails(viewModel.Order.OrderId)
.Select(c => new CashOrderDetail
{
CashOrderId = c.CashOrderId,
CashOrderItemId = c.CashOrderItemId,
CustodianNumber = c.CustodianNumber,
Price = c.Price,
ProductNumber = c.ProductNumber,
Quantity = c.Quantity,
SupplierNumber = c.SupplierNumber,
Description = c.Description,
SupplierName = c.SupplierName,
Weight = (int)c.Weight,
OrderItemTotal = c.OrderItemTotal
})
.ToList();
model.Add(viewModel);
}
}
return(model);
}