public static IEnumerable<Story> GetMyStories(this IRepositoryAsync<Story> repository, JqxGridSentData jqxGridSentData, string userId = null)
{
MyStoryQuery sq = new MyStoryQuery();
if (!string.IsNullOrWhiteSpace(userId))
sq.UserStories(userId);
if (!string.IsNullOrWhiteSpace(jqxGridSentData.searchKey))
sq.SearchByTitle(jqxGridSentData.searchKeyLower);
int t;
var result = repository.Query(sq).OrderByField(jqxGridSentData.sortorder,jqxGridSentData.sortdatafield)
.SelectPage(jqxGridSentData.pagenum + 1, jqxGridSentData.pagesize, out t).Select(x => new Story(){Id = x.Id, Title = x.Title, Description = x.Description, PostedOn = x.PostedOn, UserId = x.UserId }).AsEnumerable();
jqxGridSentData.totalrows = t;
return result;
}
public static IEnumerable<Story> FilterStoriesByUser(this IRepositoryAsync<Story> repository, string userId)
{
MyStoryQuery sq = new MyStoryQuery();
return repository.Query(sq.UserStories(userId)).Select().AsEnumerable();
}
public static IEnumerable<Story> FilterStoriesByPostedOn(this IRepositoryAsync<Story> repository, DateTime postedOn)
{
MyStoryQuery sq = new MyStoryQuery();
sq.PostedOn(postedOn);
return repository.Query(sq).Select().AsEnumerable();
}
