public PagedResult <Contracts.ProcessCategory.ProcessCategory> Get(PagedQuery pagedQuery)
{
using (var db = new RAAPEntities(GetConnectionString()))
{
var totalItems = db.ProcessCategories.Count();
try
{
return(new PagedResult <Contracts.ProcessCategory.ProcessCategory>()
{
CurrentPage = pagedQuery.Page,
TotalItems = totalItems,
TotalPages = pagedQuery.CalculatePages(totalItems),
Items =
db.ProcessCategories.AsQueryable()
.OrderByDirection(LinqHelper.OrderByDataContract <ProcessCategory>(pagedQuery.OrderByKey),
pagedQuery.IsDescending)
.Skip(pagedQuery.ItemsToSkip)
.Take(pagedQuery.PageSize)
.Select(x => x.ToContract())
.ToArray()
});
}
catch (Exception exception)
{
throw;
}
}
}
public PagedResult <Contracts.Vulnerability.Vulnerability> Get(PagedQuery pagedQuery, int[] excludeIds = null)
{
using (var db = new RAAPEntities(GetConnectionString()))
{
var itemQuery = db.Vulnerabilities.AsQueryable();
if (excludeIds != null && excludeIds.Length > 0)
{
itemQuery = itemQuery.Where(t => !excludeIds.Contains(t.VulnerabilityId));
}
var totalItems = itemQuery.Count();
try
{
return(new PagedResult <Contracts.Vulnerability.Vulnerability>()
{
CurrentPage = pagedQuery.Page,
TotalItems = totalItems,
TotalPages = pagedQuery.CalculatePages(totalItems),
Items =
itemQuery
.OrderByDirection(LinqHelper.OrderByDataContract <Vulnerability>(pagedQuery.OrderByKey),
pagedQuery.IsDescending)
.Skip(pagedQuery.ItemsToSkip)
.Take(pagedQuery.PageSize)
.Select(x => x.ToContract())
.ToArray()
});
}
catch (Exception exception)
{
throw;
}
}
}
public PagedResult <Contracts.Attribute.Attribute> Get(PagedQuery pagedQuery, string attributeTypeId, int[] excludeIds = null)
{
using (var db = new RAAPEntities(GetConnectionString()))
{
var query = db.Attributes.Where(a => a.AttributeTypeId == attributeTypeId);
if (excludeIds != null && excludeIds.Length > 0)
{
query = query.Where(t => !excludeIds.Contains(t.AttributeId));
}
var totalItems = query.Count();
return(new PagedResult <Contracts.Attribute.Attribute>()
{
CurrentPage = pagedQuery.Page,
TotalItems = totalItems,
TotalPages = pagedQuery.CalculatePages(totalItems),
Items =
query
.OrderByDirection(LinqHelper.OrderByDataContract <Database.Attribute>(pagedQuery.OrderByKey),
pagedQuery.IsDescending)
.Skip(pagedQuery.ItemsToSkip)
.Take(pagedQuery.PageSize)
.Select(x => x.ToContract())
.ToArray()
});
}
}
public PagedResult <Contracts.Company.Company> Get(PagedQuery pagedQuery)
{
using (var db = new RAAPMasterEntities())
{
var totalItems = db.Companies.Count();
return(new PagedResult <Contracts.Company.Company>
{
CurrentPage = pagedQuery.Page,
TotalItems = totalItems,
TotalPages = pagedQuery.CalculatePages(totalItems),
Items = db.Companies.AsQueryable()
.OrderByDirection(LinqHelper.OrderByDataContract <Company>(pagedQuery.OrderByKey), pagedQuery.IsDescending)
.Skip(pagedQuery.ItemsToSkip)
.Take(pagedQuery.PageSize)
.Select(x => x.ToContract())
.ToArray()
});
}
}
public Contracts.Common.PagedResult <Contracts.Risk.RiskType> GetRiskTypes(PagedQuery pagedQuery)
{
using (var db = new RAAPEntities(GetConnectionString()))
{
var totalItems = db.RiskTypes.Count();
return(new PagedResult <Contracts.Risk.RiskType>
{
CurrentPage = pagedQuery.Page,
TotalItems = totalItems,
TotalPages = pagedQuery.CalculatePages(totalItems),
Items = db.RiskTypes.AsQueryable()
.OrderByDirection(LinqHelper.OrderByDataContract <RiskType>(pagedQuery.OrderByKey), pagedQuery.IsDescending)
.Skip(pagedQuery.ItemsToSkip)
.Take(pagedQuery.PageSize)
.Select(x => x.ToContract())
.ToArray()
});
}
}
public PagedResult <Contracts.User.User> Get(PagedQuery pagedQuery, int companyId)
{
using (var db = new RAAPMasterEntities())
{
var query = db.Users.Where(u => u.CompanyId == companyId);
var totalItems = query.Count();
return(new PagedResult <Contracts.User.User>
{
CurrentPage = pagedQuery.Page,
TotalItems = totalItems,
TotalPages = pagedQuery.CalculatePages(totalItems),
Items = query.AsQueryable()
.OrderByDirection(LinqHelper.OrderByDataContract <User>(pagedQuery.OrderByKey),
pagedQuery.IsDescending)
.Skip(pagedQuery.ItemsToSkip)
.Take(pagedQuery.PageSize)
.Select(x => x.ToContract(false))
.ToArray()
});
}
}
public PagedResult <Contracts.AttributeCategory.AttributeCategory> Get(PagedQuery pagedQuery, string attributeTypeId)
{
using (var db = new RAAPEntities(GetConnectionString()))
{
var query = db.AttributeCategories.Where(a => a.AttributeTypeId == attributeTypeId);
var totalItems = query.Count();
return(new PagedResult <Contracts.AttributeCategory.AttributeCategory>()
{
CurrentPage = pagedQuery.Page,
TotalItems = totalItems,
TotalPages = pagedQuery.CalculatePages(totalItems),
Items =
query
.OrderByDirection(LinqHelper.OrderByDataContract <AttributeCategory>(pagedQuery.OrderByKey),
pagedQuery.IsDescending)
.Skip(pagedQuery.ItemsToSkip)
.Take(pagedQuery.PageSize)
.Select(x => x.ToContract())
.ToArray()
});
}
}
public PagedResult <Contracts.Attribute.Attribute> GetChilds(PagedQuery pagedQuery, int parentAttributeId)
{
using (var db = new RAAPEntities(GetConnectionString()))
{
var query = db.AttributeLinks.Where(al => al.ParentAttributeId == parentAttributeId).Select(al => al.Attribute);
var totalItems = query.Count();
return(new PagedResult <Contracts.Attribute.Attribute>()
{
CurrentPage = pagedQuery.Page,
TotalItems = totalItems,
TotalPages = pagedQuery.CalculatePages(totalItems),
Items =
query
.OrderByDirection(LinqHelper.OrderByDataContract <Database.Attribute>(pagedQuery.OrderByKey),
pagedQuery.IsDescending)
.Skip(pagedQuery.ItemsToSkip)
.Take(pagedQuery.PageSize)
.Select(x => x.ToContract())
.ToArray()
});
}
}
