foreach
string strFilePath = ConfigurationManager.AppSettings["InputPath"]; string[] strfilesToProcess = Directory.GetFiles(strFilePath,"*.txt"); // string strArchivePath = clientname + ConfigurationManager.AppSettings["key"]; // string[] strfilesToProcess = Directory.GetFiles(strFilePath, "*.txt"); string strline = ""; string strfileAccount = ""; try { foreach (string FileToGo in strfilesToProcess) { using (IPDEntities context = new IPDEntities()) { AllClientEDLog allClEdLog = new AllClientEDLog(); System.IO.StreamReader file = new System.IO.StreamReader(FileToGo); while ((strline = file.ReadLine()) != null) { if ((strline.Contains("Account Number|")) || (strline.Trim() == "")) { continue; } string[] lineData = strline.Split('|'); strfileAccount = lineData[0].Trim(); allClEdLog.Account_No = lineData[0].Trim(); allClEdLog.MRN = lineData[1].Trim(); if (lineData[3].Trim() == "") { allClEdLog.Pat_Name = lineData[2].Trim() + ", " + lineData[4].Trim(); } else { allClEdLog.Pat_Name = lineData[2].Trim() + ", " + lineData[4].Trim() + " " + lineData[3].Trim(); } allClEdLog.Carrier = lineData[5].Trim(); allClEdLog.Department_Location = lineData[10].Trim(); allClEdLog.DOS = Convert.ToDateTime(lineData[6]); allClEdLog.Registration_Time = Convert.ToDateTime(lineData[6] + " " + lineData[7].Substring(0, 2) + ":" + lineData[7].Substring(2, 2)); if (lineData[8].Trim() != "") { allClEdLog.Discharge_Time = Convert.ToDateTime(lineData[8] + " " + lineData[9].Substring(0, 2) + ":" + lineData[9].Substring(2, 2)); } allClEdLog.Disposition = lineData[11].Trim(); allClEdLog.DOB = Convert.ToDateTime(lineData[12]); allClEdLog.Gender = lineData[13].Trim(); allClEdLog.TemplateId = 580;
<appsettings> <add key="InputPath" value="\\mrsi-data2\ED_Logs\TEST\IN\" /> <add key="ArchivePath" value="\\mrsi-data2\ED_Logs\TEST\OUT\" /> <add key="RecepientAddress" value="mabraham@logixhealth.com" /> <add key="EmailErrorsTo" value="mabraham@logixhealth.com" /> <add key="EmailErrorsFrom" value="mabraham@logixhealth.com" /> </appsettings>
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)