public PubOrdersViewModel GetPubOrders(int?UserID, int PageNumber)
{
SqlParameter @outputParam = new SqlParameter {
ParameterName = "@outputParam", SqlDbType = SqlDbType.Int, Direction = ParameterDirection.Output
};
var results = GetPubOrderResults.FromSqlRaw("EXEC @outputParam=Get_PubOrders @UserID, @PageNumber, @ItemsPerPage",
outputParam,
new SqlParameter("@UserID", UserID ?? 0),
new SqlParameter("@PageNumber", PageNumber),
new SqlParameter("@ItemsPerPage", GlobalConstants.OrdersPerPage)).ToList();
if (results.Count() > 0)
{
List <UserOrderViewModel> userOrderViewModel = new List <UserOrderViewModel>();
foreach (Get_PubOrderViewModel order in results)
{
List <Get_PubUserOrderItemsViewModel> items = GetPubUserOrderItems(order.OrderId);
userOrderViewModel.Add(new UserOrderViewModel()
{
OrderDetails = order, OrderTopItems = items
});
}
return(new PubOrdersViewModel()
{
Orders = userOrderViewModel, RowCount = (int)outputParam.Value
});
}
else
{
return(null); //no results returned - order dosen't exist in DB so give nothing.
}
}
public Get_PubOrderViewModel GetPubOrder(int OrderID)
{
var results = GetPubOrderResults.FromSqlRaw("EXEC Get_PubOrder @OrderID",
new SqlParameter("@OrderID", OrderID)).ToList();
if (results.Count() > 0)
{
return(results.First());
}
else
{
return(null); //no results returned - order dosen't exist in DB so give nothing.
}
}