public static string ValidateWorksheetHistory(string SelectedItems) { string Counter="0"; string DocumentID = Convert.ToString(System.Web.HttpContext.Current.Session["docId"]); Thinkgate.Base.DataAccess.dtGeneric_Int standardids = new Base.DataAccess.dtGeneric_Int(); string[] selitems = SelectedItems.Split(','); for (var i = 0; i < selitems.Length; i++) { int nodeid; string docEntry = selitems[i]; if (Int32.TryParse(docEntry, out nodeid)) { standardids.Add(nodeid); } } DataTable dt = CompetencyWorkSheet.ValidateWorksheetHistory(DocumentID, standardids); ; if (dt != null) Counter = Convert.ToString(dt.Rows[0][0]); return Counter; }
protected void cmbStandardLevel_ItemsRequested(object sender, RadComboBoxItemsRequestedEventArgs e) { int WorksheetId = 0; string StandardSet = e.Context["StandardSet"].ToString(); if (e.Context["StandardList"] != null) { selectedlist = Convert.ToInt32(e.Context["StandardList"].ToString()); } else { selectedlist = 0; } Base.DataAccess.dtGeneric_Int _standardids = new Base.DataAccess.dtGeneric_Int(); if (selectedlist == 9)//for competency list option only { var CompetencyId = 0; Base.DataAccess.dtGeneric_Int _standardid = new Base.DataAccess.dtGeneric_Int(); if (e.Context["ListSelection"] != null) { CompetencyId = Convert.ToInt32(e.Context["ListSelection"].ToString()); } else { CompetencyId = 0; } _standardid.Add(Convert.ToInt32(CompetencyId)); DataTable dsstandard = CompetencyWorkSheet.GetCurrStabdardsById_Kentico(_standardid, true); foreach (DataRow dr in dsstandard.Rows) { _standardids.Add(Convert.ToInt32(dr[0])); } } else { if (e.Context["ListSelection"] != null && e.Context["ListSelection"] != string.Empty) { WorksheetId = Convert.ToInt32(e.Context["ListSelection"].ToString()); } else { WorksheetId = 0; } } DataTable tmpdatatable = CriteriaHelper.GetStandardLevelbyStandardList(_standardids, StandardSet, WorksheetId); cmbStandardLevel.DataSource = tmpdatatable; cmbStandardLevel.DataBind(); }
private SelectedCriteria GetCriteriaControlValues() { var criteriaController = Master.CurrentCriteria(); SelectedCriteria selectedCriteria = new SelectedCriteria(); //ViewBy selectedCriteria.SelectedViewBy = criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("ViewBy").Select(x => x.Text).FirstOrDefault(); //School selectedCriteria.SelectedSchoolId = DataIntegrity.ConvertToInt(criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("School").Select(x => x.Value).FirstOrDefault()); selectedCriteria.SelectedSchoolName = criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("School").Select(x => x.Value).FirstOrDefault(); //Teacher selectedCriteria.SelectedTeacher = criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("TeacherName").Select(x => x.Value).FirstOrDefault(); //Class selectedCriteria.SelectedClass = criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("Class").Select(x => x.Value).FirstOrDefault(); //Student selectedCriteria.SelectedStudent = criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("Student").Select(x => x.Value).FirstOrDefault(); //StandardLevel selectedCriteria.StandardLevel = criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("StandardLevel").Select(x => x.Value).FirstOrDefault(); //Demographics selectedCriteria.SelectedDemographics = criteriaController.ParseCriteria<E3Criteria.AutoCompleteCriteriaControls.ACDropDownList.ValueObject>("Demographic").Select(x => x.Value).FirstOrDefault(); //Group; selectedCriteria.SelectedGroup = criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("Group").Select(x => x.Value).FirstOrDefault(); //Worksheet List string selectedListId = "0"; if (criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("ListSelection").Select(x => x.Value).FirstOrDefault() != null) { selectedListId = criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("ListSelection").Select(x => x.Value).FirstOrDefault(); } else { selectedListId = criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("WorksheetSelection").Select(x => x.Value).FirstOrDefault(); } selectedCriteria.SelectedWorksheet = selectedListId; //StandardList selectedCriteria.StandardList = criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("StandardList").Select(x => x.Value).FirstOrDefault(); selectedCriteria.StandardSet = criteriaController.ParseCriteria<E3Criteria.AutoCompleteCriteriaControls.GetGradeSubjectCourseStandard.ValueObject>("StandardSet").Select(x => x.StandardSet).FirstOrDefault(); selectedCriteria.StandardId = criteriaController.ParseCriteria<E3Criteria.AutoCompleteCriteriaControls.GetGradeSubjectCourseStandard.ValueObject>("StandardSet").Select(x => x.StandardId).FirstOrDefault(); //if (criteriaController.CriteriaNodes[2].Values[0].Value != null && criteriaController.CriteriaNodes[2].Values[0].Value.ContainsKey("Grades")) //{ selectedCriteria.Grade = criteriaController.ParseCriteria<E3Criteria.AutoCompleteCriteriaControls.GetGradeSubjectCourseStandard.ValueObject>("StandardSet").Select(x => x.Grades).FirstOrDefault();//criteriaController.ParseCriteria<E3Criteria.AutoCompleteCriteriaControls.GetGradeSubjectCourseStandard.ValueObject>("Grades").Select(x => x.Grades).FirstOrDefault(); //} //if (criteriaController.CriteriaNodes[2].Values[0].Value != null && criteriaController.CriteriaNodes[2].Values[0].Value.ContainsKey("Subjects")) //{ selectedCriteria.Subject = criteriaController.ParseCriteria<E3Criteria.AutoCompleteCriteriaControls.GetGradeSubjectCourseStandard.ValueObject>("StandardSet").Select(x => x.Subjects).FirstOrDefault(); //criteriaController.ParseCriteria<E3Criteria.AutoCompleteCriteriaControls.GetGradeSubjectCourseStandard.ValueObject>("Subjects").Select(x => x.Subjects).FirstOrDefault(); //} //if (criteriaController.CriteriaNodes[2].Values[0].Value != null && criteriaController.CriteriaNodes[2].Values[0].Value.ContainsKey("Courses")) //{ selectedCriteria.Course = criteriaController.ParseCriteria<E3Criteria.AutoCompleteCriteriaControls.GetGradeSubjectCourseStandard.ValueObject>("StandardSet").Select(x => x.Courses).FirstOrDefault(); //} //TODO UNCOMMENT AND VERIFY BELOW CODE ONCE STANDARD LIST IS WORKING //selectedCriteria.StandardList = criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("ListSelection").Select(x => x.Value).FirstOrDefault(); selectedlist = Convert.ToInt32(criteriaController.ParseCriteria<E3Criteria.DropDownList.ValueObject>("StandardList").Select(x => x.Value).FirstOrDefault()); if (selectedlist == 9)//for competency list option only { Base.DataAccess.dtGeneric_Int _standardids = new Base.DataAccess.dtGeneric_Int(); _standardids.Add(Convert.ToInt32(selectedCriteria.SelectedWorksheet)); DataTable dsstandard = CompetencyWorkSheet.GetCurrStabdardsById_Kentico(_standardids, true); var stdListFromCompetencyList = ""; foreach (DataRow dr in dsstandard.Rows) { stdListFromCompetencyList += "_" + dr[0].ToString(); } if (!string.IsNullOrEmpty(stdListFromCompetencyList)) { selectedCriteria.StandardId = stdListFromCompetencyList.Substring(1); } selectedCriteria.SelectedWorksheet = null; } /* Created Date Range */ foreach (var val in criteriaController.ParseCriteria<DateRange.ValueObject>("DateRange")) { if (val.Type == "Start") { selectedCriteria.StartDate = val.Date; } else { selectedCriteria.EndDate = val.Date; } } return selectedCriteria; }
protected Thinkgate.Base.DataAccess.dtGeneric_Int GetStandardsbyNodeId(int nodeid) { var lststandards = new Thinkgate.Base.DataAccess.dtGeneric_Int(); string expression = string.Empty; DataTable dsstandard; try { Base.DataAccess.dtGeneric_Int _standardids = new Base.DataAccess.dtGeneric_Int(); _standardids.Add(nodeid); dsstandard = CompetencyWorkSheet.GetCurrStabdardsById_Kentico(_standardids, true); } catch (Exception ex) { throw new Exception(String.Format("The Query did not give any results {0}\n{1}", expression, ex.Message)); } if (dsstandard != null) { foreach (DataRow row in dsstandard.Rows) { lststandards.Add(Standpoint.Core.Utilities.DataIntegrity.ConvertToInt(row[0])); } } return lststandards; }