public static CoreFeature getInstance()
{
if (instance == null)
{
instance = new CoreFeature();
}
return(instance);
}
//focusing first on gMail account using recent: in username
public void FetchRecentMessages(Account emailAccount, bool isFetchLast30days)
{
SqlConnection connection = null;
SqlCommand cmd = null;
string emailUsername = null;
if (isFetchLast30days)
{
if (emailAccount.server.Contains("gmail.com"))
{
emailUsername = "******" + emailAccount.username;
}
else
{
emailUsername = emailAccount.username;
}
CoreFeature.getInstance().LogActivity(LogLevel.Debug, "Fetching *last 30 days* message", EventLogEntryType.Information);
}
else
{
emailUsername = emailAccount.username;
CoreFeature.getInstance().LogActivity(LogLevel.Debug, "Fetching *new* message", EventLogEntryType.Information);
}
if (PosLibrary.CoreFeature.getInstance().Connect(emailAccount.name, emailAccount.server, emailAccount.port, emailAccount.use_ssl, emailUsername, emailAccount.password))
{
int count = PosLibrary.CoreFeature.getInstance().getPop3Client().GetMessageCount();
for (int i = 1; i <= count; i++)
{
//Regards to : http://hpop.sourceforge.net/exampleSpecificParts.php
OpenPop.Mime.Message message = PosLibrary.CoreFeature.getInstance().getPop3Client().GetMessage(i);
MessagePart messagePart = message.FindFirstPlainTextVersion();
if (messagePart == null)
{
messagePart = message.FindFirstHtmlVersion();
}
string messageBody = null;
if (messagePart != null)
{
messageBody = messagePart.GetBodyAsText();
}
messageBody = Regex.Replace(messageBody, "<.*?>", string.Empty);
//save to appropriate inbox
connection = CoreFeature.getInstance().getDataConnection();
string sql = "insert into inbox(account_name,sender,subject,body,date, sender_ip,[to]) values (@account_name,@sender,@subject,@body,@date,@sender_ip,@to)";
cmd = new SqlCommand(sql, connection);
cmd.Parameters.Add(new SqlParameter("account_name", emailAccount.name.ToString()));
cmd.Parameters.Add(new SqlParameter("sender", message.Headers.From.ToString()));
cmd.Parameters.Add(new SqlParameter("subject", message.Headers.Subject.ToString()));
cmd.Parameters.Add(new SqlParameter("body", messageBody.ToString()));
cmd.Parameters.Add(new SqlParameter("date", message.Headers.Date.ToString()));
cmd.Parameters.Add(new SqlParameter("sender_ip", message.Headers.Received[message.Headers.Received.Count - 1].Raw.ToString()));
cmd.Parameters.Add(new SqlParameter("to", message.Headers.To[message.Headers.To.Count - 1].ToString()));
try
{
int rowAffected = cmd.ExecuteNonQuery();
CoreFeature.getInstance().LogActivity(LogLevel.Debug, "Inserting email inbox from " + message.Headers.From + ", subject=" + message.Headers.Subject + ", body=" + messageBody, EventLogEntryType.Information);
}
catch (Exception ex)
{
CoreFeature.getInstance().LogActivity(LogLevel.Debug, "[Internal Application Error] FetchRecentMessages " + ex.Message, EventLogEntryType.Information);
}
cmd.Dispose();
connection.Close();
}
// delete if there any message received from the server
if (count > 0 && !emailAccount.server.Contains("gmail.com"))
{
pop3Client.DeleteAllMessages();
pop3Client.Disconnect();
}
}
else
{
CoreFeature.getInstance().LogActivity(LogLevel.Debug, "Unable to login to your email", EventLogEntryType.Information);
}
}
