public static int InsertAgricultor(AgricultorVO Agricultor)
{
MySqlCommand cmd = new MySqlCommand("InsertAgricultor",
new MySqlConnection(Classtratarconexao.GetConnectionString()));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("nomedetentor", Agricultor.NomeDetentor));
cmd.Parameters.Add(new MySqlParameter("moradadetentor", Agricultor.MoradaDetentor));
cmd.Parameters.Add(new MySqlParameter("nif", Agricultor.Nif));
cmd.Parameters.Add(new MySqlParameter("telefone", Agricultor.Telefone));
cmd.Parameters.Add(new MySqlParameter("email", Agricultor.Email));
cmd.Parameters.Add(new MySqlParameter("password", Agricultor.Password));
cmd.Parameters.Add(new MySqlParameter("username", Agricultor.Username));
try
{
if (Classtratarconexao.AbrirConexao(cmd.Connection))
{
cmd.ExecuteNonQuery();
}
return(1);
}
catch (MySqlException ex)
{
new Exception(ex.Message);
return(0);
}
finally
{
Classtratarconexao.FecharConexao(cmd.Connection);
}
}
public static List <ConcelhoVO> GetConcelhos(int id)
{
List <ConcelhoVO> listaConcelho = new List <ConcelhoVO>();
MySqlCommand cmd = new MySqlCommand("GetConcelhos",
new MySqlConnection(Classtratarconexao.GetConnectionString()));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("idDistrito", id));
try
{
if (Classtratarconexao.AbrirConexao(cmd.Connection))
{
MySqlDataReader dr =
cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
ConcelhoVO Concelho = new ConcelhoVO();
Concelho.IdConcelho = Convert.ToInt32(dr["idConcelho"]);
Concelho.Nome = Convert.ToString(dr["nome"]);
Concelho.IdDistrito = Convert.ToInt32(dr["idDistrito"]);
listaConcelho.Add(Concelho);
}
dr.Close();
return(listaConcelho);
}
else
{
return(listaConcelho);
}
}
catch (MySqlException ex)
{
new Exception(ex.Message);
return(listaConcelho);
}
finally
{
Classtratarconexao.FecharConexao(cmd.Connection);
}
}
public static List <DistritoVO> GetDistritos()
{
List <DistritoVO> listaDistritos = new List <DistritoVO>();
MySqlCommand cmd = new MySqlCommand("GetDistritos",
new MySqlConnection(Classtratarconexao.GetConnectionString()));
cmd.CommandType = CommandType.StoredProcedure;
try
{
if (Classtratarconexao.AbrirConexao(cmd.Connection))
{
MySqlDataReader dr =
cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
DistritoVO Distrito = new DistritoVO();
Distrito.IdDistrito = Convert.ToInt32(dr["idDistrito"]);
Distrito.Nome = Convert.ToString(dr["nome"]);
listaDistritos.Add(Distrito);
}
dr.Close();
return(listaDistritos);
}
else
{
return(listaDistritos);
}
}
catch (MySqlException ex)
{
new Exception(ex.Message);
return(listaDistritos);
}
finally
{
Classtratarconexao.FecharConexao(cmd.Connection);
}
}
public static List <TipoProducaoVO> GetTipoProducao()
{
List <TipoProducaoVO> listaTipoProducao = new List <TipoProducaoVO>();
MySqlCommand cmd = new MySqlCommand("GetTipoProducao",
new MySqlConnection(Classtratarconexao.GetConnectionString()));
cmd.CommandType = CommandType.StoredProcedure;
try
{
if (Classtratarconexao.AbrirConexao(cmd.Connection))
{
MySqlDataReader dr =
cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
TipoProducaoVO TipoProducao = new TipoProducaoVO();
TipoProducao.IdTipoProducao = Convert.ToInt32(dr["idTipoProducao"]);
TipoProducao.DescricaoProducao = Convert.ToString(dr["descricaoProducao"]);
listaTipoProducao.Add(TipoProducao);
}
dr.Close();
return(listaTipoProducao);
}
else
{
return(listaTipoProducao);
}
}
catch (MySqlException ex)
{
new Exception(ex.Message);
return(listaTipoProducao);
}
finally
{
Classtratarconexao.FecharConexao(cmd.Connection);
}
}
public static int InsertExploracao(ExploracaoVO Exploracao, AssociacaoVO Associacao, TipoProducaoVO TipoProducao)
{
MySqlCommand cmd = new MySqlCommand("InsertExploracao",
new MySqlConnection(Classtratarconexao.GetConnectionString()));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("nregistoexploracao", Exploracao.NRegistoExploracao));
cmd.Parameters.Add(new MySqlParameter("nif", Exploracao.Nif));
cmd.Parameters.Add(new MySqlParameter("nomeexploracao", Exploracao.NomeExploracao));
cmd.Parameters.Add(new MySqlParameter("marca", Exploracao.Marca));
cmd.Parameters.Add(new MySqlParameter("local", Exploracao.Local));
cmd.Parameters.Add(new MySqlParameter("codpostal", Exploracao.CodPostal));
cmd.Parameters.Add(new MySqlParameter("telefone", Exploracao.Telefone));
cmd.Parameters.Add(new MySqlParameter("sistemaexploracao", Exploracao.SistemaExploracao));
cmd.Parameters.Add(new MySqlParameter("parcelarioref", Exploracao.ParcelarioRef));
cmd.Parameters.Add(new MySqlParameter("freguesia", Exploracao.Freguesia));
cmd.Parameters.Add(new MySqlParameter("idagricultor", Exploracao.IdAgricultor));
//cmd.Parameters.Add(new MySqlParameter("idassociacao", Exploracao.IdAssociacao));
cmd.Parameters.Add(new MySqlParameter("idconcelho", Exploracao.IdConcelho));
cmd.Parameters.Add(new MySqlParameter("nome", Associacao.Nome));
cmd.Parameters.Add(new MySqlParameter("nomeFuncionario", Associacao.NomeFuncionario));
cmd.Parameters.Add(new MySqlParameter("contactoFuncionario", Associacao.ContactoFuncionario));
cmd.Parameters.Add(new MySqlParameter("emailGeral", Associacao.EmailGeral));
cmd.Parameters.Add(new MySqlParameter("emailContacto", Associacao.EmailContacto));
cmd.Parameters.Add(new MySqlParameter("morada", Associacao.Morada));
cmd.Parameters.Add(new MySqlParameter("telefoneass", Associacao.Telefone));
cmd.Parameters.Add(new MySqlParameter("idTipoProducao", TipoProducao.IdTipoProducao));
cmd.Parameters.Add(new MySqlParameter("descricaoProducao", TipoProducao.DescricaoProducao));
try
{
if (Classtratarconexao.AbrirConexao(cmd.Connection))
{
cmd.ExecuteNonQuery();
}
return(1);
}
catch (MySqlException ex)
{
new Exception(ex.Message);
return(0);
}
finally
{
Classtratarconexao.FecharConexao(cmd.Connection);
}
}
public static List <AgricultorVO> GetLoginAgricultor()
{
List <AgricultorVO> agricultorItemList = new List <AgricultorVO>();
MySqlCommand cmd = new MySqlCommand("ConsultarLogin",
new MySqlConnection(Classtratarconexao.GetConnectionString()));
cmd.CommandType = CommandType.StoredProcedure;
try
{
if (Classtratarconexao.AbrirConexao(cmd.Connection))
{
MySqlDataReader dr =
cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
AgricultorVO Agri = new AgricultorVO();
Agri.Password = Convert.ToString(dr["password"]);
Agri.Username = Convert.ToString(dr["username"]);
agricultorItemList.Add(Agri);
}
dr.Close();
//cmd.Connection.Close(); //eu
return(agricultorItemList);
}
else
{
return(agricultorItemList);
}
}
catch (MySqlException ex)
{
new Exception(ex.Message);
return(agricultorItemList);
}
finally
{
Classtratarconexao.FecharConexao(cmd.Connection);
}
}
public static int GetIdAgricultor(string username)
{
int id = 0;
MySqlCommand cmd = new MySqlCommand("GetIdAgricultor",
new MySqlConnection(Classtratarconexao.GetConnectionString()));
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("user", username));
//cmd.Connection.Open();
try
{
if (Classtratarconexao.AbrirConexao(cmd.Connection))
{
MySqlDataReader dr =
cmd.ExecuteReader(CommandBehavior.CloseConnection);
while (dr.Read())
{
id = Convert.ToInt32(dr["idAgricultor"]);
}
dr.Close();
//cmd.Connection.Close(); //eu
return(id);
}
else
{
return(id);
}
}
catch (MySqlException ex)
{
new Exception(ex.Message);
return(id);
}
finally
{
Classtratarconexao.FecharConexao(cmd.Connection);
}
}
