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