public void CanMakeReportAndDetectEmptySelect() { // sometimes dependant selects can be empty at first // they are always query based though rws.ItemParameter p1 = new rws.ItemParameter(); p1.Name = "ParamSelect"; p1.Nullable = false; p1.ParameterTypeName = CrcReportDefinitionFactory.ReportServiceParameterTypes.String; p1.ValidValuesQueryBased = true; p1.ValidValues = null; rws.ItemParameter[] paramArray = new rws.ItemParameter[] { p1 }; var configMock = MockRepository.GenerateMock <CrcExtraConfiguration>(); // make main service obj var factory = new CrcReportDefinitionFactory(); var repDefn = factory.Create("TestReport", paramArray, configMock); Assert.IsNotNull(repDefn); Assert.AreEqual("TestReport", repDefn.ReportPath); Assert.AreEqual(1, repDefn.ParameterDefinitions.Count()); var p1check = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "ParamSelect"); Assert.IsNotNull(p1check); Assert.AreEqual(CrcParameterType.Select, p1check.ParameterType); }
public void RefreshParameter_CanHandleNulls() { var pd = new CrcParameterDefinition(); pd.Name = "TestParam"; pd.ParameterChoice = new CrcParameterChoice(pd.Name); pd.ParameterChoice.Values.Add("Value1"); pd.ParameterChoice.Values.Add("Value2"); pd.ParameterChoice.Values.Add("Value3"); var latestParam = new rws.ItemParameter(); latestParam.Name = "TestParam"; latestParam.ValidValues = null; latestParam.DefaultValues = null; var r = new CrcParameterRefresher(); r.RefreshParameter(pd, latestParam); Assert.IsNotNull(pd); Assert.AreEqual("TestParam", pd.Name); Assert.AreEqual(0, pd.ParameterChoice.Values.Count()); }
public void CanMakeReportAndDetectNormalBoolField() { rws.ItemParameter p1 = new rws.ItemParameter(); p1.Name = "ParamBool"; p1.Nullable = false; p1.ParameterTypeName = CrcReportDefinitionFactory.ReportServiceParameterTypes.Boolean; p1.ValidValuesQueryBased = false; p1.ValidValues = null; rws.ItemParameter[] paramArray = new rws.ItemParameter[] { p1 }; var configMock = MockRepository.GenerateMock <CrcExtraConfiguration>(); // make main service obj var factory = new CrcReportDefinitionFactory(); var repDefn = factory.Create("TestReport", paramArray, configMock); Assert.IsNotNull(repDefn); Assert.AreEqual("TestReport", repDefn.ReportPath); Assert.AreEqual(1, repDefn.ParameterDefinitions.Count()); var p1check = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "ParamBool"); Assert.IsNotNull(p1check); Assert.AreEqual(CrcParameterType.Boolean, p1check.ParameterType); }
public void CanMakeReportAndApplyRequiredFromUserToDateParams() { rws.ItemParameter p1 = new rws.ItemParameter(); p1.Name = "ParamWithDefault"; p1.ParameterTypeName = CrcReportDefinitionFactory.ReportServiceParameterTypes.DateTime; p1.DefaultValues = new string[] { "01/Jan/2011" }; p1.Nullable = false; rws.ItemParameter p2 = new rws.ItemParameter(); p2.Name = "ParamWithoutDefault"; p2.ParameterTypeName = CrcReportDefinitionFactory.ReportServiceParameterTypes.DateTime; p2.DefaultValues = new string[] { }; p2.Nullable = false; rws.ItemParameter[] paramArray = new rws.ItemParameter[] { p1, p2 }; var configMock = MockRepository.GenerateMock <CrcExtraConfiguration>(); // make main service obj var factory = new CrcReportDefinitionFactory(); var repDefn = factory.Create("TestReport", paramArray, configMock); Assert.IsNotNull(repDefn); Assert.AreEqual("TestReport", repDefn.ReportPath); Assert.AreEqual(2, repDefn.ParameterDefinitions.Count()); var p1check = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "ParamWithDefault"); Assert.IsNotNull(p1check); Assert.AreEqual(false, p1check.RequiredFromUser, "RequiredFromUser expected false"); var p2check = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "ParamWithoutDefault"); Assert.IsNotNull(p2check); Assert.AreEqual(true, p2check.RequiredFromUser, "RequiredFromUser expected true"); }
public void RefreshParameter(CrcParameterDefinition paramDefn, rws.ItemParameter latestParamDetails) { logger.DebugFormat("Updating {0} with {1} valid values", paramDefn.Name, (latestParamDetails.ValidValues != null) ? latestParamDetails.ValidValues.Count().ToString() : "null"); UpdateValidValues(paramDefn, latestParamDetails.ValidValues); if (!IsChoiceValid(paramDefn)) { logger.DebugFormat("Param {0} choices are now invalid so applying {1} default values", paramDefn.Name, (latestParamDetails.DefaultValues != null) ? latestParamDetails.DefaultValues.Count().ToString() : "null"); UpdateDefaultValues(paramDefn, latestParamDetails.DefaultValues); } }
public void CanMakeReportAndApplyRequiredFromUserToMultipicks() { rws.ItemParameter p1 = new rws.ItemParameter(); p1.Name = "ParamWithDefault"; p1.ValidValues = new rws.ValidValue[] { new rws.ValidValue() { Label = "--All--", Value = "%%" }, new rws.ValidValue() { Label = "Label1", Value = "Value1" }, new rws.ValidValue() { Label = "Label2", Value = "Value2" } }; p1.DefaultValues = new string[] { "%%" }; p1.Nullable = false; rws.ItemParameter p2 = new rws.ItemParameter(); p2.Name = "ParamWithoutDefault"; p2.ValidValues = new rws.ValidValue[] { new rws.ValidValue() { Label = "Label3", Value = "Value3" }, new rws.ValidValue() { Label = "Label4", Value = "Value4" } }; p2.DefaultValues = new string[] { }; p2.Nullable = false; rws.ItemParameter[] paramArray = new rws.ItemParameter[] { p1, p2 }; var configMock = MockRepository.GenerateMock <CrcExtraConfiguration>(); // make main service obj var factory = new CrcReportDefinitionFactory(); var repDefn = factory.Create("TestReport", paramArray, configMock); Assert.IsNotNull(repDefn); Assert.AreEqual("TestReport", repDefn.ReportPath); Assert.AreEqual(2, repDefn.ParameterDefinitions.Count()); var p1check = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "ParamWithDefault"); Assert.IsNotNull(p1check); Assert.AreEqual(false, p1check.RequiredFromUser, "RequiredFromUser expected false"); var p2check = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "ParamWithoutDefault"); Assert.IsNotNull(p2check); Assert.AreEqual(true, p2check.RequiredFromUser, "RequiredFromUser expected true"); }
public void CanMakeReportAndDetectBoolFieldWithYesNoValues() { rws.ItemParameter p1 = new rws.ItemParameter(); p1.Name = "ParamBool"; p1.Nullable = false; p1.ParameterTypeName = CrcReportDefinitionFactory.ReportServiceParameterTypes.Boolean; p1.ValidValuesQueryBased = false; p1.ValidValues = new rws.ValidValue[] { new rws.ValidValue() { Label = "Yes", Value = "true" }, new rws.ValidValue() { Label = "No", Value = "false" } }; rws.ItemParameter[] paramArray = new rws.ItemParameter[] { p1 }; var configMock = MockRepository.GenerateMock <CrcExtraConfiguration>(); // make main service obj var factory = new CrcReportDefinitionFactory(); var repDefn = factory.Create("TestReport", paramArray, configMock); Assert.IsNotNull(repDefn); Assert.AreEqual("TestReport", repDefn.ReportPath); Assert.AreEqual(1, repDefn.ParameterDefinitions.Count()); var p1check = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "ParamBool"); Assert.IsNotNull(p1check); Assert.AreEqual(CrcParameterType.Select, p1check.ParameterType); Assert.AreEqual(2, p1check.ValidValues.Count()); var v1 = p1check.ValidValues.FirstOrDefault(v => v.Value == "true"); Assert.IsNotNull(v1); Assert.AreEqual("Yes", v1.Label); var v2 = p1check.ValidValues.FirstOrDefault(v => v.Value == "false"); Assert.IsNotNull(v2); Assert.AreEqual("No", v2.Label); }
public void CanMakeReportWithNoReportConfigButIncludeDefaultEmptyEquivalents() { rws.ItemParameter p1 = new rws.ItemParameter(); p1.Name = "ParamOne"; p1.ValidValues = new rws.ValidValue[] { new rws.ValidValue() { Label = "--All--", Value = "%%" }, new rws.ValidValue() { Label = "Label1", Value = "Value1" }, new rws.ValidValue() { Label = "Label2", Value = "Value2" } }; p1.DefaultValues = new string[] { }; rws.ItemParameter[] paramArray = new rws.ItemParameter[] { p1 }; var configMock = MockRepository.GenerateMock <CrcExtraConfiguration>(); configMock.Expect(m => m.DefaultEmptyEquivalentValues).Return(new List <string>() { "", "%%" }); configMock.Expect(m => m.GetReportConfig(null)).IgnoreArguments().Return(null); // make main service obj var factory = new CrcReportDefinitionFactory(); var repDefn = factory.Create("TestReport", paramArray, configMock); Assert.IsNotNull(repDefn); Assert.AreEqual("TestReport", repDefn.ReportPath); Assert.AreEqual(1, repDefn.ParameterDefinitions.Count()); var p1check = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "ParamOne"); Assert.IsNotNull(p1check); Assert.AreEqual(3, p1check.ValidValues.Count()); Assert.IsTrue(p1check.EmptyEquivalentValues.Count() > 0); }
public void CanMakeReportAndDetectMultipickSelect() { rws.ItemParameter p1 = new rws.ItemParameter(); p1.Name = "ParamSelect"; p1.Nullable = false; p1.ParameterTypeName = CrcReportDefinitionFactory.ReportServiceParameterTypes.String; p1.ValidValuesQueryBased = false; p1.ValidValues = new rws.ValidValue[] { new rws.ValidValue() { Label = "--All--", Value = "%%" }, new rws.ValidValue() { Label = "Label1", Value = "Value1" }, new rws.ValidValue() { Label = "Label2", Value = "Value2" } }; p1.MultiValue = true; rws.ItemParameter[] paramArray = new rws.ItemParameter[] { p1 }; var configMock = MockRepository.GenerateMock <CrcExtraConfiguration>(); // make main service obj var factory = new CrcReportDefinitionFactory(); var repDefn = factory.Create("TestReport", paramArray, configMock); Assert.IsNotNull(repDefn); Assert.AreEqual("TestReport", repDefn.ReportPath); Assert.AreEqual(1, repDefn.ParameterDefinitions.Count()); var p1check = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "ParamSelect"); Assert.IsNotNull(p1check); Assert.AreEqual(CrcParameterType.MultiSelect, p1check.ParameterType); }
public void AddParameterDefinitions(rws.ItemParameter[] wsReportParameters, CrcReportDefinition repDef, CrcExtraConfiguration extraConfig, CrcReportConfig reportConfig) { List <string> showByDefault = new List <string>(); if (reportConfig != null) { showByDefault = reportConfig.GetParamsToShowByDefault(); } List <string> defaultEmptyEquivalents = new List <string>(); if (extraConfig != null && extraConfig.DefaultEmptyEquivalentValues != null) { defaultEmptyEquivalents = extraConfig.DefaultEmptyEquivalentValues; } foreach (var paramLoop in wsReportParameters) { CrcReportConfig.CrcParamConfig paramConfig = null; // get extra config for parameter, if there is any if (reportConfig != null) { paramConfig = reportConfig.CrcParamConfigs.FirstOrDefault(p => p.ParamName == paramLoop.Name); } var crcParam = new CrcParameterDefinition(); crcParam.Name = paramLoop.Name; crcParam.id = "param_" + paramLoop.Name.Replace(" ", "_"); crcParam.AllowNull = paramLoop.Nullable; crcParam.AllowBlank = paramLoop.AllowBlank; if (string.IsNullOrEmpty(paramLoop.Prompt)) { // if Prompt is null or empty, it means Parameter is 'Hidden' in SSRS crcParam.Hidden = true; crcParam.DisplayName = paramLoop.Name; } else { crcParam.DisplayName = paramLoop.Prompt; } if (string.IsNullOrEmpty(crcParam.DisplayName)) { crcParam.DisplayName = crcParam.Name; } // if PromptUser is false then Parameter is 'Internal' in SSRS if (!paramLoop.PromptUser) { crcParam.Hidden = true; } var a = new rws.ItemParameter(); if (paramLoop.ParameterTypeName != null && paramLoop.ParameterTypeName.Equals(ReportServiceParameterTypes.DateTime)) { crcParam.ParameterType = CrcParameterType.Date; } else if ((paramLoop.ValidValues != null && paramLoop.ValidValues.Count() > 0) || paramLoop.ValidValuesQueryBased) { if (paramLoop.MultiValue) { crcParam.ParameterType = CrcParameterType.MultiSelect; } else { crcParam.ParameterType = CrcParameterType.Select; } } else if (paramLoop.ParameterTypeName != null && paramLoop.ParameterTypeName.Equals(ReportServiceParameterTypes.Boolean)) { crcParam.ParameterType = CrcParameterType.Boolean; } else { crcParam.ParameterType = CrcParameterType.Text; } if (paramLoop.ValidValues != null) { foreach (var valLoop in paramLoop.ValidValues) { crcParam.ValidValues.Add(new CrcValidValue() { Value = valLoop.Value, Label = valLoop.Label }); } if (crcParam.ValidValues.Count() > 10) { crcParam.AllowListSearch = true; } } // check config for dependencies if (paramConfig != null && paramConfig.DependantParams != null && paramConfig.DependantParams.Count() > 0) { logger.DebugFormat("Param {0} has extraconfig dependancies: {1}", paramLoop.Name, string.Join(", ", paramConfig.DependantParams.ToArray())); foreach (string dpname in paramConfig.DependantParams) { crcParam.DependantParameterNames.Add(dpname); } } foreach (string sloop in defaultEmptyEquivalents) { AddEmptyEquivalent(crcParam, sloop); } // check for specific empty equivalents for this parameter if (paramConfig != null && paramConfig.EmptyEquivalentValues != null) { foreach (string sloop in paramConfig.EmptyEquivalentValues) { AddEmptyEquivalent(crcParam, sloop); } } if (showByDefault.Contains(crcParam.Name)) { crcParam.AlwaysShow = true; } repDef.ParameterDefinitions.Add(crcParam); } }