public IMarketFileExportResult[] Export(CancellationToken token)
{
var cspDunsPorts = clientDataAccess.ListCspDunsPort();
var xmlPorts = cspDunsPorts
.Where(x => x.ProviderId == 2)
.ToArray();
var collection = new List <IMarketFileExportResult>();
foreach (var xmlPort in xmlPorts)
{
if (token.IsCancellationRequested)
{
break;
}
var model = new Export820Model
{
CspDuns = xmlPort.Duns,
LdcDuns = xmlPort.LdcDuns,
LdcShortName = xmlPort.LdcShortName,
TradingPartnerId = xmlPort.TradingPartnerId,
};
var partner = marketDataAccess.LoadCspDunsTradingPartner(xmlPort.Duns, xmlPort.LdcDuns);
if (partner == null)
{
logger.ErrorFormat(
"No CSP DUNS Trading Partner record exists between CR DUNS \"{0}\" and LDC DUNS \"{1}\". 820 Transactions will not be exported.",
xmlPort.Duns, xmlPort.LdcDuns);
continue;
}
marketDataAccess.LoadCspDunsTradingPartnerConfig(partner);
model.CspDunsTradingPartnerId = partner.CspDunsTradingPartnerId;
var headers = exportDataAccess.ListUnprocessed(xmlPort.LdcDuns, xmlPort.Duns, 2);
if (headers.Length == 0)
{
logger.TraceFormat("Zero 820 Xml records found to export for TDSP Duns \"{0}\" and CR Duns \"{1}\".",
xmlPort.LdcDuns, xmlPort.Duns);
continue;
}
logger.DebugFormat("Exporting {0} unprocessed 820 record(s) for TDSP Duns \"{1}\" and CR Duns \"{2}\".",
headers.Length, xmlPort.LdcDuns, xmlPort.Duns);
XNamespace marketNamespace = "http://CIS.Integration.Schema.Market.Common.Market820";
var document = new XDocument(
new XElement(marketNamespace + "Market820",
new XAttribute(XNamespace.Xmlns + "ns0", marketNamespace),
new XElement("TransactionCount", model.HeaderCount),
new XElement("LdcIsaQualifier", partner.GetConfig("TradingPartnerISAQualifier")),
new XElement("LdcIsaIdentifier", partner.GetConfig("TradingPartnerISAIdentifier")),
new XElement("LdcDuns", partner.TradingPartnerDuns),
new XElement("CspIsaQualifier", partner.GetConfig("CspISAQualifier")),
new XElement("CspDuns", partner.CspDuns),
new XElement("MarketFileId", string.Empty),
new XElement("LdcGSIdentifier", partner.GetConfig("TradingPartnerGSIdentifier")),
new XElement("LdcN1Qualifier", partner.GetConfig("TradingPartnerN1Qualifier")),
new XElement("CspN1Qualifier", partner.GetConfig("CspN1Qualifier")),
new XElement("AuthInfoQualifier", string.Empty),
new XElement("AuthInfo", string.Empty),
new XElement("SecurityInfoQualifier", string.Empty),
new XElement("SecurityInfo", string.Empty),
new XElement("InterchangeControlNbr", string.Empty),
new XElement("AckRequested", string.Empty),
new XElement("TestIndicator", string.Empty),
new XElement("SubelementSeparator", partner.GetConfig("TradingPartnerSubElementDelimiter")),
new XElement("FunctionalGroup", "GE"),
new XElement("FunctionalGroupControlNbr", string.Empty),
new XElement("CspIsaIdentifier", partner.GetConfig("CspIsaIdentifier")),
new XElement("CspGSIdentifier", partner.GetConfig("CspGSIdentifier"))));
if (document.Root == null)
{
logger.Error("Unable to create 820 XML document. Root node element is null.");
continue;
}
foreach (var header in headers)
{
if (!header.HeaderKey.HasValue)
{
continue;
}
if (token.IsCancellationRequested)
{
break;
}
var element = new XElement("Transaction",
new XElement("SegmentCount", "0"));
WriteHeader(element, header);
model.AddHeaderKey(header.HeaderKey.Value);
document.Root.Add(element);
}
model.Document = document;
collection.Add(model);
}
return(collection.ToArray());
}
public IMarketFileExportResult[] Export(CancellationToken token)
{
var cspDunsPorts = clientDataAccess.ListCspDunsPort();
var cspDunsPort = cspDunsPorts
.Where(x => x.ProviderId == 3)
.ToArray();
var collection = new List <IMarketFileExportResult>();
foreach (var port in cspDunsPort)
{
if (token.IsCancellationRequested)
{
break;
}
var partner = marketDataAccess.LoadCspDunsTradingPartner(port.Duns, port.LdcDuns);
if (partner == null)
{
logger.ErrorFormat(
"No CSP DUNS Trading Partner record exists between CR DUNS \"{0}\" and LDC DUNS \"{1}\". 814 Transactions will not be exported.",
port.Duns, port.LdcDuns);
continue;
}
marketDataAccess.LoadCspDunsTradingPartnerConfig(partner);
var headers = exportDataAccess.ListUnprocessed(port.LdcDuns, port.Duns, 3);
if (headers.Length == 0)
{
logger.TraceFormat("Zero 814 records found to export for TDSP Duns \"{0}\" and CR Duns \"{1}\".",
port.LdcDuns, port.Duns);
continue;
}
var distinctActionCodes = headers.Select(x => new { x.ActionCode }).Distinct().ToList();
//we need to loop for each action code and based on that generate a file
foreach (var uniqueValue in distinctActionCodes)
{
var value = uniqueValue;
var headerList = new List <Type814Header>();
foreach (var header in headers)
{
if (header.ActionCode.Trim().ToUpper() == value.ActionCode.Trim().ToUpper())
{
headerList.Add(header);
}
}
if (headerList.Count <= 0)
{
continue;
}
var model = new Export814Model
{
CspDuns = port.Duns,
LdcDuns = port.LdcDuns,
LdcShortName = port.LdcShortName,
TradingPartnerId = port.TradingPartnerId,
ForSsxContent = true,
UniqueFileNameFiller = string.Format("{0}_SSX", value.ActionCode.Trim())
};
model.CspDunsTradingPartnerId = partner.CspDunsTradingPartnerId;
var fileContentBuilder = BuildFileContent(headerList, port);
model.Content = fileContentBuilder.ToString();
model.AddHeaderKeys(headerList.Where(x => x.HeaderKey.HasValue).Select(x => x.HeaderKey.Value).ToList().ToArray());
collection.Add(model);
}//loop for each Action Code combination
}
return(collection.ToArray());
}