public int getTotalRecords(UserGroupCriteria conditions)
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
return(UserGroupDataLayer.GetInstance().GetTotalRecords(connection, conditions));
}
}
public List <UserGroupInfo> GetList(UserGroupCriteria conditions)
{
SqlConnectionFactory sqlConnection = new SqlConnectionFactory();
using (SqlConnection connection = sqlConnection.GetConnection())
{
List <UserGroupInfo> ListUserInfo = UserGroupDataLayer.GetInstance().Getlist(connection, conditions);
return(ListUserInfo);
}
}
public SearchResult <UserGroupModel> SearchUserGroup(UserGroupCriteria criteria)
{
var result = new SearchResult <UserGroupModel>();
var query = userGroupRepository.GetAll().Where(FilterUserGroup(criteria));
result.ItemCount = query.Count();
query = query.Sort(criteria.Sorting, new Sorting("Name", SortDirection.Ascending));
query = query.Page(criteria.Paging);
result.ResultData = query.Select(userGroupToModel).ToList();
return(result);
}
private Expression <Func <UserGroup, bool> > FilterUserGroup(UserGroupCriteria criteria)
{
Expression <Func <UserGroup, bool> > result = t => true;
if (!string.IsNullOrWhiteSpace(criteria.Keyword))
{
result = result.And(t => EF.Functions.Like(t.Code, $"%{criteria.Keyword}%") ||
EF.Functions.Like(t.Name, $"%{criteria.Keyword}%") ||
EF.Functions.Like(t.Description, $"%{criteria.Keyword}%"));
}
if (criteria.IsActive.HasValue)
{
result = result.And(t => t.IsActive == criteria.IsActive);
}
return(result);
}
public ListResponeMessage <UserGroupInfo> GetList([FromQuery] UserGroupCriteria criteria)
{
ListResponeMessage <UserGroupInfo> ret = new ListResponeMessage <UserGroupInfo>();
try
{
ret.isSuccess = true;
ret.data = UserGroupService.GetInstance().GetList(criteria);
ret.totalRecords = UserGroupService.GetInstance().getTotalRecords(criteria);
}
catch (Exception ex)
{
ret.isSuccess = false;
ret.err.msgCode = "005";
ret.err.msgString = ex.ToString();
}
return(ret);
}
public IActionResult SearchUserGroup([FromQuery] UserGroupCriteria criteria)
{
var result = userGroupService.SearchUserGroup(criteria);
return(Ok(new SuccessResult(result)));
}
private void Display_Groups()
{
Ektron.Cms.User.IUserGroup userGroupManager = Ektron.Cms.ObjectFactory.GetUserGroup();
Ektron.Cms.UserGroupCriteria criteria = new UserGroupCriteria();
criteria.PagingInfo = new PagingInfo(m_refContentApi.RequestInformationRef.PagingSize, uxUserGroupsGrid.CurrentPage + 1);
criteria.OrderByDirection = EkEnumeration.OrderByDirection.Ascending;
criteria.OrderByField = UserGroupProperty.Name;
uxUserGroupsGrid.AddColumn(
this.m_refMsg.GetMessage("generic name")
, "[GroupName]");
uxUserGroupsGrid.Bind(
userGroupManager.GetListForUser(uId, criteria)
, criteria.PagingInfo);
}
