private void OKButton_Click(object sender, RoutedEventArgs e) { // add data to new rule add to list // add new rule to listbox item source kk // add column to Allcolumns List <ListBoxItemSource> TempList = applicationViewModel.ListOfRules.Where(t => t.DestinationColumn.ToLower() == txtDestinationField.Text.ToLower()).ToList(); if (TempList.Count > 0 && !editMode) { MessageBox.Show("Variable name already exists."); return; } EwavRule_ExpressionAssign ea = new EwavRule_ExpressionAssign(); ea.Expression = txtExpression.Text; if (((EwavColumn)cbxDataType.SelectedItem).SqlDataTypeAsString.ToString() == "Text") { ea.DataType = "System.String"; } else if (((EwavColumn)cbxDataType.SelectedItem).SqlDataTypeAsString.ToString() == "Numeric") { ea.DataType = "System.Decimal"; } // "System.String"; ea.FriendlyRule = string.Format("Assign {0} the expression: {1}", txtDestinationField.Text, txtExpression.Text); ea.DestinationColumnName = txtDestinationField.Text; ea.VaraiableName = txtDestinationField.Text; List <EwavRule_Base> rules = new List <EwavRule_Base>(); rules = applicationViewModel.EwavDefinedVariables; //Shows the error message if name already exists. if (!editMode) { for (int i = 0; i < applicationViewModel.EwavDefinedVariables.Count; i++) { if (applicationViewModel.EwavDefinedVariables[i].VaraiableName == ea.VaraiableName) { MessageBox.Show("Rule Name already exists. Select another name."); return; } } } for (int i = 0; i < rules.Count; i++) { if (ea.DestinationColumnName == rules[i].VaraiableName) { rules.RemoveAt(i); applicationViewModel.ListOfRules.RemoveAt(i); break; } } //EwavRule_ExpressionAssign ea = new EwavRule_ExpressionAssign(); //ea.Expression = txtExpression.Text; //ea.DataType = "System.String"; //ea.FriendlyRule = "Assign " + txtDestinationField.Text + " the expression: " + txtExpression.Text; //ea.DestinationColumnName = txtDestinationField.Text; applicationViewModel.InvokePreColumnChangedEvent(); // applicationViewModel.EwavDefinedVariables.Add(ea); ListBoxItemSource listBoxItem = new ListBoxItemSource(); listBoxItem.RuleString = ea.FriendlyRule; listBoxItem.NewColumn = txtDestinationField.Text; listBoxItem.AssignExpression = txtExpression.Text; listBoxItem.DataType = ((EwavColumn)cbxDataType.SelectedItem).SqlDataTypeAsString.ToString(); listBoxItem.DestinationColumn = txtDestinationField.Text; listBoxItem.SourceColumn = null; listBoxItem.RuleType = EwavRuleType.Assign; ea.VaraiableDataType = ((EwavColumn)cbxDataType.SelectedItem).SqlDataTypeAsString.ToString(); listBoxItem.Rule = ea; EwavColumn newColumn = new EwavColumn(); newColumn.Name = txtDestinationField.Text; newColumn.SqlDataTypeAsString = ((EwavColumn)cbxDataType.SelectedItem).SqlDataTypeAsString; newColumn.NoCamelName = txtDestinationField.Text; newColumn.IsUserDefined = true; if (editMode == false) { applicationViewModel.EwavSelectedDatasource.AllColumns.Add(newColumn); } applicationViewModel.ListOfRules.Add(listBoxItem); List <EwavRule_Base> tempList = applicationViewModel.EwavDefinedVariables; tempList.Add(ea); applicationViewModel.EwavDefinedVariables = tempList; this.DialogResult = true; }
/// <summary> /// Serializes the rules /// </summary> /// <param name="rule"></param> /// <returns></returns> public static XElement Serialize(this EwavRule_Base rule) { XElement element = null; if (rule is EwavRule_Format) { EwavRule_Format ruleFormat = (EwavRule_Format)rule; element = new XElement("rule", new XAttribute("type", "Rule_Format"), new XElement("friendlyRule", ruleFormat.FriendlyLabel), new XElement("sourceColumnName", ruleFormat.CbxFieldName), new XElement("destinationColumnName", ruleFormat.TxtDestinationField), new XElement("formatString", ruleFormat.CbxFormatOptions), new XElement("formatType", ruleFormat.FormatTypes), new XElement("variableDataType", ruleFormat.VaraiableDataType)); } else if (rule is EwavRule_ExpressionAssign) { EwavRule_ExpressionAssign ruleAssign = (EwavRule_ExpressionAssign)rule; element = new XElement("rule", new XAttribute("type", "Rule_ExpressionAssign"), new XElement("friendlyRule", ruleAssign.FriendlyRule), new XElement("expression", ruleAssign.Expression), new XElement("destinationColumnName", ruleAssign.DestinationColumnName), new XElement("destinationColumnType", ruleAssign.DataType), new XElement("variableDataType", ruleAssign.VaraiableDataType)); } else if (rule is EwavRule_ConditionalAssign) { EwavRule_ConditionalAssign ruleCondAssign = (EwavRule_ConditionalAssign)rule; element = new XElement("rule", new XAttribute("type", "Rule_ConditionalAssign"), new XElement("friendlyRule", ruleCondAssign.FriendlyRule.VarName), new XElement("destinationColumnName", ruleCondAssign.TxtDestination), new XElement("destinationColumnType", ruleCondAssign.DestinationColumnType), new XElement("assignValue", ruleCondAssign.AssignValue), new XElement("elseValue", ruleCondAssign.ElseValue), new XElement("cbxFieldType", ruleCondAssign.CbxFieldType), new XElement("variableDataType", ruleCondAssign.VaraiableDataType)); ruleCondAssign.ConditionsList.Serialize(element); } else if (rule is EwavRule_GroupVariable) { EwavRule_GroupVariable ruleGroupVar = (EwavRule_GroupVariable)rule; element = new XElement("rule", new XAttribute("type", "Rule_GroupVariable"), new XElement("friendlyLabel", ruleGroupVar.FriendlyLabel), new XElement("destinationColumnName", ruleGroupVar.VaraiableName), //new XElement("destinationColumnType", ruleGroupVar.VaraiableDataType), new XElement("variableDataType", ruleGroupVar.VaraiableDataType)); XElement items = new XElement("Columns"); for (int i = 0; i < ruleGroupVar.Items.Count; i++) { items.Add(new XElement("column", ruleGroupVar.Items[i].VarName)); } element.Add(items); } else if (rule is EwavRule_Recode) { EwavRule_Recode ruleRecode = (EwavRule_Recode)rule; element = new XElement("rule", new XAttribute("type", "Rule_Recode"), new XElement("friendlyRule", ruleRecode.Friendlyrule), new XElement("sourceColumnName", ruleRecode.SourceColumnName), new XElement("sourceColumnType", ruleRecode.SourceColumnType), new XElement("destinationColumnName", ruleRecode.TxtDestinationField), new XElement("destinationColumnType", ruleRecode.DestinationFieldType), //new XElement("tableColumns",(List<EwavRuleRecodeDataRow>)dataGridViewRecode.ItemsSource.Count.ToString() ), new XElement("elseValue", ruleRecode.TxtElseValue), new XElement("shouldUseWildcards", ruleRecode.CheckboxUseWildcardsIndicator), new XElement("shouldMaintainSortOrder", ruleRecode.CheckboxMaintainSortOrderIndicator), new XElement("variableDataType", ruleRecode.VaraiableDataType)); List <EwavRuleRecodeDataRow> dtb = ruleRecode.RecodeTable; XElement recodeTableElement = new XElement("recodeTable"); XElement recodeTableRowElement = null; for (int i = 0; i < dtb.Count; i++) { if (dtb[i].col1.Length > 0 && dtb[i].col1.Length > 0 && dtb[i].col1.Length > 0) { recodeTableRowElement = new XElement("recodeTableRow"); recodeTableRowElement.Add(new XElement("recodeTableData", dtb[i].col1.Replace("<", "<").Replace(">", ">"))); if (dtb[i].col2 == null) { recodeTableRowElement.Add(new XElement("recodeTableData", null)); } else if (dtb[i].col2.Length > 0) { recodeTableRowElement.Add(new XElement("recodeTableData", dtb[i].col2.Replace("<", "<").Replace(">", ">"))); } recodeTableRowElement.Add(new XElement("recodeTableData", dtb[i].col3.Replace("<", "<").Replace(">", ">"))); recodeTableElement.Add(recodeTableRowElement); } } element.Add(recodeTableElement); } else if (rule is EwavRule_SimpleAssignment) { EwavRule_SimpleAssignment ruleSimple = (EwavRule_SimpleAssignment)rule; element = new XElement("rule", new XAttribute("type", "Rule_SimpleAssign"), new XElement("friendlyRule", ruleSimple.FriendlyLabel), new XElement("assignmentType", ruleSimple.AssignmentType), new XElement("destinationColumnName", ruleSimple.TxtDestinationField), new XElement("variableDataType", ruleSimple.VaraiableDataType)); XElement paramsList = new XElement("parametersList"); for (int i = 0; i < ruleSimple.Parameters.Count; i++) { paramsList.Add(new XElement("parameter", ruleSimple.Parameters[i].VarName)); } element.Add(paramsList); } return(element); }
public List <EwavRule_Base> ConvertXMLToDefinedVariables(XDocument doc) { List <EwavRule_Base> EwavDefinedVariables = new List <EwavRule_Base>(); foreach (var item in doc.Descendants("Rules").Descendants()) { if (item.Name.ToString().ToLower() == "rule") { try { //Type gadgetType = Type.GetType(item.Attribute("type").Value); // item.Attributes["gadgetType"].Value); //EwavRule_Base rule = null; EwavRule_Base baseRule = null; switch (item.Attribute("type").Value.ToLower()) { case "rule_format": EwavRule_Format rule = new EwavRule_Format(); rule.FriendlyLabel = item.Element("friendlyRule").Value.ToString(); rule.CbxFieldName = item.Element("sourceColumnName").Value.ToString(); rule.TxtDestinationField = item.Element("destinationColumnName").Value.ToString(); rule.CbxFormatOptions = item.Element("formatString").Value.ToString(); rule.FormatTypes = (Ewav.Web.EpiDashboard.Rules.FormatTypes)Enum.Parse(typeof(Ewav.Web.EpiDashboard.Rules.FormatTypes), item.Element("formatType").Value.ToString(), true); rule.VaraiableDataType = item.Element("variableDataType").Value.ToString(); baseRule = rule; baseRule.VaraiableName = rule.TxtDestinationField; break; case "rule_expressionassign": EwavRule_ExpressionAssign ruleAssign = new EwavRule_ExpressionAssign(); ruleAssign.FriendlyRule = item.Element("friendlyRule").Value.ToString(); ruleAssign.Expression = item.Element("expression").Value.ToString(); ruleAssign.DestinationColumnName = item.Element("destinationColumnName").Value.ToString(); ruleAssign.DataType = item.Element("destinationColumnType").Value.ToString(); ruleAssign.VaraiableDataType = item.Element("variableDataType").Value.ToString(); baseRule = ruleAssign; baseRule.VaraiableName = ruleAssign.DestinationColumnName; break; case "rule_groupvariable": EwavRule_GroupVariable ruleGroupVar = new EwavRule_GroupVariable(); ruleGroupVar.FriendlyLabel = item.Element("friendlyLabel").Value.ToString(); ruleGroupVar.VaraiableName = item.Element("destinationColumnName").Value.ToString(); ruleGroupVar.VaraiableDataType = item.Element("variableDataType").Value.ToString(); List <MyString> columnList = new List <MyString>(); foreach (var column in item.Descendants("column")) { MyString colVal = new MyString(); colVal.VarName = column.Value.ToString(); columnList.Add(colVal); } ruleGroupVar.Items = columnList; baseRule = ruleGroupVar; baseRule.VaraiableName = ruleGroupVar.VaraiableName; break; case "rule_conditionalassign": EwavRule_ConditionalAssign ruleCondAssign = new EwavRule_ConditionalAssign(); MyString myString = new MyString(); myString.VarName = item.Element("friendlyRule").Value.ToString(); ruleCondAssign.FriendlyRule = myString; ruleCondAssign.TxtDestination = item.Element("destinationColumnName").Value.ToString(); ruleCondAssign.DestinationColumnType = item.Element("destinationColumnType").Value.ToString(); ruleCondAssign.AssignValue = item.Element("assignValue").Value.ToString(); ruleCondAssign.ElseValue = item.Element("elseValue").Value.ToString(); ruleCondAssign.VaraiableDataType = item.Element("variableDataType").Value.ToString(); if (item.Element("cbxFieldType") != null) { ruleCondAssign.CbxFieldType = (cbxFieldTypeEnum)Enum.Parse(typeof(cbxFieldTypeEnum), item.Element("cbxFieldType").Value.ToString(), false); } ruleCondAssign.ConditionsList = new List <EwavDataFilterCondition>(); //ruleCondAssign.ConditionsList = foreach (var condition in item.Descendants("EwavDataFilterCondition").OrderBy(x => (int)x.Attribute("order"))) { EwavDataFilterCondition df = new EwavDataFilterCondition(); if (condition.Attribute("friendlyOperand") != null) { df.FriendlyOperand = ToMyString(condition.Attribute("friendlyOperand").Value); } if (condition.Attribute("friendlyValue") != null) { df.FriendlyValue = ToMyString(condition.Attribute("friendlyValue").Value); } if (condition.Attribute("fieldName") != null) { df.FieldName = ToMyString(condition.Attribute("fieldName").Value); } if (condition.Attribute("joinType") != null) { df.JoinType = ToMyString(condition.Attribute("joinType").Value); } if (condition.Attribute("friendLowValue") != null && condition.Attribute("friendLowValue").Value != "null") { df.FriendLowValue = ToMyString(condition.Attribute("friendLowValue").Value); } if (condition.Attribute("friendHighValue") != null && condition.Attribute("friendHighValue").Value != "null") { df.FriendHighValue = ToMyString(condition.Attribute("friendHighValue").Value); } ruleCondAssign.ConditionsList.Add(df); } baseRule = ruleCondAssign; baseRule.VaraiableName = ruleCondAssign.TxtDestination; break; case "rule_simpleassign": EwavRule_SimpleAssignment ruleSimple = new EwavRule_SimpleAssignment(); ruleSimple.FriendlyLabel = item.Element("friendlyRule").Value.ToString(); ruleSimple.AssignmentType = (Ewav.Web.EpiDashboard.Rules.SimpleAssignType)Enum.Parse(typeof(Ewav.Web.EpiDashboard.Rules.SimpleAssignType), item.Element("assignmentType").Value.ToString(), true); ruleSimple.TxtDestinationField = item.Element("destinationColumnName").Value.ToString(); ruleSimple.Parameters = new List <MyString>(); ruleSimple.VaraiableDataType = item.Element("variableDataType").Value.ToString(); foreach (var item1 in item.Element("parametersList").Descendants()) { MyString mys = new MyString(); mys.VarName = item1.Value; ruleSimple.Parameters.Add(mys); } baseRule = ruleSimple; baseRule.VaraiableName = ruleSimple.TxtDestinationField; break; case "rule_recode": EwavRule_Recode ruleRecode = new EwavRule_Recode(); ruleRecode.Friendlyrule = item.Element("friendlyRule").Value.ToString(); ruleRecode.SourceColumnName = item.Element("sourceColumnName").Value.ToString(); ruleRecode.SourceColumnType = item.Element("sourceColumnType").Value.ToString(); ruleRecode.TxtDestinationField = item.Element("destinationColumnName").Value.ToString(); ruleRecode.DestinationFieldType = (DashboardVariableType)Enum.Parse(typeof(DashboardVariableType), item.Element("destinationColumnType").Value.ToString(), true); ruleRecode.TxtElseValue = item.Element("elseValue").Value.ToString(); ruleRecode.CheckboxUseWildcardsIndicator = bool.Parse(item.Element("shouldUseWildcards").Value.ToString()); ruleRecode.CheckboxMaintainSortOrderIndicator = bool.Parse(item.Element("shouldMaintainSortOrder").Value.ToString()); ruleRecode.VaraiableName = item.Element("destinationColumnName").Value.ToString(); ruleRecode.VaraiableDataType = item.Element("variableDataType").Value.ToString(); //ruleRecode.VaraiableDataType = item.Element("variableDataType").Value.ToString(); List <EwavRuleRecodeDataRow> rows = new List <EwavRuleRecodeDataRow>(); foreach (var item2 in item.Descendants("recodeTable")) { var itemmm = item2; foreach (var item3 in item2.Elements("recodeTableRow")) { EwavRuleRecodeDataRow row = new EwavRuleRecodeDataRow(); IEnumerable <XElement> enumerableList = item3.Elements("recodeTableData"); List <XElement> list = enumerableList.ToList(); if (list.Count == 2) { row.col1 = list[0].Value.ToString().Replace("<", "<").Replace(">", ">"); row.col3 = list[1].Value.ToString().Replace("<", "<").Replace(">", ">"); } else { row.col1 = list[0].Value.ToString().Replace("<", "<").Replace(">", ">"); row.col2 = list[1].Value.ToString().Replace("<", "<").Replace(">", ">"); row.col3 = list[2].Value.ToString().Replace("<", "<").Replace(">", ">"); } rows.Add(row); } } ruleRecode.RecodeTable = rows; baseRule = ruleRecode; baseRule.VaraiableName = ruleRecode.TxtDestinationField; break; default: throw new Exception("This Rule doesn't exists."); } //newColumn.SqlDataTypeAsString = (ColumnDataType)Enum.Parse(typeof(ColumnDataType), item.Element("variableDataType").Value.ToString(), false); EwavDefinedVariables.Add(baseRule); } catch (Exception ex) { //Epi.Windows.MsgBox.ShowError(DashboardSharedStrings.GADGET_LOAD_ERROR); throw new Exception("Exception occured deserializing Rules." + ex.Message); //return; } } } return(EwavDefinedVariables); }