public static EwavColumn Copy(this EwavColumn col) { return(new EwavColumn() { ChildVariableName = col.ChildVariableName, Index = col.Index, Name = col.Name, NoCamelName = col.NoCamelName, SqlDataTypeAsString = col.SqlDataTypeAsString, IsInUse = col.IsInUse, IsUserDefined = col.IsUserDefined }); }
/// <summary> /// Method used to locate the current index for selected column. /// </summary> /// <param name="Column"></param> /// <returns></returns> public int SearchCurrentIndex(EwavColumn Column, List <EwavColumn> Collection) { if (Column != null) { //List<EwavColumn> SourceColumns = this.applicationViewModel.EwavSelectedDatasource.AllColumns; //IEnumerable<EwavColumn> CBXFieldCols = from cols in SourceColumns // orderby cols.Name // select cols; List <EwavColumn> colsList = Collection; for (int i = 0; i < colsList.Count; i++) { if (Column.Name == colsList[i].Name) { return(i); } } } return(-1); }
/// <summary> /// Event Handler that handles Selected Change Event. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cbxSourceField_SelectedIndexChanged(object sender, SelectionChangedEventArgs e) { if (cbxSourceField.SelectedIndex > -1) { List <ColumnDataType> columnDataType = new List <ColumnDataType>(); columnDataType.Add(ColumnDataType.Boolean); columnDataType.Add(ColumnDataType.Numeric); columnDataType.Add(ColumnDataType.Text); columnDataType.Add(ColumnDataType.DateTime); columnDataType.Add(ColumnDataType.UserDefined); CBXFieldCols = from cols in SourceColumns where columnDataType.Contains(cols.SqlDataTypeAsString) orderby cols.Name select cols; //following code reads from the list and reads the Column as EwavColumn and also reads the name of Selected EwavColumn. foreach (EwavColumn col in CBXFieldCols.ToList()) { if (col.Name.ToLower().Equals(((EwavColumn)cbxSourceField.SelectedItem).Name.ToString().ToLower().Trim())) { sourceColumnName = col.Name; sourceColumn = col; break; } } //following code reads destinationColumnName and elseValue for selected EwavColumn foreach (EwavRule_Base rule in applicationViewModel.EwavDefinedVariables) { if (rule is EwavRule_Recode) { EwavRule_Recode rule1 = rule as EwavRule_Recode; if (SelectedItem != null && SelectedItem.DestinationColumn == rule1.TxtDestinationField.ToString()) { destinationColumnName = rule1.TxtDestinationField; elseValue = rule1.TxtElseValue; selectedDType = (rule1.DestinationFieldType.ToString() == "YesNo") ? "Yes/No" : rule1.DestinationFieldType.ToString(); checkboxMaintainSortOrder.IsChecked = rule1.CheckboxMaintainSortOrderIndicator; checkboxUseWildcards.IsChecked = rule1.CheckboxUseWildcardsIndicator; break; } } } if (!editMode) { txtDestinationField.Text = ((EwavColumn)cbxSourceField.SelectedItem).Name.ToString() + "_RECODED"; } else { txtDestinationField.Text = destinationColumnName; txtElseValue.Text = elseValue; } FillDataGrid(); } else { dataGridViewRecode.ItemsSource = null; } EnableDisableFillRanges(); }
/// <summary> /// Event Hanlder that adds the selected rule. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void OKButton_Click(object sender, RoutedEventArgs e) { if (string.IsNullOrEmpty(txtDestinationField.Text)) { MessageBox.Show("Destination field is blank."); this.DialogResult = true; return; } 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; } if (!ValidateDataGrid((List <EwavRuleRecodeDataRow>)dataGridViewRecode.ItemsSource)) { MessageBox.Show("Grid has some empty or invalid data."); return; } //following will not run while editing rule. if (!editMode) { List <ColumnDataType> columnDataType = new List <ColumnDataType>(); columnDataType.Add(ColumnDataType.Boolean); columnDataType.Add(ColumnDataType.Numeric); columnDataType.Add(ColumnDataType.Text); CBXFieldCols = from cols in SourceColumns where columnDataType.Contains(cols.SqlDataTypeAsString) orderby cols.Name select cols; List <EwavColumn> colsList = CBXFieldCols.ToList(); List <string> ColumnsList = new List <string>(); for (int i = 0; i < colsList.Count; i++) { ColumnsList.Add(colsList[i].Name); } } string friendlyRule = "Recode the values in " + sourceColumn.Name + " to " + txtDestinationField.Text + ""; EwavRule_Recode rule = new EwavRule_Recode(); rule.Friendlyrule = friendlyRule; rule.SourceColumnName = sourceColumnName; rule.SourceColumnType = ColumnSourceDataType; rule.TxtDestinationField = txtDestinationField.Text; rule.DestinationFieldType = DestinationFieldType; rule.RecodeTable = (List <EwavRuleRecodeDataRow>)dataGridViewRecode.ItemsSource; rule.TxtElseValue = txtElseValue.Text; rule.CheckboxMaintainSortOrderIndicator = (bool)checkboxMaintainSortOrder.IsChecked; rule.CheckboxUseWildcardsIndicator = (bool)checkboxUseWildcards.IsChecked; // rule.EwavRuleType = EwavRuleType.Recode; rule.VaraiableName = txtDestinationField.Text; rule.VaraiableDataType = GetDestinationColumnType(DestinationFieldType).ToString(); ListBoxItemSource listBoxItem = new ListBoxItemSource(); listBoxItem.RuleString = friendlyRule; listBoxItem.SourceColumn = sourceColumn.Name; listBoxItem.DestinationColumn = txtDestinationField.Text; listBoxItem.Rule = rule; EwavColumn newColumn = new EwavColumn(); newColumn.Name = txtDestinationField.Text; newColumn.SqlDataTypeAsString = GetDestinationColumnType(DestinationFieldType); newColumn.NoCamelName = txtDestinationField.Text; newColumn.IsUserDefined = true; //following logic is used to create a relationship between UserDefined variable using another userDefined variable. sourceColumn.ChildVariableName = newColumn.Name; //Shows the error message if name already exists. if (!editMode) { for (int i = 0; i < applicationViewModel.EwavDefinedVariables.Count; i++) { if (applicationViewModel.EwavDefinedVariables[i].VaraiableName == rule.VaraiableName) { MessageBox.Show("Rule Name already exists. Select another name."); return; } } } //determins if item already exists in collections. if it does, it is removed to get added again as a new item. bool itemExists = false; for (int i = 0; i < applicationViewModel.EwavDefinedVariables.Count; i++) { if (applicationViewModel.EwavDefinedVariables[i] is EwavRule_Recode) { EwavRule_Recode ruleRec = applicationViewModel.EwavDefinedVariables[i] as EwavRule_Recode; if (txtDestinationField.Text == ruleRec.TxtDestinationField) { applicationViewModel.EwavDefinedVariables.RemoveAt(i); itemExists = true; } } } applicationViewModel.InvokePreColumnChangedEvent(); if (!itemExists) { applicationViewModel.EwavSelectedDatasource.AllColumns.Add(newColumn); } else { ListBoxItemSource item = (ListBoxItemSource)applicationViewModel.ListOfRules.Single(r => r.DestinationColumn == listBoxItem.DestinationColumn); applicationViewModel.ListOfRules.Remove(item); } applicationViewModel.ListOfRules.Add(listBoxItem); List <EwavRule_Base> listOfRules = new List <EwavRule_Base>(); listOfRules = applicationViewModel.EwavDefinedVariables; listOfRules.Add(rule); applicationViewModel.EwavDefinedVariables = listOfRules; this.DialogResult = true; }
/// <summary> /// Handles the addition of rule in EwavDefinedVariables /// addition of rule in ListOfRules used to bind ListBox /// addition of newly created column. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void OKButton_Click(object sender, RoutedEventArgs e) { List <ListBoxItemSource> TempList = applicationViewModel.ListOfRules.Where(t => t.DestinationColumn.ToLower() == txtDestinationField.Text.ToLower()).ToList(); Boolean columnNameExists = false; columnNameExists = applicationViewModel.EwavSelectedDatasource.AllColumns.Any(c => c.Name.ToLower() == txtDestinationField.Text.ToLower()); if ((TempList.Count > 0 && !editMode) || columnNameExists) { MessageBox.Show("Variable name already exists."); return; } if (string.IsNullOrEmpty(txtDestinationField.Text)) { MessageBox.Show("Destination field is blank."); //this.DialogResult = DialogResult.None; return; } if (cbxFormatOptions.SelectedIndex < 0) { MessageBox.Show("No format options selected."); //this.DialogResult = DialogResult.None; return; } string friendlyLabel = "Format the display of " + ((EwavColumn)cbxFieldName.SelectedItem).Name.ToString() + " to show " + cbxFormatOptions.SelectedItem.ToString() + " and place the formatted values in " + txtDestinationField.Text; //, cbxFieldName.SelectedItem.ToString(), txtDestinationField.Text, cbxFormatOptions.SelectedItem.ToString(), GetFormatType()); EwavRule_Format rule = new EwavRule_Format(); rule.FriendlyLabel = friendlyLabel; rule.CbxFieldName = ((EwavColumn)cbxFieldName.SelectedItem).Name; rule.TxtDestinationField = txtDestinationField.Text; rule.FormatTypes = GetFormatType(); rule.CbxFormatOptions = cbxFormatOptions.SelectedItem.ToString(); rule.VaraiableName = txtDestinationField.Text; rule.VaraiableDataType = ColumnDataType.Text.ToString(); ListBoxItemSource listBoxItem = new ListBoxItemSource(); listBoxItem.RuleString = friendlyLabel; //listBoxItem.SourceColumn = sourceColumn.Name; listBoxItem.DestinationColumn = txtDestinationField.Text; listBoxItem.RuleType = EwavRuleType.Formatted; listBoxItem.Rule = rule; listBoxItem.SourceColumn = null; EwavColumn newcolumn = new EwavColumn(); newcolumn.Name = txtDestinationField.Text; newcolumn.SqlDataTypeAsString = ColumnDataType.Text; newcolumn.NoCamelName = txtDestinationField.Text; newcolumn.IsUserDefined = true; applicationViewModel.InvokePreColumnChangedEvent(); 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 == rule.VaraiableName) { MessageBox.Show("Rule Name already exists. Select another name."); return; } } } for (int i = 0; i < rules.Count; i++) { if (rule.TxtDestinationField == rules[i].VaraiableName) { rules.RemoveAt(i); applicationViewModel.ListOfRules.RemoveAt(i); break; } } if (!editMode) { applicationViewModel.EwavSelectedDatasource.AllColumns.Add(newcolumn); } applicationViewModel.ListOfRules.Add(listBoxItem); List <EwavRule_Base> listOfRules = new List <EwavRule_Base>(); listOfRules = applicationViewModel.EwavDefinedVariables; listOfRules.Add(rule); applicationViewModel.EwavDefinedVariables = listOfRules; this.DialogResult = true; }
public void PortClassToClient77(EwavColumn gp) { }
/*********************** Validtion Code Ends ************************************/ public static void MakeNoCamelColumn(this EwavColumn ewc) { ewc.NoCamelName = ewc.Name.FromCamelCase(); }
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; }
private void OKButton_Click(object sender, RoutedEventArgs e) { EwavRule_GroupVariable rule = new EwavRule_GroupVariable(); if (txtDestinationField.Text.Trim().Length == 0) { MessageBox.Show("Group Field Name must be entered."); return; } if (lbxFieldName.SelectedItems.Count == 0) { MessageBox.Show("Select items to include in the group."); return; } List <MyString> lbxItems = new List <MyString>(); StringBuilder listOfColumnNamesSelected = new StringBuilder(); foreach (var item in lbxFieldName.SelectedItems) { MyString itemValue = new MyString(); itemValue.VarName = ((EwavColumn)item).Name.ToString(); lbxItems.Add(itemValue); listOfColumnNamesSelected.Append(itemValue.VarName + ","); } string friendlyLabel = "Create a variable group called " + txtDestinationField.Text + " and include: " + listOfColumnNamesSelected.ToString().Substring(0, listOfColumnNamesSelected.ToString().Length - 1); rule.Items = lbxItems; rule.VaraiableName = txtDestinationField.Text; rule.VaraiableDataType = ColumnDataType.GroupVariable.ToString(); rule.FriendlyLabel = friendlyLabel; ListBoxItemSource listBoxItem = new ListBoxItemSource(); listBoxItem.RuleString = friendlyLabel; //listBoxItem.SourceColumn = sourceColumn.Name; listBoxItem.DestinationColumn = txtDestinationField.Text; listBoxItem.NewColumn = txtDestinationField.Text; listBoxItem.RuleType = EwavRuleType.GroupVariable; listBoxItem.SourceColumn = null; listBoxItem.Rule = rule; EwavColumn newcolumn = new EwavColumn(); newcolumn.Name = txtDestinationField.Text; newcolumn.SqlDataTypeAsString = ColumnDataType.GroupVariable; newcolumn.NoCamelName = txtDestinationField.Text; newcolumn.IsUserDefined = true; applicationViewModel.InvokePreColumnChangedEvent(); 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 == rule.VaraiableName) { MessageBox.Show("Rule Name already exists. Select another name."); return; } } } for (int i = 0; i < rules.Count; i++) { if (rule.VaraiableName == rules[i].VaraiableName) { rules.RemoveAt(i); applicationViewModel.ListOfRules.RemoveAt(i); break; } } if (!editMode) { applicationViewModel.EwavSelectedDatasource.AllColumns.Add(newcolumn); } applicationViewModel.ListOfRules.Add(listBoxItem); List <EwavRule_Base> listOfRules = new List <EwavRule_Base>(); listOfRules = applicationViewModel.EwavDefinedVariables; listOfRules.Add(rule); applicationViewModel.EwavDefinedVariables = listOfRules; this.DialogResult = true; }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void OKButton_Click(object sender, RoutedEventArgs e) { List <ListBoxItemSource> TempList = applicationViewModel.ListOfRules.Where(t => t.DestinationColumn.ToLower() == txtDestinationField.Text.ToLower()).ToList(); Boolean columnNameExists = false; columnNameExists = applicationViewModel.EwavSelectedDatasource.AllColumns.Any(c => c.Name.ToLower() == txtDestinationField.Text.ToLower()); //if ((TempList.Count > 0 && !editMode) || columnNameExists) //{ // MessageBox.Show("Variable name already exists."); // return; //} if (ValidateControl()) { List <EwavDataFilterCondition> listOfFilters = FilterCtrl.CreateDataFilters(); string destinationColumnType = "System.String"; ColumnDataType colType = ColumnDataType.Text; object elseValue = this.txtElseValue.Text; object assignValue = this.txtAssignValue.Text; cbxFieldTypeEnum fieldEnum = cbxFieldTypeEnum.None; switch (cbxFieldType.SelectedItem.ToString()) { case "Yes/No": destinationColumnType = "System.Boolean"; if (cmbAssignValue.SelectedIndex == 0) { assignValue = true; } else if (cmbAssignValue.SelectedIndex == 1) { assignValue = false; } if (checkboxUseElse.IsChecked == false) { elseValue = ""; } else if (cmbElseValue.SelectedIndex == 0) { elseValue = true; } else if (cmbElseValue.SelectedIndex == 1) { elseValue = false; } fieldEnum = cbxFieldTypeEnum.YesNo; colType = ColumnDataType.Boolean; break; case "Text": destinationColumnType = "System.String"; if (checkboxUseElse.IsChecked == false) { elseValue = ""; } else { elseValue = this.txtElseValue.Text; } assignValue = this.txtAssignValue.Text; fieldEnum = cbxFieldTypeEnum.Text; colType = ColumnDataType.Text; break; case "Numeric": destinationColumnType = "System.Decimal"; decimal decElse; decimal decAssign; if (checkboxUseElse.IsChecked == false) { elseValue = ""; } else { bool success1 = Decimal.TryParse(this.txtElseValue.Text, out decElse); if (success1) { elseValue = decElse; } } bool success2 = Decimal.TryParse(this.txtAssignValue.Text, out decAssign); if (success2) { assignValue = decAssign; } //if ((!success1 && checkboxUseElse.IsChecked) || !success2) //{ // Epi.Windows.MsgBox.ShowError("Invalid input detected."); // this.DialogResult = DialogResult.None; // return; //} fieldEnum = cbxFieldTypeEnum.Numeric; colType = ColumnDataType.Numeric; break; } string assignText = FilterCtrl.ConditionText.ToString().Substring(0, FilterCtrl.ConditionText.Length - 3); if (checkboxUseElse.IsChecked == true) { assignText += ". Otherwise, assign " + txtDestinationField.Text + " the value " + elseValue + "."; } //conditionText = ( ListBoxItemSource listBoxItem = new ListBoxItemSource(); listBoxItem.RuleString = "Assign " + txtDestinationField.Text + " the value " + assignValue + " when " + assignText; listBoxItem.SourceColumn = null; listBoxItem.DestinationColumn = txtDestinationField.Text; listBoxItem.RuleType = EwavRuleType.conditional; EwavRule_ConditionalAssign rule = new EwavRule_ConditionalAssign(); rule.TxtDestination = txtDestinationField.Text; rule.DestinationColumnType = destinationColumnType; rule.AssignValue = assignValue.ToString(); rule.ElseValue = elseValue.ToString(); rule.ConditionsList = listOfFilters; rule.CbxFieldType = fieldEnum; rule.VaraiableName = txtDestinationField.Text; rule.VaraiableDataType = colType.ToString(); MyString tempStr = new MyString(); tempStr.VarName = "Assign " + txtDestinationField.Text + " the value " + assignValue + " when " + assignText; rule.FriendlyRule = tempStr; EwavColumn newColumn = new EwavColumn(); newColumn.Name = txtDestinationField.Text; newColumn.SqlDataTypeAsString = colType;// ColumnDataType.Text; newColumn.NoCamelName = txtDestinationField.Text; newColumn.IsUserDefined = true; applicationViewModel.InvokePreColumnChangedEvent(); List <EwavRule_Base> rules = new List <EwavRule_Base>(); rules = applicationViewModel.EwavDefinedVariables; listBoxItem.Rule = rule; //listBoxItem.FilterConditionsPanel = pnlContainer; //Shows the error message if name already exists. if (!editMode) { for (int i = 0; i < applicationViewModel.EwavDefinedVariables.Count; i++) { if (applicationViewModel.EwavDefinedVariables[i].VaraiableName == rule.VaraiableName) { MessageBox.Show("Rule Name already exists. Select another name."); return; } } } for (int i = 0; i < rules.Count; i++) { if (rule.TxtDestination == rules[i].VaraiableName) { rules[i] = rule; //applicationViewModel.ListOfRules.RemoveAt(i); applicationViewModel.ListOfRules[i] = listBoxItem; break; } } if (!editMode) { applicationViewModel.EwavSelectedDatasource.AllColumns.Add(newColumn); applicationViewModel.ListOfRules.Add(listBoxItem); rules.Add(rule); } applicationViewModel.EwavDefinedVariables = rules; this.DialogResult = true; } }