public List <UserContract> Get(string userName, ExpressionCriteriaBase[] criteria = null, string[] properties = null)
{
Expression <Func <V_USER_ROLE_DEPT, bool> > condition = ExpressionUtils.BuildCondition <V_USER_ROLE_DEPT>(criteria);
if (properties != null && properties.Length > 0)
{
Expression <Func <V_USER_ROLE_DEPT, UserContract> > selector =
QueryableBuilderExtensions.BuildSelectorClause <V_USER_ROLE_DEPT, UserContract>(properties);
return(_userRoleDepartmentViewRepository.Get(selector, condition).Where(p => p.CreatedBy == userName).ToList());
}
return(_userRoleDepartmentViewRepository.GetAll(condition, p => p.USER_INFO_ID).Where(p => p.USER_INFO_CREATEDBY == userName).ToList().ConvertAll(p => p.ToUserContract()));
}
public List <DepartmentContract> Get(string createdBy, ExpressionCriteriaBase[] criteria = null, string[] properties = null)
{
Expression <Func <V_DEPT_DEPT, bool> > condition = ExpressionUtils.BuildCondition <V_DEPT_DEPT>(criteria);
if (properties != null && properties.Length > 0)
{
Expression <Func <V_DEPT_DEPT, DepartmentContract> > selector =
QueryableBuilderExtensions.BuildSelectorClause <V_DEPT_DEPT, DepartmentContract>(properties);
return(_depDepAuthorizeRepository.GetByUser(createdBy, selector, condition).ToList());
}
return(_depDepAuthorizeRepository.GetByUser(createdBy, condition, p => p.DEPT_INFO_CREATEDDATE).ConvertAll(p => p.ToContract()));
}
public List <AreaContract> Get(ExpressionCriteriaBase[] criteria = null, string[] properties = null)
{
Expression <Func <BASE_GEO_INFO, bool> > condition = ExpressionUtils.BuildCondition <BASE_GEO_INFO>(criteria);
if (properties != null && properties.Length > 0)
{
Expression <Func <BASE_GEO_INFO, AreaContract> > selector =
QueryableBuilderExtensions.BuildSelectorClause <BASE_GEO_INFO, AreaContract>(properties);
return(_areaRepository.Get(selector, condition));
}
return(_areaRepository.GetAll(condition, p => p.GEO_INFO_ORDER).ConvertAll(p => p.ToContract()));
}
public List <RoleContract> GetByUser(string createBy, ExpressionCriteriaBase[] criteria = null, string[] properties = null)
{
Expression <Func <BASE_ROLE_INFO, bool> > condition = ExpressionUtils.BuildCondition <BASE_ROLE_INFO>(criteria);
if (properties != null && properties.Length > 0)
{
Expression <Func <BASE_ROLE_INFO, RoleContract> > selector =
QueryableBuilderExtensions.BuildSelectorClause <BASE_ROLE_INFO, RoleContract>(properties);
return(_roleAuthorizeRepository.GetByUser(createBy, selector, condition));
}
return(_roleAuthorizeRepository.GetByUser(createBy, condition, p => p.ROLE_INFO_CREATEDDATE).ConvertAll(p => p.ToContract()));
}
public PaginationList <UserContract> Get(ExpressionCriteriaBase[] criteria, int page, int pageSize, string sort, string orderBy = "desc")
{
Expression <Func <V_USER_ROLE_DEPT, bool> > condition = ExpressionUtils.BuildCondition <V_USER_ROLE_DEPT>(criteria);
var sortMap = QueryableBuilderExtensions.GetMappingPropertyName <UserContract, V_USER_ROLE_DEPT>(sort);
var pager = _userRoleDepartmentViewRepository.GetPager(condition, sortMap ?? "USER_INFO_CREATEDDATE", orderBy ?? "desc", Math.Max(page - 1, 0) * pageSize, pageSize);
return(new PaginationList <UserContract>(pager.Items.ConvertAll(p => p.ToUserContract()))
{
TotalCount = pager.TotalCount,
PageSize = pageSize
});
}
public PaginationList <AreaContract> Get(ExpressionCriteriaBase[] criteria, int page, int pageSize, string sort,
string orderBy = "desc")
{
Expression <Func <BASE_GEO_INFO, bool> > condition = ExpressionUtils.BuildCondition <BASE_GEO_INFO>(criteria);
var sortMap = QueryableBuilderExtensions.GetMappingPropertyName <AreaContract, BASE_GEO_INFO>(sort);
var pager = _areaRepository.GetPager(condition, sortMap ?? "GEO_INFO_ORDER", orderBy ?? "desc",
Math.Max(page - 1, 0) * pageSize, pageSize);
return(new PaginationList <AreaContract>(pager.Items.ConvertAll(p => p.ToContract()))
{
TotalCount = pager.TotalCount,
PageSize = pageSize
});
}
public PaginationList <DepartmentContract> Get(string createdBy, ExpressionCriteriaBase[] criteria, string[] properties, int page, int pageSize,
string sort, string orderBy = "desc")
{
Expression <Func <V_DEPT_DEPT, bool> > condition = ExpressionUtils.BuildCondition <V_DEPT_DEPT>(criteria);
var sortMap = QueryableBuilderExtensions.GetMappingPropertyName <DepartmentContract, V_DEPT_DEPT>(sort);
if (properties != null && properties.Length > 0)
{
Expression <Func <V_DEPT_DEPT, DepartmentContract> > selector =
QueryableBuilderExtensions.BuildSelectorClause <V_DEPT_DEPT, DepartmentContract>(properties);
return(_depDepAuthorizeRepository.GetPagerByUser(createdBy, selector, condition, sortMap ?? "DEPT_INFO_CREATEDDATE", orderBy ?? "desc",
Math.Max(page - 1, 0) * pageSize, pageSize));
}
var pager = _depDepAuthorizeRepository.GetPagerByUser(createdBy, condition, sortMap ?? "DEPT_INFO_CREATEDDATE", orderBy ?? "desc", Math.Max(page - 1, 0) * pageSize, pageSize);
return(new PaginationList <DepartmentContract>(pager.Items.ConvertAll(p => p.ToContract()))
{
TotalCount = pager.TotalCount,
PageSize = pageSize
});
}
public int Count(string createdBy, ExpressionCriteriaBase[] criteria)
{
Expression <Func <V_DEPT_DEPT, bool> > condition = ExpressionUtils.BuildCondition <V_DEPT_DEPT>(criteria);
return(_depDepAuthorizeRepository.CountByUser(createdBy, condition));
}
public int Count(ExpressionCriteriaBase[] criteria)
{
Expression <Func <BASE_DEPARTMENT_INFO, bool> > condition = ExpressionUtils.BuildCondition <BASE_DEPARTMENT_INFO>(criteria);
return(_departmentRepository.Count(condition));
}
public int Count(ExpressionCriteriaBase[] criteria)
{
Expression <Func <BASE_GEO_INFO, bool> > condition = ExpressionUtils.BuildCondition <BASE_GEO_INFO>(criteria);
return(_areaRepository.Count(condition));
}
public int Count(string userName, ExpressionCriteriaBase[] criteria)
{
Expression <Func <V_USER_ROLE_DEPT, bool> > condition = ExpressionUtils.BuildCondition <V_USER_ROLE_DEPT>(criteria);
return(_userRoleDepartmentViewAuthorizeRepository.CountByUser(userName, condition));
}
public int Count(ExpressionCriteriaBase[] criteria)
{
Expression <Func <V_USER_ROLE_DEPT, bool> > condition = ExpressionUtils.BuildCondition <V_USER_ROLE_DEPT>(criteria);
return(_userRoleDepartmentViewRepository.Count(condition));
}
