public RPiConnection GetRPiConnection(int rpiConnectionId)
{
RPiConnection rpiConnection = new RPiConnection();
using (var cmd = new NpgsqlCommand())
{
cmd.Connection = this.npgSqlCon;
cmd.CommandText = "SELECT id, ip, port, password, user_id_connected, last_touch FROM public.rpi_connection WHERE id=(@rpiconid)";
cmd.Parameters.AddWithValue("@rpiconid", rpiConnectionId);
using (var reader = cmd.ExecuteReader())
{
reader.Read();
rpiConnection.rowId = reader.GetInt32(0);
rpiConnection.ip = reader.GetString(1);
rpiConnection.port = reader.GetInt32(2);
rpiConnection.status = "disconnected";
rpiConnection.password = reader.GetString(3);
rpiConnection.userId = reader.IsDBNull(4) ? -1 : reader.GetInt32(4);
rpiConnection.lastTouch = reader.GetInt32(5);
}
}
rpiConnection.userRights = this.GetRPiConnectionUserRights(rpiConnection.rowId);
return(rpiConnection);
}
public List <RPiConnection> GetRPiConnections()
{
List <RPiConnection> rpiConnections = new List <RPiConnection>();
using (var cmd = new NpgsqlCommand())
{
cmd.Connection = this.npgSqlCon;
cmd.CommandText = "SELECT id, ip, port, password, user_id_connected, last_touch FROM public.rpi_connection ORDER BY id";
using (var reader = cmd.ExecuteReader())
{
while (reader.Read())
{
RPiConnection rpiConnection = new RPiConnection();
rpiConnection.rowId = reader.GetInt32(0);
rpiConnection.ip = reader.GetString(1);
rpiConnection.port = reader.GetInt32(2);
rpiConnection.status = "disconnected";
rpiConnection.password = reader.GetString(3);
rpiConnection.userId = reader.IsDBNull(4) ? -1 : reader.GetInt32(4);
rpiConnection.lastTouch = reader.GetInt32(5);
rpiConnections.Add(rpiConnection);
}
}
}
rpiConnections.ForEach(rpiCon =>
{
rpiCon.userRights = this.GetRPiConnectionUserRights(rpiCon.rowId);
});
return(rpiConnections);
}
public JsonResult Get(int id)
{
if (!this.auth.ValidateToken(this.auth.GetToken(), out string authResponse))
{
this.HttpContext.Response.StatusCode = 401;
return(Json(new string[] { authResponse }));
}
RPiConnection rpiCon = this.rpiConService.GetRPiConnection(id);
rpiCon.password = "******";
return(Json(rpiCon));
}
public JsonResult GetConnect(int id)
{
if (!this.auth.ValidateToken(this.auth.GetToken(), out string authResponse))
{
this.HttpContext.Response.StatusCode = 401;
return(Json(new string[] { authResponse }));
}
try
{
RPiConnection rpiCon = this.rpiConService.SetRPiConnectionStatus(id, "connected");
rpiCon.password = "******";
return(Json(rpiCon));
}
catch (NpgsqlException e)
{
this.HttpContext.Response.StatusCode = 403;
return(Json("Database exception!"));
}
}
