public void RestoreDatabase(Backups backup) { //Genero la bitacora UsuariosComponent usuarios = new UsuariosComponent(); EventoBitacora eventoBitacora = new EventoBitacora(); Usuarios unUsuario = new Usuarios(); unUsuario.Id = 2; eventoBitacora.Id = 10; BitacoraComponent bitacoraComponent = new BitacoraComponent(); Bitacora bitacora = new Bitacora(backup.usuarios, eventoBitacora); bitacora.fecha = DateTime.Now.ToString("dd-MM-yyyy"); bitacora.hora = DateTime.Now.ToString("hh mm ss"); bitacoraComponent.Create(bitacora); Backups backupRestore = new Backups(backup.usuarios); BackupDAC backupDAC = new BackupDAC(); backupRestore = backupDAC.ReadBy(backup.Id); backupRestore.Path = @"C:\\Backup\" + backupRestore.Nombre + ".bak"; backupDAC.Restore(backupRestore); //restauro DVV y Base AUX UsuariosComponent usuariosComponent = new UsuariosComponent(); //usuariosComponent.RestoreBDAUX(); DVVComponent dVVComponent = new DVVComponent(); dVVComponent.CrearDVV(usuariosComponent.ListaDVH(), "Usuario"); var bkSerie = new Backups(usuariosComponent.ReadBy(unUsuario.Id)) { Fecha = bitacora.fecha, Path = backupRestore.Path, Nombre = backupRestore.Nombre, Id = backupRestore.Id, FechaRestauracion = DateTime.Now }; string output = JsonConvert.SerializeObject(bkSerie); DateTime date = new DateTime(); date = DateTime.Parse(bkSerie.Fecha); string filename = @"C:\Imagenes\json\" + date.ToString("dd-MM-yyyy") + date.ToString("ss") + ".json"; if (!File.Exists(filename)) { // Create a file to write to. System.IO.File.WriteAllText(filename, output); } else { string filename2 = @"C:\Imagenes\json\" + date.ToString("dd-MM-yyyy ss") + ".json"; System.IO.File.WriteAllText(filename2, output); } }
public void Delete(int id) { BackupDAC backupDAC = new BackupDAC(); Entities.Backups backups = new Backups(); backups = backupDAC.ReadBy(id); backups.Path = HostingEnvironment.MapPath("~/Backup/" + backups.Nombre + ".bak"); File.Delete(backups.Path); backupDAC.Delete(id); }
public void Delete(int id) { BackupDAC backupDAC = new BackupDAC(); Backups backups = new Backups(); backups = backupDAC.ReadBy(id); backups.Path = @"C:\\Backup\" + backups.Nombre + ".bak"; File.Delete(backups.Path); backupDAC.Delete(id); }
public void RestaurarBase() { Entities.Backups backupRestore = new Entities.Backups(); BackupDAC backupDAC = new BackupDAC(); backupRestore = backupDAC.ReadBy(); backupRestore.Path = HostingEnvironment.MapPath("~/Backup/" + backupRestore.Nombre + ".bak"); UsuariosComponent usuariosComponent = new UsuariosComponent(); RestoreDatabase(backupRestore); }
public void RestoreDatabase(Backups backup) { Entities.Backups backupRestore = new Entities.Backups(); BackupDAC backupDAC = new BackupDAC(); backupRestore = backupDAC.ReadBy(backup.Id); backupRestore.Path = HostingEnvironment.MapPath("~/Backup/" + backupRestore.Nombre + ".bak"); backupDAC.Restore(backupRestore); Bitacora bitacora = new Bitacora(); bitacora.eventoBitacora.Id = 11; UsuariosComponent usuarios = new UsuariosComponent(); bitacora.usuarios.Email = "*****@*****.**"; BitacoraComponent bitacoraComponent = new BitacoraComponent(); bitacoraComponent.Create(bitacora); }
public Backups ReadBy(int id) { BackupDAC backupDAC = new BackupDAC(); return(backupDAC.ReadBy(id)); }