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; }
protected void SearchBtnClick(object sender, ImageClickEventArgs e) { var searchParms = new SearchParms(); if (!String.IsNullOrEmpty(txtName.Text)) { searchParms.AddParm("studentName", txtName.Text); } }
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 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; }