public static Room[] getRoomsAndSensorsFromFloor(int homeID) { Room[] rooms = getRoomsFromFloor(homeID); if (rooms != null) { foreach (Room room in rooms) { Sensor[] sensors = null; //room.Sensors = getSensorsFromRoom(room.RoomID); MySqlConnection connn = DBConection(); MySqlCommand cmd = new MySqlCommand("SELECT * FROM sensor WHERE idrooms = @roomID", con); cmd.Parameters.Add(new MySqlParameter("@roomID", room.RoomID)); //Sensor[] sensors = null; try { con.Open(); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); List <Sensor> sensorList = new List <Sensor>(); while (reader.Read()) { Sensor sensor = new Sensor(); sensor.SensorID = reader.GetInt32("idsensor"); sensor.Value = reader.GetString("v"); string t = reader.GetString("sensorTypes"); sensor.Type = CStuff.convertMySQLEnumToCSharpEnum <SensorTypeEnum>(t); //string s = reader.GetString("state"); //sensor.State = Common.convertMySQLEnumToCSharpEnum<AlarmState>(s); sensorList.Add(sensor); } reader.Close(); sensors = sensorList.ToArray(); } catch (Exception ex) { throw ex; } finally { con.Close(); } room.Sensors = sensors; } } return(rooms); }
private void Shom_Click(object sender, EventArgs e) { Shom.Enabled = false; // Console.WriteLine(SizeCB.Items); string selectedValue = (string)vHouses.SelectedItem; Console.WriteLine(selectedValue); //Intialize Rooms Array room = new Room[Convert.ToInt32(selectedValue), Convert.ToInt32(selectedValue)]; //Console.WriteLine(selectedValue); home = dbstuff.getHouseAndRooms(Convert.ToInt32(selectedValue)); // room = dbstuff.getRoomsAndSensorsFromFloor(Convert.ToInt32(selectedValue)); test = CStuff.creatDG(dgv, home.size, home.size); Console.WriteLine(home.size); roomss = dbstuff.getRoomsFromFloor(home.Idhome); foreach (Room room in roomss) { dgv.Rows[room.X].Cells[room.Y].Value = room.Type + room.DLocations; } // Console.WriteLine(roomss[0].RoomID); // Console.WriteLine(home.Rooms[home.Idhome, home.Idhome]); // home.Rooms[home.size,home.size]; }
private void EHome_Load(object sender, EventArgs e) { try { MySqlConnection con = dbstuff.DBConection(); string selectQuery = "SELECT * FROM alarm.home where userID=@userid"; con.Open(); MySqlCommand cmd = new MySqlCommand(selectQuery, con); cmd.Parameters.AddWithValue("@userid", User.UserID); Console.WriteLine(User.UserID); MySqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { vHouses.Items.Add(reader.GetString("idhome")); } con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } CStuff.fillComboBoxFromEnum <RLocation>(ref CBCat); CStuff.fillListBoxFromEnum <Locations>(ref CLDL); CStuff.fillComboBoxFromEnum <RoomType>(ref CBType); CStuff.fillComboBoxFromEnum <SensorTypeEnum>(ref sensorTypess); }
public static Room[] getRoomsFromFloor(int homeID) { MySqlConnection con = DBConection(); MySqlCommand cmd = new MySqlCommand("SELECT * FROM rooms WHERE idhome = @homeID", con); cmd.Parameters.Add(new MySqlParameter("@homeID", homeID)); Room[] rooms = null; try { con.Open(); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); List <Room> roomList = new List <Room>(); while (reader.Read()) { Room room = new Room(); room.RoomID = reader.GetInt32("idrooms"); room.X = reader.GetInt32("x"); room.Y = reader.GetInt32("y"); room.DLocations = reader.GetString("DLocation"); string t = reader.GetString("roomsType"); room.Type = CStuff.convertMySQLEnumToCSharpEnum <RoomType>(t); //string c = reader.GetString("RLocation"); //if (c != null) //{ // room.Category = CStuff.convertMySQLEnumToCSharpEnum<RLocation>(c); //} /// room.Category = CStuff.convertMySQLEnumToCSharpEnum<RLocation>(c); roomList.Add(room); } reader.Close(); rooms = roomList.ToArray(); } catch (Exception ex) { throw ex; } finally { con.Close(); } return(rooms); }
//public static Sensor[] getSensorsFromRoom(int roomID) //{ // MySqlConnection con = DBConection(); // MySqlCommand cmd = new MySqlCommand("SELECT * FROM sensor WHERE idrooms = @roomID", con); // cmd.Parameters.Add(new MySqlParameter("@roomID", roomID)); // Sensor[] sensors = null; // try // { // con.Open(); // cmd.ExecuteNonQuery(); // MySqlDataReader reader = cmd.ExecuteReader(); // List<Sensor> sensorList = new List<Sensor>(); // while (reader.Read()) // { // Sensor sensor = new Sensor(); // sensor.SensorID = reader.GetInt32("idsensor"); // sensor.Value = reader.GetString("v"); // string t = reader.GetString("sensorTypes"); // sensor.Type = CStuff.convertMySQLEnumToCSharpEnum<SensorTypeEnum>(t); // //string s = reader.GetString("state"); // //sensor.State = Common.convertMySQLEnumToCSharpEnum<AlarmState>(s); // sensorList.Add(sensor); // } // reader.Close(); // sensors = sensorList.ToArray(); // } // catch (Exception ex) // { // throw ex; // } // finally // { // con.Close(); // } // return sensors; //} public static House getHouse(int houseid) { MySqlConnection con1 = DBConection(); MySqlCommand cmd = new MySqlCommand("SELECT * FROM home WHERE idhome = @houseID", con1); cmd.Parameters.Add(new MySqlParameter("@houseID", houseid)); House home = null; try { con1.Open(); cmd.ExecuteNonQuery(); MySqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { home = new House(); home.Idhome = reader.GetInt32("idhome"); House.HomeIDs = reader.GetInt32("idhome"); home.size = reader.GetInt32("x"); string s = reader.GetString("alarmS"); home.State = CStuff.convertMySQLEnumToCSharpEnum <AlarmS>(s); home.HName = reader.GetString("hName"); int x = reader.GetInt32("x"); int y = reader.GetInt32("y"); home.Rooms = new Room[x, y]; } else { Console.WriteLine($"No home with user ID of '{houseid}' found."); } reader.Close(); } catch (Exception ex) { throw ex; } finally { con1.Close(); } return(home); }
private void addRoom_Click(object sender, EventArgs e) { string selectedValue = (string)vHouses.SelectedItem; // room = new Room[Int32.Parse(XX.Text), Int32.Parse(YY.Text)]; var op = (RoomType)Enum.Parse(typeof(RoomType), CBType.Text.Replace(' ', '_')); // home.Rooms[Int32.Parse(XX.Text), Int32.Parse(YY.Text)] = ; // Room room = home.Rooms[Int32.Parse(XX.Text), Int32.Parse(YY.Text)]; int x = Int32.Parse(XX.Text); int y = Int32.Parse(YY.Text); room[x, y] = new Room(); room[x, y].Type = (RoomType)Enum.Parse(typeof(RoomType), CBType.Text); Console.WriteLine(room[x, y].Type); Test = ""; foreach (int i in CLDL.CheckedIndices) { Test += CLDL.Items[i].ToString(); } Console.WriteLine(dbstuff.insertRoom(House.homeIDs, x, y, CBType.Text, Test)); // Console.WriteLine(room); //room[Int32.Parse(YY.Text), Int32.Parse(XX.Text)].Type = (RoomType)Enum.Parse(typeof(RoomType), CBType.Text.Replace(' ', '_')); // Console.WriteLine(op); dgv.Rows[Int32.Parse(XX.Text)].Cells[Int32.Parse(YY.Text)].Value = CBType.Text; //Remake Table home = dbstuff.getHouseAndRooms(Convert.ToInt32(selectedValue)); // room = dbstuff.getRoomsAndSensorsFromFloor(Convert.ToInt32(selectedValue)); test = CStuff.creatDG(dgv, home.size, home.size); Console.WriteLine(home.size); roomss = dbstuff.getRoomsFromFloor(home.Idhome); foreach (Room room in roomss) { dgv.Rows[room.X].Cells[room.Y].Value = room.Type + room.DLocations; } }