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(); } } }