protected void Page_Load(object sender, EventArgs e)
{
var file = @"D:\SARS\Validate\IE_SCHEMA_VALIDATION4.txt";
var cbcXml = FdrCommon.FormatXml(File.ReadAllText(file));
var _client = new ESBMessagingServiceClient("basic");
var cbcSchemaVal = _client.ValidateSchema(Configurations.CbCValidationServiceID, cbcXml);
_client.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
var uid = Request["uid"].ToUpper();
var source = Request["src"].ToUpper();
if (string.IsNullOrEmpty(uid) || string.IsNullOrEmpty(source))
{
Response.Write("PARAMETER MISSING");
return;
}
Guid guid;
if (!Guid.TryParse(uid, out guid))
{
Response.Write("UID PARAMETER IN NOT VALID");
return;
}
var procedureName = string.Empty;
switch (source)
{
case "IN":
{
procedureName = "usp_READ_ReportXml_IN";
break;
}
case "OUT":
{
procedureName = "usp_READ_ReportXml_OUT";
break;
}
case "MNE":
{
procedureName = "usp_READ_ReportXml_MNE";
break;
}
default:
{
procedureName = null;
break;
}
}
if (string.IsNullOrEmpty(procedureName))
{
MessageBox.Show("PROCEDURE NAME IS NOT VALID");
return;
}
var recordSet = new RecordSet(procedureName, QueryType.StoredProcedure, new DBParamCollection {
{ "@UID", guid.ToString() }
});
if (!recordSet.HasRows)
{
MessageBox.Show("THER IS NO DATA AVAILABLE"); return;
}
var xmlData = recordSet[0][0].ToString();
var cbcXml = "";
if (source.Equals("MNE", StringComparison.CurrentCultureIgnoreCase))
{
var doc = new XmlDocument();
doc.LoadXml(xmlData);
var cbCXmlNodeList = doc.GetElementsByTagName("CBC_OECD", "*");
if (cbCXmlNodeList.Count > 0)
{
cbcXml = cbCXmlNodeList[0].OuterXml;
}
}
else
{
cbcXml = xmlData;
}
var client = new ESBMessagingServiceClient("basic");
//cbcXml = File.ReadAllText(@"D:\FDR\Report\CBC_OUT_KR.xml");
cbcXml = FdrCommon.FormatXml(cbcXml);
var cbcSchemaVal = client.ValidateSchema(Configurations.CbCValidationServiceID, cbcXml);
if (!cbcSchemaVal.IsValid)
{
return;
}
cbcXml = cbcXml.Replace("<CBC_OECD>", "<CBC_OECD xmlns=\"urn:oecd:ties:cbc:v1\">");
cbcXml = FdrCommon.FormatXml(cbcXml);
var cbcMessage = XmlObjectSerializer.ConvertXmlToObject <CBC_OECD>(cbcXml);
if (cbcMessage == null)
{
return;
}
var overAllReport = new StringBuilder();
overAllReport.Append(CreateMessageSpec(cbcMessage));
foreach (var cbcBody in cbcMessage.CbcBody)
{
var reportingEntity = cbcBody.ReportingEntity;
var reportingEntityHeader = CreateReportingEntityHeader();
var reportingEntityRowAndData = CreateReportingEntityRowAndData(reportingEntity);
if (cbcBody.CbcReports != null && cbcBody.CbcReports.Any())
{
reportingEntityRowAndData.AppendFormat("<tr><td {0}></td><td colspan=\"11\">", GetColumnAttributes());
var cbcReportHeaderRow = CreatCbCReportHeader();
var cbcReportDataRows = CreateCbCReportRowsAndData(cbcBody);
reportingEntityRowAndData.AppendFormat("<table width=\"100%\">{0}{1}</table></td></tr>", cbcReportHeaderRow, cbcReportDataRows);
}
overAllReport.Append(reportingEntityHeader);
overAllReport.Append(reportingEntityRowAndData);
//if (cbcBody.AdditionalInfo != null && cbcBody.AdditionalInfo.Any())
//{
// var additionalInfoHeaderRow = CreatAdditionalInfoHeader();
// var additionalInfoDataRow = new StringBuilder();
// foreach (var infoType in cbcBody.AdditionalInfo)
// {
// additionalInfoDataRow.Append(CreatAdditionalInfoRowAndData(infoType));
// }
// overAllReport.AppendFormat("<table width=\"100%\">{0}{1}</table></td></tr>", additionalInfoHeaderRow, additionalInfoDataRow);
//}
}
overAllReport.Append("</table></div>");
Export(overAllReport);
}
private static void SendMessage(string messageToSend, IncomingMessage incomingMessage, ESBMessagingServiceClient client)
{
var contract = new WriteMessageData
{
ConfigurationId = new Guid(Configurations.CBCREPORTMGT_CHANNELID),
Message = messageToSend,
CorrelationId = incomingMessage.MessageId
};
var sent = client.SendAndForget(contract);
}
