//string json3 = @"{'Type': 'M', // 'Name': 'M_940', // 'Content': [{ // 'Type': 'S', // 'Name': 'W05', // 'Content': [ { 'E': 'N' }, { 'E': '538686' }, { 'E': '' }, { 'E': '001001' }, { 'E': '538686' }] // }] //}"; //{'Type': 'M','Name': 'M_940','Content': [{'Type': 'S','Name': 'W05','Content': [ { 'E': 'N' }, { 'E': '538686' }, { 'E': '' }, { 'E': '001001' }, { 'E': '538686' }]}]} public string GetEDIDocFromJSON(string jsonEDIdata) { dynamic json = JsonConvert.DeserializeObject(jsonEDIdata, typeof(object)); //TODO: convert logic to determine map to separate method MapLoop map = Factory.GetMap((string)json.Name); //TODO: add exception handling for the string cast operation JsonMapReader jReader = new JsonMapReader(map); EdiTrans ediTxn = jReader.ReadToEnd(jsonEDIdata); var eGroup = new EdiGroup("OW"); eGroup.Transactions.Add(ediTxn); var eInterchange = new EdiInterchange(); eInterchange.Groups.Add(eGroup); EdiBatch eBatch = new EdiBatch(); eBatch.Interchanges.Add(eInterchange); //Add all service segments EdiDataWriterSettings settings = new EdiDataWriterSettings( new SegmentDefinitions.ISA(), new SegmentDefinitions.IEA(), new SegmentDefinitions.GS(), new SegmentDefinitions.GE(), new SegmentDefinitions.ST(), new SegmentDefinitions.SE(), "ZZ", "SENDER", "ZZ", "RECEIVER", "GSSENDER", "GSRECEIVER", "00401", "004010", "T", 100, 200, "\r\n", "*"); EdiDataWriter ediWriter = new EdiDataWriter(settings); return(ediWriter.WriteToString(eBatch)); }
private string writeEdiEnvelope(EdiTrans t, string functionalCode, string mode, string receiver) { //string _Sender = "84352008TEST"; //string _Receiver = "8174836888"; string _Sender = ConfigurationManager.AppSettings["Sender"]; string _Receiver = receiver; string _Version = "00401"; //create batch EdiBatch b = new EdiBatch(); b.Interchanges.Add(new EdiInterchange()); b.Interchanges.First().Groups.Add(new EdiGroup(functionalCode)); b.Interchanges.First().Groups.First().Transactions.Add(t); //Add all service segments EdiDataWriterSettings settings = new EdiDataWriterSettings( new EdiEngine.Standards.X12_004010.Segments.ISA(), new EdiEngine.Standards.X12_004010.Segments.IEA(), new EdiEngine.Standards.X12_004010.Segments.GS(), new EdiEngine.Standards.X12_004010.Segments.GE(), new EdiEngine.Standards.X12_004010.Segments.ST(), new EdiEngine.Standards.X12_004010.Segments.SE(), "ZZ", _Sender, "ZZ", _Receiver, _Sender, _Receiver, _Version, "004010", mode, 100, 200, "\r\n", "*"); EdiDataWriter w = new EdiDataWriter(settings); return(w.WriteToString(b)); }
public static string WriteEdiEnvelope(EdiTrans t, string functionalCode) { //create batch EdiBatch b = new EdiBatch(); b.Interchanges.Add(new EdiInterchange()); b.Interchanges.First().Groups.Add(new EdiGroup(functionalCode)); b.Interchanges.First().Groups.First().Transactions.Add(t); //Add all service segments EdiDataWriterSettings settings = new EdiDataWriterSettings( new SegmentDefinitions.ISA(), new SegmentDefinitions.IEA(), new SegmentDefinitions.GS(), new SegmentDefinitions.GE(), new SegmentDefinitions.ST(), new SegmentDefinitions.SE(), "ZZ", "SENDER", "ZZ", "RECEIVER", "GSSENDER", "GSRECEIVER", "00401", "004010", "T", 100, 200, "\r\n", "*"); EdiDataWriter w = new EdiDataWriter(settings); return(w.WriteToString(b)); }
public static async Task <String> SplitEDIFile(string BLOBFileName, string splitHalf, ILogger log) { log.LogInformation("SplitEDIFile function processing a request."); //Incoming JSON Payload: //{ "ediFileName":"916386MS210_202001190125_000000001.raw","splitHalf":"1"} // Parse the connection string and get a reference to the blob. var storageCredentials = new StorageCredentials("jbupsbtspaassagenv2", "Pi5FpNwJgcwJiAj7fxyCc4ncM4llKu3184a0OrTE1Jn0VxSYLGPIOZAO1j36DjT1Plmw8udLR3NXUBVNUWnucA=="); var cloudStorageAccount = new CloudStorageAccount(storageCredentials, true); var cloudBlobClient = cloudStorageAccount.CreateCloudBlobClient(); //Define BlobIN Stream CloudBlobClient blobINClient = cloudStorageAccount.CreateCloudBlobClient(); CloudBlobContainer blobINContainer = blobINClient.GetContainerReference("edi-process-split"); CloudBlockBlob blobIN = blobINContainer.GetBlockBlobReference(BLOBFileName); Stream blobINStream = await blobIN.OpenReadAsync(); //Define BlobOUT FileName - for FIRST OR SECOND half of transactions string blobOUTPreFix = ""; if (splitHalf == "1") { blobOUTPreFix = "A_"; } else { blobOUTPreFix = "B_"; } CloudBlobClient blobOUTClient = cloudStorageAccount.CreateCloudBlobClient(); CloudBlobContainer blobOUTContainer = blobOUTClient.GetContainerReference("edi-process-split"); CloudBlockBlob blobOUT = blobOUTContainer.GetBlockBlobReference(blobOUTPreFix + BLOBFileName); //Read blobIN EdiDataReader r = new EdiDataReader(); EdiBatch b = r.FromStream(blobINStream); int totEDITransCtr = 0; totEDITransCtr = b.Interchanges[0].Groups[0].Transactions.Count(); // ********************************************************** // ** SAVE Original EDI Interchange: Data & Transactions // ********************************************************** EdiInterchange OrigInter = new EdiInterchange(); OrigInter = b.Interchanges[0]; List <EdiTrans> OrigTrans = new List <EdiTrans>(); OrigTrans = b.Interchanges[0].Groups[0].Transactions; // ********************************************************** // ** Calculate SPLIT // ********************************************************** //1st Half int EDI_Trans_Ctr1 = totEDITransCtr / 2; //2nd Half int EDI_Trans_Ctr2 = totEDITransCtr - (totEDITransCtr / 2); // ********************************************************** // ** Write-Out 1st Half to file // ********************************************************** List <EdiTrans> HalfTrans = new List <EdiTrans>(); //Define LOOP Parameters - for FIRST OR SECOND half of transactions int loopStart = 0; int loopEnd = 0; if (splitHalf == "1") { loopStart = 0; loopEnd = EDI_Trans_Ctr1; } else { loopStart = EDI_Trans_Ctr1 + 1; loopEnd = totEDITransCtr; } //Process TRANSACTIONS for (int i = loopStart; i < loopEnd; i++) { EdiTrans ediItem = new EdiTrans(); ediItem = b.Interchanges[0].Groups[0].Transactions[i]; HalfTrans.Add(ediItem); } EdiBatch b2 = new EdiBatch(); //Handle InterChange EdiInterchange ediInterChgItem = new EdiInterchange(); ediInterChgItem = b.Interchanges[0]; //Remove existing EdiGroup jbEdiGroupItem = new EdiGroup(""); jbEdiGroupItem = b.Interchanges[0].Groups[0]; ediInterChgItem.Groups.RemoveRange(0, 1); //Add Interchange b2.Interchanges.Add(ediInterChgItem); //Handle Group jbEdiGroupItem.Transactions.RemoveRange(0, totEDITransCtr); ediInterChgItem.Groups.Add(jbEdiGroupItem); //Add Transactions for (int i = 0; i < HalfTrans.Count(); i++) //Hardcoded to 91 { EdiTrans ediItem = new EdiTrans(); ediItem = HalfTrans[i]; b2.Interchanges[0].Groups[0].Transactions.Add(ediItem); } EdiDataWriterSettings settings = new EdiDataWriterSettings( new SegmentDefinitions.ISA(), new SegmentDefinitions.IEA(), new SegmentDefinitions.GS(), new SegmentDefinitions.GE(), new SegmentDefinitions.ST(), new SegmentDefinitions.SE(), OrigInter.ISA.Content[4].ToString(), //isaSenderQual OrigInter.ISA.Content[5].ToString(), //isaSenderId OrigInter.ISA.Content[6].ToString(), //isaReceiverQual // OrigInter.ISA.Content[7].ToString(), //isaReceiverId "9163863M210", //isaReceiverId OrigInter.ISA.Content[8].ToString(), //gsSenderId OrigInter.ISA.Content[9].ToString(), //gsReceiverId // OrigInter.ISA.Content[10].ToString(), //JB Test OrigInter.ISA.Content[11].ToString(), //isaEdiVersion OrigInter.ISA.Content[12].ToString(), //gsEdiVersion // "00403", //gsEdiVersion OrigInter.ISA.Content[14].ToString(), //P //isaUsageIndicator //[ 000, //isaFirstControlNumber 001, //gsFirstControlNumber OrigInter.SegmentSeparator.ToString(), //segmentSeparator OrigInter.ElementSeparator.ToString()); //elementSeparator EdiDataWriter w = new EdiDataWriter(settings); string JBData = w.WriteToString(b2); log.LogInformation("trigger function - WRITING SPLIT FILE : " + blobOUT.Name.ToString()); await blobOUT.UploadTextAsync(JBData); blobINStream.Close(); return(" "); }