public static UtenteGuest GetCamera(Guid userId)
{
UtenteGuest res = new UtenteGuest();
object floorId = null;
SqlConnection conn = new SqlConnection(cnnStr);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand("SELECT NR_Camera From Users WHERE ID = @id"
, conn);
cmd.Parameters.AddWithValue("@id", userId);
SqlDataReader result = cmd.ExecuteReader();
while (result.Read())
{
res.Stanza = int.Parse(result[0].ToString());
}
SqlCommand cmd2 = new SqlCommand("SELECT ID_Piano,Temperatura,Porta from Rooms Where Camera = @RoomId", conn);
cmd2.Parameters.AddWithValue("@RoomId", res.Stanza);
result.Close();
SqlDataReader result2 = cmd2.ExecuteReader();
while (result2.Read())
{
floorId = result2[0];
res.Temperatura = decimal.Parse(result2[1].ToString());
res.StatoPorta = bool.Parse(result2[2].ToString());
}
SqlCommand cmd3 = new SqlCommand(" SELECT Piano from Floors Where ID = @FloorId", conn);
cmd3.Parameters.AddWithValue("@FloorId", floorId);
result2.Close();
SqlDataReader result3 = cmd3.ExecuteReader();
while (result3.Read())
{
res.Piano = int.Parse(result3[0].ToString());
}
result3.Close();
}
catch
{
return(null);
}
finally
{
conn.Close();
}
return(res);
}
public static void SetTemperatura(UtenteGuest utente)
{
SqlConnection conn = new SqlConnection(cnnStr);
try
{
SqlCommand cmd = new SqlCommand("UPDATE Rooms SET Temperatura = @temp WHERE Camera = @roomID", conn);
cmd.Parameters.AddWithValue("@temp", utente.Temperatura);
cmd.Parameters.AddWithValue("@roomID", utente.Stanza);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
catch
{
return;
}
}
public static List <UtenteGuest> getRooms(string x)
{
List <UtenteGuest> list = new List <UtenteGuest>();
UtenteGuest ut = new UtenteGuest();
SqlConnection conn = new SqlConnection(cnnStr);
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(@"SELECT Rooms.Temperatura,Rooms.Porta,Rooms.Camera,Rooms.Occupata FROM Floors
JOIN Rooms ON Rooms.ID_Piano = Floors.ID AND Piano = @floor", conn);
cmd.Parameters.AddWithValue("@floor", x);
var result = cmd.ExecuteReader();
while (result.Read())
{
list.Add(new UtenteGuest()
{
Piano = int.Parse(x),
Stanza = int.Parse(result[2].ToString()),
Temperatura = decimal.Parse(result[0].ToString()),
StatoPorta = bool.Parse(result[1].ToString()),
Occupato = bool.Parse(result[3].ToString())
});
}
}
catch (Exception ex)
{
Console.WriteLine(ex);
}
finally
{
conn.Close();
}
return(list);
}
