public static IEnumerable <CustomerWallItem> GetCustomerRecentActivity(GetCustomerRecentActivityRequest request)
{
List <CustomerWallItem> wallItems;
using (var context = ExigoDAL.Sql())
{
wallItems = context.Query <CustomerWallItem>(@"
SELECT CustomerWallItemID
,CustomerID
,EntryDate
,Text
,Field1
,Field2
,Field3
FROM CustomerWall
WHERE CustomerID = @CustomerID
ORDER BY EntryDate DESC
", new
{
CustomerID = request.CustomerID
}).ToList();
}
if (request.StartDate != null)
{
wallItems = wallItems.Where(c => c.EntryDate >= request.StartDate).ToList();
}
return(wallItems);
}
public static IEnumerable<CustomerWallItem> GetCustomerRecentActivity(GetCustomerRecentActivityRequest request)
{
var query = Exigo.OData().CustomerWall
.Where(c => c.CustomerID == request.CustomerID);
if (request.StartDate != null)
{
query = query.Where(c => c.EntryDate >= request.StartDate);
}
var items = query
.OrderByDescending(c => c.EntryDate)
.Select(c => c)
.Skip(request.Skip)
.Take(request.Take);
foreach (var item in items)
{
var wallItem = (CustomerWallItem)item;
yield return wallItem;
}
}
public static IEnumerable <CustomerWallItem> GetCustomerRecentActivity(GetCustomerRecentActivityRequest request)
{
var query = Exigo.OData().CustomerWall
.Where(c => c.CustomerID == request.CustomerID);
if (request.StartDate != null)
{
query = query.Where(c => c.EntryDate >= request.StartDate);
}
var items = query
.OrderByDescending(c => c.EntryDate)
.Select(c => c)
.Skip(request.Skip)
.Take(request.Take);
foreach (var item in items)
{
var wallItem = (CustomerWallItem)item;
yield return(wallItem);
}
}
