public List <Chamado> ListarAbertosUser(String user)
{
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;
comando.CommandText = "select * from tb_chamados WHERE id_usuario = '" + user + "'";
conn.Open();
using (SqlDataReader reader = comando.ExecuteReader())
{
lst = new List <Chamado>();
while (reader.Read())
{
lst.Add(Chamado.Popular(reader));
}
}
}
}
return(lst);
}
