public ResponseDepotOrder DepotOrder(RequestDepotOrder request)
{
var responseToken = GenerarToken();
var url = ConfigurationManager.AppSettings["UrlDepotOrder"];
var response = Helper.InvocarServicio <ResponseDepotOrder>(request, "POST", url, responseToken.access_token);
if (response == null)
{
throw new Exception(string.Format("Problemas con el servicio: {0}", url));
}
return(response);
}
public List <RequestDepotOrder> obtenerTramaDepotOrder(string DocumentoReferencia, string Contenedor, string TipoDoc)
{
List <RequestDepotOrder> request = new List <RequestDepotOrder>();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["cnxTramarsa"].ConnectionString);
SqlCommand cmd = new SqlCommand("SP_OBTENER_DATOS_DEPOTORDER", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@DocumentoRef", SqlDbType.VarChar).Value = DocumentoReferencia;
cmd.Parameters.Add("@Contenedor", SqlDbType.VarChar).Value = Contenedor;
cmd.Parameters.Add("@TipoDoc", SqlDbType.VarChar).Value = TipoDoc;
try
{
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
RequestDepotOrder resp = new RequestDepotOrder();
resp.OceanCarrier = dr.IsDBNull(dr.GetOrdinal("OceanCarrier")) ? "" : dr.GetString(dr.GetOrdinal("OceanCarrier"));
resp.ReferenceType = dr.IsDBNull(dr.GetOrdinal("ReferenceType")) ? "" : dr.GetString(dr.GetOrdinal("ReferenceType"));
resp.ReferenceNumber = dr.IsDBNull(dr.GetOrdinal("ReferenceNumber")) ? "" : dr.GetString(dr.GetOrdinal("ReferenceNumber"));
resp.YardCode = dr.IsDBNull(dr.GetOrdinal("YardCode")) ? "" : dr.GetString(dr.GetOrdinal("YardCode"));
resp.ActionType = dr.IsDBNull(dr.GetOrdinal("ActionType")) ? "" : dr.GetString(dr.GetOrdinal("ActionType"));
resp.OperationType = dr.IsDBNull(dr.GetOrdinal("OperationType")) ? "" : dr.GetString(dr.GetOrdinal("OperationType"));
resp.ShipperERPCode = dr.IsDBNull(dr.GetOrdinal("ShipperERPCode")) ? "" : dr.GetString(dr.GetOrdinal("ShipperERPCode"));
if (!dr.IsDBNull(dr.GetOrdinal("ForwarderERPCode")))
{
resp.ForwarderERPCode = dr.GetString(dr.GetOrdinal("ForwarderERPCode"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ConsigneeERPCode")))
{
resp.ConsigneeERPCode = dr.GetString(dr.GetOrdinal("ConsigneeERPCode"));
}
if (!dr.IsDBNull(dr.GetOrdinal("NotifyPartyERPCode")))
{
resp.NotifyPartyERPCode = dr.GetString(dr.GetOrdinal("NotifyPartyERPCode"));
}
resp.RequestDate = dr.IsDBNull(dr.GetOrdinal("RequestDate")) ? "" : dr.GetString(dr.GetOrdinal("RequestDate"));
resp.VoyageStopExternalCode = dr.IsDBNull(dr.GetOrdinal("VoyageStopExternalCode")) ? "" : dr.GetString(dr.GetOrdinal("VoyageStopExternalCode"));
if (!dr.IsDBNull(dr.GetOrdinal("VesselIMO")))
{
resp.VesselIMO = dr.GetString(dr.GetOrdinal("VesselIMO"));
}
if (!dr.IsDBNull(dr.GetOrdinal("VoyageNumber")))
{
resp.VoyageNumber = dr.GetString(dr.GetOrdinal("VoyageNumber"));
}
resp.EntryFromExternalDepot = dr.IsDBNull(dr.GetOrdinal("EntryFromExternalDepot")) ? false : dr.GetBoolean(dr.GetOrdinal("EntryFromExternalDepot"));
resp.ChargeFleet = dr.IsDBNull(dr.GetOrdinal("ChargeFleet")) ? false : dr.GetBoolean(dr.GetOrdinal("ChargeFleet"));
resp.ManifestNumber = dr.IsDBNull(dr.GetOrdinal("ManifestNumber")) ? "" : dr.GetString(dr.GetOrdinal("ManifestNumber"));
resp.PlaceOfReceipt = dr.IsDBNull(dr.GetOrdinal("PlaceOfReceipt")) ? "" : dr.GetString(dr.GetOrdinal("PlaceOfReceipt"));
resp.PortOfLoading = dr.IsDBNull(dr.GetOrdinal("PortOfLoading")) ? "" : dr.GetString(dr.GetOrdinal("PortOfLoading"));
resp.PortOfDischarge = dr.IsDBNull(dr.GetOrdinal("PortOfDischarge")) ? "" : dr.GetString(dr.GetOrdinal("PortOfDischarge"));
resp.PlaceOfDelivery = dr.IsDBNull(dr.GetOrdinal("PlaceOfDelivery")) ? "" : dr.GetString(dr.GetOrdinal("PlaceOfDelivery"));
if (!dr.IsDBNull(dr.GetOrdinal("ETADate")))
{
resp.ETADate = dr.GetString(dr.GetOrdinal("ETADate"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ETDDate")))
{
resp.ETDDate = dr.GetString(dr.GetOrdinal("ETDDate"));
}
resp.ShipmentType = dr.IsDBNull(dr.GetOrdinal("ShipmentType")) ? "" : dr.GetString(dr.GetOrdinal("ShipmentType"));
if (!dr.IsDBNull(dr.GetOrdinal("RemarksC")))
{
resp.Remarks = dr.GetString(dr.GetOrdinal("RemarksC"));
}
resp.RateAgreement = dr.IsDBNull(dr.GetOrdinal("RateAgreement")) ? "" : dr.GetString(dr.GetOrdinal("RateAgreement"));
Equipment e = new Equipment();
e.EquipmentNumber = dr.IsDBNull(dr.GetOrdinal("EquipmentNumber")) ? "" : dr.GetString(dr.GetOrdinal("EquipmentNumber"));
e.EquipmentsRequested = dr.IsDBNull(dr.GetOrdinal("EquipmentsRequested")) ? 0 : dr.GetInt32(dr.GetOrdinal("EquipmentsRequested"));
e.EquipmentTypeSize = dr.IsDBNull(dr.GetOrdinal("EquipmentTypeSize")) ? "" : dr.GetString(dr.GetOrdinal("EquipmentTypeSize"));
e.Commodity = dr.IsDBNull(dr.GetOrdinal("Commodity")) ? "" : dr.GetString(dr.GetOrdinal("Commodity"));
if (!dr.IsDBNull(dr.GetOrdinal("Remarks")))
{
e.Remarks = dr.GetString(dr.GetOrdinal("Remarks"));
}
e.MaxReturnDate = dr.IsDBNull(dr.GetOrdinal("MaxReturnDate")) ? "" : dr.GetString(dr.GetOrdinal("MaxReturnDate"));
resp.Equipments.Add(e);
request.Add(resp);
}
}
catch (Exception ex)
{
request = null;
}
finally
{
cn.Close();
}
return(request);
}
