public List <PreAdviceEquipment> ObtenerContenedores()
{
List <PreAdviceEquipment> lista = new List <PreAdviceEquipment>();
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["cnxTDepot"].ConnectionString);
SqlCommand cmd = new SqlCommand("USP_OBTENERCONTENEDORES", cn);
cmd.CommandType = CommandType.StoredProcedure;
try
{
cn.Open();
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
PreAdviceEquipment equip = new PreAdviceEquipment();
equip.EquipmentNumber = dr.IsDBNull(dr.GetOrdinal("EquipmentNumber")) ? "" : dr.GetString(dr.GetOrdinal("EquipmentNumber")).Trim();
equip.EquipmentTypeSizeISOCode = dr.IsDBNull(dr.GetOrdinal("EquipmentTypeSizeISOCode")) ? "" : dr.GetString(dr.GetOrdinal("EquipmentTypeSizeISOCode")).Trim();
equip.IsEmpty = false;
equip.IsHazardous = false;
equip.RequiresReview = false;
equip.SetPoint = 0;
equip.SetPointUnitOfMeasure = "GCS";
equip.Ventilation = 0;
equip.RelativeHumidityLevel = 0;
equip.O2Level = 0;
equip.CO2Level = 0;
equip.RequiresPlug = false;
equip.Technology = "";
lista.Add(equip);
}
}
catch (Exception ex)
{
lista = null;
}
finally
{
cn.Close();
}
return(lista);
}
public string IntegracionLlenos()
{
string dtResult = "OK";
try
{
List <PendientesLlenos> listaPendientes = da.ListaPendientesLlenos("INGRESOS");
foreach (PendientesLlenos item in listaPendientes)
{
ResponsePreAdvice resp1 = new ResponsePreAdvice();
RequestPreAdvice req1 = new RequestPreAdvice();
ResponseEquipmentOperation resp2 = new ResponseEquipmentOperation();
RequestEquipmentOperation req2 = new RequestEquipmentOperation();
req1.YardCode = item.YardCode;
req1.ActionType = item.ActionType;
req1.OperationTypeMovementCode = "";
req1.VoyageStopExternalCode = item.VoyageStopExternalCode;
req1.VesselIMO = item.VesselIMO;
req1.VoyageNumber = item.VoyageNumber;
req1.OceanCarrier = item.OceanCarrier;
req1.ReferenceType = item.ReferenceType;
req1.ReferenceNumber = item.ReferenceNumber;
req1.OperationType = item.OperationType;
req1.PlaceOfReceipt = item.PlaceOfReceipt;
req1.PortOfLoading = item.PortOfLoading;
req1.PortOfDischarge = item.PortOfDischarge;
req1.PlaceOfDelivery = item.PlaceOfDelivery;
req1.CustomerERPCode = item.CustomerERPCode.Trim();
req1.ShipmentType = item.ShipmentType;
PreAdviceEquipment e = new PreAdviceEquipment();
e.EquipmentNumber = item.EquipmentNumber;
e.EquipmentTypeSizeISOCode = item.EquipmentTypeSizeISOCode;
e.IsEmpty = false;
e.IsHazardous = false;
e.RequiresReview = false;
e.RequiresPlug = false;
e.SetPoint = 0;
e.Ventilation = 0;
e.RelativeHumidityLevel = 0;
e.O2Level = 0;
e.CO2Level = 0;
e.Technology = "";
req1.Equipments.Add(e);
string RptaValClie = "";
if (!item.CustomerERPCode.Trim().Equals(""))
{
RptaValClie = da.ValidarCliente(item.CustomerERPCode);
if (RptaValClie.Equals("N"))
{
string rpta = RegistrarClienteTRD(item.CustomerERPCode, "");
if (rpta.Equals("NO"))
{
continue;
}
}
}
req2.OceanCarrier = item.OceanCarrier;
req2.YardCode = item.YardCode;
req2.ReferenceType = item.ReferenceType;
req2.ReferenceNumber = item.ReferenceNumber;
req2.ActionType = item.ActionType;
req2.ActivityCode = item.ActivityCode;
req2.OperationTypeMovementCode = "";
req2.OperationType = item.OperationType;
req2.VehiclePlate = item.VehiclePlate;
req2.ExecutionDate = item.ExecutionDate;
req2.direction = item.direction;
req2.Status = item.Status;
req2.truckerCode = "";
req2.driverCode = "";
YardOperationEquipment a = new YardOperationEquipment();
a.EquipmentNumber = item.EquipmentNumber;
a.EquipmentTypeSizeISOCode = item.EquipmentTypeSizeISOCode;
a.IsEmpty = false;
a.IsHazardous = false;
a.RequiresReview = false;
resp1 = proxy.PreAdvice(req1);
if (resp1.isValid)
{
resp2 = proxy.EquipmentOperation(req2);
if (!resp2.isValid)
{
dtResult = "Servicio EquipmentOperation: " + resp2.messages[0].message;
}
else
{
da.ActualizarINTF(item.NUMID);
}
}
else
{
dtResult = "Servicio PreAdvice: " + resp1.messages[0].message;
}
}
}
catch (Exception ex)
{
InsertLog.Instanse.Insert(string.Format(@"Error en el metodo: {0}{1}Mensaje Error:{2}{3}Detalle Error:{4}", MethodBase.GetCurrentMethod().Name, Environment.NewLine, ex.Message, Environment.NewLine, ex.StackTrace));
dtResult = "ERROR";
}
return(dtResult);
}