public List <Chamado> Listar()
{
string connectionString = ConfigurationManager.ConnectionStrings["bancodedados"].ConnectionString;
List <Chamado> lst = new List <Chamado>();
using (SqlConnection conn = new SqlConnection(connectionString))
{
using (SqlCommand comando = new SqlCommand())
{
comando.Connection = conn;
conn.Open();
comando.CommandType = System.Data.CommandType.Text;
comando.CommandText = "select * from tb_chamados";
SqlDataReader reader = comando.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
lst = Chamado.PopularLista(reader);
}
}
return(lst);
}