private static async Task <string> ExecuteSqlDatabase(ModelTaskServiceSettings setting) { try { Adapters.AdapterSqlDatabase sqlDatabase = new Adapters.AdapterSqlDatabase(setting); var schedules = await sqlDatabase.GetDatabaseBackupSchedule(setting.Url, DateTime.Now.Hour, false); //foreach (var bkpSchedule in schedules) //{ //} if (setting.IsDebug) { foreach (var sch in schedules) { await WriteLog("Iniciando processo backup de: " + sch.Databases.DatabaseName + " " + sch.DateHourExecution.Hour); } } for (int i = 0; i < schedules.Count;) { int isExecute = schedules[i].DateHourExecution.Minute.CompareTo(DateTime.Now.Minute); int lastExecution = schedules[i].DateHourLastExecution.Date.CompareTo(DateTime.Now.Date); if ((isExecute == 0 && lastExecution == -1) || (isExecute == -1 && lastExecution == -1) && !schedules[i].BackupStatus.Equals(Model.Enum.BackupStatus.Runing)) { var isUpdated = await _helperSqlDatabase.UpdateStatusDateTimeBackup(schedules[i], Model.Enum.BackupStatus.Runing, setting); var resp = _helperSqlDatabase.BackupRun(schedules[i], setting); i++; } } await Task.Delay((setting.UpdateInterval * 60) * 1000); return("OK"); } catch (Exception err) { await WriteLog(err.Message); return("OK"); } }
private static async Task <string> ExecuteUploadGoogleDrive(ModelTaskServiceSettings setting) { try { Adapters.AdapterSqlDatabase sqlDatabase = new Adapters.AdapterSqlDatabase(setting); var schedules = await sqlDatabase.GetDatabaseBackupSchedule(setting.Url, DateTime.Now.Hour, true); for (int i = 0; i < schedules.Count; i++) { var resp = _helperSqlDatabase.ExecuteUpload(schedules[i], setting); } await Task.Delay((setting.UpdateInterval * 60) * 1000); return("OK"); } catch (Exception err) { await WriteLog(err.Message); return("OK"); } }