public void TesteRetornaDestreza()
{
DbConsultas dbConsultas = new DbConsultas();
Destreza resultado = dbConsultas.RetornaDestreza(10);
Assert.AreEqual(resultado.Classe, "N");
Assert.AreEqual(resultado.Pontos, 10);
}
public Destreza RetornaDestreza(int nrPontos)
{
SQLiteManager dbManager = new SQLiteManager();
Destreza resultado = new Destreza();
using (var db = dbManager.CreateDbContext(args))
{
resultado = db.TabelaDestreza.Single(x => x.Pontos == nrPontos);
}
return(resultado);
}
public async Task <Response> PostDestreza([FromBody] Destreza Destreza)
{
try
{
if (!ModelState.IsValid)
{
return(new Response
{
IsSuccess = false,
Message = ""
});
}
var respuesta = Existe(Destreza);
if (!respuesta.IsSuccess)
{
db.Destreza.Add(Destreza);
await db.SaveChangesAsync();
return(new Response
{
IsSuccess = true,
Message = Mensaje.Satisfactorio
});
}
return(new Response
{
IsSuccess = false,
Message = Mensaje.ExisteRegistro
});
}
catch (Exception ex)
{
await GuardarLogService.SaveLogEntry(new LogEntryTranfer
{
ApplicationName = Convert.ToString(Aplicacion.SwTH),
ExceptionTrace = ex.Message,
Message = Mensaje.Excepcion,
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Critical),
LogLevelShortName = Convert.ToString(LogLevelParameter.ERR),
UserName = "",
});
return(new Response
{
IsSuccess = false,
Message = Mensaje.Error,
});
}
}
public async Task <IActionResult> Create(Destreza destreza)
{
if (!ModelState.IsValid)
{
InicializarMensaje(null);
return(View(destreza));
}
Response response = new Response();
try
{
response = await apiServicio.InsertarAsync(destreza,
new Uri(WebApp.BaseAddress),
"api/Destrezas/InsertarDestreza");
if (response.IsSuccess)
{
var responseLog = await GuardarLogService.SaveLogEntry(new LogEntryTranfer
{
ApplicationName = Convert.ToString(Aplicacion.WebAppTh),
ExceptionTrace = null,
Message = "Se ha creado una destreza",
UserName = "******",
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Create),
LogLevelShortName = Convert.ToString(LogLevelParameter.ADV),
EntityID = string.Format("{0} {1}", "Destreza:", destreza.IdDestreza),
});
return(RedirectToAction("Index"));
}
ViewData["Error"] = response.Message;
return(View(destreza));
}
catch (Exception ex)
{
await GuardarLogService.SaveLogEntry(new LogEntryTranfer
{
ApplicationName = Convert.ToString(Aplicacion.WebAppTh),
Message = "Creando Destreza",
ExceptionTrace = ex.Message,
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Create),
LogLevelShortName = Convert.ToString(LogLevelParameter.ERR),
UserName = "******"
});
return(BadRequest());
}
}
public async Task <IActionResult> Edit(string id, Destreza destreza)
{
Response response = new Response();
try
{
if (!string.IsNullOrEmpty(id))
{
response = await apiServicio.EditarAsync(id, destreza, new Uri(WebApp.BaseAddress),
"api/Destrezas");
if (response.IsSuccess)
{
await GuardarLogService.SaveLogEntry(new LogEntryTranfer
{
ApplicationName = Convert.ToString(Aplicacion.WebAppTh),
EntityID = string.Format("{0} : {1}", "Destreza", id),
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Edit),
LogLevelShortName = Convert.ToString(LogLevelParameter.ADV),
Message = "Se ha actualizado una destreza",
UserName = "******"
});
return(RedirectToAction("Index"));
}
ViewData["Error"] = response.Message;
return(View(destreza));
}
return(BadRequest());
}
catch (Exception ex)
{
await GuardarLogService.SaveLogEntry(new LogEntryTranfer
{
ApplicationName = Convert.ToString(Aplicacion.WebAppTh),
Message = "Editando una destreza",
ExceptionTrace = ex.Message,
LogCategoryParametre = Convert.ToString(LogCategoryParameter.Edit),
LogLevelShortName = Convert.ToString(LogLevelParameter.ERR),
UserName = "******"
});
return(BadRequest());
}
}
private Response Existe(Destreza Destreza)
{
var bdd = Destreza.Nombre.ToUpper().TrimEnd().TrimStart();
var Destrezarespuesta = db.Destreza.Where(p => p.Nombre.ToUpper().TrimStart().TrimEnd() == bdd).FirstOrDefault();
if (Destrezarespuesta != null)
{
return(new Response
{
IsSuccess = true,
Message = Mensaje.ExisteRegistro,
Resultado = null,
});
}
return(new Response
{
IsSuccess = false,
Resultado = Destrezarespuesta,
});
}
public async Task <Response> PutDestreza([FromRoute] int id, [FromBody] Destreza Destreza)
{
try
{
if (!ModelState.IsValid)
{
return(new Response
{
IsSuccess = false,
Message = Mensaje.ModeloInvalido
});
}
var existe = Existe(Destreza);
if (existe.IsSuccess)
{
return(new Response
{
IsSuccess = false,
Message = Mensaje.ExisteRegistro,
});
}
var DestrezaActualizar = await db.Destreza.Where(x => x.IdDestreza == id).FirstOrDefaultAsync();
if (DestrezaActualizar != null)
{
try
{
DestrezaActualizar.Nombre = Destreza.Nombre;
db.Destreza.Update(DestrezaActualizar);
await db.SaveChangesAsync();
return(new Response
{
IsSuccess = true,
Message = Mensaje.Satisfactorio,
});
}
catch (Exception ex)
{
await GuardarLogService.SaveLogEntry(new LogEntryTranfer
{
ApplicationName = Convert.ToString(Aplicacion.SwTH),
ExceptionTrace = ex.Message,
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
});
}
}
