/// <summary>
/// Importa un archivo DDP en formato XML a la base de datos
/// </summary>
/// <param name="stream">Stream de memoria del archivo</param>
public DateTime Import(XmlDocument ddpxml, DDPVersion ddpVersion)
{
DateTime pubDate = DateTime.UtcNow;
DBDataContext context = null;
try
{
context = new DBDataContext(Config.ConnectionString);
//---------------------------------------------------
XmlNamespaceManager nsmanager = new XmlNamespaceManager(ddpxml.NameTable);
nsmanager.AddNamespace("lr", "http://gisis.imo.org/XML/LRIT/ddp/2008");
//---------------------------------------------------
//Hack-o-mati: Asociation of contracting goverment
Dictionary <ContractingGoverment, ContractingConfig> goverments = new Dictionary <ContractingGoverment, ContractingConfig>();
//Just for return, do not use here.
pubDate = DateTime.Parse(ddpxml.SelectSingleNode("/lr:DataDistributionPlan", nsmanager).Attributes["regularVersionImplementationAt"].Value);
readCGS("/lr:DataDistributionPlan/lr:ContractingGovernment", ref goverments, ref ddpxml, ref nsmanager);
readCGS("/lr:DataDistributionPlan/lr:Territory", ref goverments, ref ddpxml, ref nsmanager);
var cgda = new ContractingGovermentDataAccess(context);
var pda = new PlaceDataAccess(context);
var soda = new StandingOrderDataAccess(context);
var ssda = new SARServiceDataAccess(context);
//var exda = new ExclusionDataAccess(context);
//cgda.DropAll();
foreach (KeyValuePair <ContractingGoverment, ContractingConfig> kv in goverments)
{
kv.Key.DDPVersionId = ddpVersion.Id;
int gId = cgda.Create(kv.Key);
foreach (Place p in kv.Value.places)
{
p.ContractingGovermentId = gId;
}
foreach (SARService ss in kv.Value.sarservice)
{
ss.ContractingGovermentId = gId;
}
//foreach (Exclusion excl in kv.Value.exclusions)
// excl.ContractingGoverment = gId;
log.Debug(string.Format("{2}: Key:{0}, Value{1}", kv.Key.Name, kv.Value.places.Count, kv.Key.Id));
pda.Create(kv.Value.places.ToArray());
//exda.Create(kv.Value.exclusions.ToArray());
ssda.Create(kv.Value.sarservice.ToArray());
//Places with ids
List <Place> places = pda.GetAll(ddpVersion.regularVer + ":" + ddpVersion.inmediateVer);
//Standing orders
string path = string.Format("/lr:DataDistributionPlan/lr:CoastalStateStandingOrders/lr:StandingOrder[@contractingGovernmentID='{0}']", kv.Key.LRITId);
XmlNode standingOrder = ddpxml.SelectSingleNode(path, nsmanager);
if (standingOrder != null && !String.IsNullOrEmpty(standingOrder.InnerText))
{
foreach (string area in standingOrder.InnerText.Split(' '))
{
int id = getPlaceId(places, area);
if (id == -1)
{
continue;
}
StandingOrder so = new StandingOrder();
so.PlaceId = id;
kv.Value.standingOrders.Add(so);
}
}
//ES ACA
soda.Create(kv.Value.standingOrders.ToArray());
}
}
catch (Exception ex)
{
if (context != null)
{
context.Dispose();
}
throw new Exception("Unable to Import DDP File", ex);
}
finally
{
if (context != null)
{
context.Dispose();
}
}
return(pubDate);
}
/// <summary>
/// Valida la combinacion de accesType y requestType para un ShipPositionRequest.
/// Si hay algun error esta funcion envia un Receipt al requisitor, informandole el problema.
/// </summary>
/// <param name="shipPositionRequest">El mensaje ShipPositionRequest a ser analizado.</param>
/// <returns>Verdadero, si el mensaje es valido, False otra cosa</returns>
private bool ValidateShipPositionRequest(DataCenterLogic.DataCenterTypes.ShipPositionRequestType shipPositionRequest)
{
var ddpm = new DDPVersionManager();
var ddpVersion = ddpm.GetCurrentDDPVersion();
log.Info("Validando SPR");
#region Port state with time trigger could not be used with RequestType 1,7 or 9:
//log.Debug("Port state with time trigger could not be used with RequestType 1,7 or 9");
if (shipPositionRequest.AccessType == DataCenterLogic.DataCenterTypes.accessTypeType.Item3 &&
(shipPositionRequest.RequestType == DataCenterLogic.DataCenterTypes.requestTypeType.Item1 ||
shipPositionRequest.RequestType == DataCenterLogic.DataCenterTypes.requestTypeType.Item7 ||
shipPositionRequest.RequestType == DataCenterLogic.DataCenterTypes.requestTypeType.Item9))
{
log.Error("Validacion erronea, se envia receipt");
ReceiptManager.SendReceipt(shipPositionRequest.DataUserRequestor, shipPositionRequest.MessageId, DataCenterLogic.DataCenterTypesIDE.receiptCodeType.Item7,
string.Format("Invalid request parameters: Port could not be used with RequestType 1,7 or 9"));
return(false);
}
#endregion
#region Access type 0 only with message 4 and request 0
//log.Debug("AccessType 0 (reset) solo valido con RT 0 y MS 4");
if (shipPositionRequest.AccessType == DataCenterLogic.DataCenterTypes.accessTypeType.Item0 || shipPositionRequest.RequestType == requestTypeType.Item0)
{
//Invalid request parameters: AccessType 0 only valid with MessageType 4
if (shipPositionRequest.MessageType != DataCenterLogic.DataCenterTypes.messageTypeType1.Item4)
{
ReceiptManager.SendReceipt(shipPositionRequest.DataUserRequestor, shipPositionRequest.MessageId, DataCenterLogic.DataCenterTypesIDE.receiptCodeType.Item7,
string.Format("Invalid request parameters: AccessType 0 only valid with MessageType 4"));
log.Error("Validacion erronea, se envia receipt");
return(false);
}
// Invalid request parameters: AccessType 0 only valid with RequestType 0
if (shipPositionRequest.RequestType != DataCenterLogic.DataCenterTypes.requestTypeType.Item0 || shipPositionRequest.AccessType != DataCenterLogic.DataCenterTypes.accessTypeType.Item0)
{
ReceiptManager.SendReceipt(shipPositionRequest.DataUserRequestor, shipPositionRequest.MessageId, DataCenterLogic.DataCenterTypesIDE.receiptCodeType.Item7,
string.Format("Invalid request parameters: AccessType 0 only valid with RequestType 0"));
log.Info("Validacion erronea, se envia receipt");
return(false);
}
}
#endregion
#region REVISAR
/*
* log.Debug("Port State");
* //Invalid request parameters: Port state and RequestTypes 1,7 and 9 only valid with AccessType 5
* if( shipPositionRequest.ItemElementName == DataCenterLogic.DataCenterTypes.ItemChoiceType.Port ||
* shipPositionRequest.ItemElementName == DataCenterLogic.DataCenterTypes.ItemChoiceType.PortFacility
* && ( shipPositionRequest.RequestType == DataCenterLogic.DataCenterTypes.requestTypeType.Item1 ||
* shipPositionRequest.RequestType == DataCenterLogic.DataCenterTypes.requestTypeType.Item7 ||
* shipPositionRequest.RequestType == DataCenterLogic.DataCenterTypes.requestTypeType.Item9 )
* && shipPositionRequest.AccessType != DataCenterLogic.DataCenterTypes.accessTypeType.Item5 )
* {
* ReceiptManager.SendReceipt(shipPositionRequest.DataUserRequestor, shipPositionRequest.MessageId, DataCenterLogic.DataCenterTypesIDE.receiptCodeType.Item7,
* string.Format("Invalid request parameters: Port state and RequestTypes 1,7 and 9 only valid with AccessType 5"));
*
* return false;
* } */
#endregion
#region Invalid request parameters: RequestTypes 1,7 and 9 are the only valid for MessageType 5
//log.Debug("Si es mensaje de tipo 5 (Sar) RT solo puede ser 1 o 9");
if (shipPositionRequest.MessageType == DataCenterLogic.DataCenterTypes.messageTypeType1.Item5 &&
shipPositionRequest.RequestType != DataCenterLogic.DataCenterTypes.requestTypeType.Item1 &&
shipPositionRequest.RequestType != DataCenterLogic.DataCenterTypes.requestTypeType.Item7 &&
shipPositionRequest.RequestType != DataCenterLogic.DataCenterTypes.requestTypeType.Item9)
{
log.Error("Validacion erronea, se envia receipt");
ReceiptManager.SendReceipt(shipPositionRequest.DataUserRequestor, shipPositionRequest.MessageId, DataCenterLogic.DataCenterTypesIDE.receiptCodeType.Item7,
string.Format("Invalid request parameters: RequestTypes 1,7 and 9 are the only valid for MessageType 5"));
return(false);
}
#endregion
#region Distance is only valid with access type 3
log.Debug("Distance is only valid with access type 3");
if (shipPositionRequest.Distance != "0" && shipPositionRequest.AccessType != DataCenterLogic.DataCenterTypes.accessTypeType.Item3)
{
log.Info("Validacion erronea, se envia receipt");
ReceiptManager.SendReceipt(shipPositionRequest.DataUserRequestor, shipPositionRequest.MessageId, DataCenterLogic.DataCenterTypesIDE.receiptCodeType.Item7,
string.Format("Invalid request parameters: Distance is only valid with access type 3"));
return(false);
}
#endregion
#region Request Duration not valid for one time poll
log.Debug("Request Duration not valid for one time poll");
if (ShipPositionRequestHelper.IsOneTimePoll(shipPositionRequest.RequestType) &&
(shipPositionRequest.RequestDuration != null && (shipPositionRequest.RequestDuration.startTimeSpecified == true || shipPositionRequest.RequestDuration.stopTimeSpecified == true)))
{
log.Info("Validacion erronea, se envia receipt");
ReceiptManager.SendReceipt(shipPositionRequest.DataUserRequestor, shipPositionRequest.MessageId, DataCenterLogic.DataCenterTypesIDE.receiptCodeType.Item7,
string.Format("Invalid request parameters: Request Duration not valid for one time poll"));
return(false);
}
#endregion
#region Port State
log.Debug("Validacion Para PortStates");
if (shipPositionRequest.AccessType == DataCenterLogic.DataCenterTypes.accessTypeType.Item3 ||
shipPositionRequest.AccessType == DataCenterLogic.DataCenterTypes.accessTypeType.Item5)
{
if (shipPositionRequest.ItemElementName != ItemChoiceType.Port && shipPositionRequest.ItemElementName != ItemChoiceType.PortFacility)
{
log.Info("invalid fields for port state request, ItemElementName not port or portfacility");
ReceiptManager.SendReceipt(shipPositionRequest.DataUserRequestor, shipPositionRequest.MessageId, DataCenterLogic.DataCenterTypesIDE.receiptCodeType.Item7,
string.Format("Invalid fields for port state request, ItemElementName not port or portfacility"));
return(false);
}
string portName = shipPositionRequest.Item.ToString();
using (var pda = new PlaceDataAccess())
{
if (pda.PortExists(portName, ddpVersion.Id) == false && pda.PortFacilityExists(portName, ddpVersion.Id) == false)
{
log.Info("invalid fields for port state request, Item" + shipPositionRequest.Item.ToString() + " doesn't exists");
ReceiptManager.SendReceipt(shipPositionRequest.DataUserRequestor, shipPositionRequest.MessageId, DataCenterLogic.DataCenterTypesIDE.receiptCodeType.Item7,
string.Format("invalid fields for port state request, Item" + shipPositionRequest.Item.ToString() + " doesn't exists")
);
return(false);
}
}
}
#endregion
#region AccessType2
log.Debug("Validacion Para AccessType2");
if (shipPositionRequest.AccessType == DataCenterLogic.DataCenterTypes.accessTypeType.Item2 &&
shipPositionRequest.RequestType != requestTypeType.Item7)
{
ReceiptManager.SendReceipt(shipPositionRequest.DataUserRequestor, shipPositionRequest.MessageId, DataCenterLogic.DataCenterTypesIDE.receiptCodeType.Item7,
string.Format("Access type 2 only valid for archived data"));
return(false);
}
#endregion
//Verifica si existe el Data User que requiere la información
var cgm = new ContractingGovermentManager();
var contractingGoverment = cgm.GetContractingGovermentByLRITId(shipPositionRequest.DataUserRequestor, ddpVersion.Id);
if (contractingGoverment == null)
{
string strError = string.Format("Specified LDU '{0}' does not exist", shipPositionRequest.DataUserRequestor);
//Arma mensaje de Recibo
DataCenterLogic.DataCenterTypes.ReceiptType receipt = new DataCenterLogic.DataCenterTypes.ReceiptType();
var cmgr = new ConfigurationManager();
receipt.DDPVersionNum = DDPVersionManager.currentDDP();
receipt.Destination = shipPositionRequest.DataUserRequestor;
receipt.Message = strError;
receipt.MessageId = MessageIdManager.Generate();
receipt.MessageType = DataCenterLogic.DataCenterTypes.messageTypeType3.Item7;
receipt.Originator = cmgr.Configuration.DataCenterID;
receipt.ReceiptCode = DataCenterLogic.DataCenterTypes.receiptCodeType.Item7;
receipt.ReferenceId = shipPositionRequest.MessageId;
receipt.schemaVersion = decimal.Parse(cmgr.Configuration.SchemaVersion);
receipt.test = DataCenterLogic.DataCenterTypes.testType.Item1;
receipt.TimeStamp = DateTime.UtcNow;
Message msgout = new Message(receipt);
msgout.Label = "receipt";
//Encola mensaje
QueueManager.Instance().EnqueueOut(msgout);
log.Error(strError);
return(false);
}
log.Info("Validacion Ok");
return(true);
}
