public List <HistorialTicket> ListadoHistorialTicket(HistorialTicket entidad) { try { return(ticketService.ListadoHistorialTicket(entidad)); } catch (Exception ex) { throw; } }
public List <HistorialTicket> ListadoHistorialTicket(HistorialTicket entidad) { List <HistorialTicket> lista = null; try { using (SqlConnection conection = new SqlConnection(ConfigurationManager.ConnectionStrings["cnx"].ConnectionString)) { conection.Open(); using (SqlCommand command = new SqlCommand("ConsultarHistorialTickeT", conection)) { command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@TIC_ID", entidad.HIS_TIC_ID); using (SqlDataReader dr = command.ExecuteReader()) { if (dr.HasRows) { lista = new List <HistorialTicket>(); while (dr.Read()) { HistorialTicket item = new HistorialTicket(); item.HIS_TIC_ID = dr.GetInt32(dr.GetOrdinal("TIC_ID")); item.ATE_ID = dr.GetInt32(dr.GetOrdinal("ATE_ID")); item.TIC_CODE = dr.GetString(dr.GetOrdinal("TIC_Code")); item.PRI_Descripcion = dr.GetString(dr.GetOrdinal("Pri_Descripcion")); item.RES_Nombre = dr.GetString(dr.GetOrdinal("RES_Nombre")); item.ATE_RST_ID = dr.GetInt32(dr.GetOrdinal("ATE_RST_Id")); if (!dr.IsDBNull(dr.GetOrdinal("TIC_Descripcion"))) { item.HIS_Descripcion = dr.GetString(dr.GetOrdinal("TIC_Descripcion")); } item.HIS_FechaCambio = dr.GetDateTime(dr.GetOrdinal("ATE_FechaRegistro")).ToString("dd/MM/yyyy"); lista.Add(item); } } } } conection.Close(); } return(lista); } catch (Exception ex) { throw (ex); } }