public static void SearchUsers(Guid applicationId, ref List <User> retUsers, string searchText, ref List <Guid> departmentIds, ref List <Guid> expertiseKDIds, ref List <Guid> projectIds, ref List <Guid> processIds, ref List <Guid> communityIds, ref List <Guid> knowledgeKds, int?count, Guid?minId) { string spName = GetFullyQualifiedName("SearchUsers"); try { List <Guid> _userIds = new List <Guid>(); IDataReader reader = ProviderUtil.execute_reader(spName, applicationId, count, minId, ProviderUtil.get_search_text(searchText), ProviderUtil.list_to_string <Guid>(ref departmentIds), ProviderUtil.list_to_string <Guid>(ref expertiseKDIds), ProviderUtil.list_to_string <Guid>(ref projectIds), ProviderUtil.list_to_string <Guid>(ref processIds), ProviderUtil.list_to_string <Guid>(ref communityIds), ProviderUtil.list_to_string <Guid>(ref knowledgeKds), ','); ProviderUtil.parse_guids(ref reader, ref _userIds); retUsers = UsersController.get_users(applicationId, _userIds); } catch (Exception ex) { LogController.save_error_log(applicationId, null, spName, ex, ModuleIdentifier.SRCH); } }
public static void GetConfidentialityLevelUserIDs(Guid applicationId, ref List <Guid> retUserIds, Guid confidentialityId, string searchText, int?count, long?lowerBoundary, ref long totalCount) { string spName = GetFullyQualifiedName("GetConfidentialityLevelUserIDs"); try { IDataReader reader = ProviderUtil.execute_reader(spName, applicationId, confidentialityId, ProviderUtil.get_search_text(searchText), count, lowerBoundary); _parse_user_ids(ref reader, ref retUserIds, ref totalCount); } catch (Exception ex) { LogController.save_error_log(applicationId, null, spName, ex, ModuleIdentifier.PRVC); } }
public static List <Guid> GetDashboards(Guid applicationId, ref List <Dashboard> retDashboards, Guid?userId, Guid?nodeTypeId, Guid?nodeId, string nodeAdditionalId, DashboardType dashboardType, DashboardSubType subType, string subTypeTitle, bool?done, DateTime?dateFrom, DateTime?dateTo, string searchText, bool?getDistinctItems, bool?inWorkFlowState, int?lowerBoundary, int?count, ref long totalCount) { string spName = GetFullyQualifiedName("GetDashboards"); List <Guid> retList = new List <Guid>(); try { if (userId == Guid.Empty) { userId = null; } if (nodeTypeId == Guid.Empty) { nodeTypeId = null; } if (nodeId == Guid.Empty) { nodeId = null; } if (lowerBoundary == 0) { lowerBoundary = null; } if (!count.HasValue || count <= 0) { count = 50; } if (!string.IsNullOrEmpty(nodeAdditionalId)) { nodeAdditionalId = nodeAdditionalId.Trim(); } if (string.IsNullOrEmpty(nodeAdditionalId)) { nodeAdditionalId = null; } string strDashboardType = dashboardType == DashboardType.NotSet ? null : dashboardType.ToString(); string strSubType = subType == DashboardSubType.NotSet ? (string.IsNullOrEmpty(subTypeTitle) ? null : subTypeTitle) : subType.ToString(); IDataReader reader = ProviderUtil.execute_reader(spName, applicationId, userId, nodeTypeId, nodeId, nodeAdditionalId, strDashboardType, strSubType, done, dateFrom, dateTo, ProviderUtil.get_search_text(searchText), getDistinctItems, inWorkFlowState, lowerBoundary, count); if (!getDistinctItems.HasValue || !getDistinctItems.Value) { ProviderUtil.parse_dashboards(ref reader, ref retDashboards, ref totalCount); } else { ProviderUtil.parse_guids(ref reader, ref retList, ref totalCount); } return(retList); } catch (Exception ex) { LogController.save_error_log(applicationId, null, spName, ex, ModuleIdentifier.NTFN); return(new List <Guid>()); } }
public static void GetChildNodes(Guid applicationId, ref List <TreeNode> retTreeNodes, Guid?parentNodeId, Guid?treeId, string searchText) { string spName = GetFullyQualifiedName("GetChildNodes"); try { if (parentNodeId == Guid.Empty) { parentNodeId = null; } if (treeId == Guid.Empty) { treeId = null; } if (!parentNodeId.HasValue && !treeId.HasValue) { return; } IDataReader reader = ProviderUtil.execute_reader(spName, applicationId, parentNodeId, treeId, ProviderUtil.get_search_text(searchText)); _parse_tree_nodes(ref reader, ref retTreeNodes); } catch (Exception ex) { LogController.save_error_log(applicationId, null, spName, ex, ModuleIdentifier.DCT); } }