protected void Timer1_Tick(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["Login"];
if (cookie == null)
{
Response.Redirect("index.aspx");
return;
}
string id = cookie.Value;
List <SensorTemperatura> sensores = new List <SensorTemperatura>();
// Cria e abre a conexão com o banco de dados
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbThermalCat"].ToString())) {
conn.Open();
// Cria um comando para selecionar registros da tabela
using (SqlCommand cmd = new SqlCommand(@"
SELECT tbArduino.identificador, tbTemperatura.temperatura
FROM tbArduino CROSS APPLY
(SELECT TOP(1) tbTemperatura.temperatura
FROM tbTemperatura
WHERE tbTemperatura.idArduino = tbArduino.id
ORDER BY tbTemperatura.dataHora DESC
) tbTemperatura, tbUsuario, tbAfiliacao
WHERE tbUsuario.id=@id and tbAfiliacao.id=tbUsuario.idAfiliacao and tbArduino.idAfiliacao=tbAfiliacao.id
", conn)) {
cmd.Parameters.AddWithValue("@id", id);
using (SqlDataReader reader = cmd.ExecuteReader()) {
// Obtém os registros, um por vez
while (reader.Read() == true)
{
SensorTemperatura s = new SensorTemperatura();
s.NomeSensor = reader.GetValue(0).ToString();
s.Temperatura = reader.GetValue(1).ToString() + "°";
sensores.Add(s);
}
}
}
}
listRepeater.DataSource = sensores;
listRepeater.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
HttpCookie cookie = Request.Cookies["Login"];
if (cookie == null)
{
Response.Redirect("index.aspx");
return;
}
string id = cookie.Value;
List <SensorTemperatura> sensores = new List <SensorTemperatura>();
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["dbThermalCat"].ToString())){
cn.Open();
using (SqlCommand cmd = new SqlCommand(@"
SELECT tbUsuario.nome, tbUsuario.sobrenome, tbUsuario.idAcesso, tbAcesso.hierarquia, tbAfiliacao.nome
FROM tbUsuario, tbAcesso, tbAfiliacao
WHERE tbUsuario.id=@id and tbUsuario.idAcesso=tbAcesso.id and tbAfiliacao.id=tbUsuario.idAfiliacao", cn)){
cmd.Parameters.AddWithValue("@id", id);
using (SqlDataReader sdr = cmd.ExecuteReader()){
if (sdr.Read())
{
string nome = sdr.GetValue(sdr.GetOrdinal("nome")).ToString() + " " + sdr.GetValue(sdr.GetOrdinal("sobrenome")).ToString();
UserName.Text = nome;
UserAccess.Text = sdr.GetValue(sdr.GetOrdinal("hierarquia")).ToString();
Empresa.Text = sdr.GetValue(4).ToString();
if (!sdr.GetValue(sdr.GetOrdinal("idAcesso")).ToString().Equals("4"))
{
StringBuilder strScript = new StringBuilder();
strScript.Append(@"
<button id='AddUser' class='fa fa-plus-circle' data-toggle='tooltip' data-placement='bottom' title='Cadastrar'></button>
<button id='EditUser' class='fa fa-pencil' data-toggle='tooltip' data-placement='bottom' title='Editar'></button>
<button id='DeleteUser' class='fa fa-trash' data-toggle='tooltip' data-placement='bottom' title='Deletar'></button>
");
ltScripts.Text = strScript.ToString();
}
}
}
}
using (SqlCommand cmd = new SqlCommand(@"
SELECT tbArduino.identificador, tbTemperatura.temperatura
FROM tbArduino CROSS APPLY
(SELECT TOP(1) tbTemperatura.temperatura
FROM tbTemperatura
WHERE tbTemperatura.idArduino = tbArduino.id
ORDER BY tbTemperatura.dataHora DESC
) tbTemperatura, tbUsuario, tbAfiliacao
WHERE tbUsuario.id=@id and tbAfiliacao.id=tbUsuario.idAfiliacao and tbArduino.idAfiliacao=tbAfiliacao.id
", cn)){
cmd.Parameters.AddWithValue("@id", id);
using (SqlDataReader reader = cmd.ExecuteReader()) {
// Obtém os registros, um por vez
while (reader.Read() == true)
{
SensorTemperatura s = new SensorTemperatura();
s.NomeSensor = reader.GetValue(0).ToString();
s.Temperatura = "0°";
sensores.Add(s);
}
}
}
}
listRepeater.DataSource = sensores;
listRepeater.DataBind();
}