public async Task <IActionResult> Edit(string id)
{
try
{
var baseDatos = new Adscbdd
{
AdbdBdd = id,
};
var respuesta = await apiServicio.SeleccionarAsync(baseDatos, new Uri(WebApp.BaseAddress),
"api/BasesDatos/SeleccionarAdscBdd");
respuesta.Resultado = JsonConvert.DeserializeObject <Adscbdd>(respuesta.Resultado.ToString());
if (respuesta.IsSuccess)
{
return(View(respuesta.Resultado));
}
return(NotFound());
}
catch (Exception ex)
{
var responseLog = new EntradaLog
{
ExceptionTrace = ex.HResult.ToString() + " - " + ex.Message + " - " + ex.Source,
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Critical),
LogLevelShortName = Convert.ToString(LogLevelParameter.ERR),
ObjectPrevious = null,
ObjectNext = null,
};
await apiServicio.SalvarLog <entidades.Utils.Response>(HttpContext, responseLog);
return(BadRequest());
}
}
public async Task <IActionResult> Create(Adscbdd baseDato)
{
try
{
var response = new entidades.Utils.Response();
if (ModelState.IsValid)
{
response = await apiServicio.InsertarAsync(baseDato,
new Uri(WebApp.BaseAddress),
"api/BasesDatos/InsertarBaseDatos");
if (response.IsSuccess)
{
try
{
var responseLog = new EntradaLog
{
ExceptionTrace = null,
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Create),
LogLevelShortName = Convert.ToString(LogLevelParameter.ADV),
ObjectPrevious = null,
ObjectNext = JsonConvert.SerializeObject(response.Resultado),
};
await apiServicio.SalvarLog <entidades.Utils.Response>(HttpContext, responseLog);
}
catch (Exception)
{
return(RedirectToAction("Index"));
throw;
}
return(RedirectToAction("Index"));
}
}
InicializarMensaje(response.Message);
return(View(baseDato));
}
catch (Exception ex)
{
var responseLog = new EntradaLog
{
ExceptionTrace = ex.Message,
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Critical),
LogLevelShortName = Convert.ToString(LogLevelParameter.ERR),
ObjectPrevious = null,
ObjectNext = null,
};
await apiServicio.SalvarLog <entidades.Utils.Response>(HttpContext, responseLog);
return(BadRequest());
}
}
public async Task <Response> PostAdscbdd([FromBody] Adscbdd adscbdd)
{
try
{
if (!ModelState.IsValid)
{
return(new Response
{
IsSuccess = false,
Message = Mensaje.ModeloInvalido,
});
}
var respuesta = Existe(adscbdd);
if (!respuesta.IsSuccess)
{
db.Adscbdd.Add(adscbdd);
await db.SaveChangesAsync();
return(new Response
{
IsSuccess = true,
Message = Mensaje.Satisfactorio,
Resultado = adscbdd,
});
}
return(new Response
{
IsSuccess = false,
Message = Mensaje.ExisteRegistro
});
}
catch (Exception ex)
{
await GuardarLogService.SaveLogEntry(new LogEntryTranfer
{
ApplicationName = Convert.ToString(Aplicacion.SwSeguridad),
ExceptionTrace = ex,
Message = "Se ha producido una exepción",
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Critical),
LogLevelShortName = Convert.ToString(LogLevelParameter.ERR),
UserName = "",
});
return(new Response
{
IsSuccess = false,
Message = "Error ",
});
}
}
public async Task <Response> GetAdscbdd([FromBody] Adscbdd adscbdd)
{
try
{
if (!ModelState.IsValid)
{
return(new Response
{
IsSuccess = false,
Message = Mensaje.ModeloInvalido,
});
}
var respuesta = await db.Adscbdd.SingleOrDefaultAsync(m => m.AdbdBdd == adscbdd.AdbdBdd);
if (adscbdd == null)
{
return(new Response
{
IsSuccess = false,
Message = Mensaje.RegistroNoEncontrado,
});
}
return(new Response
{
IsSuccess = true,
Message = "Ok",
Resultado = respuesta,
});
}
catch (Exception ex)
{
await GuardarLogService.SaveLogEntry(new LogEntryTranfer
{
ApplicationName = Convert.ToString(Aplicacion.SwSeguridad),
ExceptionTrace = ex,
Message = "Se ha producido una exepción",
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Critical),
LogLevelShortName = Convert.ToString(LogLevelParameter.ERR),
UserName = "",
});
return(new Response
{
IsSuccess = false,
Message = "Error ",
});
}
}
public async Task <IActionResult> Edit(string id, Adscbdd adscbdd)
{
try
{
if (ModelState.IsValid)
{
var respuestaActualizar = await apiServicio.SeleccionarAsync(adscbdd, new Uri(WebApp.BaseAddress),
"api/BasesDatos/SeleccionarAdscBdd");
var respuesta = await apiServicio.EditarAsync(adscbdd, new Uri(WebApp.BaseAddress),
"api/BasesDatos/EditarAdscbdd");
if (respuesta.IsSuccess)
{
var responseLog = new EntradaLog
{
ExceptionTrace = null,
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Edit),
LogLevelShortName = Convert.ToString(LogLevelParameter.ADV),
ObjectPrevious = JsonConvert.SerializeObject(respuestaActualizar.Resultado),
ObjectNext = JsonConvert.SerializeObject(respuesta.Resultado),
};
await apiServicio.SalvarLog <entidades.Utils.Response>(HttpContext, responseLog);
return(RedirectToAction("Index"));
}
ViewData["Error"] = respuesta.Message;
}
return(View(adscbdd));
}
catch (Exception ex)
{
var responseLog = new EntradaLog
{
ExceptionTrace = ex.Message,
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Critical),
LogLevelShortName = Convert.ToString(LogLevelParameter.ERR),
ObjectPrevious = null,
ObjectNext = null,
};
await apiServicio.SalvarLog <entidades.Utils.Response>(HttpContext, responseLog);
return(BadRequest());
}
}
public async Task <Response> CrearAsync(Adscbdd adscbdd)
{
Response response = new Response();
try
{
response = await apiservicio.InsertarAsync(adscbdd,
new Uri(WebApp.BaseAddress),
"/api/BasesDatos/InsertarBaseDatos");
if (response.IsSuccess)
{
var responseLog = await GuardarLogService.SaveLogEntry(new LogEntryTranfer
{
ApplicationName = Convert.ToString(Aplicacion.WebAppSeguridad),
ExceptionTrace = null,
Message = "Se ha creado una base de datos",
UserName = "******",
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Create),
LogLevelShortName = Convert.ToString(LogLevelParameter.ADV),
EntityID = string.Format("{0} {1}", "Base de Datos:", adscbdd.AdbdBdd),
});
}
return(response);
}
catch (Exception ex)
{
await GuardarLogService.SaveLogEntry(new LogEntryTranfer
{
ApplicationName = Convert.ToString(Aplicacion.WebAppSeguridad),
Message = "Creando Base de Datos",
ExceptionTrace = ex,
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Create),
LogLevelShortName = Convert.ToString(LogLevelParameter.ERR),
UserName = "******"
});
response.IsSuccess = false;
response.Message = ex.Message;
return(response);
}
}
public async Task <Response> EditarAsync(string id, Adscbdd adscbdd)
{
Response response = new Response();
try
{
if (!string.IsNullOrEmpty(id))
{
response = await apiservicio.EditarAsync(id, adscbdd, new Uri(WebApp.BaseAddress),
"/api/BasesDatos");
if (response.IsSuccess)
{
await GuardarLogService.SaveLogEntry(new LogEntryTranfer
{
ApplicationName = Convert.ToString(Aplicacion.WebAppSeguridad),
EntityID = string.Format("{0} : {1}", "Base de Datos", id),
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Edit),
LogLevelShortName = Convert.ToString(LogLevelParameter.ADV),
Message = "Se ha actualizado un registro",
UserName = "******"
});
}
}
return(response);
}
catch (Exception ex)
{
await GuardarLogService.SaveLogEntry(new LogEntryTranfer
{
ApplicationName = Convert.ToString(Aplicacion.WebAppSeguridad),
Message = "Editando una base de datos",
ExceptionTrace = ex,
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Edit),
LogLevelShortName = Convert.ToString(LogLevelParameter.ERR),
UserName = "******"
});
response.IsSuccess = false;
response.Message = ex.Message;
return(response);
}
}
private Response Existe(Adscbdd adscbdd)
{
var bdd = adscbdd.AdbdBdd.ToUpper().TrimEnd().TrimStart();
var loglevelrespuesta = db.Adscbdd.Where(p => p.AdbdBdd.ToUpper().TrimStart().TrimEnd() == bdd).FirstOrDefault();
if (loglevelrespuesta != null)
{
return(new Response
{
IsSuccess = true,
Message = "Existe una base de datos de igual nombre",
Resultado = null,
});
}
return(new Response
{
IsSuccess = false,
Resultado = loglevelrespuesta,
});
}
public async Task <IActionResult> Edit(string id, Adscbdd adscbdd)
{
try
{
if (ModelState.IsValid)
{
var respuesta = await baseDatosServicio.EditarAsync(id, adscbdd);
if (respuesta.IsSuccess)
{
return(RedirectToAction("Index"));
}
ViewData["Error"] = respuesta.Message;
}
return(View(adscbdd));
}
catch (Exception)
{
return(BadRequest());
}
}
public async Task <IActionResult> Create(Adscbdd baseDato)
{
try
{
var response = new Response();
if (ModelState.IsValid)
{
response = await baseDatosServicio.CrearAsync(baseDato);
if (response.IsSuccess)
{
return(RedirectToAction("Index"));
}
}
InicializarMensaje(response.Message);
return(View(baseDato));
}
catch (Exception)
{
return(BadRequest());
}
}
public async Task <Adscbdd> SeleccionarAdscbdd(Adscbdd adscbdd)
{
var respuesta = await db.Adscbdd.Where(x => x.AdbdBdd == adscbdd.AdbdBdd).FirstOrDefaultAsync();
return(respuesta);
}
public async Task <Response> PutAdscbdd([FromBody] Adscbdd adscbdd)
{
try
{
if (!ModelState.IsValid)
{
return(new Response
{
IsSuccess = false,
Message = Mensaje.ModeloInvalido
});
}
var RespuestaActualizar = await SeleccionarAdscbdd(adscbdd);
if (RespuestaActualizar != null)
{
try
{
RespuestaActualizar.AdbdBdd = adscbdd.AdbdBdd;
RespuestaActualizar.AdbdDescripcion = adscbdd.AdbdDescripcion;
RespuestaActualizar.AdbdServidor = adscbdd.AdbdServidor;
db.Adscbdd.Update(RespuestaActualizar);
await db.SaveChangesAsync();
return(new Response
{
IsSuccess = true,
Message = Mensaje.Satisfactorio,
Resultado = RespuestaActualizar,
});
}
catch (Exception ex)
{
await GuardarLogService.SaveLogEntry(new LogEntryTranfer
{
ApplicationName = Convert.ToString(Aplicacion.SwSeguridad),
ExceptionTrace = ex,
Message = Mensaje.Excepcion,
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Critical),
LogLevelShortName = Convert.ToString(LogLevelParameter.ERR),
UserName = "",
});
return(new Response
{
IsSuccess = false,
Message = Mensaje.Error,
});
}
}
return(new Response
{
IsSuccess = false,
Message = Mensaje.ExisteRegistro
});
}
catch (Exception)
{
return(new Response
{
IsSuccess = false,
Message = Mensaje.Excepcion
});
}
}
public async Task <Response> PutAdscbdd([FromRoute] string id, [FromBody] Adscbdd adscbdd)
{
try
{
if (!ModelState.IsValid)
{
return(new Response
{
IsSuccess = false,
Message = "Módelo inválido"
});
}
var adscdbbActualizar = await db.Adscbdd.Where(x => x.AdbdBdd == id).FirstOrDefaultAsync();
if (adscdbbActualizar != null)
{
try
{
adscdbbActualizar.AdbdDescripcion = adscbdd.AdbdDescripcion;
adscdbbActualizar.AdbdServidor = adscbdd.AdbdServidor;
db.Adscbdd.Update(adscdbbActualizar);
await db.SaveChangesAsync();
return(new Response
{
IsSuccess = true,
Message = "Ok",
});
}
catch (Exception ex)
{
await GuardarLogService.SaveLogEntry(new LogEntryTranfer
{
ApplicationName = Convert.ToString(Aplicacion.SwSeguridad),
ExceptionTrace = ex,
Message = "Se ha producido una exepción",
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Critical),
LogLevelShortName = Convert.ToString(LogLevelParameter.ERR),
UserName = "",
});
return(new Response
{
IsSuccess = false,
Message = "Error ",
});
}
}
return(new Response
{
IsSuccess = false,
Message = "Existe"
});
}
catch (Exception)
{
return(new Response
{
IsSuccess = false,
Message = "Excepción"
});
}
}
