protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
// Showing devices against the roomID
string roomid = null;
string query = "SELECT * FROM devices d";
if (Request.QueryString["roomid"] != null)
{
roomid = Request.QueryString["roomid"].ToString();
query = "SELECT d.*,r.name as RoomName FROM devices d";
query += " inner join rooms r on r.id= d.roomid where roomid=" + roomid;
}
lstDevices = new List <DeviceRomms>();
using (var db = new SmartHomeDB()) {
lstDevices = db.Database.SqlQuery <DeviceRomms>(query).ToList();
}
lblRoomName.Text = lstDevices[0].RoomName;
gvDevices.DataSource = lstDevices;
gvDevices.DataBind();
Session["devices"] = lstDevices;
//#region MQTT Connection
//MqttClient MQTTclient;
//MQTTclient = new MqttClient("test.mosquitto.org");
//MQTTclient.Connect("esp");
//MQTTclient.MqttMsgPublishReceived += client_MqttMsgPublishReceived;
//#endregion
}
}
protected void Page_Load(object sender, EventArgs e)
{
List <Room> lstRooms = new List <Room>();
if (!Page.IsPostBack)
{
using (var db = new SmartHomeDB()) {
lstRooms = db.Database.SqlQuery <Room>("SELECT * FROM rooms where userid=1").ToList();
}
gvRooms.DataSource = lstRooms;
gvRooms.DataBind();
}
}
protected void gvDevices_RowCommand(object sender, GridViewCommandEventArgs e)
{
lstDevices = (List <DeviceRomms>)Session["devices"];
if (e.CommandName.ToString() == "OP")
{
using (var db = new SmartHomeDB()) {
var a = db.MyDevices; //.ToList();
var b = a.Where(d => d.ID.ToString() == e.CommandArgument.ToString()).FirstOrDefault();
b.STATE = !b.STATE;
db.SaveChanges();
var device = lstDevices.Where(d => d.ID.ToString() == e.CommandArgument.ToString()).FirstOrDefault(); //.STATE
device.STATE = !device.STATE;
gvDevices.DataSource = lstDevices;
gvDevices.DataBind();
}
}
}
