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);
}
