public IHttpActionResult UpdateOnline(ConnectedModels connected)
{
IDbConnection con = new ApplicationDbContext().Database.Connection;
ConnectedModels infoConnectedPlayer;
string sqlUno = $"SELECT * FROM dbo.Connected WHERE Id = '{connected.Id}'";
try
{
infoConnectedPlayer = con.Query <ConnectedModels>(sqlUno).FirstOrDefault();
}
catch (Exception ex)
{
return(BadRequest("Error al obtener Usuario Online individual, " + ex.Message));
}
if (!string.IsNullOrEmpty(connected.Estado))
{
infoConnectedPlayer.Estado = connected.Estado;
}
if (!string.IsNullOrEmpty(connected.NickName))
{
infoConnectedPlayer.NickName = connected.NickName;
}
if (!string.IsNullOrEmpty(connected.ImageUser))
{
infoConnectedPlayer.ImageUser = connected.ImageUser;
}
string sql = "UPDATE dbo.Connected " +
$"SET NickName = '{infoConnectedPlayer.NickName}', Estado = '{infoConnectedPlayer.Estado}', " +
$"ImageUser = '******'" +
$" WHERE Id = '{infoConnectedPlayer.Id}'";
try
{
con.Execute(sql);
}
catch (Exception e)
{
return(BadRequest("Error Update Online in database, " + e.Message));
}
finally
{
con.Close();
}
return(Ok());
}
public IHttpActionResult InsertarOnline(ConnectedModels online)
{
IDbConnection con = new ApplicationDbContext().Database.Connection;
string sql = "INSERT INTO dbo.Connected(Id,Estado,NickName,ImageUser)" +
$" VALUES ('{online.Id}','Menu','{online.NickName}','{online.ImageUser}')";
try
{
con.Execute(sql);
}
catch (Exception e)
{
return(BadRequest("Error al insertar online, " + e.Message));
}
finally
{
con.Close();
}
return(Ok());
}
public IHttpActionResult EliminarOnline(ConnectedModels connected)
{
IDbConnection con = new ApplicationDbContext().Database.Connection;
string sql = "DELETE FROM dbo.Connected" +
$" WHERE Id = '{connected.Id}'";
try
{
con.Execute(sql);
}
catch (Exception e)
{
return(BadRequest("Error al eliminar online, " + e.Message));
}
finally
{
con.Close();
}
return(Ok());
}
