public CategoryJsGridResult ListCategory(JsGridFilter filter)
{
filter = filter ?? new JsGridFilter();
filter.categoryIds = filter.categoryIds ?? new List <Guid>();
filter.categoryIds.Where(i => i != null && i != Guid.Empty).ToList();
List <CmsCategory> lst;
using (var db = new MoneyNoteDbContext())
{
var query = db.CmsCategories.AsQueryable();
if (!string.IsNullOrEmpty(filter.title))
{
query = query.Where(i => i.Title.Contains(filter.title));
}
if (filter.findRootItem != null && filter.findRootItem == true)
{
query = query.Where(i => i.ParentId == null || i.ParentId == Guid.Empty);
}
lst = query.Distinct().ToList();
return(new CategoryJsGridResult {
data = lst, itemsCount = lst.Count
});
}
}
public IActionResult SelectAll([FromBody] JsGridFilter filter)
{
return(Json(new JsonResponse <List <CmsCategory> >
{
data = new YoutubeContentRepository().ListCategory(filter).data
}));
}
public IActionResult SelectAll([FromBody] JsGridFilter filter)
{
return(Json(new JsonResponse <ContentJsGridResult>
{
data = new YoutubeContentRepository().ListContent(filter)
}));
}
public JsonResponse <ContentJsGridResult> ListContent(JsGridFilter filter)
{
return(new JsonResponse <ContentJsGridResult>
{
data = new YoutubeContentRepository().ListContent(filter, true)
});
}
public IActionResult SelectAll([FromBody] JsGridFilter filter)
{
filter = filter ?? new JsGridFilter();
filter.categoryIds = filter.categoryIds ?? new List <Guid>();
filter.categoryIds.Where(i => i != null && i != Guid.Empty).ToList();
long itemsCount = 0;
List <User> data = new List <User>();
List <UserAcl.Dto> acls = new List <UserAcl.Dto>();
using (var db = new MoneyNoteDbContext())
{
var query = db.Users.Where(i => i.IsDeleted == 0);
if (!string.IsNullOrEmpty(filter.title))
{
query = query.Where(i => i.Username.Contains(filter.title));
}
if (filter.findRootItem != null && filter.findRootItem == true)
{
query = query.Where(i => i.ParentId == null || i.ParentId == Guid.Empty);
}
if (!string.IsNullOrEmpty(filter.moduleCode))
{
query = query.Join(db.UserAcls, u => u.Id, acl => acl.UserId, (u, acl) => new { u, acl })
.Where(i => i.acl.ModuleCode == filter.moduleCode).Select(i => i.u).Distinct();
}
if (!string.IsNullOrEmpty(filter.permissionCode))
{
query = query.Join(db.UserAcls, u => u.Id, acl => acl.UserId, (u, acl) => new { u, acl })
.Where(i => i.acl.PermissionCode == filter.permissionCode).Select(i => i.u).Distinct();
}
query = query.Distinct().OrderByDescending(i => i.CreatedAt);
itemsCount = query.LongCount();
data = query.Skip((filter.pageIndex - 1) * filter.pageSize).Take(filter.pageSize).ToList();
var userIds = data.Select(i => i.Id).Distinct().ToList();
acls = db.UserAcls.Where(i => userIds.Contains(i.UserId))
.Select(i => new UserAcl.Dto
{
UserId = i.UserId,
ModuleCode = i.ModuleCode,
PermissionCode = i.PermissionCode
})
.Distinct().ToList();
return(Json(new JsonResponse <UserJsGridResult>
{
data = new UserJsGridResult
{
data = data,
itemsCount = itemsCount,
ListUserAcl = acls
}
}));
}
}
public JsonResponse <CategoryJsGridResult> ListCategory(JsGridFilter filter)
{
filter = filter ?? new JsGridFilter();
filter.categoryIds = filter.categoryIds ?? new List <Guid>();
filter.categoryIds.Where(i => i != null && i != Guid.Empty).ToList();
return(new JsonResponse <CategoryJsGridResult>
{
data = new YoutubeContentRepository().ListCategory(filter)
});
}
public ContentJsGridResult ListContent(JsGridFilter filter, bool onlyPublished = false)
{
filter = filter ?? new JsGridFilter();
filter.categoryIds = filter.categoryIds ?? new List <Guid>();
filter.categoryIds.Where(i => i != null && i != Guid.Empty).ToList();
long itemsCount = 0;
List <CmsContent> data = new List <CmsContent>();
//List<CmsCategory> listCategory = new List<CmsCategory>();
List <CmsRelation.Dto> listRelation = new List <CmsRelation.Dto>();
if (string.IsNullOrEmpty(filter.SortType) == false && filter.SortType.IndexOf("random") >= 0)
{
filter.SortType = _rnd.Next(1, 1000000) % 2 == 0 ? "oldest" : "newest";
}
using (var db = new MoneyNoteDbContext())
{
var query = db.CmsContents.AsQueryable();
if (onlyPublished)
{
query = query.Where(i => i.IsPublished == 1);
}
if (string.IsNullOrEmpty(filter.Type) == false && filter.Type.IndexOf("image") >= 0)
{
query = query.Where(i => i.UrlRef == string.Empty || i.UrlRef == null);
}
if (string.IsNullOrEmpty(filter.Type) == false && filter.Type.IndexOf("video") >= 0)
{
query = query.Where(i => i.UrlRef != string.Empty && i.UrlRef != null);
}
if (!string.IsNullOrEmpty(filter.title))
{
query = query.Where(i => i.Title.Contains(filter.title));
}
if (!string.IsNullOrEmpty(filter.description))
{
query = query.Where(i => i.Description.Contains(filter.description));
}
if (!string.IsNullOrEmpty(filter.urlRef))
{
query = query.Where(i => i.UrlRef.Contains(filter.urlRef));
}
if (filter.findRootItem != null && filter.findRootItem == true)
{
//query = query.Where(i => i.ParentId == null || i.ParentId == Guid.Empty);
var idsContentRelations = db.CmsRelations.Select(i => i.ContentId).Distinct().ToList();
query = query.Where(i => idsContentRelations.Contains(i.Id) == false);
}
else
{
if (filter.categoryIds != null && filter.categoryIds.Count > 0)
{
query = query.Join(db.CmsRelations, c => c.Id, r => r.ContentId, (c, r) => new { c, r })
.Where(m => filter.categoryIds.Contains(m.r.CategoryId))
.Select(m => m.c);
}
}
if (filter.contentId != null && filter.contentId.Value != Guid.Empty)
{
var id = filter.contentId.Value;
query = query.Where(i => i.Id == id);
}
query = query.Distinct().OrderByDescending(i => i.CreatedAt);
itemsCount = query.LongCount();
if (filter.pageSize > 0)
{
int skip = (filter.pageIndex - 1) * filter.pageSize;
skip = skip < 0 ? 0 : skip;
query = query.Skip(skip).Take(filter.pageSize);
}
if (string.IsNullOrEmpty(filter.SortType) == false && filter.SortType.IndexOf("oldest") >= 0)
{
query = query.OrderBy(i => i.CreatedAt);
}
else
{
query = query.OrderByDescending(i => i.CreatedAt);
}
data = query.ToList();
//listCategory = db.CmsCategories.Where(i => i.IsDeleted == 0).ToList();
var contentIds = data.Select(i => i.Id).ToList();
if (contentIds.Count > 0)
{
listRelation = db.CmsRelations.Where(i => contentIds.Contains(i.ContentId))
.Select(i => new CmsRelation.Dto {
CategoryId = i.CategoryId, ContentId = i.ContentId
})
.Distinct().ToList();
}
//cbeadc96-a21a-4ab8-a69b-8a56c893ffce
}
data = data.Select((i) =>
{
return((i.ThumbnailWidth == 0 || i.ThumbnailHeight == 0) ? i.CalculateThumbnail() : i);
}).ToList();
return(new ContentJsGridResult
{
data = data,
itemsCount = itemsCount,
listRelation = listRelation,
//listCategory = listCategory
});
}