public void CanMapMultiSelectParam() { var repDefn = this.MakeTestReportDefn(); var choiceColl = new CrcParameterChoiceCollection(); var multiSelect = new CrcParameterChoice(); multiSelect.Name = "PretendMultiSelect"; multiSelect.Values = new List <string>() { "M2", "M3" }; choiceColl.ParameterChoiceList.Add(multiSelect); var mapper = new CrcParameterChoiceMapper(); var mapResult = mapper.MapParameterChoices(repDefn, choiceColl); Assert.IsTrue(mapResult.MappingValid); Assert.AreEqual(0, mapResult.Complaints.Count()); var multiParamDefn = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "PretendMultiSelect"); Assert.IsNotNull(multiParamDefn); Assert.IsNotNull(multiParamDefn.ParameterChoice); Assert.AreEqual(2, multiParamDefn.ParameterChoice.Values.Count()); Assert.IsNotNull(multiParamDefn.ParameterChoice.Values.FirstOrDefault(v => v == "M2")); Assert.IsNotNull(multiParamDefn.ParameterChoice.Values.FirstOrDefault(v => v == "M3")); }
public CrcParameterChoiceCollection Create(string paramString) { var pcCol = new CrcParameterChoiceCollection(); string[] clauses = paramString.Split("&".ToCharArray()); if (clauses.Count() == 1 && string.IsNullOrEmpty(clauses[0])) return pcCol; foreach (string clauseLoop in clauses) { int isnullPos = clauseLoop.IndexOf(":isnull"); int equalsPos = clauseLoop.IndexOf("="); string pname = null; string pval = null; if (isnullPos > 0) { pname = clauseLoop.Substring(0, isnullPos); string boolString = clauseLoop.Substring(isnullPos + 8); bool isNullValue = bool.Parse( boolString); if (!isNullValue) throw new ApplicationException(String.Format("not sure how to interpret false in clause {0}", clauseLoop)); else pval = null; } else if (equalsPos > 0) { pname = clauseLoop.Substring(0, equalsPos); pval = HttpUtility.UrlDecode(clauseLoop.Substring(equalsPos + 1)); } else throw new ApplicationException(String.Format("Could not parse clause {0}", clauseLoop)); // we now have a pname and pval var pcExists = pcCol.ParameterChoiceList.FirstOrDefault(p => p.Name == pname); if (pcExists == null) { var newPc = new CrcParameterChoice(pname); pcCol.ParameterChoiceList.Add(newPc); pcExists = newPc; } pcExists.Values.Add(pval); } return pcCol; }
public void CanMapDetectWrongName() { var repDefn = this.MakeTestReportDefn(); var choiceColl = new CrcParameterChoiceCollection(); var multiSelect = new CrcParameterChoice(); multiSelect.Name = "WrongName"; multiSelect.Values = new List <string>() { "M2", "M3" }; choiceColl.ParameterChoiceList.Add(multiSelect); var mapper = new CrcParameterChoiceMapper(); var mapResult = mapper.MapParameterChoices(repDefn, choiceColl); Assert.IsFalse(mapResult.MappingValid); Assert.IsTrue(mapResult.Complaints.Contains("Param WrongName not found")); }
public void CanMapDateParam() { var repDefn = this.MakeTestReportDefn(); var choiceColl = new CrcParameterChoiceCollection(); var dateChoice = new CrcParameterChoice(); dateChoice.Name = "PretendDateParam"; dateChoice.SingleValue = "2010-06-02"; choiceColl.ParameterChoiceList.Add(dateChoice); var mapper = new CrcParameterChoiceMapper(); var mapResult = mapper.MapParameterChoices(repDefn, choiceColl); Assert.IsTrue(mapResult.MappingValid); Assert.AreEqual(0, mapResult.Complaints.Count()); var dateParamDefn = repDefn.ParameterDefinitions.FirstOrDefault(p=> p.Name == "PretendDateParam"); Assert.IsNotNull(dateParamDefn); Assert.IsNotNull(dateParamDefn.ParameterChoice); Assert.AreEqual("2010-06-02", dateParamDefn.ParameterChoice.SingleValue); }
public void CanMapDateParam() { var repDefn = this.MakeTestReportDefn(); var choiceColl = new CrcParameterChoiceCollection(); var dateChoice = new CrcParameterChoice(); dateChoice.Name = "PretendDateParam"; dateChoice.SingleValue = "2010-06-02"; choiceColl.ParameterChoiceList.Add(dateChoice); var mapper = new CrcParameterChoiceMapper(); var mapResult = mapper.MapParameterChoices(repDefn, choiceColl); Assert.IsTrue(mapResult.MappingValid); Assert.AreEqual(0, mapResult.Complaints.Count()); var dateParamDefn = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "PretendDateParam"); Assert.IsNotNull(dateParamDefn); Assert.IsNotNull(dateParamDefn.ParameterChoice); Assert.AreEqual("2010-06-02", dateParamDefn.ParameterChoice.SingleValue); }
public void CanMapSingleSelectParam() { var repDefn = this.MakeTestReportDefn(); var choiceColl = new CrcParameterChoiceCollection(); var singleSelect = new CrcParameterChoice(); singleSelect.Name = "PretendSingleSelect"; singleSelect.SingleValue = "S2"; choiceColl.ParameterChoiceList.Add(singleSelect); var mapper = new CrcParameterChoiceMapper(); var mapResult = mapper.MapParameterChoices(repDefn, choiceColl); Assert.IsTrue(mapResult.MappingValid); Assert.AreEqual(0, mapResult.Complaints.Count()); var singleParamDefn = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "PretendSingleSelect"); Assert.IsNotNull(singleParamDefn); Assert.IsNotNull(singleParamDefn.ParameterChoice); Assert.AreEqual("S2", singleParamDefn.ParameterChoice.SingleValue); }
/// <summary> /// applies the specified CrcParameterChoiceCollection to the specified report definition /// will set the ParameterChoice property of matching ParameterDefinitions as required /// </summary> /// <param name="repDefn"></param> /// <param name="paramChoices"></param> /// <returns>ParameterMapResult - if MappingValid is false, see Complaints collection</returns> public ParameterMapResult MapParameterChoices(CrcReportDefinition repDefn, CrcParameterChoiceCollection paramChoices) { var res = new ParameterMapResult(); res.Complaints = new List<string>(); string cultureForDateParsing = GetCultureForDateParsing(); foreach (CrcParameterChoice choiceLoop in paramChoices.ParameterChoiceList) { var defnMatch = repDefn.ParameterDefinitions.FirstOrDefault(pd => pd.Name == choiceLoop.Name); if (defnMatch == null) { res.Complaints.Add(String.Format("Param {0} not found", choiceLoop.Name)); continue; } if (defnMatch.ParameterType == CrcParameterType.Date) { if (choiceLoop.SingleValue == null) { defnMatch.ParameterChoice = choiceLoop.DeepClone(); continue; } var parseResult = ParseDateStringVariousWays(choiceLoop.SingleValue, cultureForDateParsing); if (parseResult.CouldParse) { var parsedChoice = new CrcParameterChoice(choiceLoop.Name); parsedChoice.SingleValue = parseResult.DateTime.ToString("yyyy-MM-dd"); defnMatch.ParameterChoice = parsedChoice; continue; } res.Complaints.Add(String.Format("Could not parse date {0} into Param {1}", choiceLoop.SingleValue, choiceLoop.Name)); } else if (defnMatch.ParameterType == CrcParameterType.Boolean) { if (string.IsNullOrEmpty(choiceLoop.SingleValue) || choiceLoop.SingleValue == "True" || choiceLoop.SingleValue == "False") { defnMatch.ParameterChoice = choiceLoop.DeepClone(); continue; } res.Complaints.Add(String.Format("Could not parse boolean {0} into Param {1}", choiceLoop.SingleValue, choiceLoop.Name)); } else if (defnMatch.ParameterType == CrcParameterType.Text) { defnMatch.ParameterChoice = choiceLoop.DeepClone(); continue; } else if (defnMatch.ValidValues.Count() > 0) { bool valuesOK = true; foreach (string chosenValue in choiceLoop.Values) { if (defnMatch.ValidValues.FirstOrDefault(vv => vv.Value == chosenValue) == null) { res.Complaints.Add(String.Format("Could not apply value {0} into Param {1} because it is not a valid option", chosenValue, choiceLoop.Name)); valuesOK = false; } } if (valuesOK) { defnMatch.ParameterChoice = choiceLoop.DeepClone(); continue; } } } res.MappingValid = (res.Complaints.Count() == 0); return res; }
public void CanMapSingleSelectParam() { var repDefn = this.MakeTestReportDefn(); var choiceColl = new CrcParameterChoiceCollection(); var singleSelect = new CrcParameterChoice(); singleSelect.Name = "PretendSingleSelect"; singleSelect.SingleValue = "S2"; choiceColl.ParameterChoiceList.Add(singleSelect); var mapper = new CrcParameterChoiceMapper(); var mapResult = mapper.MapParameterChoices(repDefn, choiceColl); Assert.IsTrue(mapResult.MappingValid); Assert.AreEqual(0, mapResult.Complaints.Count()); var singleParamDefn = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "PretendSingleSelect"); Assert.IsNotNull(singleParamDefn); Assert.IsNotNull(singleParamDefn.ParameterChoice); Assert.AreEqual("S2", singleParamDefn.ParameterChoice.SingleValue); }
public void CanMapMultiSelectParam() { var repDefn = this.MakeTestReportDefn(); var choiceColl = new CrcParameterChoiceCollection(); var multiSelect = new CrcParameterChoice(); multiSelect.Name = "PretendMultiSelect"; multiSelect.Values = new List<string>() { "M2", "M3" }; choiceColl.ParameterChoiceList.Add(multiSelect); var mapper = new CrcParameterChoiceMapper(); var mapResult = mapper.MapParameterChoices(repDefn, choiceColl); Assert.IsTrue(mapResult.MappingValid); Assert.AreEqual(0, mapResult.Complaints.Count()); var multiParamDefn = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "PretendMultiSelect"); Assert.IsNotNull(multiParamDefn); Assert.IsNotNull(multiParamDefn.ParameterChoice); Assert.AreEqual(2, multiParamDefn.ParameterChoice.Values.Count()); Assert.IsNotNull(multiParamDefn.ParameterChoice.Values.FirstOrDefault(v => v == "M2")); Assert.IsNotNull(multiParamDefn.ParameterChoice.Values.FirstOrDefault(v => v == "M3")); }
public void CanMapDetectWrongName() { var repDefn = this.MakeTestReportDefn(); var choiceColl = new CrcParameterChoiceCollection(); var multiSelect = new CrcParameterChoice(); multiSelect.Name = "WrongName"; multiSelect.Values = new List<string>() { "M2", "M3" }; choiceColl.ParameterChoiceList.Add(multiSelect); var mapper = new CrcParameterChoiceMapper(); var mapResult = mapper.MapParameterChoices(repDefn, choiceColl); Assert.IsFalse(mapResult.MappingValid); Assert.IsTrue(mapResult.Complaints.Contains("Param WrongName not found")); }
public void CanRefreshDependantParameters_Simple() { // make report defn var repDefn = new CrcReportDefinition(); repDefn.ReportPath = "Test/Report"; var pd1 = new CrcParameterDefinition(); pd1.Name = "ParamOne"; pd1.ValidValues.Add(new CrcValidValue() { Label = "Label1", Value = "Value1" }); pd1.ValidValues.Add(new CrcValidValue() { Label = "Label2", Value = "Value2" }); pd1.ValidValues.Add(new CrcValidValue() { Label = "Label3", Value = "Value3" }); pd1.DependantParameterNames.Add("ParamTwo"); var pd2 = new CrcParameterDefinition(); pd2.Name = "ParamTwo"; pd2.ValidValues.Add(new CrcValidValue() { Label = "SubLabel1_1", Value = "SubValue1_1" }); pd2.ValidValues.Add(new CrcValidValue() { Label = "SubLabel1_2", Value = "SubValue1_2" }); pd2.ValidValues.Add(new CrcValidValue() { Label = "SubLabel2_1", Value = "SubValue2_1" }); pd2.ValidValues.Add(new CrcValidValue() { Label = "SubLabel2_2", Value = "SubValue2_2" }); pd2.ValidValues.Add(new CrcValidValue() { Label = "SubLabel3_1", Value = "SubValue3_1" }); repDefn.ParameterDefinitions.Add(pd1); repDefn.ParameterDefinitions.Add(pd2); // make choice collection var choiceCollection = new CrcParameterChoiceCollection(); var paramChoice = new CrcParameterChoice("ParamOne"); paramChoice.Values.Add("Value2"); choiceCollection.ParameterChoiceList.Add(paramChoice); // make server side params to return ItemParameter p1 = new ItemParameter(); p1.Name = "ParamOne"; p1.ValidValues = new ValidValue[] { new ValidValue() { Label = "Label1", Value = "Value1" }, new ValidValue() { Label = "Label2", Value = "Value2" }, new ValidValue() { Label = "Label3", Value = "Value3" } }; p1.DefaultValues = new string[] { }; ItemParameter p2 = new ItemParameter(); p2.Name = "ParamTwo"; p2.ValidValues = new ValidValue[] { new ValidValue() { Label = "SubLabel2_1", Value = "SubValue2_1" }, new ValidValue() { Label = "SubLabel2_2", Value = "SubValue2_2" } }; p2.DefaultValues = new string[] { }; ItemParameter[] paramArrayToReturn = new ItemParameter[] { p1, p2 }; // make mocks for ccs var mf = new TestDoubles.MockSsrsWebServiceFactory(); var soapClientFactory = mf.MakeMockSoapClientFactory( mf.MakeMockReportingService2010Soap("Value2", paramArrayToReturn)); var cacheMock = MockRepository.GenerateMock <CrcCacheManager>(); var configMock = MockRepository.GenerateMock <CrcExtraConfiguration>(); // make ccs var ccs = new CrissCrossServices(soapClientFactory, cacheMock, configMock, null); ccs.RefreshDependantParameters(repDefn, choiceCollection); Assert.AreEqual(2, repDefn.ParameterDefinitions.Count()); var pd1check = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "ParamOne"); Assert.IsNotNull(pd1check); Assert.AreEqual("Value2", pd1check.ParameterChoice.SingleValue); var pd2check = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "ParamTwo"); Assert.IsNotNull(pd2check); Assert.AreEqual(2, pd2check.ValidValues.Count()); Assert.IsNotNull(pd2check.ValidValues.FirstOrDefault(vv => vv.Value == "SubValue2_1")); Assert.IsNotNull(pd2check.ValidValues.FirstOrDefault(vv => vv.Value == "SubValue2_2")); }
public void CanRefreshDependantParameters_Simple() { // make report defn var repDefn = new CrcReportDefinition(); repDefn.ReportPath = "Test/Report"; var pd1 = new CrcParameterDefinition(); pd1.Name = "ParamOne"; pd1.ValidValues.Add(new CrcValidValue() { Label = "Label1", Value = "Value1" }); pd1.ValidValues.Add(new CrcValidValue() { Label = "Label2", Value = "Value2" }); pd1.ValidValues.Add(new CrcValidValue() { Label = "Label3", Value = "Value3" }); pd1.DependantParameterNames.Add("ParamTwo"); var pd2 = new CrcParameterDefinition(); pd2.Name = "ParamTwo"; pd2.ValidValues.Add(new CrcValidValue() { Label = "SubLabel1_1", Value = "SubValue1_1" }); pd2.ValidValues.Add(new CrcValidValue() { Label = "SubLabel1_2", Value = "SubValue1_2" }); pd2.ValidValues.Add(new CrcValidValue() { Label = "SubLabel2_1", Value = "SubValue2_1" }); pd2.ValidValues.Add(new CrcValidValue() { Label = "SubLabel2_2", Value = "SubValue2_2" }); pd2.ValidValues.Add(new CrcValidValue() { Label = "SubLabel3_1", Value = "SubValue3_1" }); repDefn.ParameterDefinitions.Add(pd1); repDefn.ParameterDefinitions.Add(pd2); // make choice collection var choiceCollection = new CrcParameterChoiceCollection(); var paramChoice = new CrcParameterChoice("ParamOne"); paramChoice.Values.Add("Value2"); choiceCollection.ParameterChoiceList.Add( paramChoice); // make server side params to return ReportParameter p1 = new ReportParameter(); p1.Name = "ParamOne"; p1.ValidValues = new ValidValue[]{ new ValidValue(){Label = "Label1", Value = "Value1"}, new ValidValue(){Label = "Label2", Value = "Value2"}, new ValidValue(){Label = "Label3", Value = "Value3"}}; p1.DefaultValues = new string[] { }; ReportParameter p2 = new ReportParameter(); p2.Name = "ParamTwo"; p2.ValidValues = new ValidValue[]{ new ValidValue(){Label = "SubLabel2_1", Value = "SubValue2_1"}, new ValidValue(){Label = "SubLabel2_2", Value = "SubValue2_2"}}; p2.DefaultValues = new string[] { }; ReportParameter[] paramArrayToReturn = new ReportParameter[] { p1, p2 }; // make mocks for ccs var mf = new TestDoubles.MockSsrsWebServiceFactory(); var soapClientFactory = mf.MakeMockSoapClientFactory( mf.MakeMockReportingService2005Soap("Value2", paramArrayToReturn)); var cacheMock = MockRepository.GenerateMock<CrcCacheManager>(); var configMock = MockRepository.GenerateMock<CrcExtraConfiguration>(); // make ccs var ccs = new CrissCrossServices(soapClientFactory, cacheMock, configMock, null); ccs.RefreshDependantParameters(repDefn, choiceCollection); Assert.AreEqual(2,repDefn.ParameterDefinitions.Count()); var pd1check = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "ParamOne"); Assert.IsNotNull(pd1check); Assert.AreEqual("Value2", pd1check.ParameterChoice.SingleValue); var pd2check = repDefn.ParameterDefinitions.FirstOrDefault(p => p.Name == "ParamTwo"); Assert.IsNotNull(pd2check); Assert.AreEqual(2, pd2check.ValidValues.Count()); Assert.IsNotNull(pd2check.ValidValues.FirstOrDefault( vv => vv.Value == "SubValue2_1")); Assert.IsNotNull(pd2check.ValidValues.FirstOrDefault( vv => vv.Value == "SubValue2_2")); }
public void ApplyParameterDefaults(rws.ReportParameter[] wsReportParameters, CrcReportDefinition repDef) { // first build up a choicecollection from the defaults var choiceCol = new CrcParameterChoiceCollection(); foreach (var paramLoop in wsReportParameters) { if (paramLoop.DefaultValues != null) { var crcChoice = new CrcParameterChoice(paramLoop.Name); foreach (string valString in paramLoop.DefaultValues) crcChoice.Values.Add(valString); choiceCol.ParameterChoiceList.Add(crcChoice); } } // now apply it to the repdef var mapper = new CrcParameterChoiceMapper(); var mapResult = mapper.MapParameterChoices(repDef, choiceCol); if (!mapResult.MappingValid) throw new ApplicationException(string.Format("Could not map report defaults for report {0}. Problems: {1}", repDef.DisplayName, string.Join(", ", mapResult.Complaints.ToArray()))); }