public void FilterParameter001() { // Arrange var expected = JObject.Parse(@" { ""filter"": [ ""_id_:X"", ""_score_:Y"" ] }"); string actual; var jObject = new JObject(); var expressionCache = new ExpressionCache <TestDocument>(); var expressionBuilder = new ExpressionBuilder <TestDocument>(expressionCache); var parameter1 = new FilterParameter <TestDocument>(expressionBuilder); var parameter2 = new FilterParameter <TestDocument>(expressionBuilder); parameter1.Configure(new Single <TestDocument>(q => q.Id, "X")); parameter2.Configure(new Single <TestDocument>(q => q.Score, "Y")); // Act parameter1.Execute(jObject); parameter2.Execute(jObject); actual = jObject.ToString(); // Assert Assert.Equal(expected.ToString(), actual); }
public void FilterQueryParameter001() { // Arrange var container = new List <string>(); var solrOptions = new SolrExpressOptions(); var solrConnection = new FakeSolrConnection <TestDocument>(); var expressionBuilder = new ExpressionBuilder <TestDocument>(solrOptions, solrConnection); expressionBuilder.LoadDocument(); var parameter1 = new FilterParameter <TestDocument>(); parameter1.Query = new SearchQuery <TestDocument>(expressionBuilder).Field(q => q.Id).AddValue("X"); var parameter2 = new FilterParameter <TestDocument>(); parameter2.Query = new SearchQuery <TestDocument>(expressionBuilder).Field(q => q.Score).AddValue("Y"); // Act parameter1.Execute(); parameter1.AddResultInContainer(container); parameter2.Execute(); parameter2.AddResultInContainer(container); // Assert Assert.Equal(2, container.Count); Assert.Equal("fq=id:\"X\"", container[0]); Assert.Equal("fq=score:\"Y\"", container[1]); }
public IActionResult GetClassworkResults([FromBody] FilterParameter filterParam) { QueryParameter qp = ParseQueryString(); var records = _service.GetClassworkSummary(filterParam.StartDate, filterParam.EndDate); return(Ok(records)); }
public JsonResult FilterContactsByAccount(FilterParameter searchParam) { var userViewModel = new List <UserViewModel>(); var userModel = _accountService.GetContactList(searchParam); Mapper.Map(userModel, userViewModel); return(Json(userViewModel, JsonRequestBehavior.AllowGet)); }
public JsonResult FilterAccounts(FilterParameter searchParam) { var accountModel = new List <AccountModel>(); var accountViewModel = new List <AccountViewModel>(); accountModel = _accountService.AccountFilter(searchParam); Mapper.Map(accountModel, accountViewModel); return(Json(new { Success = true, Accounts = accountViewModel, Message = "Successful" }, JsonRequestBehavior.AllowGet)); }
private static bool DecideFilterDisplay(FilterParameter filterParameter) { return(filterParameter.Race != -1 || filterParameter.Gender != -1 || filterParameter.Hispanic != null || filterParameter.FrlIndicator != null || filterParameter.IEPIndicator != null || filterParameter.LEPIndicator != null); }
public ActionResult SummaryReportById(int teacherId, bool viewMeetExceedSummary = true) { try { SetNavigationLinksUrl(); SetViewBag(viewMeetExceedSummary); ViewBag.SummaryLink = "SummaryReportById"; ViewBag.TeacherFilter = teacherId; bool unAuthorizedRequest = false; SiteUser su = ((SiteUser)Session["SiteUser"]); ModelServices modelServices = new ModelServices(); StudentService studentService = new StudentService(su, entities); int defaultDistrict = su.Districts[0].Id; int schoolYearId = modelServices.SchoolYearId(); int[] userSchools = modelServices.getSchoolsByUserId(su.EdsUserId).ToArray(); var dropdownTeachers = modelServices.TeacherDropDownDataBySchoolAndYear(userSchools, schoolYearId, defaultDistrict); unAuthorizedRequest = dropdownTeachers.Where(x => x.Id == teacherId).Count() == 0 ? true : false; if (unAuthorizedRequest) { return(RedirectToAction("AccessDenied", "Error")); } TIRSummaryModel data = new TIRSummaryModel(); data.SchoolYear = modelServices.SchoolYearDescription(); data.DropDown = new DropDownData(); data.DropDown.Year = new YearDropDown(modelServices.SchoolYearDropDownData()); data.DropDown.Year.SelectedYear = schoolYearId; data.DropDown.District = new DistrictDropDown(modelServices.DistrictDropDownDataByUser(su.EdsUserId)); data.DropDown.Teacher = new TeacherDropDown(dropdownTeachers); data.DropDown.Teacher.SelectedTeacher = teacherId; data.DropDown.Race = new RaceDropDown(modelServices.DropDownDataForRace(), true); data.DropDown.Gender = new GenderDropDown(modelServices.DropDownDataForGender(), true); data.DropDown.SchoolClass = new ClassDropDown(modelServices.GetClassesByTeacher(schoolYearId, new[] { teacherId })); var filterParameter = new FilterParameter { ClassId = classDefaultValue, Teacher = teacherId, School = userSchools.First(), Year = schoolYearId, SchoolYear = data.SchoolYear }; data.SummaryList = modelServices.GetSummaryReport(filterParameter); data.DropDown.School = new SchoolDropDown(modelServices.GetSchoolDropDownData(su.EdsUserId, schoolYearId)); var reportFilterViewModel = ReportsFilterHelper.PopulateReportFilterViewModel(filterParameter, modelServices, su); ViewBag.ReportFilters = reportFilterViewModel; return(View("SummaryReport", data)); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return(View("GeneralError")); } }
public FramebufferTextureSpecification(TextureFormat format, FilterParameter filter = FilterParameter.Linear) { Format = format; Filter = filter; Index = null; dontDraw = false; }
public void Initialize(Object passedObj) { FilterParameter filterParam = passedObj as FilterParameter; if (filterParam != null) { dockPanel = filterParam.dockPanel; Width = filterParam.Width; Height = filterParam.Height; m_History = filterParam.History; if (filterParam.SysConfig != null) { m_defaultDensityDefaultValue = filterParam.SysConfig.DensityAlarmDefaultValue; m_defaultDensitySetOnCaseOpen = filterParam.SysConfig.DensityAlarmSetOnCaseOpen; m_profile = filterParam.SysConfig.Profile; } else { m_defaultDensityDefaultValue = 0.0; m_defaultDensitySetOnCaseOpen = false; } HistoryFilter filter = new HistoryFilter(); filter.name = m_Name; if (m_defaultDensitySetOnCaseOpen) { if (m_profile != null && m_profile.DensityAlarmValue != 0.0) { filter.parameter = m_profile.DensityAlarmValue.ToString(); } else { filter.parameter = m_defaultDensityDefaultValue.ToString(); } } else { filter.parameter = "0.0"; } m_History.SetFirstStep(filter); m_ValueSlider.IsEnabled = false; if (m_profile != null && m_profile.DensityAlarmValue != 0.0) { m_ValueSlider.Value = m_profile.DensityAlarmValue * 100.0; } else { m_ValueSlider.Value = m_defaultDensityDefaultValue * 100.0; } m_ValueSlider.IsEnabled = true; m_ValTextBox.Text = (m_ValueSlider.Value).ToString("F0") + " %"; } }
private static bool DecideFilterDisplay(FilterParameter filterParameter) { return (filterParameter.Race != -1 || filterParameter.Gender != -1 || filterParameter.Hispanic != null || filterParameter.FrlIndicator != null || filterParameter.IEPIndicator != null || filterParameter.LEPIndicator != null); }
public void FilterParameter002() { // Arrange var expressionCache = new ExpressionCache <TestDocument>(); var expressionBuilder = new ExpressionBuilder <TestDocument>(expressionCache); var parameter = new FilterParameter <TestDocument>(expressionBuilder); // Act / Assert Assert.Throws <ArgumentNullException>(() => parameter.Configure(null)); }
public JsonResult FilterProducts(FilterParameter searchParam) { var productViewModel = new List <ProductViewModel>(); var products = _productService.FilterProducts(searchParam); Mapper.Map(products, productViewModel); return(Json(new { Success = true, Products = productViewModel, Message = "Success" }, JsonRequestBehavior.AllowGet)); }
public async Task <IActionResult> AllTeacherList(FilterParameter model) { int count; TeacherListModel teacherModel1 = new TeacherListModel(); teacherModel1.TeacherModel = _classBookService.AllTeacherListModel(model, out count, model.PageIndex); teacherModel1.Pager = new Pager(count, model.PageIndex); var result = await _viewRenderService.RenderToStringAsync("_TeacherListPartialView", teacherModel1); return(Content(result)); }
public async Task <IActionResult> AllCareerExpertList(FilterParameter model) { int count; CareerExpertListModel classmodel1 = new CareerExpertListModel(); classmodel1.CareerExpertModel = _classBookService.AllCareerExpertListModel(model, out count, model.PageIndex); classmodel1.Pager = new Pager(count, model.PageIndex); var result = await _viewRenderService.RenderToStringAsync("_CareerExpertListPartialView", classmodel1); return(Content(result)); }
public IEnumerable <IDBObject> GetRecords(string searchSubstring) { // Блок отвечающий за создание массива объектов FilterParameter FilterParameter[] parameters = new FilterParameter[1]; parameters[0] = new FilterParameter() { Name = "@searchSubstring", Type = FilterParameterType.String, Value = searchSubstring }; var result = DataReader.ExecQuery <Person>(storedProcedureName, parameters); return(result); }
public IActionResult AllCareerExpertList() { int count = 0; CareerExpertListModel model = new CareerExpertListModel(); model.States = _classBookModelFactory.PrepareStateDropDown(); model.ClassesList = _classBookModelFactory.PrepareClassesDropDown(); model.TeacherList = _classBookModelFactory.PrepareTeacherDropDown(); FilterParameter filterParameterModel = new FilterParameter(); model.CareerExpertModel = _classBookService.AllCareerExpertListModel(filterParameterModel, out count, 1); model.Pager = new Pager(count, 1); return(View(model)); }
public void AddEntitySetCache() { CacheContainer.Current.LoadCache(); List <User> users = CacheContainer.Current.GetObjects <User>(); FilterParameter p1 = FilterParameter.CreateFilterParamater <User>("ID", 0); FilterParameter p2 = FilterParameter.CreateFilterParamater <User>("Name", "Name1", FilterCondition.Like); IList filterUsers = CacheContainer.Current.GetObjectsWithFilter <User>(p2); List <BfCodeInfo> codes = CacheContainer.Current.GetObjects <BfCodeInfo>(); FilterParameter pc2 = FilterParameter.CreateFilterParamater <BfCodeInfo>("CODE", "2", FilterCondition.Like); IList filterCodes = CacheContainer.Current.GetObjectsWithFilter <BfCodeInfo>(pc2); }
private List <object> CreateLabResultsFilter(string personId, string[] labResults) { Filter filter = new Filter(); string conditions = "lower(observationidentifiertext) in ("; string inCondition = ""; for (int srIndex = 0; srIndex < labResults.Length; srIndex++) { inCondition = $"{inCondition},'{labResults[srIndex].ToLower().Replace("_"," ")}'"; } inCondition = inCondition.TrimStart(','); conditions = $"{conditions} {inCondition}) and person_id = @person_id"; filter.filterClause = conditions; Filters filters = new Filters(); filters.filters.Add(filter); FilterParameter parameter = new FilterParameter(); parameter.paramName = "person_id"; parameter.paramValue = personId; FilterParameters filterParameters = new FilterParameters(); filterParameters.filterparams.Add(parameter); SelectStatement selectStatement = new SelectStatement(); selectStatement.selectstatement = "SELECT distinct on (observationidentifiertext) observationidentifiertext, *"; OrderByGroupByStatement orderByGroupByStatement = new OrderByGroupByStatement(); orderByGroupByStatement.ordergroupbystatement = "ORDER BY observationidentifiertext, observationdatetime DESC"; List <object> body = new List <object>(); body.Add(filters); body.Add(filterParameters); body.Add(selectStatement); body.Add(orderByGroupByStatement); return(body); }
public IActionResult AllTeacherList() { int count = 0; TeacherListModel model = new TeacherListModel(); model.States = _classBookModelFactory.PrepareStateDropDown(); model.BoardList = _classBookModelFactory.PrepareBoardDropDown(); model.MediumList = _classBookModelFactory.PrepareMediumDropDown(); model.StandardList = _classBookModelFactory.PrepareStandardDropDown(); FilterParameter filterParameterModel = new FilterParameter(); model.TeacherModel = _classBookService.AllTeacherListModel(filterParameterModel, out count, 1); model.Pager = new Pager(count, 1); return(View(model)); }
/// <summary> /// 設定画面表示メソッド /// </summary> /// <returns></returns> public void Setting() { FilterParam = new FilterParameter(3); if (SettingForm == null) { SettingForm = new FilterSetting(FilterParam); } else if (SettingForm.IsDisposed) { SettingForm = new FilterSetting(FilterParam); } SettingForm.Show(); return; }
public override object ReadJson(JsonReader reader, Type objectType, object existingValue, JsonSerializer serializer) { try { JObject jObject = JObject.Load(reader); FilterParameter fp = new FilterParameter(); Regex rx = new Regex("and'(?<and>[\\w\\d]*)'or'(?<or>[\\w\\d]*)'"); Match m = rx.Match(jObject.Properties().ElementAt(0).Name); if (m != null && m.Success) { fp.AndGroupName = m.Groups["and"].Value; fp.OrGroupName = m.Groups["or"].Value; } rx = new Regex("^(?<colname>[^\\s]*)\\s(?<op>[^\\s]*)\\s(?<valtype>[\\d\\w\\.]*)'(?<valval>.*)'$"); m = rx.Match((string)jObject.Properties().ElementAt(0).Value); if (m != null && m.Success) { fp.ColumnName = m.Groups["colname"].Value; fp.Operator = (OperatorType)Enum.Parse(typeof(OperatorType), m.Groups["op"].Value); Type targetType = Type.GetType("System." + m.Groups["valtype"].Value); object o = JsonConvert.DeserializeObject(m.Groups["valval"].Value); if (o != null && targetType != null && o.GetType() != targetType) { if (targetType == typeof(Guid) && o.GetType() == typeof(string)) { o = new Guid((string)o); } else { o = Convert.ChangeType(o, targetType); } } fp.Value = o; } return fp; } catch (Exception ex) { throw ex; } }
public static ReportFilterViewModel PopulateReportFilterViewModel(FilterParameter filterParameter, ModelServices modelService, SiteUser siteUser) { string defaultText = "All"; var reportFilterViewModel = new ReportFilterViewModel(); reportFilterViewModel.TeacherName = modelService.GetUserNameByUserId(filterParameter.Teacher); reportFilterViewModel.ClassName = filterParameter.ClassId != -1 ? modelService.GetClassDesc(filterParameter.ClassId) : defaultText; reportFilterViewModel.Race = (filterParameter.Race == -1) ? defaultText : modelService.GetRaceDesc(filterParameter.Race); reportFilterViewModel.Gender = (filterParameter.Gender == -1) ? defaultText : modelService.GetGenderDesc(filterParameter.Gender); //TODO: till now first record with district name and Id is picked up. Need to refactor if user belongs to multiple district. reportFilterViewModel.DistrictName = siteUser.Districts.First().Name; reportFilterViewModel.IsAdmin = HelperService.AllowUiEdits(siteUser.RoleDesc, "REPORT"); reportFilterViewModel.DisplayAdminFilters = DecideFilterDisplay(filterParameter); reportFilterViewModel.FrlIndicator = filterParameter.FrlIndicator; reportFilterViewModel.LepIndicator = filterParameter.LEPIndicator; reportFilterViewModel.IepIndicator = filterParameter.IEPIndicator; reportFilterViewModel.Hispanic = filterParameter.Hispanic; reportFilterViewModel.SchoolYear = filterParameter.SchoolYear; return reportFilterViewModel; }
private Dictionary<string, string> GetParameters(GetFeaturesByIDsParameters parameters) { Dictionary<string, string> dictionary = new Dictionary<string, string>(); dictionary.Add("getFeatureMode", "\"ID\""); if (parameters.DatasetNames != null && parameters.DatasetNames.Count > 0) { string jsonDatasetNames = "["; List<string> list = new List<string>(); for (int i = 0; i < parameters.DatasetNames.Count; i++) { list.Add(string.Format("\"{0}\"", parameters.DatasetNames[i])); } jsonDatasetNames += string.Join(",", list.ToArray()); jsonDatasetNames += "]"; dictionary.Add("datasetNames", jsonDatasetNames); } if (parameters.IDs != null && parameters.IDs.Count > 0) { string jsonIDs = "["; List<string> list = new List<string>(); for (int i = 0; i < parameters.IDs.Count; i++) { list.Add(parameters.IDs[i].ToString()); } jsonIDs += string.Join(",", list.ToArray()); jsonIDs += "]"; dictionary.Add("ids", jsonIDs); } if (parameters.Fields != null && parameters.Fields.Count > 0) { FilterParameter fp = new FilterParameter(); fp.Fields = parameters.Fields; dictionary.Add("queryParameter", FilterParameter.ToJson(fp)); } return dictionary; }
public ActionResult SummaryReportById(int teacherId, bool viewMeetExceedSummary = true) { try { SetNavigationLinksUrl(); SetViewBag(viewMeetExceedSummary); ViewBag.SummaryLink = "SummaryReportById"; ViewBag.TeacherFilter = teacherId; bool unAuthorizedRequest = false; SiteUser su = ((SiteUser)Session["SiteUser"]); ModelServices modelServices = new ModelServices(); StudentService studentService = new StudentService(su, entities); int defaultDistrict = su.Districts[0].Id; int schoolYearId = modelServices.SchoolYearId(); int[] userSchools = modelServices.getSchoolsByUserId(su.EdsUserId).ToArray(); var dropdownTeachers = modelServices.TeacherDropDownDataBySchoolAndYear(userSchools, schoolYearId, defaultDistrict); unAuthorizedRequest = dropdownTeachers.Where(x => x.Id == teacherId).Count() == 0 ? true : false; if (unAuthorizedRequest) { return RedirectToAction("AccessDenied", "Error"); } TIRSummaryModel data = new TIRSummaryModel(); data.SchoolYear = modelServices.SchoolYearDescription(); data.DropDown = new DropDownData(); data.DropDown.Year = new YearDropDown(modelServices.SchoolYearDropDownData()); data.DropDown.Year.SelectedYear = schoolYearId; data.DropDown.District = new DistrictDropDown(modelServices.DistrictDropDownDataByUser(su.EdsUserId)); data.DropDown.Teacher = new TeacherDropDown(dropdownTeachers); data.DropDown.Teacher.SelectedTeacher = teacherId; data.DropDown.Race = new RaceDropDown(modelServices.DropDownDataForRace(), true); data.DropDown.Gender = new GenderDropDown(modelServices.DropDownDataForGender(), true); data.DropDown.SchoolClass = new ClassDropDown(modelServices.GetClassesByTeacher(schoolYearId, new[] { teacherId })); var filterParameter = new FilterParameter { ClassId = classDefaultValue, Teacher = teacherId, School = userSchools.First(), Year = schoolYearId, SchoolYear = data.SchoolYear }; data.SummaryList = modelServices.GetSummaryReport(filterParameter); data.DropDown.School = new SchoolDropDown(modelServices.GetSchoolDropDownData(su.EdsUserId, schoolYearId)); var reportFilterViewModel = ReportsFilterHelper.PopulateReportFilterViewModel(filterParameter, modelServices, su); ViewBag.ReportFilters = reportFilterViewModel; return View("SummaryReport", data); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }
public ActionResult SummaryReport(bool viewMeetExceedSummary = true) { try { SetNavigationLinksUrl(); ViewBag.SummaryLink = "SummaryReport"; SetViewBag(viewMeetExceedSummary); SiteUser su = ((SiteUser)Session["SiteUser"]); ModelServices modelServices = new ModelServices(); StudentService studentService = new StudentService(su, entities); int defaultDistrict = su.Districts[0].Id; int schoolYearId = modelServices.SchoolYearId(); int[] userSchools = modelServices.getSchoolsByUserId(su.EdsUserId).ToArray(); TIRSummaryModel data = new TIRSummaryModel(); data.SchoolYear = modelServices.SchoolYearDescription(); data.DropDown = new DropDownData(); data.DropDown.Year = new YearDropDown(modelServices.SchoolYearDropDownData()); data.DropDown.Year.SelectedYear = schoolYearId; data.DropDown.District = new DistrictDropDown(modelServices.DistrictDropDownDataByUser(su.EdsUserId)); data.DropDown.Race = new RaceDropDown(modelServices.DropDownDataForRace(), true); data.DropDown.Race.SelectedRace = -1; data.DropDown.Gender = new GenderDropDown(modelServices.DropDownDataForGender(), true); data.DropDown.Gender.SelectedGender = -1; data.DropDown.School = new SchoolDropDown(modelServices.GetSchoolDropDownData(su.EdsUserId, schoolYearId)); if (su.isTeacher) { data.DropDown.Teacher = new TeacherDropDown( new List<DropDownIdName>() { new DropDownIdName() { Id = su.EdsUserId, Name = su.UserFullName } }); data.DropDown.SchoolClass = new ClassDropDown(modelServices.GetClassesByTeacher(schoolYearId, new[] { su.EdsUserId })); } else // data administrator and eds administrator { int[] schoolsTeacher = modelServices.getTeachersBySchoolsId(userSchools).ToArray(); data.DropDown.Teacher = new TeacherDropDown(modelServices.TeacherDropDownDataBySchoolAndYear(userSchools, schoolYearId, defaultDistrict)); data.DropDown.SchoolClass = new ClassDropDown(modelServices.GetClassesByTeacher(schoolYearId, schoolsTeacher)); } var filterParameter = new FilterParameter { ClassId = classDefaultValue, Teacher = su.EdsUserId, School = userSchools.First(), Year = schoolYearId, SchoolYear = data.SchoolYear }; data.SummaryList = modelServices.GetSummaryReport(filterParameter); var reportFilterViewModel = ReportsFilterHelper.PopulateReportFilterViewModel(filterParameter, modelServices, su); ViewBag.ReportFilters = reportFilterViewModel; return View(data); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }
public ActionResult UpdateGrid(FilterParameter filterParameter) { try { SetNavigationLinksUrl(); SetViewBag(filterParameter.ViewMeetExceedSummary); ViewBag.SummaryLink = "UpdateGrid"; bool unAuthorizedRequest = false; SiteUser su = ((SiteUser)Session["SiteUser"]); ModelServices modelServices = new ModelServices(); TIRSummaryModel data = new TIRSummaryModel(); int defaultDistrict = su.Districts[0].Id; data.DropDown = new DropDownData(); ViewBag.FilterParameter = filterParameter; #region Initializations var dropdownSchools = modelServices.GetSchoolDropDownData(su.EdsUserId, filterParameter.Year); var schoolCount = dropdownSchools.Where(x => x.Id == filterParameter.School).Count(); unAuthorizedRequest = schoolCount == 0 ? true : false; if (unAuthorizedRequest) { return RedirectToAction("AccessDenied", "Error"); } if (!unAuthorizedRequest) { if (su.isTeacher) { unAuthorizedRequest = (su.EdsUserId != filterParameter.Teacher) ? true : false; if (!unAuthorizedRequest) data.DropDown.Teacher = new TeacherDropDown(new List<DropDownIdName>() { new DropDownIdName() { Id = su.EdsUserId, Name = su.UserFullName } }); } else { var dropdownTeachers = modelServices.TeacherDropDownDataBySchoolAndYear(new int[] { filterParameter.School }, filterParameter.Year, defaultDistrict); unAuthorizedRequest = dropdownTeachers.Where(x => x.Id == filterParameter.Teacher).Count() == 0 ? true : false; if (!unAuthorizedRequest) { data.DropDown.Teacher = new TeacherDropDown(dropdownTeachers); data.DropDown.Teacher.SelectedTeacher = filterParameter.Teacher; } } } #endregion //TODO: need to refactor below code if possible. ViewBag.TeacherFilter = filterParameter.Teacher; ViewBag.SchoolFilter = filterParameter.School; ViewBag.YearFilter = filterParameter.Year; ViewBag.ClassFilter = filterParameter.ClassId; ViewBag.Race = filterParameter.Race; ViewBag.Gender = filterParameter.Gender; ViewBag.FrlIndicator = filterParameter.FrlIndicator; ViewBag.IEPIndicator = filterParameter.IEPIndicator; ViewBag.LEPIndicator = filterParameter.LEPIndicator; ViewBag.Hispanic = filterParameter.Hispanic; #region Init Filter Parameters data.SchoolYear = modelServices.SchoolYearDescriptionByYearId(filterParameter.Year); data.DropDown.Year = new YearDropDown(modelServices.SchoolYearDropDownData()); data.DropDown.Year.SelectedYear = filterParameter.Year; data.DropDown.District = new DistrictDropDown(modelServices.DistrictDropDownDataByUser(su.EdsUserId)); data.DropDown.School = new SchoolDropDown(dropdownSchools); data.DropDown.School.SelectedSchool = filterParameter.School; data.SummaryList = modelServices.GetSummaryReport(filterParameter); data.DropDown.SchoolClass = new ClassDropDown(modelServices.GetClassesByTeacher(filterParameter.Year, new[] { filterParameter.Teacher })); data.DropDown.Race = new RaceDropDown(modelServices.DropDownDataForRace(), true); data.DropDown.Race.SelectedRace = filterParameter.Race; data.DropDown.Gender = new GenderDropDown(modelServices.DropDownDataForGender(), true); data.DropDown.Gender.SelectedGender = filterParameter.Gender; data.Hispanic = filterParameter.Hispanic; data.IepIndicator = filterParameter.IEPIndicator; data.LepIndicator = filterParameter.LEPIndicator; data.FrlIndicator = filterParameter.FrlIndicator; data.DropDown.SchoolClass.SelectedClass = filterParameter.ClassId; #endregion filterParameter.SchoolYear = data.SchoolYear; var reportFilterViewModel = ReportsFilterHelper.PopulateReportFilterViewModel(filterParameter, modelServices, su); ViewBag.ReportFilters = reportFilterViewModel; return View("SummaryReport", data); } catch (Exception ex) { Logging log = new Logging(); log.LogException(ex); return View("GeneralError"); } }
internal List<TIRSummary> GetSummaryReport(FilterParameter filterParameter) { List<TIRSummary> tirSummaryList = new List<TIRSummary>(); SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString); connection.Open(); SqlCommand command = new SqlCommand("spGetTeacherSummaryView", connection); command.CommandType = System.Data.CommandType.StoredProcedure; command.Parameters.Add(new SqlParameter("@teacherId", filterParameter.Teacher)); command.Parameters.Add(new SqlParameter("@schoolId", filterParameter.School)); command.Parameters.Add(new SqlParameter("@schoolYearId", filterParameter.Year)); command.Parameters.Add(new SqlParameter("@classId", filterParameter.ClassId)); command.Parameters.Add(new SqlParameter("@ViewMeetExceedSummary", filterParameter.ViewMeetExceedSummary)); command.Parameters.Add(new SqlParameter("@Race", filterParameter.Race == -1 ? (int?)null : filterParameter.Race)); command.Parameters.Add(new SqlParameter("@Gender", filterParameter.Gender == -1 ? (int?)null : filterParameter.Gender)); command.Parameters.Add(new SqlParameter("@FrlIndicator", filterParameter.FrlIndicator)); command.Parameters.Add(new SqlParameter("@IepIndicator", filterParameter.IEPIndicator)); command.Parameters.Add(new SqlParameter("@LepIndicator", filterParameter.LEPIndicator)); command.Parameters.Add(new SqlParameter("@Hispanic", filterParameter.Hispanic)); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { TIRSummary tempSummary = new TIRSummary(); tempSummary.GradeLevel = int.Parse(reader["Grade"].ToString()); tempSummary.TeacherId = filterParameter.Teacher; tempSummary.YearId = filterParameter.Year; tempSummary.ClassId = filterParameter.ClassId; tempSummary.SubjectId = int.Parse(reader["SubjectId"].ToString()); tempSummary.AssessmentCode = reader["AssessmentCode"].ToString(); tempSummary.SubjectDesc = reader["ClassSubject"].ToString(); tempSummary.Weighting = HelperService.GetRoundedValue(RoundingType.SiteDefaultDecimalPlace, Convert.ToDecimal(reader["Weighting"])); tempSummary.AssessmentTypeId = reader["AssessmentTypeId"].ToString(); tempSummary.Impact = reader["Impact"] == DBNull.Value ? (decimal?)null : HelperService.GetRoundedValue(RoundingType.SiteDefaultDecimalPlace, Convert.ToDecimal(reader["Impact"])); tempSummary.NoOfStudent = reader["NoOfStudent"] == DBNull.Value ? 0 : int.Parse(reader["NoOfStudent"].ToString()); tempSummary.Average = reader["Average"] == DBNull.Value ? (decimal?)null : HelperService.GetRoundedValue(RoundingType.SiteDefaultDecimalPlace, Convert.ToDecimal(reader["Average"])); tempSummary.AssessmentGradeWeightingId = int.Parse(reader["AssessmentGradeWeightingId"].ToString()); tempSummary.MeetExceedPerc = reader["MeetExceedPerc"] == DBNull.Value ? (decimal)0.0 : HelperService.GetRoundedValue(RoundingType.SiteDefaultDecimalPlace, Convert.ToDecimal(reader["MeetExceedPerc"])); tempSummary.AverageOrMEValue = filterParameter.ViewMeetExceedSummary ? tempSummary.MeetExceedPerc : tempSummary.Average; tempSummary.MeetExceedPoints = reader["MeetExceedPoints"] == DBNull.Value ? (decimal?)null : HelperService.GetRoundedValue(RoundingType.DoubleDecimalplace, Convert.ToDecimal(reader["MeetExceedPoints"])); tempSummary.MeetExceedCategory = reader["MeetExceedCategory"] == DBNull.Value ? (int?)null : int.Parse(reader["MeetExceedCategory"].ToString()); tempSummary.WeightedImpact = filterParameter.ViewMeetExceedSummary ? CalculateWeightedImpact(tempSummary.MeetExceedPoints, tempSummary.Weighting) : CalculateWeightedImpact(tempSummary.Average, tempSummary.Weighting); tempSummary.IsAssessmentExist = (bool)reader["IsAssessmentExist"]; tempSummary.ReportTemplateId = Convert.ToInt32(reader["ReportTemplateId"]); tempSummary.AssessmentTypeDesc = Convert.ToString(reader["AssessmentTypeDesc"]); tirSummaryList.Add(tempSummary); } reader.Close(); connection.Close(); return tirSummaryList; }
private void InitializeReportMetadata(TIRDetailModel model, TIRDetailReportParameter detailReportParameter) { base.SetNavigationLinksUrl(); int decimalPlace = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["SiteDecimalPlace"].ToString()); SiteUser su = ((SiteUser)Session["SiteUser"]); ModelServices service = new ModelServices(); model.SchoolYear = service.SchoolYearDescriptionByYearId(detailReportParameter.Year); SetDetailReportUrlData(detailReportParameter); UpdateReportTemplateConfigurations(service, detailReportParameter.ReportTemplateId); model.AssessmentList = service.GetDetailReportAssessmentList(su.Districts.First().Id, detailReportParameter); var list = (model.AssessmentList).Select(x => x.AssessmentDesc).ToList(); var details = service.GetDetailReport(list, su.Districts.First().Id, detailReportParameter); model.details = details; model.Subject = service.GetSubjectDescriptionById(detailReportParameter.Subject); int[] studentCounts = new int[5]; decimal[] impactSums = new decimal[5]; decimal[] avgImpacts = new decimal[5]; int[] countOfMeetOrExceed = new int[5]; decimal[] percOfMeetOrExceed = new decimal[5]; //TODO: Need to handle null check here if no data found in model.details list it will give object refrence not found error. studentCounts[0] = model.details.Count(d => d.ScoreData1.Impact != null); studentCounts[1] = model.details.Count(d => d.ScoreData2.Impact != null); studentCounts[2] = model.details.Count(d => d.ScoreData3.Impact != null); studentCounts[3] = model.details.Count(d => d.ScoreData4.Impact != null); studentCounts[4] = model.details.Count(d => d.ScoreData5.Impact != null); impactSums[0] = model.details.Sum(d => d.ScoreData1.Impact.GetValueOrDefault()); impactSums[1] = model.details.Sum(d => d.ScoreData2.Impact.GetValueOrDefault()); impactSums[2] = model.details.Sum(d => d.ScoreData3.Impact.GetValueOrDefault()); impactSums[3] = model.details.Sum(d => d.ScoreData4.Impact.GetValueOrDefault()); impactSums[4] = model.details.Sum(d => d.ScoreData5.Impact.GetValueOrDefault()); for (int i = 0; i < studentCounts.Length; i++) { if (studentCounts[i] > 0) { avgImpacts[i] = Math.Round(impactSums[i] / studentCounts[i], decimalPlace); } } countOfMeetOrExceed[0] = model.details.Where(tirDetail => tirDetail.ScoreData1.Impact >= -2).Count(); countOfMeetOrExceed[1] = model.details.Where(tirDetail => tirDetail.ScoreData2.Impact >= -2).Count(); countOfMeetOrExceed[2] = model.details.Where(tirDetail => tirDetail.ScoreData3.Impact >= -2).Count(); countOfMeetOrExceed[3] = model.details.Where(tirDetail => tirDetail.ScoreData4.Impact >= -2).Count(); countOfMeetOrExceed[4] = model.details.Where(tirDetail => tirDetail.ScoreData5.Impact >= -2).Count(); service.IsChildAssessmentsExists(model.AssessmentList); for (int i = 0; i < model.AssessmentList.Count; i++) { if (studentCounts[i] > 0) { percOfMeetOrExceed[i] = GetPerOfMeetValue(countOfMeetOrExceed[i], studentCounts[i], true); } } ViewBag.percOfMeetOrExceed = percOfMeetOrExceed; ViewBag.studentCounts = studentCounts; ViewBag.impactSums = impactSums; ViewBag.avgImpacts = avgImpacts; var filterParameter = new FilterParameter { ClassId = detailReportParameter.ClassId, Teacher = detailReportParameter.Teacher, Year = detailReportParameter.Year, Race = detailReportParameter.Race, Gender = detailReportParameter.Gender, FrlIndicator = detailReportParameter.FrlIndicator, IEPIndicator = detailReportParameter.IEPIndicator, LEPIndicator = detailReportParameter.LEPIndicator, Hispanic = detailReportParameter.Hispanic, SchoolYear = model.SchoolYear }; var reportFilterViewModel = ReportsFilterHelper.PopulateReportFilterViewModel(filterParameter, service, su); ViewBag.ReportFilters = reportFilterViewModel; }
private Dictionary<string, string> GetParameters(GetFeaturesByGeometryParameters parameters) { Dictionary<string, string> dictionary = new Dictionary<string, string>(); if (string.IsNullOrEmpty(parameters.AttributeFilter)) { dictionary.Add("getFeatureMode", "\"SPATIAL\""); } else { dictionary.Add("getFeatureMode", "\"SPATIAL_ATTRIBUTEFILTER\""); dictionary.Add("attributeFilter", parameters.AttributeFilter); } if (parameters.DatasetNames != null && parameters.DatasetNames.Count > 0) { string jsonDatasetNames = "["; List<string> list = new List<string>(); for (int i = 0; i < parameters.DatasetNames.Count; i++) { list.Add(string.Format("\"{0}\"", parameters.DatasetNames[i])); } jsonDatasetNames += string.Join(",", list.ToArray()); jsonDatasetNames += "]"; dictionary.Add("datasetNames", jsonDatasetNames); } else { throw new ArgumentNullException(ExceptionStrings.ArgumentIsNull); } dictionary.Add("spatialQueryMode", parameters.SpatialQueryMode.ToString().ToUpper()); if (parameters.Geometry != null) { dictionary.Add("geometry", ServerGeometry.ToJson(Bridge.ToServerGeometry(parameters.Geometry))); } else { throw new ArgumentNullException(ExceptionStrings.ArgumentIsNull); } if (parameters.Fields != null && parameters.Fields.Count > 0) { FilterParameter fp = new FilterParameter(); fp.Fields = parameters.Fields; dictionary.Add("queryParameter", FilterParameter.ToJson(fp)); } return dictionary; }
private void InitializeReportMetadata(HeirarchicalTIRDetailModel model, TIRDetailReportParameter detailReportParameter) { base.SetNavigationLinksUrl(); int decimalPlace = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["SiteDecimalPlace"].ToString()); SiteUser su = ((SiteUser)Session["SiteUser"]); ModelServices service = new ModelServices(); model.SchoolYear = service.SchoolYearDescriptionByYearId(detailReportParameter.Year); SetDetailReportUrlData(detailReportParameter); UpdateReportTemplateConfigurations(service, detailReportParameter.ReportTemplateId); ViewBag.SchoolTermList = service.GetSchoolTerms(detailReportParameter); var details = service.GetHeirarchicalDetailReport(su.Districts.First().Id, detailReportParameter); model.details = details; model.Subject = service.GetSubjectDescriptionById(detailReportParameter.Subject); model.SubjectId = detailReportParameter.Subject; model.SchoolYearId = detailReportParameter.Year; model.AssessmentTypeId = detailReportParameter.AssessmentTypeId; model.CameFromTitle = detailReportParameter.CameFromTitle; if (details.Count > 0) { model.AssessmentList = new List<AssessmentMEPerc>(); var firstTirDetail = details[0]; var schoolTermId = firstTirDetail.SchoolTermId; detailReportParameter.InputTermId = schoolTermId; foreach (var score in firstTirDetail.ScoreDataCollection) { AssignMePercentForAssessment(score, service, su, detailReportParameter, ref model.AssessmentList); } service.IsChildAssessmentsExists(model.AssessmentList); List<int> studentCounts = studentCounts = new List<int>(); List<decimal> impactSums = new List<decimal>(); List<decimal> avgImpacts = new List<decimal>(); List<int> countOfMeetOrExceed = new List<int>(); for (int i = 0; i < model.details[0].ScoreDataCollection.Count; i++) { studentCounts.Add(model.details.Count(d => d.ScoreDataCollection[i].Impact != null)); impactSums.Add(model.details.Sum(d => d.ScoreDataCollection[i].Impact.GetValueOrDefault())); countOfMeetOrExceed.Add(model.details.Where(d => d.ScoreDataCollection[i].Impact >= -2).Count()); if (studentCounts[i] > 0) { avgImpacts.Add(Math.Round(impactSums[i] / studentCounts[i], decimalPlace)); } else { avgImpacts.Add(0); } } ViewBag.avgImpacts = avgImpacts; } var filterParameter = new FilterParameter { ClassId = detailReportParameter.ClassId, Teacher = detailReportParameter.Teacher, Year = detailReportParameter.Year, Race = detailReportParameter.Race, Gender = detailReportParameter.Gender, FrlIndicator = detailReportParameter.FrlIndicator, IEPIndicator = detailReportParameter.IEPIndicator, LEPIndicator = detailReportParameter.LEPIndicator, Hispanic = detailReportParameter.Hispanic, SchoolYear = model.SchoolYear }; var reportFilterViewModel = ReportsFilterHelper.PopulateReportFilterViewModel(filterParameter, service, su); ViewBag.ReportFilters = reportFilterViewModel; }