public IErrorsInfo CopyEntityStructure(IDataSource sourceds, IDataSource destds, string srcentity, string destentity, IProgress <PassedArgs> progress, CancellationToken token, bool CreateMissingEntity = true) { try { EntityStructure item = sourceds.GetEntityStructure(srcentity, true); if (item != null) { if (destds.Category == DatasourceCategory.RDBMS) { IRDBSource rDB = (IRDBSource)destds; rDB.DisableFKConstraints(item); } if (destds.CreateEntityAs(item)) { DMEEditor.AddLogMessage("Success", $"Creating Entity {item.EntityName} on {destds.DatasourceName}", DateTime.Now, 0, null, Errors.Ok); } else { DMEEditor.AddLogMessage("Fail", $"Error : Could not Create Entity {item.EntityName} on {destds.DatasourceName}", DateTime.Now, 0, null, Errors.Failed); } if (destds.Category == DatasourceCategory.RDBMS) { IRDBSource rDB = (IRDBSource)destds; rDB.EnableFKConstraints(item); } } } catch (Exception ex) { DMEEditor.AddLogMessage("Fail", $"Error Could not Create Entity {srcentity} on {destds.DatasourceName} ({ex.Message})", DateTime.Now, -1, "CopyDatabase", Errors.Failed); } return(DMEEditor.ErrorObject); }
private IErrorsInfo RunCopyEntityScript(ref SyncEntity sc, IDataSource sourceds, IDataSource destds, string srcentity, string destentity, IProgress <PassedArgs> progress, CancellationToken token, bool CreateMissingEntity = true) { try { int errorcount = 0; EntityStructure item = sourceds.GetEntityStructure(srcentity, true); if (item != null) { if (destds.Category == DatasourceCategory.RDBMS) { IRDBSource rDB = (IRDBSource)destds; rDB.DisableFKConstraints(item); } if (destds.CheckEntityExist(item.EntityName)) { object srcTb; string entname; var src = Task.Run(() => { return(sourceds.GetEntity(item.EntityName, null)); }); src.Wait(); srcTb = src.Result; List <object> srcList = new List <object>(); if (src.Result != null) { DMTypeBuilder.CreateNewObject(item.EntityName, item.EntityName, item.Fields); if (srcTb.GetType().FullName.Contains("DataTable")) { srcList = DMEEditor.Utilfunction.GetListByDataTable((DataTable)srcTb, DMTypeBuilder.myType, item); } if (srcTb.GetType().FullName.Contains("List")) { srcList = (List <object>)srcTb; } if (srcTb.GetType().FullName.Contains("IEnumerable")) { srcList = (List <object>)srcTb; } ScriptCount += srcList.Count(); //if (progress != null) //{ // PassedArgs ps = new PassedArgs { ParameterInt1 = CurrentScriptRecord, ParameterInt2 = ScriptCount }; // progress.Report(ps); //} foreach (var r in srcList) { CurrentScriptRecord += 1; DMEEditor.ErrorObject = destds.InsertEntity(item.EntityName, r); token.ThrowIfCancellationRequested(); if (DMEEditor.ErrorObject.Flag == Errors.Failed) { SyncErrorsandTracking tr = new SyncErrorsandTracking(); errorcount++; tr.errormessage = DMEEditor.ErrorObject.Message; tr.errorsInfo = DMEEditor.ErrorObject; tr.rundate = DateTime.Now; tr.sourceEntityName = item.EntityName; tr.currenrecordindex = CurrentScriptRecord; tr.sourceDataSourceName = item.DataSourceID; tr.parentscriptid = sc.id; sc.Tracking.Add(tr); if (progress != null) { PassedArgs ps = new PassedArgs { EventType = "Update", ParameterInt1 = CurrentScriptRecord, ParameterInt2 = ScriptCount, ParameterString3 = DMEEditor.ErrorObject.Message }; progress.Report(ps); } if (errorcount >= StopErrorCount) { stoprun = true; PassedArgs ps = new PassedArgs { EventType = "Stop", ParameterInt1 = CurrentScriptRecord, ParameterInt2 = ScriptCount, ParameterString3 = DMEEditor.ErrorObject.Message }; progress.Report(ps); } } else { if (progress != null) { PassedArgs ps = new PassedArgs { EventType = "NA", ParameterInt1 = CurrentScriptRecord, ParameterInt2 = ScriptCount, ParameterString3 = DMEEditor.ErrorObject.Message }; progress.Report(ps); } } } } if (progress != null) { PassedArgs ps = new PassedArgs { ParameterString1 = $"Ended Copying Data from {srcentity} on {sourceds.DatasourceName} to {srcentity} on {destds.DatasourceName} ", ParameterInt1 = CurrentScriptRecord, ParameterInt2 = ScriptCount }; progress.Report(ps); } } else { DMEEditor.AddLogMessage("Copy Data", $"Error Could not Copy Entity Date {srcentity} on {sourceds.DatasourceName} to {srcentity} on {destds.DatasourceName} ", DateTime.Now, 0, null, Errors.Failed); } if (destds.Category == DatasourceCategory.RDBMS) { IRDBSource rDB = (IRDBSource)destds; rDB.EnableFKConstraints(item); } } else { DMEEditor.AddLogMessage("Copy Data", $"Error Could not Find Entity {srcentity} on {sourceds.DatasourceName} to {srcentity} on {destds.DatasourceName} ", DateTime.Now, 0, null, Errors.Failed); } } catch (Exception ex) { DMEEditor.AddLogMessage("Fail", $"Error copying Data {srcentity} on {sourceds.DatasourceName} to {srcentity} on {destds.DatasourceName} ({ex.Message})", DateTime.Now, -1, "CopyDatabase", Errors.Failed); } return(DMEEditor.ErrorObject); }
public IErrorsInfo CopyEntityData(IDataSource sourceds, IDataSource destds, string srcentity, string destentity, IProgress <PassedArgs> progress, CancellationToken token, bool CreateMissingEntity = true) { try { int errorcount = 0; EntityStructure item = sourceds.GetEntityStructure(srcentity, true); if (item != null) { if (destds.Category == DatasourceCategory.RDBMS) { IRDBSource rDB = (IRDBSource)destds; rDB.DisableFKConstraints(item); } if (destds.CreateEntityAs(item)) { object srcTb; string entname; var src = Task.Run(() => { return(sourceds.GetEntity(item.EntityName, null)); }); src.Wait(); srcTb = src.Result; List <object> srcList = new List <object>(); if (src.Result != null) { DMTypeBuilder.CreateNewObject(item.EntityName, item.EntityName, item.Fields); if (srcTb.GetType().FullName.Contains("DataTable")) { srcList = DMEEditor.Utilfunction.GetListByDataTable((DataTable)srcTb, DMTypeBuilder.myType, item); } if (srcTb.GetType().FullName.Contains("List")) { srcList = (List <object>)srcTb; } if (srcTb.GetType().FullName.Contains("IEnumerable")) { srcList = (List <object>)srcTb; } ScriptCount += srcList.Count(); //if (progress != null) //{ // PassedArgs ps = new PassedArgs { ParameterInt1 = CurrentScriptRecord, ParameterInt2 = ScriptCount }; // progress.Report(ps); //} foreach (var r in srcList) { CurrentScriptRecord += 1; DMEEditor.ErrorObject = destds.InsertEntity(item.EntityName, r); token.ThrowIfCancellationRequested(); if (progress != null) { PassedArgs ps = new PassedArgs { ParameterInt1 = CurrentScriptRecord, ParameterInt2 = ScriptCount, ParameterString3 = DMEEditor.ErrorObject.Message }; progress.Report(ps); } } } //var dst = Task.Run<IErrorsInfo>(() => { return destds.UpdateEntities(destentity, srcTb,progress); }); //dst.Wait(); if (progress != null) { PassedArgs ps = new PassedArgs { ParameterString1 = $"Ended Copying Data from {srcentity} on {sourceds.DatasourceName} to {srcentity} on {destds.DatasourceName} ", ParameterInt1 = CurrentScriptRecord, ParameterInt2 = ScriptCount }; progress.Report(ps); } // DMEEditor.AddLogMessage("Copy Data", $"Ended Copying Data from {srcentity} on {sourceds.DatasourceName} to {srcentity} on {destds.DatasourceName} ", DateTime.Now, 0, null, Errors.Ok); } else { DMEEditor.AddLogMessage("Copy Data", $"Error Could not Copy Entity Date {srcentity} on {sourceds.DatasourceName} to {srcentity} on {destds.DatasourceName} ", DateTime.Now, 0, null, Errors.Failed); } if (destds.Category == DatasourceCategory.RDBMS) { IRDBSource rDB = (IRDBSource)destds; rDB.EnableFKConstraints(item); } } else { DMEEditor.AddLogMessage("Copy Data", $"Error Could not Find Entity {srcentity} on {sourceds.DatasourceName} to {srcentity} on {destds.DatasourceName} ", DateTime.Now, 0, null, Errors.Failed); } } catch (Exception ex) { DMEEditor.AddLogMessage("Fail", $"Error copying Data {srcentity} on {sourceds.DatasourceName} to {srcentity} on {destds.DatasourceName} ({ex.Message})", DateTime.Now, -1, "CopyDatabase", Errors.Failed); } return(DMEEditor.ErrorObject); }