void llenarGrilla()
{
try
{
MGbackup.Rows.Clear();
BackupComponent backupComponent = new BackupComponent();
List <Backups> backups = new List <Backups>();
backups = backupComponent.MostrarJson();
int n = 0;
foreach (Backups item in backups)
{
n = MGbackup.Rows.Add();
MGbackup.Rows[n].Cells[0].Value = item.Nombre;
MGbackup.Rows[n].Cells[1].Value = item.FechaRestauracion;
MGbackup.Rows[n].Cells[2].Value = item.Nombre;
MGbackup.Rows[n].Cells[3].Value = item.Id;
MGbackup.Rows[n].Cells[4].Value = item.usuarios.Email;
MGbackup.Rows[n].Cells[5].Value = item.Fecha;
n++;
}
}
catch (Exception error)
{
MetroMessageBox.Show(this, error.Message, "Error al cargar", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
//
// GET: /DVV/Edit/5
public ActionResult Resultado(bool estado)
{
if (!estado)
{
BackupComponent backupComponent = new BackupComponent();
backupComponent.RestaurarBase();
}
return(View());
}
// GET: Backup/Create
public ActionResult Create()
{
BackupComponent backupComponent = new BackupComponent();
Usuarios usuarios = new Usuarios();
Usuarios user = new Usuarios();
user = (Usuarios)Session["UserName"];
backupComponent.Create(user.Id);
return(RedirectToAction("Index"));
}
/// <summary>
/// Set backup input properties
/// </summary>
/// <param name="input"></param>
public void SetBackupInput(BackupInfo input)
{
this.backupInfo = input;
// convert the types
this.backupComponent = (BackupComponent)input.BackupComponent;
this.backupType = (BackupType)input.BackupType;
this.backupDeviceType = (BackupDeviceType)input.BackupDeviceType;
if (this.backupRestoreUtil.IsHADRDatabase(this.backupInfo.DatabaseName))
{
this.isLocalPrimaryReplica = this.backupRestoreUtil.IsLocalPrimaryReplica(this.backupInfo.DatabaseName);
}
}
public ActionResult Delete(int id, FormCollection collection)
{
try
{
BackupComponent backupComponent = new BackupComponent();
backupComponent.Delete(id);
// TODO: Add delete logic here
return(RedirectToAction("Index"));
}
catch (Exception e)
{
return(View());
}
}
public ActionResult ConsistenciaBD(FormCollection collection)
{
try
{
bool status = bool.Parse(collection.Get("estado"));
if (!status)
{
BackupComponent backupComponent = new BackupComponent();
backupComponent.RestaurarBase();
}
// TODO: Add delete logic here
return(RedirectToAction("Index"));
}
catch (Exception e)
{
return(View());
}
}
// GET: Backup/Edit/5
public ActionResult Restore(int id)
{
try
{
// TODO: Add update logic here
Backups backups = new Backups();
backups.Id = id;
BackupComponent backupComponent = new BackupComponent();
Usuarios user = new Usuarios();
user = (Usuarios)Session["UserName"];
backups.usuarios = user;
backupComponent.RestoreDatabase(backups);
return(RedirectToAction("Index"));
}
catch (Exception e)
{
return(View());
}
}
public bool VerificarDVV()
{
UsuariosComponent usuariosComponent = new UsuariosComponent();
DVVComponent dVVComponent = new DVVComponent();
DVV dvvTabla = new DVV();
dvvTabla = dVVComponent.ObtenerDVV("Usuario");
string dvhTabla = usuariosComponent.ListaDVH();
DVV dvvGenerado = new DVV();
dvvGenerado = dVVComponent.GenerarDVV(dvhTabla, "Usuario");
if (dvvTabla.dvv == dvvGenerado.dvv)
{
return(true);
}
else
{
BackupComponent backupComponent = new BackupComponent();
backupComponent.RestaurarBase();
return(false);
}
}
public LoginError VerificarLogin(Usuarios usuarios)
{
BitacoraComponent bitacoraComponent = new BitacoraComponent();
Bitacora bitacora = new Bitacora();
bitacora.usuarios = usuarios;
bool userName = VeriricarUserName(usuarios);
LoginError loginError = new LoginError();
if (userName)
{
UsuariosComponent usuariosComponent = new UsuariosComponent();
Usuarios usuarioTabla = new Usuarios();
usuarioTabla = usuariosComponent.ReadByEmail(usuarios.Email);
bool password = VerificarContraseña(usuarioTabla.Id, usuarios);
VerificarIntentos(usuarioTabla.Id);
if (password)
{
bool DVH = VerificarDVH(usuarioTabla.Id, usuarios);
if (DVH)
{
bool DVV = VerificarDVV();
if (DVV)
{
if (VerificarBloqueado(usuarioTabla.Id))
{
bitacora.eventoBitacora.Id = 5;
bitacoraComponent.Create(bitacora);
loginError.error = "";
}
else
{
loginError.error = "La cuenta esta Bloqueada. Envie un email con el error a [email protected] ";
bitacora.eventoBitacora.Id = 1;
bitacoraComponent.Create(bitacora);
}
}
else
{
loginError.error = "Error Interno, vualva a intentar";
bitacora.eventoBitacora.Id = 2;
bitacoraComponent.Create(bitacora);
BackupComponent backupComponent = new BackupComponent();
backupComponent.RestaurarBase();
}
}
else
{
loginError.error = "Error Interno, vualva a intentar";
bitacora.eventoBitacora.Id = 3;
bitacoraComponent.Create(bitacora);
BackupComponent backupComponent = new BackupComponent();
backupComponent.RestaurarBase();
}
}
else
{
loginError.error = "Usuario o Contraseña Invalido";
bitacora.eventoBitacora.Id = 4;
bitacoraComponent.Create(bitacora);
}
}
else
{
loginError.error = "Usuario o Contraseña Invalido";
}
return(loginError);
}
// GET: Backup/Delete/5
public ActionResult Delete(int id)
{
BackupComponent backupComponent = new BackupComponent();
return(View(backupComponent.ReadBy(id)));
}
// GET: Backup
public ActionResult Index()
{
BackupComponent backupComponent = new BackupComponent();
return(View(backupComponent.Read()));
}
