/// <summary> /// /// </summary> private void SetSortingLinks() { string baseURL = GetQueryString("AdminSchemaPatients.aspx", BaseProtocolId, BaseSchemaId, string.Empty, false); MRNSort.NavigateUrl = baseURL + "&sortCol=ptmrn&sortDir=desc"; NameSort.NavigateUrl = baseURL + "&sortCol=Name&sortDir=asc"; StudyIdSort.NavigateUrl = baseURL + "&sortCol=StudyId&sortDir=asc"; // set sorting if needed if (!string.IsNullOrEmpty(QuerySortColumn)) { if (QuerySortColumn.Equals("name", StringComparison.CurrentCultureIgnoreCase)) { if (QuerySortDir.Equals("asc")) { MRNSort.NavigateUrl = baseURL + "&sortCol=ptmrn&sortDir=asc"; NameSort.NavigateUrl = baseURL + "&sortCol=Name&sortDir=desc"; StudyIdSort.NavigateUrl = baseURL + "&sortCol=StudyId&sortDir=asc"; } else { MRNSort.NavigateUrl = baseURL + "&sortCol=ptmrn&sortDir=asc"; NameSort.NavigateUrl = baseURL + "&sortCol=Name&sortDir=asc"; StudyIdSort.NavigateUrl = baseURL + "&sortCol=StudyId&sortDir=asc"; } } if (QuerySortColumn.Equals("ptmrn")) { if (QuerySortDir.Equals("asc")) { MRNSort.NavigateUrl = baseURL + "&sortCol=ptmrn&sortDir=desc"; NameSort.NavigateUrl = baseURL + "&sortCol=Name&sortDir=asc"; StudyIdSort.NavigateUrl = baseURL + "&sortCol=StudyId&sortDir=asc"; } else { MRNSort.NavigateUrl = baseURL + "&sortCol=ptmrn&sortDir=asc"; NameSort.NavigateUrl = baseURL + "&sortCol=Name&sortDir=asc"; StudyIdSort.NavigateUrl = baseURL + "&sortCol=StudyId&sortDir=asc"; } } if (QuerySortColumn.Equals("StudyId")) { if (QuerySortDir.Equals("asc")) { MRNSort.NavigateUrl = baseURL + "&sortCol=ptmrn&sortDir=asc"; NameSort.NavigateUrl = baseURL + "&sortCol=Name&sortDir=asc"; StudyIdSort.NavigateUrl = baseURL + "&sortCol=StudyId&sortDir=desc"; } else { MRNSort.NavigateUrl = baseURL + "&sortCol=ptmrn&sortDir=asc"; NameSort.NavigateUrl = baseURL + "&sortCol=Name&sortDir=asc"; StudyIdSort.NavigateUrl = baseURL + "&sortCol=StudyId&sortDir=asc"; } } } }
/// <summary> /// Build the list of patients on the schema /// </summary> private void BuildSchemaPatients() { if (!string.IsNullOrEmpty(BaseSchemaId)) { int schemaId = int.Parse(BaseSchemaId); string dataset = CacheManager.GetDatasetSQL(Session[SessionKey.DatasetId]); DataView dv = ProtocolMgmtDa.GetPatientsByProtocolSchema(schemaId, dataset).DefaultView; // determine sort string sortCol = Patient.PtLastName; string sortDir = "asc"; if (!string.IsNullOrEmpty(QuerySortColumn)) { sortCol = QuerySortColumn.Equals("ptmrn") ? Patient.PtMRN : Patient.PtLastName; sortDir = !string.IsNullOrEmpty(QuerySortDir) && QuerySortDir.Equals("asc") ? "desc" : "asc"; } dv.Sort = sortCol + " " + sortDir; SchemaPatientsRptr.DataSource = dv; SchemaPatientsRptr.DataBind(); } }