public IHttpActionResult UpdatePartida(GamesModels games)
{
GamesModels newGame;
IDbConnection con = new ApplicationDbContext().Database.Connection;
string sqlIdPartida = $"SELECT Id FROM dbo.Games WHERE IdPlayer = '{games.IdPlayer}' ORDER BY Id ASC";
try
{
newGame = con.Query <GamesModels>(sqlIdPartida).LastOrDefault();
}
catch (Exception ex)
{
return(BadRequest("No se ha podido encontrar la partida, " + ex.Message));
}
string sql = "UPDATE dbo.Games " +
$"SET Final = '{DateTime.Now}', Points = {games.Points}" +
$" WHERE Id = '{newGame.Id}'";
try
{
con.Execute(sql);
}
catch (Exception e)
{
return(BadRequest("Error al actualizar una partida," + e.Message));
}
finally
{
con.Close();
}
return(Ok());
}
public IHttpActionResult InsertPartidaNueva(GamesModels partida)
{
IDbConnection con = new ApplicationDbContext().Database.Connection;
// IdJugador,Inicio, Final, Dificultad y puntuacion
string sql = "INSERT INTO dbo.Games(IdPlayer,Final,Difficulty,Points)" +
$" VALUES ('{partida.IdPlayer}',null,{partida.Difficulty},0)";
try
{
con.Execute(sql);
}
catch (Exception e)
{
return(BadRequest("Error insertar nueva partida," + e.Message));
}
finally
{
con.Close();
}
return(Ok());
}
