/******************************************************************** LISTAR INGREDIENTE - FORMULACAO ********************************************************************/ public List <Formulacao> DetalhesIngrediente(String ID, Object CodigoFormulacao) { //SqlConnection Conexao = new SqlConnection(ConfigurationManager.ConnectionStrings["BancoEstoque"].ConnectionString); SqlConnection Conexao = new SqlConnection("Server = DESKTOP-PHTQI5U\\SQLEXPRESS; Database = DRLTCC; Trusted_Connection = True;"); Conexao.Open(); SqlCommand Comando = new SqlCommand(); Comando.Connection = Conexao; Comando.CommandText = "SELECT P.Porcentagem, I.NomeIngrediente FROM Formu_Ingrediente P JOIN Ingrediente I on CodigoIngrediente = FK_CodigoIngrediente WHERE FK_CodigoIngrediente = @FK_CodigoIngrediente AND FK_CodigoFormulacao = @FK_CodigoFormulacao;"; Comando.Parameters.AddWithValue("@FK_CodigoIngrediente", ID); Comando.Parameters.AddWithValue("@FK_CodigoFormulacao", CodigoFormulacao); SqlDataReader Leitor = Comando.ExecuteReader(); List <Formulacao> DetalheIngrediente = new List <Formulacao>(); while (Leitor.Read()) { Formulacao F = new Formulacao(); F.NomeIngrediente = Leitor["NomeIngrediente"].ToString(); F.Porcentagem = Convert.ToDouble(Leitor["Porcentagem"].ToString()); DetalheIngrediente.Add(F); } return(DetalheIngrediente); }
/******************************************************************** LISTAR FORMULAÇÕES ********************************************************************/ public List <Formulacao> ListarFormulacoes() { //SqlConnection Conexao = new SqlConnection(ConfigurationManager.ConnectionStrings["BancoEstoque"].ConnectionString); SqlConnection Conexao = new SqlConnection("Server = DESKTOP-PHTQI5U\\SQLEXPRESS; Database = DRLTCC; Trusted_Connection = True;"); Conexao.Open(); SqlCommand Comando = new SqlCommand(); Comando.Connection = Conexao; Comando.CommandText = "SELECT * FROM Formulacao;"; SqlDataReader Leitor = Comando.ExecuteReader(); List <Formulacao> Formulacoes = new List <Formulacao>(); while (Leitor.Read()) { Formulacao F = new Formulacao(); F.CodigoFormulacao = Convert.ToInt32(Leitor["CodigoFormulacao"].ToString()); F.NomeFormulacao = Leitor["NomeFormulacao"].ToString(); Formulacoes.Add(F); } Conexao.Close(); return(Formulacoes); }