// Extract Filename:
varFilename = MsgExcelFileRequest(FILE.ReceivedFileName);
varFilename = MsgExcelFileRequest(FILE.ReceivedFileName);
// Using variables to alter values:
varXmlTemp = MsgExcelFileRequest.xml;
varInnerText = varXmlTemp.InnerXml;
varInnerText = varXmlTemp.InnerXml.Replace("<", "<");
varInnerText = varInnerText.Replace(">", ">");
varXmlTemp = MsgExcelFileRequest.xml;
varInnerText = varXmlTemp.InnerXml;
varInnerText = varXmlTemp.InnerXml.Replace("<", "<");
varInnerText = varInnerText.Replace(">", ">");
// Create xml from the altered values:
varXml.LoadXml(System.String.Format("<ns0:usp_Logic_Entries_Insert xmlns:ns0=\"http://schemas.microsoft.com/Sql/2008/05/TypedProcedures/dbo\"><ns0:XmlFilename>{0}</ns0:XmlFilename><ns0:XmlData>{1}</ns0:XmlData></ns0:usp_Logic_Entries_Insert>", varFilename, varInnerText));
varXml.LoadXml(System.String.Format("<ns0:usp_Logic_Entries_Insert xmlns:ns0=\"http://schemas.microsoft.com/Sql/2008/05/TypedProcedures/dbo\"><ns0:XmlFilename>{0}</ns0:XmlFilename><ns0:XmlData>{1}</ns0:XmlData></ns0:usp_Logic_Entries_Insert>", varFilename, varInnerText));
// Assigned created xml to the input message:
MsgUspLogicEntriesInsertInput.xml = varXml;
MsgUspLogicEntriesInsertInput.xml = varXml;
// Trace logs:
System.Diagnostics.EventLog.WriteEntry("Logic - Step103_01 - SaveExcelFileRecordsToDb.odx", System.String.Format("Saving ExcelFile \"{0}\".", varFilename));
System.Diagnostics.EventLog.WriteEntry("Logic - Step103_01 - SaveExcelFileRecordsToDb.odx", System.String.Format("Saving ExcelFile \"{0}\".", varFilename));
Comments
Post a Comment