private void LoadSearchCriteria()
{
var searchCriteria = new Criteria();
var demographicParms = new SearchParms();
demographicParms.AddParm("", "");
searchCriteria.Add(new Classes.Criterion()
{
Header = "Demographics",
Key = "Demographics",
Locked = true,
Empty = true
});
searchCriteria.Add(new Classes.Criterion()
{
Header = "Demographics",
Key = "Race",
Removable = true
});
searchCriteria.Add(new Classes.Criterion()
{
Header = "Demographics",
Key = "EOSL",
Object = "Yes",
Removable = true
});
searchCriteria.Add(new Classes.Criterion()
{
Header = "Demographics",
Key = "Gifted",
Object = "No",
Removable = true
});
searchCriteria.Add(new Classes.Criterion()
{
Header = "Demographics",
Key = "Special needs",
Object = "Yes",
Removable = true
});
SearchParms = new SearchParms();
SearchParms.AddParm("reportCriteria", searchCriteria);
var guid = System.Guid.NewGuid().ToString();
hiddenTxtBox.Text = guid;
Guid = guid;
Session["Criteria_" + guid] = searchCriteria;
}
private void LoadSearchCriteria()
{
var yearList = new List<string> { _year };
var testList = new List<int> { _testId };
var searchCriteria = new Criteria();
var demographicParms = new SearchParms();
demographicParms.AddParm(string.Empty, string.Empty);
switch (_parent)
{
case "Class":
searchCriteria.Add(new Criterion
{
Header = "Class\\Group",
Locked = true,
Key = "Class",
Object = Base.Classes.Class.GetClassByID(DataIntegrity.ConvertToInt(_class)).ClassName,
ReportStringKey = "CID",
ReportStringVal = _class,
Type = "String",
Description = "Classes"
});
break;
case "School":
var school = Base.Classes.School.GetSchoolByID(_parentId);
searchCriteria.Add(new Criterion
{
Header = "School",
Locked = true,
Key = "School",
Object = school.Name,
Type = "String"
});
break;
case "Teacher":
searchCriteria.Add(new Criterion
{
Header = "Teacher",
Locked = true,
Key = "Teacher",
Object = TeacherDB.GetTeacherByPage(_parentId).TeacherName,
Type = "String"
});
break;
}
switch (_level)
{
case "Class":
searchCriteria.Add(new Criterion
{
Header = "Class\\Group",
Key = "Class",
Object = Base.Classes.Class.GetClassByID(DataIntegrity.ConvertToInt(_class)).ClassName,
ReportStringKey = "CID",
ReportStringVal = _levelId.ToString(CultureInfo.CurrentCulture),
Type = "String",
Description = "Classes",
Locked = false,
UIType = UIType.DropDownList,
DataSource = Base.Classes.Reports.GetReportingLevels(_level, _levelId, DataIntegrity.ConvertToInt(_parentId), testList, 0),
DataTextField = "Name",
DataValueField = "ID"
});
break;
case "Student":
searchCriteria.Add(new Criterion
{
Header = "Student",
Locked = false,
Key = "Student",
Object = StudentDB.GetStudentByID(_levelId).StudentName,
Type = "String",
Description = "Classes",
UIType = UIType.DropDownList,
ReportStringKey = "StudentRecID",
ReportStringVal = _levelId.ToString(CultureInfo.CurrentCulture),
DataSource = Base.Classes.Reports.GetReportingLevels(_level, _levelId, DataIntegrity.ConvertToInt(_parentId), testList, 0),
DataTextField = "Name",
DataValueField = "ID"
});
break;
case "Teacher":
searchCriteria.Add(new Criterion
{
Header = "Teacher",
Key = "Teacher",
Object = TeacherDB.GetTeacherByPage(_levelId).TeacherName,
ReportStringKey = "TEAID",
ReportStringVal = _levelId.ToString(CultureInfo.CurrentCulture),
Type = "String",
Locked = false,
UIType = UIType.DropDownList
});
break;
}
DataTable assessmentListDataTable = Base.Classes.Reports.GetTestList(_level, _levelId,
DataIntegrity.ConvertToInt(_class), yearList, 0);
searchCriteria.Add(new Criterion
{
Header = "Assessment",
Locked = assessmentListDataTable.Rows.Count < 2,
Key = "Assessment",
Object = _testId == 0 ? "" : Assessment.GetAssessmentByID(_testId).TestName,
Type = "String",
ReportStringKey = "TID",
ReportStringVal = _testId == 0 ? "" : _testId.ToString(CultureInfo.CurrentCulture),
Description = "2010-2011",
UIType = UIType.DropDownList,
DataSource = assessmentListDataTable,
DataTextField = "Name",
DataValueField = "ID"
});
searchCriteria.Add(new Criterion
{
Header = "Type",
Key = "Type",
Object = _type,
ReportStringKey = "TTYPES",
ReportStringVal = _type,
Type = "String",
Description = "type",
Locked = true
});
searchCriteria.Add(new Criterion
{
Header = "Year(s)",
Key = "Year(s)",
Object = _year,
ReportStringKey = "TYRS",
ReportStringVal = _year,
Type = "String",
Description = "2010-2011",
Locked = true
});
searchCriteria.Add(new Criterion
{
Header = "Terms",
Key = "Terms",
Type = "String",
ReportStringKey = "TTERMS",
ReportStringVal = _term,
Description = "List of terms",
Object = _term,
Locked = true
});
searchCriteria.Add(new Criterion
{
Header = "Demographics",
Key = "Demographics",
Locked = true,
Empty = true
});
searchCriteria.Add(new Criterion
{
Header = "Groups",
Key = "group",
Object = _groups,
ReportStringKey = "GRP",
ReportStringVal = _groups,
Type = "String",
Description = "Groups Filter",
Locked = true,
UIType = UIType.DropDownList,
DataSource = null,
DataTextField = "DisplayName",
DataValueField = "RoleId",
Visible = false
});
SearchParms = new SearchParms();
SearchParms.AddParm("reportCriteria", searchCriteria);
var guid = Guid.NewGuid().ToString();
hiddenTxtBox.Text = guid;
Session["Criteria_" + guid] = searchCriteria;
}
private Criteria LoadSearchCriteria()
{
var criteria = new Criteria();
criteria.Add(new Criterion
{
Header = "Name",
Key = "Name",
Type = "String",
Description = string.Empty,
Locked = false,
UIType = UIType.TextBox,
Removable = true
});
criteria.Add(new Criterion
{
Header = "Student ID",
Key = "StudentID",
Type = "String",
Description = string.Empty,
Locked = false,
UIType = UIType.TextBox,
Removable = true
});
criteria.Add(new Criterion
{
Header = "RTI",
Key = "RTI",
Type = "String",
Description = string.Empty,
Locked = false,
UIType = UIType.RTI
});
criteria.Add(new Criterion
{
Header = "Cluster",
Key = "Cluster",
Type = "String",
Description = string.Empty,
Locked = false,
UIType = UIType.CheckBoxList,
DataSource = Base.Classes.Cluster.GetClusterListForDropDown(UserPage),
DataTextField = "Cluster",
DataValueField = "Cluster",
Removable = true
});
// School Type
var schoolTypeDataTable = new DataTable();
var schoolTypesForLoggedInUser = SchoolTypeMasterList.GetSchoolTypeListForUser(SessionObject.LoggedInUser);
schoolTypeDataTable.Columns.Add("SchoolType");
foreach (var s in schoolTypesForLoggedInUser)
{
schoolTypeDataTable.Rows.Add(s);
}
criteria.Add(new Criterion
{
Header = "School Type",
Key = "SchoolType",
Type = "String",
Description = string.Empty,
Locked = false,
UIType = UIType.CheckBoxList,
DataSource = schoolTypeDataTable,
DataTextField = "SchoolType",
DataValueField = "SchoolType",
DefaultValue = _selectedSchoolType,
Removable = true,
ServiceUrl = "../../Services/School.svc/GetAllSchoolsFromSchoolTypes",
ServiceOnSuccess = "getAllSchoolsFromSchoolTypes",
Dependencies = new[]
{
Criterion.CreateDependency("SchoolType", "SchoolTypes"),
Criterion.CreateDependency("School", "Schools")
}
});
// School
var schoolDataTable = new DataTable();
var schoolsForLooggedInUser = SchoolMasterList.GetSchoolsForUser(SessionObject.LoggedInUser);
schoolDataTable.Columns.Add("Name");
schoolDataTable.Columns.Add("ID");
foreach (var s in schoolsForLooggedInUser)
{
schoolDataTable.Rows.Add(s.Name, s.ID);
}
criteria.Add(new Criterion
{
Header = "School",
Key = "School",
Type = "String",
Description = string.Empty,
Locked = false,
UIType = UIType.DropDownList,
DataSource = schoolDataTable,
DataTextField = "Name",
DataValueField = "ID",
Removable = true
});
// School
var gradeDataTable = new DataTable();
gradeDataTable.Columns.Add("Grade");
foreach (Grade g in Thinkgate.Base.Classes.Grade.GetGradesForStudents())
{
gradeDataTable.Rows.Add(g.DisplayText);
}
criteria.Add(new Criterion
{
Header = "Grade",
Key = "Grade",
Type = "String",
DataTextField = "Grade",
DataValueField = "Grade",
Description = string.Empty,
Locked = false,
DefaultValue = _selectedGrade,
DataSource = gradeDataTable,
UIType = UIType.CheckBoxList,
Removable = true
});
criteria.Add(new Criterion
{
Header = "Demographics",
Key = "Demographics",
Type = "String",
Description = string.Empty,
Locked = false,
UIType = UIType.Demographics
});
// Enrollment
var enrollmentDataTable = new DataTable();
enrollmentDataTable.Columns.Add("Enrollment");
enrollmentDataTable.Rows.Add("Current Year");
enrollmentDataTable.Rows.Add("Prior Years");
enrollmentDataTable.Rows.Add("All Years");
criteria.Add(new Criterion
{
Header = "Enrollment",
Key = "Enrollment",
Type = "String",
Description = string.Empty,
DefaultValue = enrollmentDataTable.Rows[0].ItemArray[0].ToString(),
DataSource = enrollmentDataTable,
Locked = false,
DataTextField = "Enrollment",
DataValueField = "Enrollment",
UIType = UIType.DropDownList
});
return criteria;
}
private Criteria LoadSearchCriteria()
{
var criteria = new Criteria();
#region Criterion: Grade
var gradesDT = new DataTable();
var gradesByCurrCourses =
Thinkgate.Base.Classes.CourseMasterList.GetClassCoursesForUser(SessionObject.LoggedInUser).GetGradeList();
gradesDT.Columns.Add("Grade");
foreach (var g in gradesByCurrCourses)
{
gradesDT.Rows.Add(g.DisplayText);
}
criteria.Add(new Criterion
{
Header = "Grade",
Key = "Grade",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Grade",
DataValueField = "Grade",
Removable = true,
DataSource = gradesDT,
UIType = UIType.CheckBoxList,
ServiceUrl = "../../Services/GradeSubjectCourse.svc/GetCurrSubjectsAndCourses",
ServiceOnSuccess = "getCurrGradesSubjectsAndCourses",
Dependencies = new[]
{
Criterion.CreateDependency("Grade", "Grades"),
Criterion.CreateDependency("Subject", "Subjects"),
Criterion.CreateDependency("Curriculum", "Courses")
}
});
#endregion
#region Criterion: Subject
var subjectsDT = new DataTable();
var subjectsByCurrCourses =
Thinkgate.Base.Classes.CourseMasterList.GetClassCoursesForUser(SessionObject.LoggedInUser).GetSubjectList();
subjectsDT.Columns.Add("Subject");
foreach (var subjectText in subjectsByCurrCourses.Select(s => s.DisplayText).Distinct())
{
subjectsDT.Rows.Add(subjectText);
}
criteria.Add(new Criterion
{
Header = "Subject",
Key = "Subject",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Subject",
DataValueField = "Subject",
Removable = true,
DataSource = subjectsDT,
UIType = UIType.CheckBoxList,
ServiceUrl = "../../Services/GradeSubjectCourse.svc/GetCurrCourses",
ServiceOnSuccess = "getCurrCoursesFromSubjects",
Dependencies = new[]
{
Criterion.CreateDependency("Grade", "Grades"),
Criterion.CreateDependency("Subject", "Subjects"),
Criterion.CreateDependency("Curriculum", "Courses")
}
});
#endregion
#region Criterion: Course
var currCourses =
Thinkgate.Base.Classes.CourseMasterList.GetCurrCoursesForUser(SessionObject.LoggedInUser);
var currcourseDt = new DataTable();
currcourseDt.Columns.Add("CourseName");
currcourseDt.Columns.Add("CourseID");
currCourses.Sort((x, y) => String.Compare(x.Grade.DisplayText, y.Grade.DisplayText));
foreach (var c in currCourses)
{
currcourseDt.Rows.Add(c.Grade + "-" + c.CourseName, c.ID);
}
criteria.Add(new Criterion
{
Header = "Course",
Key = "Curriculum",
DataSource = currcourseDt,
DataTextField = "CourseName",
DataValueField = "CourseID",
Locked = false,
Removable = true,
Description = string.Empty,
Type = "String",
UIType = UIType.DropDownList
});
#endregion
#region Criterion: Category
criteria.Add(new Criterion
{
Header = "Category",
Key = "Category",
Type = "String",
Description = string.Empty,
Locked = true,
Removable = false,
Object = Category,
UIType = UIType.DropDownList,
DataSource = Thinkgate.Base.Classes.Assessment.GetCategories(SessionObject.LoggedInUser.UserId),
DataTextField = "TestCategory",
DataValueField = "TestCategory"
});
#endregion
#region Criterion: Type
//CREATE TESTTYPE DT FOR DATASOURCE
var typeDT = new DataTable();
typeDT.Columns.Add("TypeText");
typeDT.Columns.Add("TypeVal");
List<string> typeListTable = new List<string>();
dictionaryItem = Base.Classes.TestTypes.TypeWithSecureFlag(Category,true);
isSecuredFlag = dictionaryItem != null && dictionaryItem.Where(x => Boolean.Parse(x.Value.ToString())).Select(y => y.Key).ToList().Distinct().Any();
if (dictionaryItem != null && dictionaryItem.Select(c => c.Key).Any())
{
if (isSecuredFlag && UserHasPermission(Permission.Access_SecureTesting))
typeListTable = dictionaryItem.Select(c => c.Key).ToList();
else
typeListTable = dictionaryItem.Where(c => !c.Value).Select(c => c.Key).ToList();
}
foreach (var testType in typeListTable)
{
typeDT.Rows.Add(testType, testType);
}
criteria.Add(new Criterion
{
Header = "Type",
Key = "Type",
Type = "String",
Description = string.Empty,
Locked = false,
UIType = UIType.CheckBoxList,
DataSource = typeDT,
DataTextField = "TypeText",
DataValueField = "TypeVal",
Removable = true
});
#endregion
DataTable terms = new DataTable();
terms.Columns.Add("Term");
foreach (var str in Thinkgate.Base.Classes.Assessment.GetTerms())
{
// this is ridiculous, but will ultimatly be replaced so I'm adding this in so I can store the terms in cache as a list, not a datatable
terms.Rows.Add(str);
}
#region Criterion: Terms
criteria.Add(new Criterion
{
Header = "Terms",
Key = "Terms",
Type = "String",
Description = string.Empty,
Locked = false,
UIType = UIType.CheckBoxList,
DataSource = terms,
DataTextField = "Term",
DataValueField = "Term",
Removable = true
});
#endregion
#region Criterion: Status
var statusDT = new DataTable();
var defaultStatusValue = "All";
statusDT.Columns.Add("StatusText");
statusDT.Columns.Add("StatusVal");
if (Category.ToLower() == "district" && !UserHasPermission(Permission.Edit_AssessmentDistrict_Unproofed)
|| Category.ToLower() == "state" && !(DistrictParms.LoadDistrictParms().isStateSystem))
{
defaultStatusValue = "Proofed";
statusDT.Rows.Add("Proofed", "Proofed");
}
else
{
statusDT.Rows.Add("All", "All");
statusDT.Rows.Add("Proofed", "Proofed");
statusDT.Rows.Add("Unproofed", "Unproofed");
}
criteria.Add(new Criterion
{
Header = "Status",
Key = "Status",
Type = "String",
Description = string.Empty,
Locked = false,
UIType = UIType.DropDownList,
DataSource = statusDT,
DataTextField = "StatusText",
DataValueField = "StatusVal",
Removable = false,
Object = defaultStatusValue,
ReportStringVal = defaultStatusValue
});
#endregion
#region Criterion: Text Search
var textSearchDT = new DataTable();
textSearchDT.Columns.Add("SearchFieldKey");
textSearchDT.Rows.Add("Any Words");
textSearchDT.Rows.Add("All Words");
textSearchDT.Rows.Add("Exact Phrase");
textSearchDT.Rows.Add("Keywords");
textSearchDT.Rows.Add("Author");
criteria.Add(new Criterion
{
Header = "Text Search",
Key = "TextSearch",
Type = "String",
UIType = UIType.AssessmentTextSearch,
DataSource = textSearchDT,
DataTextField = "SearchFieldKey",
DataValueField = "SearchFieldKey",
Removable = true
});
#endregion
#region Criterion: Year
criteria.Add(new Criterion
{
Header = "Year",
Key = "Year",
Type = "String",
Description = string.Empty,
Locked = false,
UIType = UIType.DropDownList,
DataSource = Thinkgate.Base.Classes.Assessment.GetYears(),
DataTextField = "Year",
DataValueField = "Year",
Removable = false,
Object = DistrictParms.LoadDistrictParms().Year
});
#endregion
#region Criterion: Created Date
criteria.Add(new Criterion
{
Header = "Created Date",
Key = "CreatedDate",
Type = "String",
Description = string.Empty,
Locked = false,
UIType = UIType.DatePicker,
Removable = true,
IsHeader = true
});
criteria.Add(new Criterion
{
Header = "Created Date",
Key = "CreatedDateStart",
Type = "String",
Description = string.Empty,
IsHeader = false,
Removable = true
});
criteria.Add(new Criterion
{
Header = "Created Date",
Key = "CreatedDateEnd",
Type = "String",
Description = string.Empty,
IsHeader = false,
Removable = true
});
#endregion
return criteria;
}
private Criteria LoadLRMISearchCriteria()
{
var criteria = new Criteria();
#region Criterion: Grade
var gradesDT = new DataTable();
var gradesByCurrCourses =
CourseMasterList.GetClassCoursesForUser(SessionObject.LoggedInUser).GetGradeList();
gradesDT.Columns.Add("Grades");
foreach (var g in gradesByCurrCourses)
{
gradesDT.Rows.Add(g.DisplayText);
}
criteria.Add(new Criterion
{
Header = "Grades",
Key = "Grades",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Grades",
DataValueField = "Grades",
Removable = true,
DataSource = gradesDT,
UIType = UIType.CheckBoxList,
ServiceUrl = "../../Services/GradeSubjectCourse.svc/GetCurrSubjectsAndCourses",
ServiceOnSuccess = "getCurrGradesSubjectsAndCourses",
Dependencies = new[]
{
Criterion.CreateDependency("Grades", "Grades"),
Criterion.CreateDependency("Subjects", "Subjects")
}
});
#endregion
#region Criterion: Subject
var subjectsDT = new DataTable();
var subjectsByCurrCourses =
Thinkgate.Base.Classes.CourseMasterList.GetClassCoursesForUser(SessionObject.LoggedInUser).GetSubjectList();
subjectsDT.Columns.Add("Subjects");
foreach (var subjectText in subjectsByCurrCourses.Select(s => s.DisplayText).Distinct())
{
subjectsDT.Rows.Add(subjectText);
}
criteria.Add(new Criterion
{
Header = "Educational Subject",
Key = "Subjects",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Subjects",
DataValueField = "Subjects",
Removable = true,
DataSource = subjectsDT,
UIType = UIType.CheckBoxList,
ServiceUrl = "../../Services/GradeSubjectCourse.svc/GetCurrCourses",
ServiceOnSuccess = "getCurrCoursesFromSubjects",
Dependencies = new[]
{
Criterion.CreateDependency("Grades", "Grades"),
Criterion.CreateDependency("Subject", "Subjects"),
Criterion.CreateDependency("Curriculum", "Courses")
}
});
#endregion
criteria.Add(new Criterion
{
Header = "Learning Resource:",
Key = "LearningResource",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Description",
DataValueField = "Description",
Removable = true,
DataSource = dtLearningResources,
UIType = UIType.CheckBoxList,
ServiceUrl = null,
ServiceOnSuccess = null,
Dependencies = null
});
criteria.Add(new Criterion
{
Header = "Educational Use",
Key = "EducationalUse",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Description",
DataValueField = "Description",
Removable = false,
DataSource = dtEducationalUse,
UIType = UIType.CheckBoxList,
ServiceUrl = null,
ServiceOnSuccess = null,
Dependencies = null,
DefaultValue = ((DataRow)dtEducationalUse.Rows[0])["Description"].ToString()
});
criteria.Add(new Criterion
{
Header = "End User",
Key = "EndUser",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Description",
DataValueField = "Description",
Removable = false,
DataSource = dtEndUsers,
UIType = UIType.CheckBoxList,
ServiceUrl = null,
ServiceOnSuccess = null,
Dependencies = null,
DefaultValue = ((DataRow)dtEndUsers.Rows[0])["Description"].ToString()
});
criteria.Add(new Criterion
{
Header = "Creator",
Key = "Creator",
Locked = false,
Removable = true,
Description = string.Empty,
Type = "String",
UIType = UIType.TextBox
});
criteria.Add(new Criterion
{
Header = "Publisher",
Key = "Publisher",
Locked = false,
Removable = true,
Description = string.Empty,
Type = "String",
UIType = UIType.TextBox
});
criteria.Add(new Criterion
{
Header = "Usage Rights",
Key = "UsageRights",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "SelectDescription",
DataValueField = "SelectDescription",
Removable = true,
DataSource = dtCreativeCommons,
UIType = UIType.CheckBoxList,
ServiceUrl = null,
ServiceOnSuccess = null,
Dependencies = null
});
criteria.Add(new Criterion
{
Header = "Media Type",
Key = "MediaType",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Description",
DataValueField = "Description",
Removable = true,
DataSource = dtMediaTypes,
UIType = UIType.CheckBoxList,
ServiceUrl = null,
ServiceOnSuccess = null,
Dependencies = null
});
criteria.Add(new Criterion
{
Header = "Language",
Key = "Language",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Description",
DataValueField = "Description",
Removable = true,
DataSource = dtLanguages,
UIType = UIType.CheckBoxList,
ServiceUrl = null,
ServiceOnSuccess = null,
Dependencies = null
});
criteria.Add(new Criterion
{
Header = "Age Appropriate",
Key = "AgeAppropriate",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Description",
DataValueField = "Description",
Removable = true,
DataSource = dtAgeAppropriate,
UIType = UIType.CheckBoxList,
ServiceUrl = null,
ServiceOnSuccess = null,
Dependencies = null
});
//criteria.Add(new Criterion
//{
// Header = "Time Required",
// Key = "Duration",
// Type = "String",
// Description = string.Empty,
// Locked = false,
// Removable = true,
// UIType = UIType.Duration
//});
//Assessed (Standard) search
//criteria.Add(new Criterion
//{
// UIType = UIType.GradeSubjectStandards,
// Header = "Assessed",
// Key = "Assessed",
// Locked = false,
// Removable = true,
// Description = string.Empty,
// Type = "String"
//});
criteria.Add(new Criterion
{
Header = "Text Complexity",
Key = "TextComplexity",
Locked = false,
Removable = true,
Description = string.Empty,
Type = "String",
UIType = UIType.TextBox
});
criteria.Add(new Criterion
{
Header = "Reading Level",
Key = "ReadingLevel",
Locked = false,
Removable = true,
Description = string.Empty,
Type = "String",
UIType = UIType.TextBox
});
criteria.Add(new Criterion
{
Header = "Interactivity Type:",
Key = "Activity",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Description",
DataValueField = "Description",
Removable = true,
DataSource = dtActivity,
UIType = UIType.CheckBoxList,
ServiceUrl = null,
ServiceOnSuccess = null,
Dependencies = null
});
return criteria;
}
private void LoadCriteria()
{
var ctlReportCriteria = (Thinkgate.Controls.Reports.ReportCriteria)LoadControl("~/Controls/Reports/ReportCriteria.ascx");
ctlReportCriteria.ID = "ctlItemAnalysisCriteria";
if (Tile.TileParms.GetParm("CriteriaGUID") == null) return;
Guid = (string)Tile.TileParms.GetParm("CriteriaGUID");
guidValue.Value = Guid;
if (Session["Criteria_" + Guid] == null) return;
_reportCriteria = Guid == null ? null : (Criteria)Session["Criteria_" + Guid];
ctlReportCriteria.Guid = Guid;
ctlReportCriteria.ReloadReport += RemoteReportReload;
criteriaPlaceholder.Controls.Add(ctlReportCriteria);
}
private Criteria LoadSearchCriteria()
{
var criteria = new Criteria();
DataTable dtUserName = GetUserNames();
criteria.Add(new Criterion
{
Header = "Name",
Key = "UserFullName",
DataTextField = "UserFullName",
DataValueField = "UserFullName",
Type = "String",
DataSource = dtUserName,
Description = string.Empty,
Locked = false,
Removable = true,
UIType = UIType.DropDownList
});
DataTable dtUserId = GetUserIds();
criteria.Add(new Criterion
{
Header = "User ID",
Key = "UserID",
DataTextField = "UserID",
DataValueField = "UserID",
Type = "String",
DataSource = dtUserId,
Description = string.Empty,
Locked = false,
Removable = true,
UIType = UIType.DropDownList
});
DataTable dtRoleName = GetRoleNames();
criteria.Add(new Criterion
{
Header = "User Type",
Key = "RoleName",
DataTextField = "RoleName",
DataValueField = "RoleName",
Type = "String",
DataSource = dtRoleName,
Description = string.Empty,
Locked = false,
Removable = true,
UIType = UIType.CheckBoxList
});
DataTable dtCluster = Thinkgate.Base.Classes.SchoolMasterList.GetClustersForUser(SessionObject.LoggedInUser).ToDataTable("Cluster");
criteria.Add(new Criterion
{
Header = "Cluster",
Key = "Cluster",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Cluster",
DataValueField = "Cluster",
Removable = true,
DataSource = dtCluster,
UIType = UIType.CheckBoxList
});
DataTable dtSchoolType = Thinkgate.Base.Classes.SchoolMasterList.GetSchoolTypesForUser(SessionObject.LoggedInUser).ToDataTable("Type");
criteria.Add(new Criterion
{
Header = "School Type",
Key = "SchoolType",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Type",
DataValueField = "Type",
Removable = true,
DataSource = dtSchoolType,
UIType = UIType.CheckBoxList,
ServiceUrl = "../../Services/School.svc/GetAllSchoolsFromSchoolTypes",
ServiceOnSuccess = "getAllSchoolsFromSchoolTypes",
Dependencies = new[]
{
Criterion.CreateDependency("SchoolType", "SchoolTypes"),
Criterion.CreateDependency("School", "Schools")
}
});
// School
var schoolDataTable = new DataTable();
var schoolsForLooggedInUser = SchoolMasterList.GetSchoolsForUser(SessionObject.LoggedInUser);
schoolDataTable.Columns.Add("Name");
schoolDataTable.Columns.Add("ID");
foreach (var s in schoolsForLooggedInUser)
{
schoolDataTable.Rows.Add(s.Name, s.ID);
}
criteria.Add(new Criterion
{
Header = "School",
Key = "School",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Name",
DataValueField = "ID",
Removable = true,
DataSource = schoolDataTable,
UIType = UIType.DropDownList
});
return criteria;
}
private void LoadSearchCriteria()
{
_guid = Guid.NewGuid().ToString();
hiddenTxtBox.Text = _guid;
//Session["Criteria_" + _guid] = searchCriteria;
return;
var yearList = new List<string> { this._year };
var searchCriteria = new Criteria();
#region Criterion: Assessment
var assessmentTypesTable = Thinkgate.Base.Classes.Reports.GetTestTypesForStateReporting();
//CLEANUP: WSH - Need to strip out all of this old critiera stuff once the new fct and proficiency stuff is verified.
/*
* WSH: 8/20/12 - removed for Sarasota demo per meeting request -
var _assessmentType = (assessmentTypesTable.Rows.Count > 0) ? assessmentTypesTable.Rows[0]["Type"].ToString() : "";
foreach (DataRow row in assessmentTypesTable.Rows)
{
if (row["Type"].ToString() == "FCAT2")
{
_assessmentType = "FCAT2";
break;
}
}
*/
searchCriteria.Add(new Criterion()
{
Header = "Assessment",
Locked = false,
Key = "TestType",
Object = "",
Type = "String",
ReportStringKey = "TID",
ReportStringVal = "",
UIType = UIType.DropDownList,
DataSource = assessmentTypesTable,
DataTextField = "Type",
DataValueField = "Type",
IsRequired = true/*,
DefaultValue = _assessmentType*/
});
#endregion
#region Criterion: Year
var yearsTable = Thinkgate.Base.Classes.Reports.GetYearsForStateReporting();
// WSH: 8/20/12 - removed for Sarasota demo per meeting request - if (yearsTable.Rows.Count > 0) _year = yearsTable.Rows[0]["Year"].ToString();
searchCriteria.Add(new Classes.Criterion()
{
Key = "Year",
Header = "Year",
Type = "String",
Removable = true,
Locked = false,
IsHeader = true,
DataTextField = "Year",
DataValueField = "Year",
UIType = UIType.DropDownList,
DataSource = yearsTable,/*
DefaultValue = _year,*/
IsRequired = true,
ServiceUrl = ResolveUrl("~/Services/GradeSubjectCourse.svc/GetTeachersBySchools"),
ServiceOnSuccess = "getTeachers",
Dependencies = new[]
{
Criterion.CreateDependency("Grade", "Grades"),
Criterion.CreateDependency("School", "Schools"),
Criterion.CreateDependency("Teacher", "Teachers"),
Criterion.CreateDependency("Year", "Years")
}
});
#endregion
#region Criterion: Grade
searchCriteria.Add(new Criterion
{
Header = "Grade",
Key = "Grade",
Type = "String",
Description = string.Empty,
Locked = false,
DataSource = Thinkgate.Base.Classes.Reports.GetGradesForStateReporting(),
UIType = UIType.DropDownList,
Removable = true,
IsRequired = true,
ServiceUrl = ResolveUrl("~/Services/GradeSubjectCourse.svc/GetSchoolsAndTeachersByGrade"),
ServiceOnSuccess = "getSchoolsAndTeachers",
Dependencies = new[]
{
Criterion.CreateDependency("Grade", "Grades"),
Criterion.CreateDependency("School", "Schools"),
Criterion.CreateDependency("Teacher", "Teachers"),
Criterion.CreateDependency("Year", "Years")
}
});
#endregion
#region Criterion: Subject
searchCriteria.Add(new Criterion
{
Header = "Subject",
Key = "Subject",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Subject",
DataValueField = "Subject",
Removable = true,
DataSource = Thinkgate.Base.Classes.Reports.GetSubjectsForStateReporting(),
UIType = UIType.DropDownList,
IsRequired = true
});
#endregion
#region Criterion: School
var schoolDataTable = new System.Data.DataTable();
var schoolsForLoggedInUser = SchoolMasterList.GetSchoolsForUser(SessionObject.LoggedInUser);
schoolsForLoggedInUser = schoolsForLoggedInUser.FindAll(s => s.Grades.IndexOf("03") > -1);
schoolDataTable.Columns.Add("Name");
schoolDataTable.Columns.Add("ID");
foreach (var s in schoolsForLoggedInUser)
{
schoolDataTable.Rows.Add(s.Name, s.ID);
}
searchCriteria.Add(new Criterion
{
Header = "School",
Key = "School",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Name",
DataValueField = "ID",
Removable = true,
DataSource = schoolDataTable,
UIType = UIType.DropDownList,
ServiceUrl = ResolveUrl("~/Services/GradeSubjectCourse.svc/GetTeachersBySchools"),
ServiceOnSuccess = "getTeachers",
Dependencies = new[]
{
Criterion.CreateDependency("Grade", "Grades"),
Criterion.CreateDependency("School", "Schools"),
Criterion.CreateDependency("Teacher", "Teachers"),
Criterion.CreateDependency("Year", "Years")
}
});
#endregion
#region Criterion: Teacher
var teachers = new System.Data.DataTable();//Base.Classes.Teacher.GetTeachersBySchoolsDT(schoolsForLoggedInUser.Select(s => s.ID).ToList());
teachers.Columns.Add("ID");
teachers.Columns.Add("TeacherName");
searchCriteria.Add(new Criterion
{
Header = "Teacher",
Key = "Teacher",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "TeacherName",
DataValueField = "ID",
Removable = true,
DataSource = teachers,
UIType = UIType.DropDownList
});
#endregion
#region Criterion: Class
var classCourseList = Thinkgate.Base.Classes.CourseMasterList.GetClassCoursesForUser(SessionObject.LoggedInUser);
List<Int32> schoolIDs = new List<int>();
schoolIDs.Add(0);
var classesForLooggedInUser = Thinkgate.Base.Classes.Class.SearchClasses(classCourseList, null, schoolIDs, "");
searchCriteria.Add(new Criterion
{
Header = "Class",
Key = "Class",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "ClassName",
DataValueField = "ClassID",
Removable = true,
DataSource = classesForLooggedInUser,
UIType = UIType.DropDownList
});
#endregion
#region Criterion: Demographics
searchCriteria.Add(new Criterion()
{
Header = "Demographics",
Key = "Demographics",
Type = "String",
Description = string.Empty,
Locked = false,
UIType = UIType.Demographics
});
#endregion
SearchParms = new SearchParms();
SearchParms.AddParm("reportCriteria", searchCriteria);
_guid = Guid.NewGuid().ToString();
hiddenTxtBox.Text = _guid;
Session["Criteria_" + _guid] = searchCriteria;
}
protected void RemoteReportReload(object sender, EventArgs e)
{
Session["ItemAnalysisData_" + AnalysisType + "_" + Guid] = null;
if (Session["Criteria_" + Guid] == null) return;
_reportCriteria = Guid == null ? null : (Criteria)Session["Criteria_" + Guid];
LoadReport();
}
private Criteria LoadSearchCriteria()
{
var criteria = new Criteria();
#region Criterion: Cluster
DataTable dtCluster = Thinkgate.Base.Classes.SchoolMasterList.GetClustersForUser(SessionObject.LoggedInUser).ToDataTable("Cluster");
criteria.Add(new Criterion
{
Header = "Cluster",
Key = "Cluster",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Cluster",
DataValueField = "Cluster",
Removable = true,
DataSource = dtCluster,
UIType = UIType.CheckBoxList
});
#endregion
#region Criterion: School type
var schoolTypeDataTable = new DataTable();
var schoolTypesForLoggedInUser = SchoolTypeMasterList.GetSchoolTypeListForUser(SessionObject.LoggedInUser);
schoolTypeDataTable.Columns.Add("SchoolType");
foreach (var s in schoolTypesForLoggedInUser)
{
schoolTypeDataTable.Rows.Add(s);
}
criteria.Add(new Criterion
{
Header = "School Type",
Key = "SchoolType",
Type = "String",
Description = string.Empty,
Locked = false,
Removable = true,
DataSource = schoolTypeDataTable,
UIType = UIType.CheckBoxList,
DataTextField = "SchoolType",
DataValueField = "SchoolType",
DefaultValue = _selectedSchoolType,
ServiceUrl = "../../Services/School.svc/GetAllSchoolsFromSchoolTypes",
ServiceOnSuccess = "getAllSchoolsFromSchoolTypes",
Dependencies = new[]
{
Criterion.CreateDependency("SchoolType", "SchoolTypes"),
Criterion.CreateDependency("School", "Schools")
}
});
#endregion
#region Criterion: School
var schoolDataTable = new DataTable();
var schoolsForLooggedInUser = SchoolMasterList.GetSchoolsForUser(SessionObject.LoggedInUser);
var result = schoolsForLooggedInUser.Select(e => new ComparerSchools { Name = e.Name, ID = e.ID }).ToList();
result.Sort(new AlphanumComparator());
schoolDataTable.Columns.Add("Name");
schoolDataTable.Columns.Add("ID");
foreach (var s in result)
{
schoolDataTable.Rows.Add(s.Name, s.ID);
}
criteria.Add(new Criterion
{
Header = "School",
Key = "School",
Type = "String",
Description = string.Empty,
Locked = false,
UIType = UIType.DropDownList,
DataSource = schoolDataTable,
DataTextField = "Name",
DataValueField = "ID",
Removable = true
});
#endregion
#region Criterion: School ID
DataTable dtSchoolId = Thinkgate.Base.Classes.SchoolMasterList.GetSchoolIdsForUser(SessionObject.LoggedInUser).ToDataTable("SchoolID");
criteria.Add(new Criterion
{
Header = "School ID",
Key = "SchoolID",
Type = "String",
Description = string.Empty,
Locked = false,
Removable = true,
Object = Category,
UIType = UIType.DropDownList,
DataSource = dtSchoolId,
DataTextField = "SchoolID",
DataValueField = "SchoolID"
});
#endregion
return criteria;
}
private void LoadCriteria()
{
_reportCriteria = Guid == null ? null : (Criteria)Session["Criteria_" + Guid];
}
private void LoadCriteria()
{
var ctlReportCriteria = (Thinkgate.Controls.Reports.ReportCriteria)LoadControl("~/Controls/Reports/ReportCriteria.ascx");
ctlReportCriteria.ID = "ctlAtRiskStandardCriteria";
if (Tile.TileParms.GetParm("CriteriaGUID") == null) return;
Guid = (!string.IsNullOrEmpty(_guidforPDFView)) ? _guidforPDFView : (string)Tile.TileParms.GetParm("CriteriaGUID");
if (Session["Criteria_" + Guid] == null) return;
ctlReportCriteria.Guid = Guid;
ctlReportCriteria.ReloadReport += RemoteReportReload;
criteriaPlaceholder.Controls.Add(ctlReportCriteria);
_level = Request.QueryString["level"];
_levelID = Request.QueryString["levelID"];
_testID = Request.QueryString["testID"];
_parent = Request.QueryString["parent"];
_parentID = Request.QueryString["parentID"];
_reportCriteria = (Criteria)Session["Criteria_" + Guid];
_criteriaOverrides = ((Criteria)_reportCriteria).GetCriteriaOverrideString();
}
protected void RemoteReportReload(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(Guid)) KillReport("No GUID for report criteria. <br/> Contact support.");
if (Session["Criteria_" + Guid] == null) KillReport("Criteria session object lost. <br/> Contact support.");
_reportCriteria = (Criteria)Session["Criteria_" + Guid];
_criteriaOverrides = ((Criteria)_reportCriteria).GetCriteriaOverrideString();
LoadReport();
}
private Criteria LoadSearchCriteria()
{
var criteria = new Criteria();
#region Criterion: Grade
var gradesDT = new DataTable();
var gradesByCurrCourses = CourseMasterList.GetClassCoursesForUser(SessionObject.LoggedInUser).GetGradeList();
gradesDT.Columns.Add("Grade");
foreach (var g in gradesByCurrCourses)
{
gradesDT.Rows.Add(g.DisplayText);
}
criteria.Add(new Criterion
{
Header = "Grade",
Key = "Grade",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Grade",
DataValueField = "Grade",
Removable = true,
DataSource = gradesDT,
UIType = UIType.CheckBoxList,
ServiceUrl = "../../Services/GradeSubjectCourse.svc/GetClassSubjectsAndCourses",
ServiceOnSuccess = "getClassGradesSubjectsAndCourses",
Dependencies = new[]
{
Criterion.CreateDependency("Grade", "Grades"),
Criterion.CreateDependency("Subject", "Subjects"),
Criterion.CreateDependency("ClassCourses", "Courses")
}
});
#endregion
#region Criterion: Subject
var subjectsDT = new DataTable();
var subjectsByCurrCourses = CourseMasterList.GetClassCoursesForUser(SessionObject.LoggedInUser).GetSubjectList();
subjectsDT.Columns.Add("Subject");
foreach (var s in subjectsByCurrCourses)
{
subjectsDT.Rows.Add(s.DisplayText);
}
criteria.Add(new Criterion
{
Header = "Subject",
Key = "Subject",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Subject",
DataValueField = "Subject",
Removable = true,
DataSource = subjectsDT,
UIType = UIType.CheckBoxList,
ServiceUrl = "../../Services/GradeSubjectCourse.svc/GetClassCourses",
ServiceOnSuccess = "getClassCoursesFromSubjects",
Dependencies = new[]
{
Criterion.CreateDependency("Grade", "Grades"),
Criterion.CreateDependency("Subject", "Subjects"),
Criterion.CreateDependency("ClassCourses", "Courses")
}
});
#endregion
#region Criterion: Course
var curriculumCourses = CourseMasterList.GetClassCoursesForUser(SessionObject.LoggedInUser);
var courseDt = new DataTable();
courseDt.Columns.Add("CourseName");
courseDt.Columns.Add("CourseID");
foreach (var c in curriculumCourses)
{
courseDt.Rows.Add(c.Grade + "-" + c.CourseName, c.ID);
}
criteria.Add(new Criterion
{
Header = "Course",
Key = "ClassCourses",
DataSource = courseDt,
DataTextField = "CourseName",
DataValueField = "CourseID",
Locked = false,
Removable = true,
Description = string.Empty,
Type = "String",
UIType = UIType.DropDownList
});
#endregion
#region Criterion: Cluster
DataTable dtCluster = Thinkgate.Base.Classes.SchoolMasterList.GetClustersForUser(SessionObject.LoggedInUser).ToDataTable("Cluster");
criteria.Add(new Criterion
{
Header = "Cluster",
Key = "Cluster",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Cluster",
DataValueField = "Cluster",
Removable = true,
DataSource = dtCluster,
UIType = UIType.CheckBoxList
});
#endregion
#region Criterion: School type
var schoolTypeDataTable = new DataTable();
var schoolTypesForLoggedInUser = SchoolTypeMasterList.GetSchoolTypeListForUser(SessionObject.LoggedInUser);
schoolTypeDataTable.Columns.Add("SchoolType");
foreach (var s in schoolTypesForLoggedInUser)
{
schoolTypeDataTable.Rows.Add(s);
}
criteria.Add(new Criterion
{
Header = "School Type",
Key = "SchoolType",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "SchoolType",
DataValueField = "SchoolType",
DefaultValue = _selectedSchoolType,
Removable = true,
DataSource = schoolTypeDataTable,
UIType = UIType.CheckBoxList,
ServiceUrl = "../../Services/School.svc/GetAllSchoolsFromSchoolTypes",
ServiceOnSuccess = "getAllSchoolsFromSchoolTypes",
Dependencies = new[]
{
Criterion.CreateDependency("SchoolType", "SchoolTypes"),
Criterion.CreateDependency("School", "Schools")
}
});
#endregion
#region Criterion: School
var schoolDataTable = new DataTable();
var schoolsForLooggedInUser = SchoolMasterList.GetSchoolsForUser(SessionObject.LoggedInUser);
schoolDataTable.Columns.Add("Name");
schoolDataTable.Columns.Add("ID", typeof(Int32));
foreach (var s in schoolsForLooggedInUser)
{
schoolDataTable.Rows.Add(s.Name, s.ID);
}
criteria.Add(new Criterion
{
Header = "School",
Key = "School",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Name",
DataValueField = "ID",
Removable = true,
DataSource = schoolDataTable,
UIType = UIType.CheckBoxList
});
#endregion
#region Criterion: Teacher
criteria.Add(new Criterion
{
Header = "Teacher",
Key = "AssessmentAssignmentTeacher",
//DataTextField = "CourseName",
//DataValueField = "CourseID",
Locked = false,
Removable = true,
Description = string.Empty,
Type = "String",
UIType = UIType.TextBox
});
#endregion
#region Criterion: Semester
criteria.Add(new Criterion
{
Header = "Semester",
Key = "Semester",
Type = "String",
Description = string.Empty,
Locked = false,
Removable = true,
DataTextField = "Semester",
DataValueField = "Semester",
DataSource = Thinkgate.Base.Classes.Semester.GetSemesterListForDropDown(),
UIType = UIType.DropDownList
});
#endregion
#region Criterion: Period
criteria.Add(new Criterion
{
Header = "Period",
Key = "Period",
Type = "String",
Description = string.Empty,
Locked = false,
DataTextField = "Period",
DataValueField = "Period",
Removable = true,
DataSource = Thinkgate.Base.Classes.PeriodMasterList.GetPeriodDataTableForDropDown("Period"),
UIType = UIType.CheckBoxList
});
#endregion
#region Criterion: Section
criteria.Add(new Criterion
{
Header = "Section",
Key = "Section",
Type = "String",
Description = string.Empty,
Locked = false,
Removable = true,
UIType = UIType.TextBox
});
#endregion
#region Criterion: Block
criteria.Add(new Criterion
{
Header = "Block",
Key = "Block",
//DataTextField = "CourseName",
//DataValueField = "CourseID",
Locked = false,
Removable = true,
Description = string.Empty,
Type = "String",
UIType = UIType.TextBox
});
#endregion
return criteria;
}
