public ActionResult GetListGenre(IDataTablesRequest dataTableParam, ResourceGenreSearchViewModel searchViewModel)
{
return Json(ResourceBusiness.GetListGenre(dataTableParam, searchViewModel));
}
public DataTablesResponse GetListGenre(IDataTablesRequest dataTableParam, ResourceGenreSearchViewModel searchViewModel)
{
try
{
var query = ResourceRepository.GetAll(x => x.IsDeleted == false && x.Type == (int) ResourceType.Genre, null, x => x.Genres);
if (searchViewModel.GenreId > 0)
{
query = query.Where(x => x.Genres.Any(g => g.IsDeleted == false && g.Id == searchViewModel.GenreId));
}
var dataTableHelper = new DataTableHelper<ResourceGenreViewModel, Resource>(query, x => new ResourceGenreViewModel
{
Id = x.Id,
Url = x.Url,
Tag = x.Tag,
Genre = x.Genres.AsQueryable().Any(y => y.IsDeleted == false) ? x.Genres.AsQueryable().FirstOrDefault().Title : ""
});
var entities = dataTableHelper.GetDataVMForResponse(dataTableParam);
var result = dataTableHelper.GetDataToList(dataTableParam, entities);
return new DataTablesResponse(dataTableParam.Draw, result, entities.Count(), entities.Count());
}
catch (Exception ex)
{
Provider.Instance.LogError(ex);
return new DataTablesResponse(dataTableParam.Draw, new List<ResourceGenreViewModel>(), 0, 0);
}
}