public List <GM_Comentario> ListadoComentario(GM_Comentario entidad)
{
try
{
return(ticketDA.ListadoComentario(entidad));
}
catch (Exception ex)
{
throw;
}
}
public List <GM_Comentario> ListadoComentario(GM_Comentario entidad)
{
List <GM_Comentario> ListaComentario = null;
try
{
using (SqlConnection conection = new SqlConnection(ConfigurationManager.ConnectionStrings["cnx"].ConnectionString))
{
conection.Open();
using (SqlCommand command = new SqlCommand("ListarComentario", conection))
{
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@IdTicket", entidad.IdTicket);
using (SqlDataReader dr = command.ExecuteReader())
{
if (dr.HasRows)
{
ListaComentario = new List <GM_Comentario>();
while (dr.Read())
{
GM_Comentario coment = new GM_Comentario();
coment.IdComentario = dr.GetInt32(dr.GetOrdinal("IdComentario"));
coment.DesComentario = dr.GetString(dr.GetOrdinal("DesComentario"));
coment.FeCreComentario = dr.GetDateTime(dr.GetOrdinal("FeCreComentario")).ToString("dd/MM/yyyy");
coment.IdTicket = dr.GetInt32(dr.GetOrdinal("IdTicket"));
coment.IdEmpleado = dr.GetInt32(dr.GetOrdinal("IdEmpleado"));
coment.NomEmpleado = dr.GetString(dr.GetOrdinal("NomEmpleado"));
ListaComentario.Add(coment);
}
}
}
}
conection.Close();
}
return(ListaComentario);
}
catch (Exception ex)
{
throw (ex);
}
}
