/// <summary>
/// use the pop client to get the latest message
/// </summary>
/// <returns></returns>
private bool GetLastestUpload_POP()
{
//return true;
try
{
using (Pop3Client client = new Pop3Client())
{
//string hostname = "pop.gmail.com";
//int port = 995;
//bool useSsl = true;
//string username = "******";
//string password = "******";
// Connect to the server
int portNo = 0;
if (int.TryParse(_popPort, out portNo))
{
client.Connect(_popHost, portNo, true);
// Authenticate ourselves towards the server
client.Authenticate(_icmsEmailAddress, _smtpPassword);
string fileName = string.Empty;
// We know the message contains an attachment with the name "useful.pdf".
// We want to save this to a file with the same name
//for (int i = client.GetMessageCount(); i == 0; i--)
//{
int latestMessage = client.GetMessageCount();
Message message = client.GetMessage(latestMessage);
MMDAutomation.Messageing.MessageLog msgLog = new MessageLog(message.Headers.MessageId, message.Headers.DateSent, _sqlConnectionString);
if (message.Headers.Subject.Contains(_emailSubject))
{
if (!msgLog.CheckMessageId())
{
//message not found -- process file
foreach (MessagePart attachment in message.FindAllAttachments())
{
fileName = attachment.FileName;
if (fileName.Split('.')[1].Equals("xlsx")) //attachment.FileName.Equals(@"WADALAOR.xlsx"))
{
// Save the raw bytes to a file
//string fileLocation = @"C:\Users\Marnee Dearman\Documents\SK Auto\ICMS Excel Downloads\";
_attachment += fileName.Replace(" ", "");
System.IO.File.WriteAllBytes(_attachment, attachment.Body);
LogUpload("File downloaded at " + DateTime.Now);
}
}
msgLog.LogMessageId();
}
}
//client.DeleteMessage(latestMessage);
}
//client.Dispose();
//}
return true;
}
}
catch (Exception ex)
{
AutoUploadLog log = new AutoUploadLog("GetLatesUpload_POP: " + ex.Message, _sqlConnectionString);
return false;
}
}
private void LogUpload(string message)
{
AutoUploadLog uploadLog = new AutoUploadLog(message, _sqlConnectionString);
try
{
uploadLog.LogToDatabase();
}
catch
{
}
}