public bool ExecuteNow() { ClientServer sc = new ClientServer(this.ClientID); DataExport de = new DataExport(sc.GetServer().Connection()); de.Merge <ExportSettings>(Settings); Data.ImportExport im = new Data.ImportExport(); try { Status = ImportExportStatus.progress; im.UpdateScheduleStatus(this.ClientID, ExportImportID, (int)Status, ""); string fileName = @"/sqldump-" + Guid.NewGuid().ToString() + ".sql"; var path = FolderPath + fileName; de.ExportTo(path); Status = ImportExportStatus.completed; im.UpdateScheduleStatus(this.ClientID, ExportImportID, (int)Status, "", fileName); } catch (Exception ex) { Status = ImportExportStatus.error; im.UpdateScheduleStatus(this.ClientID, ExportImportID, (int)Status, ex.Message); throw ex; } finally { } return(true); }
public bool Save() { Data.ImportExport im = new Data.ImportExport(); this.ExportImportID = im.SaveSchedule(this.ClientID, Newtonsoft.Json.JsonConvert.SerializeObject(Settings), 0, ExportDate, FolderPath, false, 2); return(true); }
public bool Save() { //ClientServer sc = new ClientServer(this.ClientID); Data.ImportExport im = new Data.ImportExport(); this.ExportImportID = im.SaveSchedule(this.ClientID, "", 0, DateTime.Now, ImportFilePath, IgnoreSQLErrors, 1); return(true); }
public string ImportFrom(string filePath, bool ignoreError) { try { Data.ImportExport im = new Data.ImportExport(); return(im.Import(Conn, ignoreError, filePath)); } catch (Exception ex) { throw ex; } }
public ExportEvent getExportEvent(string importExportID) { Data.ImportExport ie = new Data.ImportExport(); DataTable dt = ie.GetExportEventByID(this.ClientID, importExportID); var a = dt.toList <ExportEvent>(new DataFieldMappings().Add("ClientID", "ClientID") .Add("EventDateTime", "ExportDate") .Add("ImportExportID", "ExportImportID", true) .Add("FilePath", "FolderPath") .Add("Errors", "Errors") .Add("Status", "Status") .Add("Settings", "ExportSetting"), null, (x, y) => dynamic(x, y)); return(a.FirstOrDefault()); }
public List <ImportEvent> GetImportList() { Data.ImportExport ie = new Data.ImportExport(); DataTable dt = ie.GetAllImportEvents(this.ClientID); var a = dt.toList <ImportEvent>(new DataFieldMappings().Add("ClientID", "ClientID") .Add("EventDateTime", "ExportDate") .Add("ImportExportID", "ExportImportID", true) .Add("FilePath", "FolderPath") .Add("Errors", "Errors") .Add("Status", "Status") .Add("IgnoreSQLErrors", "IgnoreSQLErrors"), null, (x, y) => dynamic(x, y)); return(a); }
/// <summary> /// /// </summary> /// <returns></returns> public List <ExportEvent> GetPendingExportList() { Data.ImportExport ie = new Data.ImportExport(); DataTable dt = ie.GetPendingEvents(this.ClientID, 2); var a = dt.toList <ExportEvent>(new DataFieldMappings().Add("ClientID", "ClientID") .Add("EventDateTime", "ExportDate") .Add("ImportExportID", "ExportImportID", true) .Add("FilePath", "FolderPath") .Add("Errors", "Errors") .Add("Status", "Status") .Add("Settings", "ExportSetting"), null, (x, y) => dynamic(x, y)); a = a.Where(x => x.Status == ImportExportStatus.pending).ToList(); return(a); }
public bool ImportNow() { ClientServer sc = new ClientServer(this.ClientID); DataImport di = new DataImport(sc.GetServer().Connection()); Data.ImportExport im = new Data.ImportExport(); try { string assemblyFolder = Path.GetDirectoryName(Assembly.GetExecutingAssembly().CodeBase); assemblyFolder = assemblyFolder.Replace("\\Debug", ""); assemblyFolder = assemblyFolder.Replace("\\bin", ""); assemblyFolder = assemblyFolder.Replace("\\netcoreapp2.1", ""); assemblyFolder = assemblyFolder.Replace("file:\\", ""); if (ImportFilePath.StartsWith("~")) { ImportFilePath = ImportFilePath.Substring(1); } string impPath = assemblyFolder + ImportFilePath; Status = ImportExportStatus.progress; im.UpdateScheduleStatus(this.ClientID, ExportImportID, (int)Status, ""); string rst = di.ImportFrom(impPath, IgnoreSQLErrors); if (rst == "done") { Status = ImportExportStatus.completed; im.UpdateScheduleStatus(this.ClientID, ExportImportID, (int)Status, ""); return(true); } else { Status = ImportExportStatus.error; im.UpdateScheduleStatus(this.ClientID, ExportImportID, (int)Status, rst); return(false); } } catch (Exception ex) { Status = ImportExportStatus.error; im.UpdateScheduleStatus(this.ClientID, ExportImportID, (int)Status, ex.Message); throw ex; } finally { } }
public bool ExportTo(string folder) { Data.ImportExport im = new Data.ImportExport(); bool exTable = false; bool exRow = false; if (Type == ExportType.structureonly) { exTable = true; exRow = false; } else { exTable = true; exRow = true; } try { return(im.Export(Conn, folder, EnableDropDatabase, EnableCreateDatabase, EnableDropDatabase, exTable, exRow, EnableExportFunction, EnableExportStoredProcedure, EnableExportTrigger, EnableExportEvent, EnableExportViews, MaxSQLLength, (int)BlobExportMode)); } catch (Exception ex) { throw ex; } }