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); } }