private void btloggin_Click(object sender, EventArgs e)
{
try{
//String myConnection = "datasource=localhost;port=3306;username=root;password=;";
//MySqlConnection myConn = new MySqlConnection(myConnection);
//MySqlCommand SelectComand = new MySqlCommand("select * from bmnd.agricultor where username='******'and password='******' ;", myConn);
//MySqlDataReader myReader;
//myConn.Open();
//myReader = SelectComand.ExecuteReader();
//int count = 0;
//while (myReader.Read())
//{
// count = count + 1;
//}
AgricultorBUS Agricultorbus = new AgricultorBUS();
bool var = false;
for (int i = 0; i < Agricultorbus.GetLoginAgricultor().Count(); i++)
{
if (Agricultorbus.GetLoginAgricultor()[i].Username.Equals(username_txt.Text) && Agricultorbus.GetLoginAgricultor()[i].Password.Equals(password_txt.Text))
{
var = true;
}
}
if (var)
{
MessageBox.Show("Username e password Correctos");
}
else
{
MessageBox.Show("Username e Password errados...Tente outravez.");
//myConn.Close();
}
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
Formnovaexploracao frm = new Formnovaexploracao(username_txt.Text);
frm.Show();
Hide();
}
private void registrar()
{
if ((tbnome.Text != "") && (tbmorada.Text != "") && (tbnif.Text != "") && (tbtlm.Text != "") && (tbemail.Text != "") && (tbuser.Text != "") && (tbpass.Text != ""))
{
try
{
//MySqlCommand gravar = conexao.CreateCommand();
//gravar.CommandText = "Insert into agricultor (nomeDetentor,enderecoDetentor,nif,telefone,email,password,username) VALUE(@nomeDetentor,@enderecoDetentor,@nif,@telefone,@email,@password,@username)";
////gravar.Parameters.AddWithValue("@nomeDetentor", tbnome.Text);
////gravar.Parameters.AddWithValue("@enderecoDetentor", tbmorada.Text);
////gravar.Parameters.AddWithValue("@nif", tbnif.Text);
////gravar.Parameters.AddWithValue("@telefone", tbtlm.Text);
////gravar.Parameters.AddWithValue("@email", tbemail.Text);
////gravar.Parameters.AddWithValue("@password", tbpass.Text);
////gravar.Parameters.AddWithValue("@username", tbuser.Text);
//conexao.Open();
//gravar.ExecuteNonQuery();
AgricultorVO Agricultor = new AgricultorVO();
Agricultor.NomeDetentor = tbnome.Text;
Agricultor.MoradaDetentor = tbmorada.Text;
Agricultor.Nif = tbnif.Text;
Agricultor.Telefone = tbtlm.Text;
Agricultor.Email = tbemail.Text;
Agricultor.Password = tbpass.Text;
Agricultor.Username = tbuser.Text;
AgricultorBUS Agricultorbus = new AgricultorBUS();
if (Agricultorbus.InsertAgricultor(Agricultor) == 1)
{
MessageBox.Show("Agricultor inserido");
}
else
{
MessageBox.Show(" falha");
}
tbnome.Clear();
tbmorada.Clear();
tbnif.Clear();
tbtlm.Clear();
tbemail.Clear();
tbuser.Clear();
tbpass.Clear();
}
catch (Exception ex)
{
MessageBox.Show("Erro a criar utilizador!");
throw ex;
//conexao.Close();
}
finally
{
//conexao.Close();
MessageBox.Show("Criado com sucesso!");
}
}
else
{
MessageBox.Show("Verificar os campos!");
}
}
private void exploracao()
{
if ((tbnregexplo.Text != "") && (tbnifexp.Text != "") && (tbnomeexp.Text != "") && (tbmarcaexpl.Text != "") && (tbmoradaexpl.Text != "") && (tbcodpostexpl.Text != "") && (tbtelefexpl.Text != "") && (tbsistemaexplo.Text != "") && (tbparcelexpl.Text != "") && (tbfregexpl.Text != ""))
{
try
{
//AgricultorVO Agricultor = new AgricultorVO();
//Agricultor.NomeDetentor = tbnome.Text;
//Agricultor.MoradaDetentor = tbmorada.Text;
//Agricultor.Nif = tbnif.Text;
//Agricultor.Telefone = tbtlm.Text;
//Agricultor.Email = tbemail.Text;
//Agricultor.Password = tbpass.Text;
//Agricultor.Username = tbuser.Text;
//AgricultorBUS Agricultorbus = new AgricultorBUS();
//if (Agricultorbus.InsertAgricultor(Agricultor) == 1)
// MessageBox.Show("Agricultor inserido");
//else
// MessageBox.Show(" falha");
//AgricultorVO Agricultor = new AgricultorVO();
TipoProducaoVO TipoProducao = new TipoProducaoVO();
AssociacaoVO Associacao = new AssociacaoVO();
ExploracaoVO Exploracao = new ExploracaoVO();
AgricultorBUS Agricultor = new AgricultorBUS();
Exploracao.NRegistoExploracao = tbnregexplo.Text;
Exploracao.Nif = tbnifexp.Text;
Exploracao.NomeExploracao = tbnomeexp.Text;
Exploracao.Marca = tbmarcaexpl.Text;
Exploracao.Local = tbmoradaexpl.Text;
Exploracao.CodPostal = tbcodpostexpl.Text;
Exploracao.IdAgricultor = Convert.ToInt32(Agricultor.GetIdAgricultor(variavelLocal));
Exploracao.IdConcelho = Convert.ToInt32(cbconcelhoexpl.SelectedValue);
Exploracao.Telefone = tbtelefexpl.Text;
Exploracao.SistemaExploracao = tbsistemaexplo.Text;
Exploracao.ParcelarioRef = tbparcelexpl.Text;
Exploracao.Freguesia = tbfregexpl.Text;
Associacao.Nome = tbnomeass.Text;
Associacao.NomeFuncionario = tbnomefuncass.Text;
Associacao.ContactoFuncionario = tbcontactfuncass.Text;
Associacao.EmailGeral = tbemailgeralass.Text;
Associacao.EmailContacto = tbemailcontacass.Text;
Associacao.Morada = tbmoradaass.Text;
Associacao.Telefone = tbteleass.Text;
TipoProducao.IdTipoProducao = Convert.ToInt32(cbtipoprodexpl.SelectedValue);
ExploracaoBUS Exploracaobus = new ExploracaoBUS();
if (Exploracaobus.InsertExploracao(Exploracao, Associacao, TipoProducao) == 1)
{
MessageBox.Show("Exploração inserida");
}
else
{
MessageBox.Show(" falha");
}
tbnregexplo.Clear();
tbnifexp.Clear();
tbnomeexp.Clear();
tbmarcaexpl.Clear();
tbmoradaexpl.Clear();
tbcodpostexpl.Clear();
tbtelefexpl.Clear();
tbsistemaexplo.Clear();
tbparcelexpl.Clear();
tbfregexpl.Clear();
}
catch (Exception ex)
{
MessageBox.Show("Erro a criar exploração!");
throw ex;
//conexao.Close();
}
}
}
