static void Main(string[] args) { try { if (args.Length > 0) { int planID = Convert.ToInt32(args[0]); string dir = string.Format(AppHelper.FilesDirectory, AppHelper.PlanAbbrev(planID)); if (!Directory.Exists(dir)) { throw (new Exception("The directory '" + dir + "' does not exist.")); } List <string> files = new List <string>(); files.Add(CreateTxtFile(planID, AppHelper.TextFile.CredData)); files.Add(CreateTxtFile(planID, AppHelper.TextFile.DEA_Expirables)); files.Add(CreateTxtFile(planID, AppHelper.TextFile.INS_Expirables)); files.Add(CreateTxtFile(planID, AppHelper.TextFile.Languages)); files.Add(CreateTxtFile(planID, AppHelper.TextFile.LIC_Expirables)); files.Add(CreateTxtFile(planID, AppHelper.TextFile.Reports)); files.Add(CreateTxtFile(planID, AppHelper.TextFile.SDC_Expirables)); files.Add(CreateTxtFile(planID, AppHelper.TextFile.MultiSpecialty)); } else { throw (new Exception("No Plan ID Supplied.")); } } catch (Exception E) { AppHelper.LogError(E); } }
private static DataTable RunSQL(string SqlText, List <SqlParameter> Parameters, SqlConnection Con, CommandType CmdType) { DataTable dt = new DataTable(); try { SqlCommand cm = new SqlCommand(SqlText, Con); cm.CommandType = CmdType; cm.CommandTimeout = 240; foreach (SqlParameter param in Parameters) { cm.Parameters.Add(param); } SqlDataAdapter da = new SqlDataAdapter(cm); da.Fill(dt); } catch (Exception E) { AppHelper.LogError(E); } return(dt); }
/*private static string GetReportsTxt(string FileName, int PlanID, string ConText) * { * string rtnStr = ""; * * try * { * DataTable dt = GetInvDates(PlanID); * string abbrev = AppHelper.PlanAbbrev(PlanID); * * using (MemoryStream ms = new MemoryStream()) * { * using (StreamWriter txtFile = new StreamWriter(ms)) * { * List<string> linesLst = new List<string>(); * int i = 0; * * foreach (DataRow dr in dt.Rows) * { * DateTime invDate = Convert.ToDateTime(dr["InvDate"]); * string month = invDate.ToString("MM"); * string day = invDate.ToString("dd"); * string year = invDate.ToString("yyyy"); * string root = (invDate.Year == DateTime.Now.Year ? "Current" : "Archive " + year); * * string rptFile = string.Format(@"\\Reports\{0}\{1}\{2}\{3}\Reports.txt", root, month, abbrev, day); * if (File.Exists(rptFile)) * { * using (StreamReader sr = new StreamReader(rptFile)) * { * using (StringReader reader = new StringReader(sr.ReadToEnd())) * { * string line = null; * while ((line = reader.ReadLine()) != null) * { * if ((line != "No Data Files") && (!linesLst.Contains(line))) * { * txtFile.WriteLine(line); * linesLst.Add(line); * } * * Console.SetCursorPosition(ConText.Length, Console.CursorTop); * Console.Write(i++); * } * reader.Close(); * } * sr.Close(); * } * } * } * if (linesLst.Count <= 0) { txtFile.WriteLine("No Data Files"); } * txtFile.Close(); * } * rtnStr = MemoryStreamToFile(ms, FileName, PlanID); * } * } * catch (Exception E) * { * AppHelper.LogError(E); * } * * return rtnStr; * }*/ private static string GetSFRTextFile(string FileName, string SFRFileName, int PlanID, string ConText) { string rtnStr = ""; try { DataTable dt = GetInvDates(PlanID); string abbrev = AppHelper.PlanAbbrev(PlanID); using (MemoryStream ms = new MemoryStream()) { using (StreamWriter txtFile = new StreamWriter(ms)) { List <string> linesLst = new List <string>(); int i = 0; foreach (DataRow dr in dt.Rows) { DateTime invDate = Convert.ToDateTime(dr["InvDate"]); string month = invDate.ToString("MM"); string day = invDate.ToString("dd"); string year = invDate.ToString("yyyy"); //string root = (invDate.Year == DateTime.Now.Year ? "Current" : "Archive " + year); string root = year; string rptFile = string.Format(@"\\OldReports\{0}\{1}\{2}\{3}\{4}", root, month, abbrev, day, SFRFileName); //string rptFile = string.Format(@"\\Reports\{0}\{1}\{2}\{3}\{4}", root, month, abbrev, day, SFRFileName); if (File.Exists(rptFile)) { using (StreamReader sr = new StreamReader(rptFile)) { using (StringReader reader = new StringReader(sr.ReadToEnd())) { string line = null; while ((line = reader.ReadLine()) != null) { if ((line != "No Data Files") && (!linesLst.Contains(line))) { txtFile.WriteLine(line); linesLst.Add(line); } Console.SetCursorPosition(ConText.Length, Console.CursorTop); Console.Write(i++); } reader.Close(); } sr.Close(); } } } if (linesLst.Count <= 0) { txtFile.WriteLine("No Data Files"); } txtFile.Close(); } rtnStr = MemoryStreamToFile(ms, FileName, PlanID); } } catch (Exception E) { AppHelper.LogError(E); } return(rtnStr); }