public PageLeavingEventArgs OnPageLeaving(PageLeavingEventArgs e) { /* * GlobalVariables.SourceColumns.Add(new Database.MyDbColumn { ColumnName = "ID" }); * GlobalVariables.SourceColumns.Add(new Database.MyDbColumn { ColumnName = "S_NAME" }); * GlobalVariables.SourceColumns.Add(new Database.MyDbColumn { ColumnName = "I_AGE" }); * GlobalVariables.SourceColumns.Add(new Database.MyDbColumn { ColumnName = "S_ADDRESS" }); * GlobalVariables.SourceColumns.Add(new Database.MyDbColumn { ColumnName = "D_CREATED" }); * GlobalVariables.SourceColumns.Add(new Database.MyDbColumn { ColumnName = "D_MODIFIED" }); * * GlobalVariables.TargetColumns.Add(new Database.MyDbColumn { ColumnName = "EmployeeID" }); * GlobalVariables.TargetColumns.Add(new Database.MyDbColumn { ColumnName = "Name" }); * GlobalVariables.TargetColumns.Add(new Database.MyDbColumn { ColumnName = "Age_Current" }); * GlobalVariables.TargetColumns.Add(new Database.MyDbColumn { ColumnName = "Age_Original" }); * GlobalVariables.TargetColumns.Add(new Database.MyDbColumn { ColumnName = "Age_Previous" }); * GlobalVariables.TargetColumns.Add(new Database.MyDbColumn { ColumnName = "Age_Effective_From" }); * GlobalVariables.TargetColumns.Add(new Database.MyDbColumn { ColumnName = "Address" }); * GlobalVariables.TargetColumns.Add(new Database.MyDbColumn { ColumnName = "StartDate" }); * GlobalVariables.TargetColumns.Add(new Database.MyDbColumn { ColumnName = "EndDate" }); * GlobalVariables.TargetColumns.Add(new Database.MyDbColumn { ColumnName = "IsActiveRecord" }); * * GlobalVariables.UserColumns.Add(new Database.MyDbColumn { ColumnName = "@CurrentDateTime" }); */ return(e); }
public PageLeavingEventArgs OnPageLeaving(PageLeavingEventArgs e) { if (dataGridView1.Rows.Count > 0) { e.Cancel = true; e.PageErrors.Add(new PageError { Control = dataGridView1, ErrorMessage = "Duplicate Business Keys found!" }); } return(e); }
public PageLeavingEventArgs OnPageLeaving(PageLeavingEventArgs e) { if (!GlobalVariables.ColumnMappings.Any(cm => cm.TransformationCode == ETransformationCode.DELETED_DATE || cm.TransformationCode == ETransformationCode.IS_DELETED) && GlobalVariables.Options.RecordsOnTargetNotFoundOnSourceMode == ERecordsOnTargetNotFoundOnSourceMode.UpdateTargetField) { e.Cancel = true; e.PageErrors.Add(new PageError { Control = propertyGrid1, ErrorMessage = "Cannot select UpdateTargetField option when there are no 'Deleted Date' and/or 'Is Deleted' transformations defined" }); } return(e); }
public PageLeavingEventArgs OnPageLeaving(PageLeavingEventArgs e) { var result = transformationGridView1.GetMappingResults(); if (result.Messages.Any(m => m.MessageType == Components.EMappingMessageType.ERROR)) { e.Cancel = true; e.PageErrors.Add(new PageError { Control = panel2, ErrorMessage = result.Messages.First(m => m.MessageType == Components.EMappingMessageType.ERROR).MessageText }); } return(e); }
public PageLeavingEventArgs OnPageLeaving(PageLeavingEventArgs e) { List <string> variableValues = new List <string>(); GlobalVariables.UserColumns.Clear(); GlobalVariables.UserColumnsDefinitions.Clear(); Exception ex = testSQL(); if (ex != null) { e.Cancel = true; e.PageErrors.Add(new PageError { Control = dgvUserFields, ErrorMessage = string.Format("System Fields are not defined properly! Use TSQL standards.{0}{0}Error:{0}{1}", Environment.NewLine, ex.Message) }); return(e); } DbCommand cmd = GlobalVariables.SourceConnection.GetConn().CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = getSQL(true); DbDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { variableValues.Add(rdr[1].ToString()); } rdr.Close(); for (int i = 0; i < dgvUserFields.Rows.Count - 1; i++) { if (!dgvUserFields.Rows[i].IsNewRow) { GlobalVariables.UserColumns.Add(new MyDbColumn { ColumnName = "@" + dgvUserFields.Rows[i].Cells["colName"].Value }); GlobalVariables.UserColumnsDefinitions.Add(new MyUserVariable { Name = dgvUserFields.Rows[i].Cells["colName"].Value.ToString(), ColumnName = "@" + dgvUserFields.Rows[i].Cells["colName"].Value, DataType = dgvUserFields.Rows[i].Cells["colDataType"].Value.ToString(), Definition = dgvUserFields.Rows[i].Cells["colDefinition"].Value.ToString(), Value = variableValues[i].ToUpper() }); } } GlobalVariables.UserColumnsDefsQuery = getSQL(false); return(e); }
public PageLeavingEventArgs OnPageLeaving(PageLeavingEventArgs e) { if (GlobalVariables.TargetConnection == null) { GlobalVariables.TargetConnection = DbHelper.CreateConnection(rtbTgtConnStr.Text); } if (GlobalVariables.TargetConnection == null) { e.Cancel = true; e.PageErrors.Add(new PageError { Control = rtbTgtConnStr, ErrorMessage = "Target connection cannot be established." }); } if (GlobalVariables.TargetConnection != null && !GlobalVariables.TargetConnection.IsConnectionOpened()) { e.Cancel = true; e.PageErrors.Add(new PageError { Control = rtbTgtConnStr, ErrorMessage = "Target connection cannot be opened." }); } if (string.IsNullOrEmpty(cbxTgtTableOrViewName.Text)) { e.Cancel = true; e.PageErrors.Add(new PageError { Control = cbxTgtTableOrViewName, ErrorMessage = "You must select source table or view" }); } if (!e.Cancel) { string commandText = "SELECT * FROM " + cbxTgtTableOrViewName.Text; var tc = DbHelper.GetColumns(GlobalVariables.TargetConnection, commandText); if (tc != null) { GlobalVariables.TargetColumns = tc.ToList(); } GlobalVariables.TargetObjectName = cbxTgtTableOrViewName.Text; } return(e); }
private void buttonNext_Click(object sender, EventArgs e) { var plea = new PageLeavingEventArgs(); errorProvider1.Clear(); var res = _pages[CurrentPageIndex].OnPageLeaving(plea); if (!res.Cancel) { CurrentPageIndex = getNextShowablePageIndex(); _pages[CurrentPageIndex].OnPageEntering(); showPage((TheMasterPage)_pages[CurrentPageIndex]); } else { for (int i = res.PageErrors.Count - 1; i >= 0; i--) //foreach (PageError pe in res.PageErrors) { errorProvider1.SetIconAlignment(res.PageErrors[i].Control, ErrorIconAlignment.MiddleLeft); errorProvider1.SetError(res.PageErrors[i].Control, !string.IsNullOrEmpty(res.PageErrors[i].ErrorMessage) ? res.PageErrors[i].ErrorMessage : "Error"); } } }
public PageLeavingEventArgs OnPageLeaving(PageLeavingEventArgs e) { if (GlobalVariables.SourceConnection == null) { GlobalVariables.SourceConnection = DbHelper.CreateConnection(rtbSrcConnStr.Text); } if (GlobalVariables.SourceConnection == null) { e.Cancel = true; e.PageErrors.Add(new PageError { Control = rtbSrcConnStr, ErrorMessage = "Source connection cannot be established" }); } if (GlobalVariables.SourceConnection != null && !GlobalVariables.SourceConnection.IsConnectionOpened()) { e.Cancel = true; e.PageErrors.Add(new PageError { Control = rtbSrcConnStr, ErrorMessage = "Source connection cannot be opened" }); } if (rbIsTableOrView.Checked && cbxSrcTableOrViewName.SelectedIndex < 0) { e.Cancel = true; e.PageErrors.Add(new PageError { Control = cbxSrcTableOrViewName, ErrorMessage = "Select source table or view" }); } if (rbIsCommandText.Checked && string.IsNullOrEmpty(rtbCommandText.Text)) { e.Cancel = true; e.PageErrors.Add(new PageError { Control = rtbCommandText, ErrorMessage = "Enter source command text" }); } if (!e.Cancel) { string commandText; if (rbIsTableOrView.Checked) { commandText = "SELECT * FROM " + cbxSrcTableOrViewName.Text; } else { commandText = rtbCommandText.Text; } var sc = DbHelper.GetColumns(GlobalVariables.SourceConnection, commandText); if (sc != null) { GlobalVariables.SourceColumns = sc.ToList(); } GlobalVariables.SourceObjectName = cbxSrcTableOrViewName.Text; GlobalVariables.SourceIsTableOrViewMode = rbIsTableOrView.Checked; GlobalVariables.SourceCommandText = rtbCommandText.Text; } return(e); }
public PageLeavingEventArgs OnPageLeaving(PageLeavingEventArgs e) { return(e); }