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