/// <summary>
/// Get Marketing Channels
/// </summary>
public MarketingChannelSearchRequestResponse Get([FromUri] MarketingChannelSearchRequest request)
{
if (request == null || !ModelState.IsValid)
{
throw new HttpException((int)HttpStatusCode.BadRequest, "Invalid Request");
}
return(marketingChannelService.SearchMarketingChannel(request).CreateFromm());
}
/// <summary>
/// Search Marketing Channel
/// </summary>
public MarketingChannelSearchRequestResponse SearchMarketingChannel(MarketingChannelSearchRequest request)
{
int rowCount;
return(new MarketingChannelSearchRequestResponse
{
MarketingChannels = marketingChannelRepository.SearchMarketingChannel(request, out rowCount),
TotalCount = rowCount
});
}
/// <summary>
/// Search Marketing Channel
/// </summary>
public IEnumerable <MarketingChannel> SearchMarketingChannel(MarketingChannelSearchRequest request, out int rowCount)
{
int fromRow = (request.PageNo - 1) * request.PageSize;
int toRow = request.PageSize;
Expression <Func <MarketingChannel, bool> > query =
marketingChannel =>
(string.IsNullOrEmpty(request.MarketingChannelFilterText) ||
(marketingChannel.MarketingChannelCode.Contains(request.MarketingChannelFilterText)) ||
(marketingChannel.MarketingChannelName.Contains(request.MarketingChannelFilterText)));
rowCount = DbSet.Count(query);
return(request.IsAsc
? DbSet.Where(query)
.OrderBy(marketingChannelOrderByClause[request.MarketingChannelOrderBy])
.Skip(fromRow)
.Take(toRow)
.ToList()
: DbSet.Where(query)
.OrderByDescending(marketingChannelOrderByClause[request.MarketingChannelOrderBy])
.Skip(fromRow)
.Take(toRow)
.ToList());
}
