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();
}
