public ResponseConsultarVolanteDespacho ConsultarVolanteDespacho(RequestConsultarVolanteDespacho request) { ResponseConsultarVolanteDespacho response = new ResponseConsultarVolanteDespacho(); VolanteDespachoBL cvbl = new VolanteDespachoBL(); response = cvbl.ConsultarVolanteDespacho(request); return(response); }
public ResponseConsultarVolanteDespacho ConsultarVolanteDespacho(RequestConsultarVolanteDespacho request) { ResponseConsultarVolanteDespacho response = new ResponseConsultarVolanteDespacho(); VolanteDespachoDA VolanteDespachoDA = new VolanteDespachoDA(); response = VolanteDespachoDA.ConsultarVolanteDespacho(request); return(response); }
public ResponseConsultarVolanteDespacho ConsultarVolanteDespacho(RequestConsultarVolanteDespacho request) { ResponseConsultarVolanteDespacho response = new ResponseConsultarVolanteDespacho(); SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["cnxANTP"].ToString()); try { SqlCommand cmd = new SqlCommand("USP_ListaVolanteDespacho", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@BL", SqlDbType.VarChar, 25).Value = request.BL; con.Open(); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { response.Empresa = dr.IsDBNull(dr.GetOrdinal("Empresa")) ? "" : dr.GetString(dr.GetOrdinal("Empresa")); response.CodigoRegimen = dr.IsDBNull(dr.GetOrdinal("CodigoRegimen")) ? "" : dr.GetString(dr.GetOrdinal("CodigoRegimen")); response.Regimen = dr.IsDBNull(dr.GetOrdinal("Regimen")) ? "" : dr.GetString(dr.GetOrdinal("Regimen")); response.Recalada = dr.IsDBNull(dr.GetOrdinal("Recalada")) ? "" : dr.GetString(dr.GetOrdinal("Recalada")); response.PuertoOrigen = dr.IsDBNull(dr.GetOrdinal("PuertoOrigen")) ? "" : dr.GetString(dr.GetOrdinal("PuertoOrigen")); response.DescripcionPuerto = dr.IsDBNull(dr.GetOrdinal("DescPuertoOrigen")) ? "" : dr.GetString(dr.GetOrdinal("DescPuertoOrigen")); response.PuertoEmbarque = dr.IsDBNull(dr.GetOrdinal("PuertoEmbarque")) ? "" : dr.GetString(dr.GetOrdinal("PuertoEmbarque")); response.DescripcionPuertoEmbarque = dr.IsDBNull(dr.GetOrdinal("DescPuertoEmbarque")) ? "" : dr.GetString(dr.GetOrdinal("DescPuertoEmbarque")); response.TipoDocumento = dr.IsDBNull(dr.GetOrdinal("TipoDocumento")) ? "" : dr.GetString(dr.GetOrdinal("TipoDocumento")); response.DescripcionDocumento = dr.IsDBNull(dr.GetOrdinal("DescripcionDocumento")) ? "" : dr.GetString(dr.GetOrdinal("DescripcionDocumento")); response.BL = dr.IsDBNull(dr.GetOrdinal("BL")) ? "" : dr.GetString(dr.GetOrdinal("BL")); response.NumeroVolante = dr.IsDBNull(dr.GetOrdinal("NumeroVolante")) ? "" : dr.GetString(dr.GetOrdinal("NumeroVolante")); } } catch (Exception ex) { response = null; } finally { con.Close(); } return(response); }