public async Task GetAllMailsAsync()
{
_retrievalClient.SetMailFolder(_settings.MailFolderName);
var uIds = await _retrievalClient.GetUIds(new ImapFilter());
var existingMails = await _repo.GetExistingUidsAsync(_settings.MailFolderName);
var existingUids = existingMails.Select(x => x.UniqueId).ToList();
ImapFilter uIdFilter = new();
if (existingUids.Count > 0)
{
uIdFilter = new ImapFilter().Uids(uIds.Where(x => !existingUids.Contains(x.Id)).ToList());
}
await foreach (var imapMessage in _mailConverter.GetMessagesAsync(uIdFilter))
{
try
{
var email = await _repo.SaveEmailAsync(imapMessage);
if (email == null)
{
_logger.LogInformation($"Email from imap folder '{imapMessage.MailFolder}', uId '{imapMessage.UId}' could not be saved to database.");
continue;
}
var fullFileName = Path.Combine(_settings.DownloadDirectory, EXPORT_PATH, CleanUpMailFolderName(_settings.MailFolderName), email.FileName + IME_FILE_EXTENSION);
if (!await _fileSystem.TryWriteAllBytesAsync(fullFileName, imapMessage.MimeMessageBytes))
{
await _repo.DeleteEmailAsync(email);
_logger.LogInformation($"Email from imap folder '{imapMessage.MailFolder}', uId '{imapMessage.UId}' could not be saved to disc.");
}
}
catch (System.Exception ex)
{
_logger.LogError(ex.Message);
}
}
}
private async Task ProcessAccount(Credentials imapCreds, DataAccount account)
{
var mail2db = new Client(imapCreds);
var converter = new MailTypeConverter(mail2db);
var availableFolders = await mail2db.GetMailFolders();
var folders = mailFolders.IntersectCaseIgnore(availableFolders).ToList();
var filter = new ImapFilter();
foreach (var mailFolder in folders)
{
if (InvalidMailfolder(mailFolder))
{
continue;
}
try {
mail2db.SetMailFolder(mailFolder);
var countInFolder = await mail2db.GetTotalMailCount();
if (mail2db.OpenedMailFolder.IsNullOrEmpty())
{
continue;
}
Console.WriteLine($"{account.EmailAddress} mail folder: '{mail2db.OpenedMailFolder}'");
Console.WriteLine($"Total Count: {countInFolder}");
var savedMessages = await db.Query(SqlBase <DataMessage> .TableName)
.Select(nameof(DataMessage.EmailAccountId), nameof(DataMessage.UId), nameof(DataMessage.MailFolder))
.Where(new { EmailAccountId = account.Id, MailFolder = mailFolder })
.GetAsync <DataMessage>();
Console.WriteLine("Existing Uids: {0}", savedMessages.Count());
Console.WriteLine("===================\n");
converter.UIdsToExclude = savedMessages.Select(x => x.UId).ToArray();
async Task ProcessImapMessage(ImapMessage item)
{
//var TA = db.Connection.BeginTransaction();
Console.WriteLine("Saving: {0}\t{1}\"{2}\"", item?.ReceivedAtLocal,
SpacePadding(item?.From?.EmailAddress),
item?.Subject);
try {
if (!savedMessages.MessageExists(item.UId, item.MailFolder, account.Id))
{
var msgId = await db.Query(SqlBase <DataMessage> .TableName).InsertGetIdAsync <uint>(item.ToData(account.Id));
foreach (var contact in item.ToDataContact(msgId))
{
await db.Query(SqlBase <DataContact> .TableName).InsertAsync(contact);
}
if (item.HasAttachments)
{
foreach (var file in item.ToAttachment(msgId))
{
Console.WriteLine("Saving Attachment: {0}", file.Filename);
await db.Query(SqlBase <DataAttachment> .TableName).InsertAsync(file);
}
}
}
//TA.Commit();
} catch (Exception ex) {
//TA.Rollback();
Console.WriteLine(ex.Message);
}
}
await converter.GetMessagesAsync(ProcessImapMessage, filter);
} catch (Exception ex2) {
Console.WriteLine(ex2.Message);
}
GC.Collect();
Console.WriteLine("\n");
}
}
