//Select statement
public Modulo Select(int id)
{
string query = "select modulo.tipo,modulo.idmodulo,modulo.nome,localizacao,estado,para from modulo join usuario on modulo.idusuario=usuario.idusuario left join ligacao l on l.idmodulo = modulo.idmodulo where usuario.idusuario=" + id;
//Create a list to store the result
Modulo modulo = new Modulo();
List <No> lista = new List <No>();
List <Ligacao> ligacao = new List <Ligacao>();
No auxiliarNo = new No();
Ligacao auxiliarLigacao = new Ligacao();
auxiliarNo.id = 0; auxiliarNo.label = "Casa";
lista.Add(auxiliarNo);
//Open connection
if (this.OpenConnection() == true)
{
//Create Command
MySqlCommand cmd = new MySqlCommand(query, connection);
//Create a data reader and Execute the command
MySqlDataReader dataReader = cmd.ExecuteReader();
//Read the data and store them in the list
while (dataReader.Read())
{
auxiliarNo = new No();
auxiliarLigacao = new Ligacao();
auxiliarNo.id = Convert.ToInt32(dataReader["idmodulo"]);
auxiliarNo.label = Convert.ToString(dataReader["nome"]);
auxiliarLigacao.from = Convert.ToInt32(dataReader["idmodulo"]);
auxiliarNo.tipo = Convert.ToInt32(dataReader["tipo"]);
if (auxiliarNo.tipo == 1)
{
auxiliarLigacao.to = Convert.ToInt32(dataReader["para"]);
auxiliarNo.attributes = Convert.ToString(dataReader["localizacao"]);
auxiliarNo.title = Convert.ToInt32(dataReader["estado"]) == 1 ? "Ligado" : "Desligado";
if (Convert.ToInt32(dataReader["estado"]) == 1)
{
auxiliarNo.color = "#FA5858";
}
else
{
auxiliarNo.color = "#00FF80";
}
}
else
{
auxiliarNo.color = "#F2F5A9";
auxiliarLigacao.to = 0;
}
lista.Add(auxiliarNo);
ligacao.Add(auxiliarLigacao);
}
modulo.nos = lista;
modulo.ligacoes = ligacao;
//close Data Reader
dataReader.Close();
//close Connection
this.CloseConnection();
//return list to be displayed
return(modulo);
}
else
{
return(modulo);
}
}
public Controladora()
{
Controladora_Modulo = new Modulo();
Controladora_Operaciones = new List <Operacion>();
}