SqlConnection conn = new SqlConnection(conString);
ReportDocument MyReport = new ReportDocument();
try
{
conn.Open();
SqlCommand cmd = new SqlCommand(sqlQuery, conn);
SqlDataReader reader = cmd.ExecuteReader();
int i = 0;
Boolean[] emailsent = new Boolean[1000];
for (int x = 1; x < 1000; x++)
{ emailsent[x] = false; }
while (reader.Read())
{
if (reader["notify_event"].ToString()== "ANNC" )
{
i++;
Console.WriteLine(i + " " + reader["sec_no"].ToString() + " " + reader[2].ToString() + " " + reader[3].ToString() + " " + reader["sub_no"].ToString()
+ " " + reader["add_cymd"].ToString() );
MyReport.Load(@"\\lgc-oma-rpt\reports\NOTSNOTBYSECv2.rpt");
MyReport.SetDatabaseLogon("xxxxxx", "xxxxxx", "lgc-oma-sql", "corpdata");
MyReport.SetParameterValue("sec_no", reader["sec_no"].ToString());
MyReport.SetParameterValue("AddDate", reader["add_cymd"]);
MyReport.SetParameterValue("rep", reader["rep"].ToString());
DestFolder destfolder = new DestFolder();
destfolder.myBaseFldr = @"\\jhill\c$\junk";
destfolder.CreateSubFolder((int)reader["sub_no"], "ANNC");
// Use new DLL here to set tempPDF
tempPDF = destfolder.FolderPath;
PDFReport = tempPDF + @"\" + reader["sub_no"].ToString() + "-" + reader["rep"].ToString() + "-" + reader["sec_no"].ToString() + "-" + i.ToString() +"-NOTS.pdf";
MyReport.ExportToDisk(ExportFormatType.PortableDocFormat, PDFReport);
CCEmail = " ";
if (reader.GetSqlBoolean(5) == true)
{
EmailPDF(reader, PDFReport, FromEmail, reader["NOTS_ToEmail"].ToString(), CCEmail);
emailsent[reader.GetInt32(4)] = true;
}
}
}
CheckForNoEmail(emailsent, FromEmail);
}
catch (Exception ee)
{
Console.WriteLine("error " + ee);
}
conn.Close();
Console.WriteLine("Out of stuff to do for today");
IP Logged