/******************************************************************** DETALHES DO LOTE ********************************************************************/ public List <Ingrediente> DetalhesLote(String ID) { //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 Ingrediente WHERE FK_CodigoLote = @FK_CodigoLote;"; Comando.Parameters.AddWithValue("@FK_CodigoLote", ID); SqlDataReader Leitor = Comando.ExecuteReader(); List <Ingrediente> DetalhesLote = new List <Ingrediente>(); while (Leitor.Read()) { Ingrediente I = new Ingrediente(); I.CodigoIngrediente = Convert.ToInt32(Leitor["CodigoIngrediente"].ToString()); I.NomeIngrediente = Leitor["NomeIngrediente"].ToString(); I.UnidadeMedida = Leitor["UnidadeMedida"].ToString(); I.QtdIngrediente = Convert.ToInt32(Leitor["QtdIngrediente"].ToString()); DetalhesLote.Add(I); } Conexao.Close(); return(DetalhesLote); }
/******************************************************************** LISTAR INGREDIENTE - ALTERAR INGREDIENTE F ********************************************************************/ public List <Ingrediente> IngredienteF() { //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 CodigoIngrediente, NomeIngrediente FROM Ingrediente;"; SqlDataReader Leitor = Comando.ExecuteReader(); while (Leitor.Read()) { Ingrediente I = new Ingrediente(); I.CodigoIngrediente = Convert.ToInt32(Leitor["CodigoIngrediente"].ToString()); I.NomeIngrediente = Leitor["NomeIngrediente"].ToString(); Ingredientes.Add(I); } Conexao.Close(); return(Ingredientes); }
/******************************************************************** LISTAR INGREDIENTE RETIRADO ********************************************************************/ public List <Ingrediente> ListaIngredientesRetirados() { //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 I.NomeIngrediente,I.FK_CodigoLote,L.NomeLote,IR.*, I.UnidadeMedida FROM IngredienteRetirado IR JOIN Ingrediente I ON CodigoIngrediente = FK_CodigoIngrediente JOIN Lote L ON CodigoLote = FK_CodigoLote;"; SqlDataReader Leitor = Comando.ExecuteReader(); List <Ingrediente> Retirados = new List <Ingrediente>(); while (Leitor.Read()) { Ingrediente I = new Ingrediente(); I.CodigoIngrediente = Convert.ToInt32(Leitor["FK_CodigoIngrediente"].ToString()); I.NomeIngrediente = Leitor["NomeIngrediente"].ToString(); I.FK_NIFUsuario = Convert.ToInt32(Leitor["FK_NIFUsuario"].ToString()); I.QtdIngrediente = Convert.ToInt32(Leitor["QtdRetirado"].ToString()); I.DataRetirada = Convert.ToDateTime(Leitor["DataRetirado"].ToString()); I.UnidadeMedida = Leitor["UnidadeMedida"].ToString(); I.FK_CodigoLote = Convert.ToInt32(Leitor["FK_CodigoLote"].ToString()); I.NomeLote = Leitor["NomeLote"].ToString(); Retirados.Add(I); } return(Retirados); }
/******************************************************************** LISTAR INGREDIENTE ********************************************************************/ public List <Ingrediente> ListarIngredientes() { //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 I.*, L.CodigoLote, L.NomeLote FROM Ingrediente I JOIN Lote L ON CodigoLote = FK_CodigoLote;"; SqlDataReader Leitor = Comando.ExecuteReader(); while (Leitor.Read()) { Ingrediente I = new Ingrediente(); I.FK_CodigoLote = Convert.ToInt32(Leitor["FK_CodigoLote"].ToString()); I.NomeLote = Leitor["NomeLote"].ToString(); I.CodigoIngrediente = Convert.ToInt32(Leitor["CodigoIngrediente"].ToString()); I.NomeIngrediente = Leitor["NomeIngrediente"].ToString(); I.QtdIngrediente = Convert.ToInt32(Leitor["QtdIngrediente"].ToString()); I.UnidadeMedida = Leitor["UnidadeMedida"].ToString(); I.NivelRisco = Convert.ToInt32(Leitor["NivelRisco"].ToString()); I.FK_CodigoLote = Convert.ToInt32(Leitor["FK_CodigoLote"].ToString()); Ingredientes.Add(I); } Conexao.Close(); teste = Ingredientes.Count(); return(Ingredientes); }