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();
}
// 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();
}
// 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();
}
}
// 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!!");
}
// 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();
}
private void button20_Click(object sender, RoutedEventArgs e)
{
tabControl1.SelectedIndex = 10;
button5.Visibility = Visibility.Visible;
databaseconnection NewConnection = new databaseconnection();
NewConnection.dbConnection();
databaseconnection.db.Close();
}
// 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;
}
// 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();
}
//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();
}
// 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!!");
}
// 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;
}
// 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!!");
}
// 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();
}
// 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();
}