public bool RestoreBDByTime(DateTime dateTimeRestore) { QueryStrings.CurrentPathDevice = ExecuteQuery <String> .Execute(ConnectionInfo, QueryStrings.GetDevicePath, (sqlDataReader) => { return(SqlSupport.Read <String>(sqlDataReader, "physical_name")); }).FirstOrDefault(); QueryStrings.ThirdRestoreDBByTime = dateTimeRestore.ToString("yyyy-MM-dd HH:mm:ss"); try { ExecuteQuery <int> .ExecuteNonQuery(ConnectionInfo, QueryStrings.FirstRestoreDbByTime); ExecuteQuery <int> .Execute(ConnectionInfo, QueryStrings.SecondRestoreDBByTime, null); ExecuteQuery <int> .ExecuteNonQuery(ConnectionInfo, QueryStrings.ThirdRestoreDBByTime); ExecuteQuery <int> .ExecuteNonQuery(ConnectionInfo, QueryStrings.LastRestoreDBByTime); return(true); } catch (SqlException sqlEx) { return(false); } }
public bool CreateDevice() { String currentPath = this.GetType().Assembly.Location; String folderPath = currentPath.Substring(0, currentPath.LastIndexOf("\\")); DirectoryInfo directoryInfo = null; if (!Directory.Exists($"{folderPath}\\BackupFiles\\{CurrentDataBase.Name}")) { directoryInfo = Directory.CreateDirectory($"{folderPath}\\BackupFiles\\{CurrentDataBase.Name}"); } if (directoryInfo == null) { QueryStrings.CurrentPathDevice = $"{folderPath}\\BackupFiles\\{CurrentDataBase.Name}\\{CurrentDataBase.Name}.bak"; } else { QueryStrings.CurrentPathDevice = $"{directoryInfo.FullName}\\{CurrentDataBase.Name}.bak"; } IEnumerable <Boolean> result = ExecuteQuery <Boolean> .Execute(ConnectionInfo, QueryStrings.CreateDevice, (sqlDataReader) => { return(SqlSupport.Read <Boolean>(sqlDataReader, "")); }); this.CurrentDataBase = _currentDB; return(result.FirstOrDefault()); }
private string GetCurrentDeviceOfDB() { IEnumerable <String> devicesname = ExecuteQuery <String> .Execute(ConnectionInfo, QueryStrings.GetAllDeviceNameByDBName , (sqlDataReader) => { return(SqlSupport.Read <String>(sqlDataReader, "logical_device_name")); }); return(devicesname.FirstOrDefault()); }
private bool CurrentDBHadDevice() { IEnumerable <String> devicesname = ExecuteQuery <String> .Execute(ConnectionInfo, QueryStrings.GetAllDeviceName , (sqlDataReader) => { return(SqlSupport.Read <String>(sqlDataReader, "name")); }); return(devicesname.Where(x => x.Contains(CurrentDataBase.Name)).Count() > 0); }
private IEnumerable <PositionBackupInfo> GetAllPositionBackupVersions() { return(ExecuteQuery <PositionBackupInfo> .Execute(ConnectionInfo, QueryStrings.GetAllPositionOfBackupVersions, (sqlDataReader) => { return new PositionBackupInfo() { Position = SqlSupport.Read <Int32>(sqlDataReader, "position"), Description = SqlSupport.Read <String>(sqlDataReader, "description"), BackupDateTime = SqlSupport.Read <DateTime>(sqlDataReader, "backup_start_date"), UserBackup = SqlSupport.Read <String>(sqlDataReader, "user_name"), }; } )); }
public bool ValidateRestoreDBByTime() { try { int result = ExecuteQuery <int> .Execute(ConnectionInfo, QueryStrings.ValidateRestoreDBByTime, (sqlDataReader) => { return(SqlSupport.Read <Int32>(sqlDataReader, "result")); }).FirstOrDefault <int>(); if (result == 0) { return(false); } return(true); } catch (SqlException sqlEx) { return(false); } }
public BK(ConnectionInfo connectionInfo, ListDatabaseBaseChanged changed, CurrentDatabaseChanged currentChanged) { ConnectionInfo = connectionInfo; this.OnListDatabaseBaseChanged = changed; this.OnCurrentDatabaseChanged = currentChanged; DatabaseBases = ExecuteQuery <DatabaseBase> .Execute(connectionInfo, QueryStrings.GetAllDatabaseName, (sqlDataReader) => { return(new DatabaseBase() { ID = SqlSupport.Read <Int32>(sqlDataReader, "database_id"), Name = SqlSupport.Read <String>(sqlDataReader, "name"), }); }).ToList <DatabaseBase>(); if (DatabaseBases.Count != 0) { CurrentDataBase = DatabaseBases[0]; } }