private void sendEmail(EmailObject eml)
{
string myDate = today.ToString("dd MMMM yyyy");
//new outlook instance
Outlook.Application app = new Outlook.Application();
Outlook.MailItem mail = app.CreateItem(Outlook.OlItemType.olMailItem);
{
string[] files = Directory.GetFiles(AttachmentDestination);
int fileCount = 0;
foreach (string file in files)
{
Console.WriteLine("attatching file : " + file);
mail.Attachments.Add(file);
fileCount++;
}
if (fileCount > 0)
{
mail.Importance = Outlook.OlImportance.olImportanceHigh;
mail.Subject = myDate + " " + eml.EmailSubject;
mail.To = eml.Emails;
mail.Body = eml.EmailBody;
Console.WriteLine("sending...");
mail.Send();
}
}
}
public GenerateEmail(EmailObject emlObj)
{
// TODO: Complete member initialization
this.sqlString = emlObj.Queries;
this.users = emlObj.Emails;
this.excelFolder = ConfigurationManager.ConnectionStrings["wbLoc"].ConnectionString;
CreateSpreadsheets();
var emlSend = new SendEmail(emlObj, excelFolder);
}
public SendEmail(EmailObject eml, string DownloadDestination)
{
AttachmentDestination = DownloadDestination;
today = DateTime.Today;
sendEmail(eml);
}
private void readTable(DataTable dt)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
//convert object array to string array with linq expression
string[] emailData = ((IEnumerable)dt.Rows[i].ItemArray).Cast<object>()
.Select(x => x.ToString()).ToArray();
var emlObj = new EmailObject(emailData);
var gen = new GenerateEmail(emlObj);
}
}
