private void startReceive()
{
QuerysDb querysDb = new QuerysDb();
var emails = querysDb.SelectEmails();
for (int key = 0; key < emails.Rows.Count; key++)
{
if (!backList.Contains(emails.Rows[key][1].ToString()))
{
if (!string.IsNullOrWhiteSpace(emails.Rows[key][1].ToString()))
{
mail_grid.Rows.Add(false, emails.Rows[key][3].ToString(), emails.Rows[key][4].ToString(), emails.Rows[key][5].ToString(), emails.Rows[key][6].ToString());
backList.Add(emails.Rows[key][1].ToString());
}
}
}
Thread thread = new Thread(() => {
try
{
var client = new Pop3Client();
client.Connect("pop.mail.yahoo.com", 995, true);
client.Authenticate(Toemail, Topass);
var count = client.GetMessageCount();
OpenPop.Mime.Message message = client.GetMessage(count);
// var mailbody = ASCIIEncoding.ASCII.GetString(message.RawMessage);
StringBuilder builder = new StringBuilder();
OpenPop.Mime.MessagePart plainText = message.FindFirstPlainTextVersion();
if (plainText != null)
{
CreateDb.ExecuteSqlCommand($"INSERT INTO box_mail (dateId, mail_from, subject, body, tipo) VALUES('{message.Headers.Date.Trim()}','{message.Headers.From}','{message.Headers.Subject.Trim()}','{plainText.GetBodyAsText()}', 'text')");
}
else
{
// Might include a part holding html instead
OpenPop.Mime.MessagePart html = message.FindFirstHtmlVersion();
if (html != null)
{
CreateDb.ExecuteSqlCommand($"INSERT INTO box_mail (dateId, mail_from, subject, body, tipo) VALUES('{message.Headers.Date.Trim()}','{message.Headers.From}','{message.Headers.Subject.Trim()}','{html.GetBodyAsText()}', 'html')");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
// corpo_email.AppendText(ex.Message + "\r\n");
}
})
{
IsBackground = true
};
thread.Start();
}
