public Index(int page = 1, int perpage = int.MaxValue, Guid?parentDocumentId = null, string titlePart = null, bool?isRoot = null) { var db = new Models.Domains.MySQL.Entities.DMsDbContext(); var query = db.Documents.AsQueryable(); query = query.Where(c => c.IsBook && c.IsAbstract && !c.IsMain); if (parentDocumentId.HasValue) { query = query.Where(c => c.ParentDocumentId == parentDocumentId); } if (!string.IsNullOrWhiteSpace(titlePart)) { titlePart = titlePart.Trim(); query = query.Where(c => c.Title.Contains(titlePart)); } if (isRoot.HasValue) { if (isRoot.Value) { query = query.Where(c => c.ParentDocumentId == null); } else { query = query.Where(c => c.ParentDocumentId != null); } } this.Count = query.Count(); var queryOrdered = query.OrderBy(c => c.Priority).ThenBy(c => c.DocumentId); var queryCurrentPage = queryOrdered.Skip((page - 1) * perpage).Take(perpage); this.List = queryCurrentPage.ToList().Select(c => new Details(c)).ToList(); }
public Index(int page = 1, int perpage = int.MaxValue) { var db = new Models.Domains.MySQL.Entities.DMsDbContext(); var query = db.AdditionCategories.AsQueryable(); var queryOrdered = query.OrderBy(c => c.Name); var queryCurrentPage = queryOrdered.Skip((page - 1) * perpage).Take(perpage); this.List = queryCurrentPage.ToList().Select(c => new Details(c)).ToList(); }
public Index(int page = 1, int perpage = int.MaxValue, Guid?documentId = null) { var db = new Models.Domains.MySQL.Entities.DMsDbContext(); var query = db.Additions.AsQueryable(); if (documentId.HasValue) { query = query.Where(c => c.DocumentId == documentId); } var queryOrdered = query.OrderBy(c => c.AdditionCategory.Name).ThenBy(c => c.Description).ThenBy(c => c.AdditionId); var queryCurrentPage = queryOrdered.Skip((page - 1) * perpage).Take(perpage); this.List = queryCurrentPage.ToList().Select(c => new Details(c)).ToList(); }
public Index(int page = 1, int perpage = int.MaxValue, Guid?parentDocumentId = null) { var db = new Models.Domains.MySQL.Entities.DMsDbContext(); var query = db.Documents.AsQueryable(); query = query.Where(c => c.IsBook && !c.IsMain && !c.IsAbstract); if (parentDocumentId.HasValue) { query = query.Where(c => c.ParentDocumentId == parentDocumentId); } this.Count = query.Count(); var queryOrdered = query.OrderBy(c => c.Priority).ThenBy(c => c.DocumentId); var queryCurrentPage = queryOrdered.Skip((page - 1) * perpage).Take(perpage); this.List = queryCurrentPage.ToList().Select(c => new Details(c)).ToList(); }