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