change function so it will only get a part of the users

HI ,

Ive got the following webapp. using asp.net /c# .

Now when we go to the userpage. The page_load will be loaded.

IN the paige load there is a function to check if it is a postback. If it isn't a postback a function is called to get the users and show them in a repeater. However. The first time it loads it get all the users. the second time it doesn;t get the users ( because, it is a postback). Olso every page shows 10 users ( for now) we can change that by editing the pageSize.

How can i change te code, so it will only get the users it need ( not all of them). here is the code. please give me some advice or tips how to change the code.

protected void Page_Load(object sender, EventArgs e)
{
try
{
if (PortalApplication == null)
return;
if (!IsPostBack)
FillRptUsers();
}
catch (Exception ex)
{
PortalApplication.HandleException(ex);
ShowFailureText();
}
}
public void FillRptUsers()
{
var serviceProviderId = PortalApplication.User.serviceProviderId;
var groupId = PortalApplication.User.groupId;
var users = PortalApplication.GetGroupUsers(serviceProviderId, groupId, UserFilter.Text, (CurrentPage - 1) * PageSize, PageSize);
}

Cassie Mod9y ago

public class CompleetApplication : PortalApplication
{
public List GetGroupUsers(string serviceProviderId, string groupId, string filter, int offset, int limit)
{
var agent = TechnicServiceAgentFactory.NewAgent();
return agent.GetGroupUsers(_requestId, User.sessionId, User.jSessionId, serviceProviderId, groupId, null, null, null, filter, offset, limit);
}

We uses entity framework for the wcf service ( service reference and service agent). although we are mostly trieng to replace the service agent by a service reference .

TechnicService.cs

public GetGroupUsersResponse GetGroupUsers(GetGroupUsersRequest request)
{
var response = new GetGroupUsersResponse();
try
{
var requestValidator = ValidationFactory.CreateValidator();
validateRequest(requestValidator.Validate(request));
var users = GroupLogic.GetGroupUsers(_log, request.requestId, request.sessionId, request.jSessionId, request.serviceProviderId, request.groupId, request.matchUserId, request.matchDepartment, request.matchExtension, request.filter, request.startIndex, request.maxItems).ToList();
response.users = users.ToWcf();
response.result = true;
}
catch (ServiceException e)
{
ResponseBase responseBase = response;
handleServiceException(e, request.requestId, request.requestUsername, MethodBase.GetCurrentMethod(), ref responseBase);
return (GetGroupUsersResponse)responseBase;
}
catch (Exception e)
{
ResponseBase responseBase = response;
handleException(e, request.requestId, request.requestUsername, MethodBase.GetCurrentMethod(), ref responseBase);
return (GetGroupUsersResponse)responseBase;
}
return response;
}

public static IEnumerable GetGroupUsers(ILog log, Guid requestId, Guid sessionId, string jSessionId, string serviceProviderId, string groupId, string matchUserId = null, string matchDepartment = null, string matchExtension = null, string filter = null, int startIndex = 0, int? maxItems = null)
{
log.Info(requestId, MethodInfo.GetCurrentMethod().DeclaringType.Name, "Begin execute");
// Set up session
var session = new Broadworks.OCI.OciSession(sessionId, jSessionId);
var ociRequest = new Broadworks.OCI.Schema.UserGetListInGroupRequest
{
serviceProviderId = serviceProviderId,
GroupId = groupId
};
var searchCriteriaUserId = new List
{
new Broadworks.OCI.Schema.SearchCriteriaUserId
{
mode = Broadworks.OCI.Schema.SearchMode.StartsWith,
value = groupId,
isCaseInsensitive = true
}
};
if (!string.IsNullOrEmpty(matchUserId))
searchCriteriaUserId.Add(new Broadworks.OCI.Schema.SearchCriteriaUserId
{
mode = Broadworks.OCI.Schema.SearchMode.Contains,
value = matchUserId,
isCaseInsensitive = true
});
ociRequest.searchCriteriaUserId = searchCriteriaUserId.ToArray();
// Not possible to filter on an empty department; Broadworks XML validation error. Fixed in LinQ filtering below
if (!string.IsNullOrEmpty(matchDepartment))
ociRequest.searchCriteriaExactUserDepartment = new Broadworks.OCI.Schema.SearchCriteriaExactUserDepartment
{
departmentKey = new Broadworks.OCI.Schema.GroupDepartmentKey
{
serviceProviderId = serviceProviderId,
groupId = groupId,
name = matchDepartment
}
};
if (!string.IsNullOrEmpty(matchExtension))
ociRequest.searchCriteriaExtension = new[]
{
new Broadworks.OCI.Schema.SearchCriteriaExtension
{
mode = Broadworks.OCI.Schema.SearchMode.StartsWith,
value = matchExtension
}
};
// Send the request
var ociResponse = session.Send(ociRequest);
// Check if succeeded
ErrorHandler.CheckError(log, sessionId, requestId, MethodInfo.GetCurrentMethod().DeclaringType.Name, ociResponse);
Debug.Assert(ociResponse.GetType() == typeof(Broadworks.OCI.Schema.UserGetListInGroupResponse));
var userDictionaryList = ((Broadworks.OCI.Schema.UserGetListInGroupResponse)ociResponse).userTable.ToDictionaryList();
// Response to UserGetListInGroupRequest. Contains a table with column headings:
// "User Id", "Last Name", "First Name", "Department", "Phone Number", "Phone Number Activated", "Email Address", "Hiragana Last Name", "Hiragana First Name", "In Trunk Group", "Extension"
var users = userDictionaryList.Select(user => new Model.User
{
userId = user["User Id"],
lastName = user["Last Name"],
firstName = user["First Name"],
departmentFullPath = user["Department"],
phoneNumber = user["Phone Number"],
emailAddress = user["Email Address"],
// TODO: Why also return these? They are already provided in the request?
serviceProviderId = serviceProviderId,
groupId = groupId,
hiraganaLastName = user["Hiragana Last Name"],
hiraganaFirstName = user["Hiragana First Name"],
extension = user["Extension"]
});
// Filter for empty departments
if (matchDepartment == string.Empty)
users = users.Where(u => u.departmentFullPath == string.Empty);
// Apply the filter. This can not be done by Broadworks because it has no OR relation
if (!string.IsNullOrEmpty(filter))
users = users.Where(u => u.lastName.ToUpper().Contains(filter.ToUpper()) || u.firstName.ToUpper().Contains(filter.ToUpper()) || u.phoneNumber.ToUpper().Contains(filter.ToUpper()) || u.extension.ToUpper().Contains(filter.ToUpper()));
var userArray = users.ToArray();
// Do requests to see id a user has a CallCenterBasic sevice pack
var ociRequests = userArray.Select(u => (Broadworks.OCI.Schema.OCIRequest)new Broadworks.OCI.Schema.UserServiceIsAssignedRequest
{
userId = u.userId,
Item = UserServices.CallCenterBasic
}).ToArray();
// Send the requests
var ociResponses = session.Send(ociRequests);
// Check if succeeded
ErrorHandler.CheckError(log, sessionId, requestId, MethodInfo.GetCurrentMethod().DeclaringType.Name, ociResponses);
// Put back the result
for (var i = 0; i < userArray.Length; ++i)
userArray[i].hasCallQueueService = ((Broadworks.OCI.Schema.UserServiceIsAssignedResponse)ociResponses[i]).isAssigned;
log.Info(requestId, MethodInfo.GetCurrentMethod().DeclaringType.Name, "End execute");
return users;
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Cassie Mod9y ago
1. public class CompleetApplication : PortalApplication
2. {
3. public List GetGroupUsers(string serviceProviderId, string groupId, string filter, int offset, int limit)
4. {
5. var agent = TechnicServiceAgentFactory.NewAgent();
6. return agent.GetGroupUsers(_requestId, User.sessionId, User.jSessionId, serviceProviderId, groupId, null, null, null, filter, offset, limit);
7. }
We uses entity framework for the wcf service ( service reference and service agent). although we are mostly trieng to replace the service agent by a service reference .

TechnicService.cs
public GetGroupUsersResponse GetGroupUsers(GetGroupUsersRequest request)
{
    var response = new GetGroupUsersResponse();
    try
    {
        var requestValidator = ValidationFactory.CreateValidator();
        validateRequest(requestValidator.Validate(request));
        var users = GroupLogic.GetGroupUsers(_log, request.requestId, request.sessionId, request.jSessionId, request.serviceProviderId, request.groupId, request.matchUserId, request.matchDepartment, request.matchExtension, request.filter, request.startIndex, request.maxItems).ToList();
        response.users = users.ToWcf();
        response.result = true;
    }

    catch (ServiceException e)
    {
        ResponseBase responseBase = response;
        handleServiceException(e, request.requestId, request.requestUsername, MethodBase.GetCurrentMethod(), ref responseBase);
        return (GetGroupUsersResponse)responseBase;
    }
    catch (Exception e)
    {
        ResponseBase responseBase = response;
        handleException(e, request.requestId, request.requestUsername, MethodBase.GetCurrentMethod(), ref responseBase);
        return (GetGroupUsersResponse)responseBase;
    }
    return response;
}
public static IEnumerable GetGroupUsers(ILog log, Guid requestId, Guid sessionId, string jSessionId, string serviceProviderId, string groupId, string matchUserId = null, string matchDepartment = null, string matchExtension = null, string filter = null, int startIndex = 0, int? maxItems = null)
       {
           log.Info(requestId, MethodInfo.GetCurrentMethod().DeclaringType.Name, "Begin execute");

           // Set up session
           var session = new Broadworks.OCI.OciSession(sessionId, jSessionId);

           var ociRequest = new Broadworks.OCI.Schema.UserGetListInGroupRequest
           {
               serviceProviderId = serviceProviderId,
               GroupId = groupId
           };

           var searchCriteriaUserId = new List
           {
               new Broadworks.OCI.Schema.SearchCriteriaUserId
               {
                   mode = Broadworks.OCI.Schema.SearchMode.StartsWith,
                   value = groupId,
                   isCaseInsensitive = true
               }
           };

           if (!string.IsNullOrEmpty(matchUserId))
               searchCriteriaUserId.Add(new Broadworks.OCI.Schema.SearchCriteriaUserId
               {
                   mode = Broadworks.OCI.Schema.SearchMode.Contains,
                   value = matchUserId,
                   isCaseInsensitive = true
               });

           ociRequest.searchCriteriaUserId = searchCriteriaUserId.ToArray();

           // Not possible to filter on an empty department; Broadworks XML validation error. Fixed in LinQ filtering below
           if (!string.IsNullOrEmpty(matchDepartment))
               ociRequest.searchCriteriaExactUserDepartment = new Broadworks.OCI.Schema.SearchCriteriaExactUserDepartment
               {
                   departmentKey = new Broadworks.OCI.Schema.GroupDepartmentKey
                   {
                       serviceProviderId = serviceProviderId,
                       groupId = groupId,
                       name = matchDepartment
                   }
               };

           if (!string.IsNullOrEmpty(matchExtension))
               ociRequest.searchCriteriaExtension = new[]
               {
                   new Broadworks.OCI.Schema.SearchCriteriaExtension
                   {
                       mode = Broadworks.OCI.Schema.SearchMode.StartsWith,
                       value = matchExtension
                   }
               };

           // Send the request
           var ociResponse = session.Send(ociRequest);
           // Check if succeeded
           ErrorHandler.CheckError(log, sessionId, requestId, MethodInfo.GetCurrentMethod().DeclaringType.Name, ociResponse);
           Debug.Assert(ociResponse.GetType() == typeof(Broadworks.OCI.Schema.UserGetListInGroupResponse));

           var userDictionaryList = ((Broadworks.OCI.Schema.UserGetListInGroupResponse)ociResponse).userTable.ToDictionaryList();
           // Response to UserGetListInGroupRequest. Contains a table with column headings:
           // "User Id", "Last Name", "First Name", "Department", "Phone Number", "Phone Number Activated", "Email Address",  "Hiragana Last Name", "Hiragana First Name", "In Trunk Group", "Extension"

           var users = userDictionaryList.Select(user => new Model.User
           {
               userId = user["User Id"],
               lastName = user["Last Name"],
               firstName = user["First Name"],
               departmentFullPath = user["Department"],
               phoneNumber = user["Phone Number"],
               emailAddress = user["Email Address"],
               // TODO: Why also return these? They are already provided in the request?
               serviceProviderId = serviceProviderId,
               groupId = groupId,
               hiraganaLastName = user["Hiragana Last Name"],
               hiraganaFirstName = user["Hiragana First Name"],
               extension = user["Extension"]
           });

           // Filter for empty departments
           if (matchDepartment == string.Empty)
               users = users.Where(u => u.departmentFullPath == string.Empty);

           // Apply the filter. This can not be done by Broadworks because it has no OR relation
           if (!string.IsNullOrEmpty(filter))
               users = users.Where(u => u.lastName.ToUpper().Contains(filter.ToUpper()) || u.firstName.ToUpper().Contains(filter.ToUpper()) || u.phoneNumber.ToUpper().Contains(filter.ToUpper()) || u.extension.ToUpper().Contains(filter.ToUpper()));

           var userArray = users.ToArray();
           // Do requests to see id a user has a CallCenterBasic sevice pack
           var ociRequests = userArray.Select(u => (Broadworks.OCI.Schema.OCIRequest)new Broadworks.OCI.Schema.UserServiceIsAssignedRequest
           {
               userId = u.userId,
               Item = UserServices.CallCenterBasic
           }).ToArray();
           // Send the requests
           var ociResponses = session.Send(ociRequests);
           // Check if succeeded
           ErrorHandler.CheckError(log, sessionId, requestId, MethodInfo.GetCurrentMethod().DeclaringType.Name, ociResponses);
           // Put back the result
           for (var i = 0; i < userArray.Length; ++i)
               userArray[i].hasCallQueueService = ((Broadworks.OCI.Schema.UserServiceIsAssignedResponse)ociResponses[i]).isAssigned;

           log.Info(requestId, MethodInfo.GetCurrentMethod().DeclaringType.Name, "End execute");

           return users;
       }