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