static void Main(string[] args)
{
try
{
ExcelHelper eh = new ExcelHelper();
// do babylon
ISTCDataDataSet1TableAdapters.BillOfLadingTableAdapter bol = new ISTCDataDataSet1TableAdapters.BillOfLadingTableAdapter();
DateTime today = DateTime.Now;
DateTime reportDate = new DateTime(today.Year, today.Month, today.Day - 1);
ISTCDataDataSet1.BillOfLadingDataTable table = bol.GetDataBPReport(25, reportDate);
List <List <object> > writeRows = ExtractData(table);
eh.WriteWorkSheet(writeRows, reportDate, "Babylon");
// nj
table = bol.GetDataBPReport(59, reportDate);
writeRows = ExtractData(table);
eh.WriteWorkSheet(writeRows, reportDate, "Jersey");
// bk
table = bol.GetDataBPReport(60, reportDate);
writeRows = ExtractData(table);
eh.WriteWorkSheet(writeRows, reportDate, "Brooklyn");
string path = eh.SaveAs();
Attachment attach = new Attachment(path);
var fromAddress = new MailAddress("*****@*****.**", "ITC Tech");
var toAddress = new MailAddress("*****@*****.**", "Dave");
const string fromPassword = "******";
const string subject = "BP Email";
const string body = "See Attached";
TextReader sr = new StreamReader("d:/Reports/emails.txt");
string emailTo = sr.ReadLine();
var smtp = new SmtpClient
{
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = body
})
{
message.Attachments.Add(attach);
message.To.Add(emailTo);
smtp.Send(message);
}
}
catch (Exception e)
{
TextWriter tw = new StreamWriter("D:/Reports/log.txt");
// write a line of text to the file
tw.WriteLine("ERRORS:");
tw.WriteLine(e.Message + " " + e.StackTrace);
tw.Close();
}
}
static void Main(string[] args)
{
try
{
ExcelHelper eh = new ExcelHelper();
// do babylon
ISTCDataDataSet1TableAdapters.BillOfLadingTableAdapter bol = new ISTCDataDataSet1TableAdapters.BillOfLadingTableAdapter();
DateTime today = DateTime.Now;
DateTime reportDate = new DateTime(today.Year, today.Month, today.Day - 1);
ISTCDataDataSet1.BillOfLadingDataTable table = bol.GetDataBPReport(25, reportDate);
List<List<object>> writeRows = ExtractData(table);
eh.WriteWorkSheet(writeRows, reportDate, "Babylon");
// nj
table = bol.GetDataBPReport(59, reportDate);
writeRows = ExtractData(table);
eh.WriteWorkSheet(writeRows, reportDate, "Jersey");
// bk
table = bol.GetDataBPReport(60, reportDate);
writeRows = ExtractData(table);
eh.WriteWorkSheet(writeRows, reportDate, "Brooklyn");
string path = eh.SaveAs();
Attachment attach = new Attachment(path);
var fromAddress = new MailAddress("*****@*****.**", "ITC Tech");
var toAddress = new MailAddress("*****@*****.**", "Dave");
const string fromPassword = "******";
const string subject = "BP Email";
const string body = "See Attached";
TextReader sr = new StreamReader("d:/Reports/emails.txt");
string emailTo = sr.ReadLine();
var smtp = new SmtpClient
{
Host = "smtp.gmail.com",
Port = 587,
EnableSsl = true,
DeliveryMethod = SmtpDeliveryMethod.Network,
UseDefaultCredentials = false,
Credentials = new NetworkCredential(fromAddress.Address, fromPassword)
};
using (var message = new MailMessage(fromAddress, toAddress)
{
Subject = subject,
Body = body
})
{
message.Attachments.Add(attach);
message.To.Add(emailTo);
smtp.Send(message);
}
}
catch (Exception e)
{
TextWriter tw = new StreamWriter("D:/Reports/log.txt");
// write a line of text to the file
tw.WriteLine("ERRORS:");
tw.WriteLine(e.Message + " " + e.StackTrace);
tw.Close();
}
}