Ejemplo n.º 1
0
        public Form1()
        {
            InitializeComponent();

            ArrayList list = new ArrayList();

            databaseconnection NewConnection = new databaseconnection();
            NewConnection.dbConnection();

            MySqlCommand querysql = new MySqlCommand("select * from distrito", databaseconnection.db);

            MySqlDataReader dataread = querysql.ExecuteReader();



            //int count = 0;
            while (dataread.Read())
            {
                // count = count + 1;
                //comboBox1.Items.Add(dataread["id_distrito"].ToString() + " " + "-" + " " + dataread["nome_dist"].ToString());
                list.Add(dataread["id_distrito"].ToString());
                list.Add(dataread["nome_dist"].ToString());
            }

            foreach (string value in list)
            {
                MessageBox.Show(value);
                //Console.WriteLine(value); // bird, plant
            }

           // dataGrid1.ItemsSource = list;
            //comboBox1.Items.Add("Adicionar novo Distrito");
            /*if (count == 0)
            {
                comboBox1.Visibility = Visibility.Hidden;
            }

            else
            {
                comboBox1.Visibility = Visibility.Visible;

            }*/

            databaseconnection.db.Close();




        }
Ejemplo n.º 2
0
        // Login
        private void button2_Click(object sender, RoutedEventArgs e)
        {
            databaseconnection NewConnection = new databaseconnection();
            NewConnection.dbConnection();
            MySqlCommand querysql = new MySqlCommand("select nome_util, password from utilizadores where nome_util='" + this.textBox1.Text + "' and password='******'", databaseconnection.db);
            MySqlDataReader dataread = querysql.ExecuteReader();
            int count = 0;
            while (dataread.Read())
            {
                count = 1;
            }

            if (count == 1)
            {

                MessageBox.Show("Login with sucess!!");
                tabControl1.SelectedIndex = 1;
                button2.Visibility = Visibility.Hidden;
                button3.Visibility = Visibility.Visible;
                int temp = textBox3.Text.Length;
                if (temp == 0)
                {
                    button4.IsHitTestVisible = false;
                }
                else
                {
                    button4.IsHitTestVisible = true;
                }
            }

            else
            {
                MessageBox.Show("Invalid User ID ou Password!!");
            }

            databaseconnection.db.Close();
        }
Ejemplo n.º 3
0
        // inserir sintomas.
        private void button22_Click(object sender, RoutedEventArgs e)
        {
            
            String selectedItem = comboBox5.Items[comboBox5.SelectedIndex].ToString();
            String selectedItem1 = comboBox6.Items[comboBox6.SelectedIndex].ToString();
            String selectedItem2 = comboBox7.Items[comboBox7.SelectedIndex].ToString();
            String selectedItem3 = comboBox9.Items[comboBox9.SelectedIndex].ToString();
            String[] getid_pai = selectedItem.Split(' ');
            String[] getid_prox = selectedItem1.Split(' ');
            String[] getid_def = selectedItem2.Split(' ');
            int aux1 = Convert.ToInt32(getid_pai[0]);
            int aux2 = Convert.ToInt32(getid_prox[0]);
            int aux3 = Convert.ToInt32(getid_def[0]);
            databaseconnection NewConnection = new databaseconnection();
            NewConnection.dbConnection();

            if (String.Compare(selectedItem3, "Sem Resposta.")==0 && aux3 == 0)
            {
                MySqlCommand querysql = new MySqlCommand("INSERT INTO sintomas (sintoma, id_quest_fk, prox_quest) Values ('" + this.textBox11.Text + "','"+ aux1 +"','" + aux2 + "')", databaseconnection.db);
                querysql.ExecuteNonQuery();
                databaseconnection.db.Close();
              
                MessageBox.Show("Sucesso!!");
                textBox11.Clear();
            }

            
        }
Ejemplo n.º 4
0
        // questionario inserir perguntas
        private void button14_Click(object sender, RoutedEventArgs e)
        {
            String selectedItem1 = comboBox4.Items[comboBox4.SelectedIndex].ToString();
            String[] getid_qs = selectedItem1.Split(' ');
            int aux1 = Convert.ToInt32(getid_qs[0]);
            databaseconnection NewConnection = new databaseconnection();
            NewConnection.dbConnection();

            

            if (radioButton3.IsChecked == true)
            {
                MySqlCommand querysql = new MySqlCommand("INSERT INTO questionarios (questao, id_qs_fk) Values ('" + this.textBox7.Text + "','"+ aux1 +"')", databaseconnection.db);
                querysql.ExecuteNonQuery();

                MySqlCommand querysql1 = new MySqlCommand("SELECT id_quest FROM questionarios WHERE questao = '" + this.textBox7.Text + "'", databaseconnection.db);
                MySqlDataReader dataread = querysql1.ExecuteReader();
                String readaux = "";
                while (dataread.Read())
                {
                    readaux = dataread["id_quest"].ToString();
                }
                dataread.Close();
                int getid_perg = Convert.ToInt32(readaux);

                MySqlCommand querysql2 = new MySqlCommand("UPDATE questionset SET questionarios_id_quest = '" + getid_perg + "' WHERE id_qs = '" + aux1 + "'", databaseconnection.db);
                querysql2.ExecuteNonQuery();

                MessageBox.Show("Sucesso!!");
                radioButton3.IsEnabled = false;
                radioButton4.IsChecked = true;
                
            }
            if (radioButton4.IsChecked == true)
            {
                MySqlCommand querysql = new MySqlCommand("INSERT INTO questionarios (questao, id_qs_fk) Values ('" + this.textBox7.Text + "','" + aux1 + "')", databaseconnection.db);
                querysql.ExecuteNonQuery();
            }
            if (radioButton3.IsChecked == false && radioButton4.IsChecked == false)
            {
               
            }

            textBox7.Clear();

            databaseconnection.db.Close();
            MessageBox.Show("Sucesso!!");
        }
Ejemplo n.º 5
0
        // inserir especie
        private void button21_Click(object sender, RoutedEventArgs e)
        {
            String selectedItem1 = comboBox8.Items[comboBox8.SelectedIndex].ToString();
            String[] getid_qs = selectedItem1.Split(' ');
            int aux1 = Convert.ToInt32(getid_qs[0]);
           
            databaseconnection NewConnection = new databaseconnection();
            NewConnection.dbConnection();

            MySqlCommand querysql = new MySqlCommand("INSERT INTO especies (nome_comum, nome_cientifico, questionset_id_qs) Values ('" + this.textBox9.Text + "','" + this.textBox10.Text + "','"+ aux1 +"')", databaseconnection.db);
            querysql.ExecuteNonQuery();
            databaseconnection.db.Close();
            MessageBox.Show("Sucesso!!");
            FTPclass ligacao = new FTPclass();
            ligacao.criar_diretoria(url, user, pwd, this.textBox9.Text);

            string arquivo = ligacao.getfolderfile(this.textBox9.Text, "Sem deficiencia");
            //MessageBox.Show(arquivo);
            //string path = System.IO.Path.GetDirectoryName(arquivo);
            string nome_arquivo = System.IO.Path.GetFileName(arquivo) ; 
            ligacao.upload(arquivo,url,user,pwd,nome_arquivo,this.textBox9.Text);
            MessageBox.Show("Operação com Sucesso!!");
            textBox9.Clear();
            textBox10.Clear();

            

            

        }
Ejemplo n.º 6
0
        private void button20_Click(object sender, RoutedEventArgs e)
        {
            tabControl1.SelectedIndex = 10;

            button5.Visibility = Visibility.Visible;

            databaseconnection NewConnection = new databaseconnection();
            NewConnection.dbConnection();

            databaseconnection.db.Close();
        }
Ejemplo n.º 7
0
        // inserir pergunta de prediagnostico e fazer inserção seguinte
        private void button11_Click(object sender, RoutedEventArgs e)
        {
            String temp1="";
            String selectedItem1 = comboBox2.Items[comboBox2.SelectedIndex].ToString();
            String selectedItem2 = comboBox3.Items[comboBox3.SelectedIndex].ToString();
            String[] getid_qs = selectedItem1.Split(' ');
            String[] getid_pred = selectedItem2.Split(' ');
            int aux = Convert.ToInt32(getid_pred[0]);
            int aux1 = Convert.ToInt32(getid_qs[0]);

            if (radioButton2.IsChecked == true)
            {
                temp1 = radioButton2.Content.ToString();
                MessageBox.Show(temp1);
            }
            if (radioButton1.IsChecked == true)
            {
                temp1 = radioButton1.Content.ToString();
                MessageBox.Show(temp1);
            }
            if(radioButton2.IsChecked == false && radioButton1.IsChecked == false)
            {
                temp1 = null;
                MessageBox.Show(temp1);
            }
            databaseconnection NewConnection = new databaseconnection();
            NewConnection.dbConnection();



            if (String.Compare(selectedItem2, "0 - Esta é a primeira pergunta!") == 0)
            {
                MySqlCommand querysql = new MySqlCommand("INSERT INTO pre_diagnostico (pergunta, resposta, flag, id_qs_fk_pd) Values ('" + this.textBox5.Text + "', '" + this.textBox6.Text + "', '" + temp1 + "','" + aux1 + "')", databaseconnection.db);
                querysql.ExecuteNonQuery();
                MessageBox.Show("teste!!");

                MySqlCommand querysql1 = new MySqlCommand("SELECT id_pergunta FROM pre_diagnostico WHERE pergunta = '" + this.textBox5.Text + "'", databaseconnection.db);
                MySqlDataReader dataread = querysql1.ExecuteReader();
                String readaux="";
                while (dataread.Read())
                {
                    readaux = dataread["id_pergunta"].ToString();
                }
                dataread.Close();
                int getid_perg = Convert.ToInt32(readaux);

                MySqlCommand querysql2 = new MySqlCommand("UPDATE questionset SET pre_diagnostico_perguntaid = '" + getid_perg + "' WHERE id_qs = '" + aux1 + "'", databaseconnection.db);
                querysql2.ExecuteNonQuery();
                                
                MessageBox.Show("Sucesso!!");

            }
            else
            {
                MySqlCommand querysql = new MySqlCommand("INSERT INTO pre_diagnostico (pergunta, resposta, flag, id_qs_fk_pd) Values ('" + this.textBox5.Text + "', '" + this.textBox6.Text + "', '" + temp1 + "','" + aux1 + "')", databaseconnection.db);
                querysql.ExecuteNonQuery();
                MessageBox.Show("teste!!");

                MySqlCommand querysql1 = new MySqlCommand("SELECT id_pergunta FROM pre_diagnostico WHERE pergunta = '" + this.textBox5.Text + "'", databaseconnection.db);
                MySqlDataReader dataread = querysql1.ExecuteReader();
                String readaux = "";
                while (dataread.Read())
                {
                    readaux = dataread["id_pergunta"].ToString();
                }
                dataread.Close();
                int getid_perg = Convert.ToInt32(readaux);

                MySqlCommand querysql2 = new MySqlCommand("UPDATE pre_diagnostico SET pre_diagnostico_id_pergunta= '" + getid_perg + "' WHERE id_pergunta = '" + aux + "'", databaseconnection.db);
                querysql2.ExecuteNonQuery();

                MessageBox.Show("Sucesso!!");
            }

            MessageBox.Show("Sucesso!!");

            radioButton1.IsChecked = false;
            radioButton2.IsChecked = false;
            textBox5.Clear();
            textBox6.Clear();
            comboBox3.Items.Clear();

            MySqlCommand querysql3 = new MySqlCommand("select * from pre_diagnostico", databaseconnection.db);
            MySqlDataReader dataread1 = querysql3.ExecuteReader();
            int count = 0;
            while (dataread1.Read())
            {
                count++;
                comboBox3.Items.Add(dataread1["id_pergunta"].ToString() + " " + "-" + " " + dataread1["pergunta"].ToString());
            }
        

            dataread1.Close();
            databaseconnection.db.Close();

            comboBox3.SelectedIndex = count-1;

        }
Ejemplo n.º 8
0
        // menu inserir sintomas
        private void button18_Click(object sender, RoutedEventArgs e)
        {
            tabControl1.SelectedIndex = 7;

            button5.Visibility = Visibility.Visible;

            comboBox9.Items.Add("Sem Resposta.");
            comboBox9.Items.Add("Apresenta a seguinte deficiência nutritiva:");
            comboBox9.Items.Add("Poderá não ser uma deficiência nutritiva.");
            comboBox9.SelectedIndex = 0;


            databaseconnection NewConnection = new databaseconnection();
            NewConnection.dbConnection();

            MySqlCommand querysql = new MySqlCommand("select * from questionarios", databaseconnection.db);

            MySqlDataReader dataread = querysql.ExecuteReader();
  
            while (dataread.Read())
            {
               
                comboBox5.Items.Add(dataread["id_quest"].ToString() + " " + "-" + " " + dataread["questao"].ToString());
                comboBox6.Items.Add(dataread["id_quest"].ToString() + " " + "-" + " " + dataread["questao"].ToString());
            }
            dataread.Close();

            MySqlCommand querysql1 = new MySqlCommand("select * from deficiencias", databaseconnection.db);

            MySqlDataReader dataread1 = querysql1.ExecuteReader();

            comboBox7.Items.Add("0 - Sem deficiência.");
            while (dataread1.Read())
            {

                comboBox7.Items.Add(dataread1["id_deficiencia"].ToString() + " " + "-" + " " + dataread1["nome_deficiencia"].ToString());
                
            }
            dataread1.Close();
            
            comboBox5.SelectedIndex = 0;
            comboBox6.SelectedIndex = 1;
            comboBox7.SelectedIndex = 0;

            databaseconnection.db.Close();
        }
Ejemplo n.º 9
0
        //menu inserir especie
        private void button19_Click(object sender, RoutedEventArgs e)
        {
            tabControl1.SelectedIndex = 9;

            button5.Visibility = Visibility.Visible;

            databaseconnection NewConnection = new databaseconnection();
            NewConnection.dbConnection();

            MySqlCommand querysql = new MySqlCommand("select * from Questionset", databaseconnection.db);

            MySqlDataReader dataread = querysql.ExecuteReader();

            int count = 0;
            while (dataread.Read())
            {
                count = count + 1;
                comboBox8.Items.Add(dataread["id_qs"].ToString() + " " + "-" + " " + dataread["name_qs"].ToString());
            }

            comboBox8.SelectedIndex = 0;
            databaseconnection.db.Close();

        }
Ejemplo n.º 10
0
        // inserir deficieencia
        private void button16_Click(object sender, RoutedEventArgs e)
        {
            databaseconnection NewConnection = new databaseconnection();
            NewConnection.dbConnection();

            MySqlCommand querysql = new MySqlCommand("INSERT INTO deficiencias (nome_deficiencia) Values ('" + this.textBox8.Text + "')", databaseconnection.db);
            querysql.ExecuteNonQuery();
            databaseconnection.db.Close();
            MessageBox.Show("Sucesso!!");
        }
Ejemplo n.º 11
0
        // pre-diagnostico menu botão
        private void button9_Click(object sender, RoutedEventArgs e)
        {
            tabControl1.SelectedIndex = 5;

            button5.Visibility = Visibility.Visible;

            databaseconnection NewConnection = new databaseconnection();
            NewConnection.dbConnection();

            MySqlCommand querysql = new MySqlCommand("select * from Questionset", databaseconnection.db);
            
            MySqlDataReader dataread = querysql.ExecuteReader();
           
            int count = 0;
            comboBox2.Items.Add("Escolha a sua QuestionSet");
            while (dataread.Read())
            {
                count = count + 1;
                comboBox2.Items.Add(dataread["id_qs"].ToString() + " " + "-" + " " + dataread["name_qs"].ToString());
            }

            
            if (count == 0)
            {
                comboBox2.Visibility = Visibility.Visible;
            }

            else
            {
                comboBox2.Visibility = Visibility.Visible;

            }
            dataread.Close();

            MySqlCommand querysql1 = new MySqlCommand("select * from pre_diagnostico", databaseconnection.db);
            MySqlDataReader dataread1 = querysql1.ExecuteReader();

            comboBox3.Items.Add("0 - Esta é a primeira pergunta!");
            while (dataread1.Read())
            {
                comboBox3.Items.Add(dataread1["id_pergunta"].ToString() + " " + "-" + " " + dataread1["pergunta"].ToString());
            }
            dataread1.Close();
            databaseconnection.db.Close();

            comboBox2.SelectedIndex = 0;
            comboBox3.SelectedIndex = 0;
           

        }
Ejemplo n.º 12
0
        // inserir concelho
        private void button7_Click(object sender, RoutedEventArgs e)
        {

            string selectedItem = comboBox1.Items[comboBox1.SelectedIndex].ToString();

            string[] getid_dist = selectedItem.Split(' ');

            databaseconnection NewConnection = new databaseconnection();
            NewConnection.dbConnection();

            MySqlCommand querysql = new MySqlCommand("INSERT INTO concelho (iddistrito_fk, nome_conc) Values ('" + getid_dist[0] + "','" + this.textBox2.Text + "')", databaseconnection.db);
            querysql.ExecuteNonQuery();
            databaseconnection.db.Close();
            MessageBox.Show("Sucesso!!");

        }
Ejemplo n.º 13
0
        // inserir concelho
        private void button6_Click(object sender, RoutedEventArgs e)
        {
            tabControl1.SelectedIndex = 3;
            textBox2.Clear();
            button2.Visibility = Visibility.Hidden;
            button5.Visibility = Visibility.Visible;
            
            databaseconnection NewConnection = new databaseconnection();
            NewConnection.dbConnection();

            MySqlCommand querysql = new MySqlCommand("select * from distrito", databaseconnection.db);

            MySqlDataReader dataread = querysql.ExecuteReader();

                                  
        
            int count = 0;
            while (dataread.Read())
            {
                count = count + 1;
                comboBox1.Items.Add(dataread["id_distrito"].ToString() + " " + "-" + " " + dataread["nome_dist"].ToString());
            }

            comboBox1.Items.Add("Adicionar novo Distrito");
            if (count == 0)
            {
                comboBox1.Visibility = Visibility.Hidden;
            }

            else
            {
                comboBox1.Visibility = Visibility.Visible;

            }

            databaseconnection.db.Close();
        }
Ejemplo n.º 14
0
        // Inserir distrito menu
        private void button1_Click_1(object sender, RoutedEventArgs e)
        {
            tabControl1.SelectedIndex = 2;   
            button5.Visibility = Visibility.Visible;

            ArrayList list = new ArrayList();

            databaseconnection NewConnection = new databaseconnection();
            NewConnection.dbConnection();

            MySqlCommand querysql = new MySqlCommand("select * from distrito", databaseconnection.db);

            MySqlDataReader dataread = querysql.ExecuteReader();

            

            //int count = 0;
            while (dataread.Read())
            {
               // count = count + 1;
                //comboBox1.Items.Add(dataread["id_distrito"].ToString() + " " + "-" + " " + dataread["nome_dist"].ToString());
                list.Add(dataread["id_distrito"].ToString());
                list.Add(dataread["nome_dist"].ToString());
            }

            foreach (string value in list)
            {
                MessageBox.Show(value);
                //Console.WriteLine(value); // bird, plant
            }

            dataGrid1.ItemsSource = list;
            //comboBox1.Items.Add("Adicionar novo Distrito");
            /*if (count == 0)
            {
                comboBox1.Visibility = Visibility.Hidden;
            }

            else
            {
                comboBox1.Visibility = Visibility.Visible;

            }*/

            databaseconnection.db.Close();


        }