private static void Main(string[] args) { //Set the application directory as the current directory string appPath = Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().GetName().CodeBase); appPath = appPath.Replace("file:\\", ""); Directory.SetCurrentDirectory(appPath); MSCRMNtoNAssociationsTransportManager man = new MSCRMNtoNAssociationsTransportManager(); string selectedProfileName = ""; if (args.Length == 0) { if (man.Profiles.Count == 0) { Console.WriteLine("\nNo profiles found."); return; } //Display all profiles for selection Console.WriteLine("\nSpecify the Profile to run (1-{0}) [1] : ", man.Profiles.Count); int tpCpt = 1; foreach (NtoNAssociationsTransportProfile profile in man.Profiles) { Console.WriteLine(tpCpt + ". " + profile.ProfileName); tpCpt++; } String input = Console.ReadLine(); if (input == String.Empty) { input = "1"; } int depNumber; Int32.TryParse(input, out depNumber); if (depNumber > 0 && depNumber <= man.Profiles.Count) { selectedProfileName = man.Profiles[depNumber - 1].ProfileName; } else { Console.WriteLine("The specified Profile does not exist."); return; } } else { //Check that the Profile name is provided if (string.IsNullOrEmpty(args[0])) { return; } selectedProfileName = args[0]; } NtoNAssociationsTransportProfile p = man.GetProfile(selectedProfileName); if (p == null) { Console.WriteLine("The specified Profile does not exist."); return; } man.RunProfile(p); }
/// <summary> /// Exports the specified profile. /// </summary> /// <param name="profile">The profile.</param> /// <param name="transportReportFileName">Name of the transport report file.</param> private void Export(NtoNAssociationsTransportProfile profile, string transportReportFileName) { NtoNTransportReport report = null; try { report = new NtoNTransportReport(transportReportFileName); //Get Transport Report if (File.Exists(transportReportFileName)) { report = ReadTransportReport(transportReportFileName); } //Clean Data folder string dataExportFolder = Folder + "\\" + profile.ProfileName + "\\Data"; if (Directory.Exists(dataExportFolder)) { Directory.Delete(dataExportFolder, true); } Directory.CreateDirectory(dataExportFolder); MSCRMConnection connection = profile.getSourceConneciton(); NtoNRelationshipsStructure es = ReadEnvStructure(profile.SourceConnectionName); _serviceProxy = cm.connect(connection); IOrganizationService service = (IOrganizationService)_serviceProxy; List<NtoNTransportReportLine> TransportReport = new List<NtoNTransportReportLine>(); profile.TotalExportedRecords = 0; //Mesure export time DateTime exportStartDT = DateTime.Now; LogManager.WriteLog("Start exporting data from " + connection.ConnectionName); int recordCount = 0; if (es != null) { foreach (SelectedNtoNRelationship ee in profile.SelectedNtoNRelationships) { LogManager.WriteLog("Exporting data for relationship " + ee.RelationshipSchemaName); DateTime entityExportStartDT = DateTime.Now; string fetchXml = "<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='false'>"; fetchXml += "<entity name='" + ee.IntersectEntityName + "'>"; //Get Entity structure NtoNRelationship strE = new NtoNRelationship(); foreach (NtoNRelationship envE in es.NtoNRelationships) { if (envE.IntersectEntityName == ee.IntersectEntityName) { strE = envE; fetchXml += "<attribute name='" + strE.Entity1IntersectAttribute + "' />"; fetchXml += "<attribute name='" + strE.Entity2IntersectAttribute + "' />"; if (ee.IntersectEntityName == "listmember" || ee.IntersectEntityName == "campaignitem") fetchXml += "<attribute name='entitytype' />"; else if (ee.IntersectEntityName == "campaignactivityitem") fetchXml += "<attribute name='itemobjecttypecode' />"; break; } } //Add Query filter int objectTypeCode = 0; if (ee.Entity2LogicalName == "account") objectTypeCode = 1; else if (ee.Entity2LogicalName == "campaign") objectTypeCode = 4400; else if (ee.Entity2LogicalName == "contact") objectTypeCode = 2; else if (ee.Entity2LogicalName == "lead") objectTypeCode = 4; else if (ee.Entity2LogicalName == "list") objectTypeCode = 4300; else if (ee.Entity2LogicalName == "product") objectTypeCode = 1024; else if (ee.Entity2LogicalName == "salesliterature") objectTypeCode = 1038; if (ee.IntersectEntityName == "campaignitem") fetchXml += "<filter type='and'><condition attribute='entitytype' operator='eq' value='" + objectTypeCode + "' /></filter>"; else if (ee.IntersectEntityName == "campaignactivityitem") fetchXml += "<filter type='and'><condition attribute='itemobjecttypecode' operator='eq' value='" + objectTypeCode + "' /></filter>"; fetchXml += "</entity></fetch>"; int recordCountPerEntity = ExportEntity(profile, fetchXml, ee.RelationshipSchemaName); recordCount += recordCountPerEntity; DateTime entityExportEndDT = DateTime.Now; TimeSpan ts = entityExportEndDT - entityExportStartDT; NtoNTransportReportLine transportReportLine = new NtoNTransportReportLine(); transportReportLine.RelationshipSchemaName = ee.RelationshipSchemaName; transportReportLine.ExportedRecords = recordCountPerEntity; report.TotalExportedRecords += recordCountPerEntity; transportReportLine.ExportedIn = ts.ToString().Substring(0, 10); transportReportLine.ExportStartedAt = entityExportStartDT.ToString(); transportReportLine.ExportFinishedAt = entityExportEndDT.ToString(); report.ReportLines.Add(transportReportLine); WriteTransportReport(report, transportReportFileName); } } TimeSpan exportTimeSpan = DateTime.Now - exportStartDT; LogManager.WriteLog("Export finished for " + profile.SourceConnectionName + ". Exported " + recordCount + " records in " + exportTimeSpan.ToString().Substring(0, 10)); } catch (FaultException<Microsoft.Xrm.Sdk.OrganizationServiceFault> ex) { LogManager.WriteLog("Error:" + ex.Detail.Message + "\n" + ex.Detail.TraceText); } catch (Exception ex) { if (ex.InnerException != null) { LogManager.WriteLog("Error:" + ex.Message + "\n" + ex.InnerException.Message); } else { LogManager.WriteLog("Error:" + ex.Message); } } }
/// <summary> /// Imports the specified profile. /// </summary> /// <param name="profile">The profile.</param> /// <param name="transportReportFileName">Name of the transport report file.</param> private void Import(NtoNAssociationsTransportProfile profile, string transportReportFileName) { int totalTreatedRecords = 0; int totalImportFailures = 0; int totalImportSuccess = 0; int ReconnectionRetryCount = 5; try { NtoNTransportReport report = new NtoNTransportReport(transportReportFileName); //Get Transport Report if (File.Exists(transportReportFileName)) { report = ReadTransportReport(transportReportFileName); } MSCRMConnection connection = profile.getTargetConneciton(); ; _serviceProxy = cm.connect(connection); IOrganizationService service = (IOrganizationService)_serviceProxy; LogManager.WriteLog("Start importing data in " + connection.ConnectionName); //Mesure import time DateTime importStartDT = DateTime.Now; //es = ReadEnvStructure(profile.SourceConnectionName); foreach (SelectedNtoNRelationship ee in profile.SelectedNtoNRelationships) { //Check if there are any records to import if (ee.ExportedRecords == 0) { continue; } //Mesure import time DateTime entityImportStartDT = DateTime.Now; string entityFolderPath = Folder + "\\" + profile.ProfileName + "\\Data\\" + ee.RelationshipSchemaName; string[] filePaths = Directory.GetFiles(entityFolderPath, "*.xml"); LogManager.WriteLog("Importing " + ee.RelationshipSchemaName + " records."); int treatedRecordsForEntity = 0; int importedRecordsForEntity = 0; int importFailuresForEntity = 0; foreach (string filePath in filePaths) { List<Type> knownTypes = new List<Type>(); knownTypes.Add(typeof(Entity)); XmlDictionaryReaderQuotas XRQ = new XmlDictionaryReaderQuotas(); XRQ.MaxStringContentLength = int.MaxValue; using(FileStream fs = new FileStream(filePath, FileMode.Open)) using (XmlDictionaryReader reader = XmlDictionaryReader.CreateTextReader(fs, XRQ)) { DataContractSerializer ser = new DataContractSerializer(typeof(EntityCollection), knownTypes); EntityCollection fromDisk = (EntityCollection)ser.ReadObject(reader, true); foreach (Entity en in fromDisk.Entities) { EntityReference relatedEntity1 = new EntityReference(); EntityReference relatedEntity2 = new EntityReference(); try { Guid relatedEntity1Id = getRelatedEntityGuid(en[ee.Entity1IntersectAttribute]); Guid relatedEntity2Id = getRelatedEntityGuid(en[ee.Entity2IntersectAttribute]); relatedEntity1 = new EntityReference { LogicalName = ee.Entity1LogicalName, Id = relatedEntity1Id }; relatedEntity2 = new EntityReference { LogicalName = ee.Entity2LogicalName, Id = relatedEntity2Id }; if (!AlreadyAssociated(_serviceProxy, ee, relatedEntity1Id, relatedEntity2Id)) { if (ee.IntersectEntityName == "listmember") { Guid entity_id = Guid.Empty; Guid list_id = Guid.Empty; if (ee.Entity1LogicalName == "list") { entity_id = relatedEntity2Id; list_id = relatedEntity1Id; } else { entity_id = relatedEntity1Id; list_id = relatedEntity2Id; } AddMemberListRequest request = new AddMemberListRequest(); request.EntityId = entity_id; request.ListId = list_id; AddMemberListResponse response = (AddMemberListResponse)service.Execute(request); } else if (ee.IntersectEntityName == "campaignitem") { Guid entity_id = Guid.Empty; Guid list_id = Guid.Empty; string EntityName = ""; if (ee.Entity1LogicalName == "campaign") { entity_id = relatedEntity2Id; list_id = relatedEntity1Id; EntityName = (string)en["entitytype"]; relatedEntity2.LogicalName = EntityName; } else { entity_id = relatedEntity1Id; list_id = relatedEntity2Id; EntityName = (string)en["entitytype"]; relatedEntity1.LogicalName = EntityName; } AddItemCampaignRequest req = new AddItemCampaignRequest(); req.CampaignId = relatedEntity1Id; req.EntityName = EntityName; req.EntityId = entity_id; AddItemCampaignResponse resp = (AddItemCampaignResponse)service.Execute(req); } else if (ee.IntersectEntityName == "campaignactivityitem") { Guid entity_id = Guid.Empty; Guid list_id = Guid.Empty; string EntityName = ""; if (ee.Entity1LogicalName == "campaignactivity") { entity_id = relatedEntity2Id; list_id = relatedEntity1Id; EntityName = (string)en["itemobjecttypecode"]; relatedEntity2.LogicalName = EntityName; } else { entity_id = relatedEntity1Id; list_id = relatedEntity2Id; EntityName = (string)en["itemobjecttypecode"]; relatedEntity1.LogicalName = EntityName; } AddItemCampaignActivityRequest req = new AddItemCampaignActivityRequest(); req.CampaignActivityId = relatedEntity1Id; req.EntityName = EntityName; req.ItemId = entity_id; AddItemCampaignActivityResponse resp = (AddItemCampaignActivityResponse)service.Execute(req); } else { EntityReferenceCollection relatedEntities = new EntityReferenceCollection(); relatedEntities.Add(relatedEntity2); Relationship relationship = new Relationship(ee.RelationshipSchemaName); relationship.PrimaryEntityRole = EntityRole.Referencing; service.Associate(relatedEntity1.LogicalName, relatedEntity1.Id, relationship, relatedEntities); } } importedRecordsForEntity++; totalImportSuccess++; } catch (FaultException<Microsoft.Xrm.Sdk.OrganizationServiceFault> ex) { totalImportFailures++; importFailuresForEntity++; NtoNRelationshipsImportFailure failure = new NtoNRelationshipsImportFailure { CreatedOn = DateTime.Now.ToString(), NtoNRelationshipName = ee.RelationshipSchemaName, Reason = ex.Detail.Message, UrlEntity1 = profile.getSourceConneciton().ServerAddress + "main.aspx?pagetype=entityrecord&etn=" + relatedEntity1.LogicalName + "&id=" + relatedEntity1.Id.ToString(), UrlEntity2 = profile.getSourceConneciton().ServerAddress + "main.aspx?pagetype=entityrecord&etn=" + relatedEntity2.LogicalName + "&id=" + relatedEntity2.Id.ToString() }; report.TotalImportFailures += 1; //Insert the Failure line in the Failures Report WriteNewImportFailureLine(failure, importFailuresReportFileName); } catch (Exception ex) { //Check if the authentification session is expired if (ex.InnerException != null && ex.InnerException.Message.StartsWith("ID3242")) { LogManager.WriteLog("Error:The CRM authentication session expired. Reconnection attempt n° " + ReconnectionRetryCount); ReconnectionRetryCount--; //On 5 failed reconnections exit if (ReconnectionRetryCount == 0) throw; _serviceProxy = cm.connect(connection); service = (IOrganizationService)_serviceProxy; LogManager.WriteLog("Error:The CRM authentication session expired."); totalImportFailures++; importFailuresForEntity++; NtoNRelationshipsImportFailure failure = new NtoNRelationshipsImportFailure { CreatedOn = DateTime.Now.ToString(), NtoNRelationshipName = ee.RelationshipSchemaName, Reason = ex.InnerException.Message, UrlEntity1 = profile.getSourceConneciton().ServerAddress + "main.aspx?pagetype=entityrecord&etn=" + relatedEntity1.LogicalName + "&id=" + relatedEntity1.Id.ToString(), UrlEntity2 = profile.getSourceConneciton().ServerAddress + "main.aspx?pagetype=entityrecord&etn=" + relatedEntity2.LogicalName + "&id=" + relatedEntity2.Id.ToString() }; report.TotalImportFailures += 1; //Insert the Failure line in the Failures Report WriteNewImportFailureLine(failure, importFailuresReportFileName); } else { throw; } } totalTreatedRecords++; treatedRecordsForEntity++; updateTransportReport(report, ee, importedRecordsForEntity, importFailuresForEntity, entityImportStartDT); } } } LogManager.WriteLog("Treated " + treatedRecordsForEntity + " " + ee.RelationshipSchemaName + " records with " + importedRecordsForEntity + " successfully imported records and " + importFailuresForEntity + " failures."); } TimeSpan importTimeSpan = DateTime.Now - importStartDT; LogManager.WriteLog("Import finished for " + connection.ConnectionName + ". Treated " + totalTreatedRecords + " records in " + importTimeSpan.ToString().Substring(0, 10) + ". Successfuly imported " + totalImportSuccess + " records and " + totalImportFailures + " failures."); WriteTransportReport(report, transportReportFileName); } catch (FaultException<Microsoft.Xrm.Sdk.OrganizationServiceFault> ex) { LogManager.WriteLog("Error:" + ex.Detail.Message + "\n" + ex.Detail.TraceText); } catch (Exception ex) { if (ex.InnerException != null) LogManager.WriteLog("Error:" + ex.Message + "\n" + ex.InnerException.Message); else { LogManager.WriteLog("Error:" + ex.Message); } } }
/// <summary> /// Runs the profile. /// </summary> /// <param name="profile">The profile.</param> /// <returns>The Execution Report File Name</returns> public string RunProfile(NtoNAssociationsTransportProfile profile) { LogManager.WriteLog("Running N*N Transportation Profile: " + profile.ProfileName); //Check if there are selected Relationships to transport if (profile.SelectedNtoNRelationships == null || profile.SelectedNtoNRelationships.Count == 0) { LogManager.WriteLog("No Relationships selected for transport. Select the Relationships and then run the profile"); return ""; } DateTime now = DateTime.Now; ReportFileName = Folder + "\\" + profile.ProfileName + "\\ExecutionReports\\TransportReport" + now.Year + "-" + now.Month + "-" + now.Day + "-" + now.Hour + "-" + now.Minute + "-" + now.Second + ".xml"; importFailuresReportFileName = Folder + "\\" + profile.ProfileName + "\\ExecutionReports\\ImportFailuresReport" + now.Year + "-" + now.Month + "-" + now.Day + "-" + now.Hour + "-" + now.Minute + "-" + now.Second + ".xml"; //Initialize Execution Reports folder string executionReportsFolder = Folder + "\\" + profile.ProfileName + "\\ExecutionReports"; if (!Directory.Exists(executionReportsFolder)) { Directory.CreateDirectory(executionReportsFolder); } //Create Transport Report NtoNTransportReport tr = new NtoNTransportReport(profile.ProfileName); WriteTransportReport(tr, ReportFileName); //Check for the Operation to execute if (profile.Operation == 0) { //Export data Export(profile, ReportFileName); } else if (profile.Operation == 1) { //Import Data Import(profile, ReportFileName); } else if (profile.Operation == 2) { //Transport data => Export + Import Export(profile, ReportFileName); Import(profile, ReportFileName); } NtoNTransportReport report = ReadTransportReport(ReportFileName); report.TransportFinishedAt = DateTime.Now.ToString(); report.TransportCompleted = true; TimeSpan TransportTimeSpan = DateTime.Now - Convert.ToDateTime(report.TransportStartedAt); report.TransportedIn = TransportTimeSpan.ToString().Substring(0, 10); WriteTransportReport(report, ReportFileName); return ReportFileName; }
/// <summary> /// Updates the profile. /// </summary> /// <param name="profile">The profile.</param> public void UpdateProfile(NtoNAssociationsTransportProfile profile) { if (!Directory.Exists(Folder + "\\" + profile.ProfileName)) Directory.CreateDirectory(Folder + "\\" + profile.ProfileName); //Refresh Profiles in case some other instance is updating the profiles ReadProfiles(); for (int i = 0; i < Profiles.Count; i++) { if (Profiles[i].ProfileName == profile.ProfileName) { Profiles[i] = profile; break; } } WriteProfiles(); }
/// <summary> /// Deletes the profile. /// </summary> /// <param name="profile">The profile.</param> public void DeleteProfile(NtoNAssociationsTransportProfile profile) { //Refresh Profiles in case some other instance is updating the profiles ReadProfiles(); for (int i = 0; i < Profiles.Count; i++) { if (Profiles[i].ProfileName == profile.ProfileName) { Profiles.RemoveAt(i); } } //Delete Profile folder try { if (Directory.Exists(Folder + "\\" + profile.ProfileName)) Directory.Delete(Folder + "\\" + profile.ProfileName, true); } catch (Exception) { throw; } //Save Profiles WriteProfiles(); }
/// <summary> /// Exports the entity. /// </summary> /// <param name="profile">The profile.</param> /// <param name="fetchXml">The fetch fetchXML query.</param> /// <param name="RelationshipSchemaName">Name of the relationship schema.</param> /// <returns>The number of exported record for the Entity</returns> public int ExportEntity(NtoNAssociationsTransportProfile profile, string fetchXml, string RelationshipSchemaName) { //Set the number of records per page to retrieve. //This value should not be bigger than 5000 as this is the limit of records provided by the CRM int fetchCount = 5000; // Initialize the file number. int fileNumber = 1; // Initialize the number of records. int recordCount = 0; // Specify the current paging cookie. For retrieving the first page, pagingCookie should be null. string pagingCookie = null; string entityName = ""; while (true) { // Build fetchXml string with the placeholders. string xml = CreateXml(fetchXml, pagingCookie, fileNumber, fetchCount); // Execute the fetch query and get the xml result. RetrieveMultipleRequest fetchRequest = new RetrieveMultipleRequest { Query = new FetchExpression(xml) }; EntityCollection returnCollection = ((RetrieveMultipleResponse)_serviceProxy.Execute(fetchRequest)).EntityCollection; recordCount += returnCollection.Entities.Count; if (recordCount > 0) { string entityFolderName = Folder + "\\" + profile.ProfileName + "\\Data\\" + RelationshipSchemaName; entityName = returnCollection.EntityName; if (!Directory.Exists(entityFolderName)) Directory.CreateDirectory(entityFolderName); List<Type> knownTypes = new List<Type>(); knownTypes.Add(typeof(Entity)); int fileCpt = 1000000 + fileNumber; string filename = entityFolderName + "\\" + fileCpt + ".xml"; FileStream writer = new FileStream(filename, FileMode.Create); DataContractSerializer ser = new DataContractSerializer(typeof(EntityCollection), knownTypes); ser.WriteObject(writer, returnCollection); writer.Close(); } // Check for more records, if it returns 1. if (returnCollection.MoreRecords) { // Increment the page number to retrieve the next page. fileNumber++; pagingCookie = returnCollection.PagingCookie; } else { // If no more records in the result nodes, exit the loop. break; } } if (recordCount > 0) { //Save Exported Entites number foreach (SelectedNtoNRelationship ee in profile.SelectedNtoNRelationships) { if (RelationshipSchemaName == ee.RelationshipSchemaName) { ee.ExportedRecords = recordCount; } } profile.TotalExportedRecords += recordCount; UpdateProfile(profile); } LogManager.WriteLog("Exported " + recordCount + " " + entityName + " records."); return recordCount; }
/// <summary> /// Creates the profile. /// </summary> /// <param name="profile">The profile.</param> public void CreateProfile(NtoNAssociationsTransportProfile profile) { if (!Directory.Exists(Folder + "\\" + profile.ProfileName)) Directory.CreateDirectory(Folder + "\\" + profile.ProfileName); //Refresh Profiles in case some other instance is updating the profiles ReadProfiles(); //Creating new Profile Profiles.Add(profile); WriteProfiles(); }
private bool SaveProfile() { bool result = true; //Check that all fields are provided if (string.IsNullOrEmpty(textBoxTransportationProfileName.Text)) { MessageBox.Show("Profile Name is mandatory!"); return false; } //Check that the name of the profile is valid if (textBoxTransportationProfileName.Text.Contains(" ") || textBoxTransportationProfileName.Text.Contains("\\") || textBoxTransportationProfileName.Text.Contains("/") || textBoxTransportationProfileName.Text.Contains(">") || textBoxTransportationProfileName.Text.Contains("<") || textBoxTransportationProfileName.Text.Contains("?") || textBoxTransportationProfileName.Text.Contains("*") || textBoxTransportationProfileName.Text.Contains(":") || textBoxTransportationProfileName.Text.Contains("|") || textBoxTransportationProfileName.Text.Contains("\"") || textBoxTransportationProfileName.Text.Contains("'") ) { MessageBox.Show("You shouldn't use spaces nor the following characters (\\/<>?*:|\"') in the Profile Name as it will be used to create folders and files."); return false; } if (comboBoxConnectionSource.SelectedItem == null) { MessageBox.Show("You must select a Source for the Profile"); return false; } if (comboBoxConnectionTarget.SelectedItem == null && comboBoxOperation.SelectedItem.ToString() != "Export Data") { MessageBox.Show("You must select a Target for the Profile"); return false; } //Check if this is a creation if (currentProfile == null) { //Check if a Connection having the same name exist already foreach (NtoNAssociationsTransportProfile tp in man.Profiles) { if (tp.ProfileName.ToLower() == textBoxTransportationProfileName.Text.ToLower()) { MessageBox.Show("Profile with the name " + textBoxTransportationProfileName.Text + " exist already. Please select another name"); return false; } } NtoNAssociationsTransportProfile newProfile = new NtoNAssociationsTransportProfile(); newProfile.ProfileName = textBoxTransportationProfileName.Text; //newProfile.ImportMode = comboBoxImportMode.SelectedIndex; newProfile.SourceConnectionName = comboBoxConnectionSource.SelectedItem.ToString(); newProfile.setSourceConneciton(); if (comboBoxOperation.SelectedItem.ToString() != "Export Data") { newProfile.TargetConnectionName = comboBoxConnectionTarget.SelectedItem.ToString(); newProfile.setTargetConneciton(); } newProfile.SelectedNtoNRelationships = new List<SelectedNtoNRelationship>(); dataGridView1.EndEdit(); foreach (DataGridViewRow row in this.dataGridView1.Rows) { DataGridViewCheckBoxCell check = (DataGridViewCheckBoxCell)row.Cells[0]; if (check.Value != null && (bool)check.Value) { NtoNRelationship nnr = es.NtoNRelationships.Find(r => r.RelationshipSchemaName == (string)row.Cells[1].Value); SelectedNtoNRelationship ee = new SelectedNtoNRelationship(); ee.RelationshipSchemaName = nnr.RelationshipSchemaName; ee.IntersectEntityName = nnr.IntersectEntityName; ee.Entity1IntersectAttribute = nnr.Entity1IntersectAttribute; ee.Entity1LogicalName = nnr.Entity1LogicalName; ee.Entity2IntersectAttribute = nnr.Entity2IntersectAttribute; ee.Entity2LogicalName = nnr.Entity2LogicalName; ee.ExportedRecords = 0; newProfile.SelectedNtoNRelationships.Add(ee); } } newProfile.Operation = comboBoxOperation.SelectedIndex; man.CreateProfile(newProfile); comboBoxTransportationProfiles.Items.AddRange(new object[] { newProfile.ProfileName }); comboBoxTransportationProfiles.SelectedItem = newProfile.ProfileName; currentProfile = newProfile; } else { currentProfile.ProfileName = textBoxTransportationProfileName.Text; //currentProfile.ImportMode = comboBoxImportMode.SelectedIndex; currentProfile.SourceConnectionName = comboBoxConnectionSource.SelectedItem.ToString(); currentProfile.setSourceConneciton(); if (comboBoxOperation.SelectedItem.ToString() != "Export Data") { currentProfile.TargetConnectionName = comboBoxConnectionTarget.SelectedItem.ToString(); currentProfile.setTargetConneciton(); } //Backup Export Records numbers if existing List<SelectedNtoNRelationship> backupSelectedEntites = currentProfile.SelectedNtoNRelationships; currentProfile.SelectedNtoNRelationships = new List<SelectedNtoNRelationship>(); NtoNAssociationsTransportProfile oldProfile = man.GetProfile(currentProfile.ProfileName); dataGridView1.EndEdit(); foreach (DataGridViewRow row in this.dataGridView1.Rows) { DataGridViewCheckBoxCell check = (DataGridViewCheckBoxCell)row.Cells[0]; if (check.Value != null && (bool)check.Value) { NtoNRelationship nnr = es.NtoNRelationships.Find(r => r.RelationshipSchemaName == (string)row.Cells[1].Value); SelectedNtoNRelationship ee = new SelectedNtoNRelationship(); ee.RelationshipSchemaName = nnr.RelationshipSchemaName; ee.IntersectEntityName = nnr.IntersectEntityName; ee.Entity1IntersectAttribute = nnr.Entity1IntersectAttribute; ee.Entity1LogicalName = nnr.Entity1LogicalName; ee.Entity2IntersectAttribute = nnr.Entity2IntersectAttribute; ee.Entity2LogicalName = nnr.Entity2LogicalName; ee.ExportedRecords = 0; currentProfile.SelectedNtoNRelationships.Add(ee); } } currentProfile.Operation = comboBoxOperation.SelectedIndex; man.UpdateProfile(currentProfile); } runProfileToolStripMenuItem.Enabled = true; toolStripStatusLabel.Text = "Profile " + currentProfile.ProfileName + " saved."; LogManager.WriteLog("Profile " + currentProfile.ProfileName + " saved."); return result; }
private void newToolStripMenuItem_Click(object sender, EventArgs e) { currentProfile = null; textBoxTransportationProfileName.Text = ""; //comboBoxImportMode.SelectedIndex = 0; comboBoxConnectionSource.SelectedItem = null; comboBoxConnectionTarget.SelectedItem = null; comboBoxTransportationProfiles.SelectedItem = null; comboBoxOperation.SelectedIndex = 2; //comboBoxImportMode.SelectedIndex = 1; }
private void deleteProfileToolStripMenuItem_Click(object sender, EventArgs e) { string currentTransportationProfileName = currentProfile.ProfileName; DialogResult dResTest; dResTest = MessageBox.Show("Are you sure you want to delete this Profile ?", "Confirm Profile Deletion", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dResTest == DialogResult.No) { return; } else { comboBoxTransportationProfiles.Items.Remove(currentProfile.ProfileName); comboBoxTransportationProfiles.SelectedItem = null; man.DeleteProfile(currentProfile); currentProfile = null; textBoxTransportationProfileName.Text = ""; labelStructureLastLoadedDate.Text = "never"; textBoxTransportationProfileName.Enabled = true; comboBoxConnectionSource.SelectedItem = null; comboBoxConnectionTarget.SelectedItem = null; comboBoxOperation.SelectedIndex = 2; //comboBoxImportMode.SelectedIndex = 1; toolStripStatusLabel.Text = "Profile " + currentTransportationProfileName + " deleted"; } }
private void comboBoxTransportationProfiles_SelectedIndexChanged(object sender, EventArgs e) { comboBoxConnectionSource.SelectedItem = null; comboBoxConnectionTarget.SelectedItem = null; if (comboBoxTransportationProfiles.SelectedItem != null) { currentProfile = man.Profiles[comboBoxTransportationProfiles.SelectedIndex]; textBoxTransportationProfileName.Text = currentProfile.ProfileName; //comboBoxImportMode.SelectedIndex = currentProfile.ImportMode; comboBoxConnectionSource.SelectedItem = currentProfile.SourceConnectionName; comboBoxConnectionTarget.SelectedItem = currentProfile.TargetConnectionName; TemporarySelectedEntityListForIgnoredAttributes = currentProfile.SelectedNtoNRelationships; deleteProfileToolStripMenuItem.Enabled = true; textBoxTransportationProfileName.Enabled = false; comboBoxOperation.SelectedIndex = currentProfile.Operation; runProfileToolStripMenuItem.Enabled = true; } else { currentProfile = null; textBoxTransportationProfileName.Text = ""; comboBoxOperation.SelectedIndex = 2; //comboBoxImportMode.SelectedIndex = 1; deleteProfileToolStripMenuItem.Enabled = false; textBoxTransportationProfileName.Enabled = true; labelStructureLastLoadedDate.Text = "never"; runProfileToolStripMenuItem.Enabled = false; } }