public ResponseListaVolanteDespacho ListaVolanteDespacho(RequestListaVolanteDespacho request)
{
ResponseListaVolanteDespacho response = new ResponseListaVolanteDespacho();
ListaVolanteDespachoDA da = new ListaVolanteDespachoDA();
response = da.ListaVolanteDespacho(request);
return(response);
}
public ResponseListaVolanteDespacho ListaVolanteDespacho(RequestListaVolanteDespacho request)
{
ResponseListaVolanteDespacho response = new ResponseListaVolanteDespacho();
List <ListaVolanteDespacho> ListaVolanteDespachoList = new List <ListaVolanteDespacho>();
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cnxANTP"].ToString());
try
{
SqlCommand com = new SqlCommand("USP_ListaVolanteDespacho", con);
com.CommandType = CommandType.StoredProcedure;
com.Parameters.Add("@BL", SqlDbType.VarChar, 25).Value = request.Bl;
//com.CommandTimeout = 30000;
con.Open();
SqlDataReader dr = com.ExecuteReader();
while (dr.Read())
{
ListaVolanteDespacho tp = new ListaVolanteDespacho();
tp.Empresa = dr.IsDBNull(dr.GetOrdinal("Empresa")) ? "" : dr.GetString(dr.GetOrdinal("Empresa"));
tp.CodigoRegimen = dr.IsDBNull(dr.GetOrdinal("CodigoRegimen")) ? "" : dr.GetString(dr.GetOrdinal("CodigoRegimen"));
tp.Regimen = dr.IsDBNull(dr.GetOrdinal("Regimen")) ? "" : dr.GetString(dr.GetOrdinal("Regimen"));
tp.Recalada = dr.IsDBNull(dr.GetOrdinal("Recalada")) ? "" : dr.GetString(dr.GetOrdinal("Recalada"));
tp.PuertoOrigen = dr.IsDBNull(dr.GetOrdinal("PuertoOrigen")) ? "" : dr.GetString(dr.GetOrdinal("PuertoOrigen"));
tp.PuertoEmbarque = dr.IsDBNull(dr.GetOrdinal("PuertoEmbarque")) ? "" : dr.GetString(dr.GetOrdinal("PuertoEmbarque"));
tp.TipoDocumento = dr.IsDBNull(dr.GetOrdinal("TipoDocumento")) ? "" : dr.GetString(dr.GetOrdinal("TipoDocumento"));
tp.BL = dr.IsDBNull(dr.GetOrdinal("BL")) ? "" : dr.GetString(dr.GetOrdinal("BL"));
tp.NumeroVolante = dr.IsDBNull(dr.GetOrdinal("NumeroVolante")) ? "" : dr.GetString(dr.GetOrdinal("NumeroVolante"));
ListaVolanteDespachoList.Add(tp);
}
response.VolanteDespachoList = ListaVolanteDespachoList;
}
catch (Exception ex)
{
response.VolanteDespachoList = null;
}
finally
{
con.Close();
}
return(response);
}
