private static void UpdateMessageChainFlag(IDaoFactory daoFactory, int tenant, string user, int messageId, string fieldFrom, string fieldTo)
{
var daoMail = daoFactory.CreateMailDao(tenant, user);
var mail = daoMail.GetMail(new ConcreteUserMessageExp(messageId, tenant, user));
if (mail == null)
{
return;
}
var daoMailInfo = daoFactory.CreateMailInfoDao(tenant, user);
var maxValue = daoMailInfo.GetFieldMaxValue <bool>(
SimpleMessagesExp.CreateBuilder(tenant, user)
.SetChainId(mail.ChainId)
.SetMailboxId(mail.MailboxId)
.SetFolder((int)mail.Folder)
.Build(),
fieldFrom);
var daoChain = daoFactory.CreateChainDao(tenant, user);
daoChain.SetFieldValue(
SimpleConversationsExp.CreateBuilder(tenant, user)
.SetChainId(mail.ChainId)
.SetMailboxId(mail.MailboxId)
.SetFolder((int)mail.Folder)
.Build(),
fieldTo,
maxValue);
}
public void RecalculateCounters(IDaoFactory daoFactory, List <int> userFolderIds)
{
var chainDao = daoFactory.CreateChainDao(Tenant, User);
var mailInfoDao = daoFactory.CreateMailInfoDao(Tenant, User);
var totalUfMessList = mailInfoDao.GetMailUserFolderCount(userFolderIds);
var unreadUfMessUfList = mailInfoDao.GetMailUserFolderCount(userFolderIds, true);
var totalUfConvList = chainDao.GetChainUserFolderCount(userFolderIds);
var unreadUfConvUfList = chainDao.GetChainUserFolderCount(userFolderIds, true);
foreach (var id in userFolderIds.Select(id => (uint)id))
{
int totalMess;
totalUfMessList.TryGetValue(id, out totalMess);
int unreadMess;
unreadUfMessUfList.TryGetValue(id, out unreadMess);
int totalConv;
totalUfConvList.TryGetValue(id, out totalConv);
int unreadConv;
unreadUfConvUfList.TryGetValue(id, out unreadConv);
SetFolderCounters(daoFactory, id,
unreadMess, totalMess, unreadConv, totalConv);
}
}
public void UpdateChainTags(IDaoFactory daoFactory, string chainId, FolderType folder, int mailboxId, int tenant, string user)
{
var tags = GetChainTags(daoFactory, chainId, folder, mailboxId, tenant, user);
var daoChain = daoFactory.CreateChainDao(tenant, user);
daoChain.SetFieldValue(
SimpleConversationsExp.CreateBuilder(tenant, user)
.SetChainId(chainId)
.SetMailboxId(mailboxId)
.SetFolder((int)folder)
.Build(),
ChainTable.Columns.Tags,
tags);
}
/// <summary>
/// Set mailbox removed
/// </summary>
/// <param name="daoFactory"></param>
/// <param name="mailBoxData"></param>
/// <returns>Return freed quota value</returns>
private static long RemoveMailBoxInfo(IDaoFactory daoFactory, MailBoxData mailBoxData)
{
if (mailBoxData.MailBoxId <= 0)
{
throw new Exception("MailBox id is 0");
}
var daoMailbox = daoFactory.CreateMailboxDao();
var mailbox = daoMailbox.GetMailBox(
new СoncreteUserMailboxExp(mailBoxData.MailBoxId, mailBoxData.TenantId, mailBoxData.UserId, null));
if (mailbox == null)
{
throw new Exception(string.Format("MailBox with id = {0} (Tenant={1}, User='******') not found",
mailBoxData.MailBoxId, mailBoxData.TenantId, mailBoxData.UserId));
}
daoMailbox.SetMailboxRemoved(mailbox);
var daoChain = daoFactory.CreateChainDao(mailBoxData.TenantId, mailBoxData.UserId);
var folderTypes = Enum.GetValues(typeof(FolderType)).Cast <int>().ToList();
daoChain.Delete(
SimpleConversationsExp.CreateBuilder(mailBoxData.TenantId, mailBoxData.UserId)
.SetFoldersIds(folderTypes)
.SetMailboxId(mailBoxData.MailBoxId)
.Build());
var daoCrmLink = daoFactory.CreateCrmLinkDao(mailBoxData.TenantId, mailBoxData.UserId);
daoCrmLink.RemoveCrmLinks(mailBoxData.MailBoxId);
var daoMailInfo = daoFactory.CreateMailInfoDao(mailBoxData.TenantId, mailBoxData.UserId);
daoMailInfo.SetFieldValue(
SimpleMessagesExp.CreateBuilder(mailBoxData.TenantId, mailBoxData.UserId)
.SetMailboxId(mailBoxData.MailBoxId)
.Build(),
MailTable.Columns.IsRemoved,
true);
var exp = new ConcreteMailboxAttachmentsExp(mailBoxData.MailBoxId, mailBoxData.TenantId, mailBoxData.UserId,
onlyEmbedded: null);
var daoAttachment = daoFactory.CreateAttachmentDao(mailBoxData.TenantId, mailBoxData.UserId);
var totalAttachmentsSize = daoAttachment.GetAttachmentsSize(exp);
daoAttachment.SetAttachmnetsRemoved(exp);
var tagDao = daoFactory.CreateTagDao(mailBoxData.TenantId, mailBoxData.UserId);
var tagMailDao = daoFactory.CreateTagMailDao(mailBoxData.TenantId, mailBoxData.UserId);
var tagIds = tagMailDao.GetTagIds(mailBoxData.MailBoxId);
tagMailDao.DeleteByMailboxId(mailBoxData.MailBoxId);
foreach (var tagId in tagIds)
{
var tag = tagDao.GetTag(tagId);
if (tag == null)
{
continue;
}
var count = tagMailDao.CalculateTagCount(tag.Id);
tag.Count = count;
tagDao.SaveTag(tag);
}
daoFactory.CreateMailboxSignatureDao(mailBoxData.TenantId, mailBoxData.UserId).DeleteSignature(mailBoxData.MailBoxId);
daoFactory.CreateMailboxAutoreplyDao(mailBoxData.TenantId, mailBoxData.UserId)
.DeleteAutoreply(mailBoxData.MailBoxId);
daoFactory.CreateMailboxAutoreplyHistoryDao(mailBoxData.TenantId, mailBoxData.UserId).DeleteAutoreplyHistory(mailBoxData.MailBoxId);
daoFactory.CreateAlertDao(mailBoxData.TenantId, mailBoxData.UserId).DeleteAlerts(mailBoxData.MailBoxId);
daoFactory.CreateUserFolderXMailDao(mailBoxData.TenantId, mailBoxData.UserId)
.RemoveByMailbox(mailBoxData.MailBoxId);
return(totalAttachmentsSize);
}
// Method for updating chain flags, date and length.
public void UpdateChain(IDaoFactory daoFactory, string chainId, FolderType folder, uint?userFolderId, int mailboxId,
int tenant, string user)
{
if (string.IsNullOrEmpty(chainId))
{
return;
}
var db = daoFactory.DbManager;
var engine = new EngineFactory(tenant, user, Log);
var daoMailInfo = daoFactory.CreateMailInfoDao(tenant, user);
const string m_alias = "m";
var getChainQuery = new SqlQuery(MailTable.TABLE_NAME.Alias(m_alias))
.SelectCount()
.SelectMax(MailTable.Columns.DateSent.Prefix(m_alias))
.SelectMax(MailTable.Columns.Unread.Prefix(m_alias))
.SelectMax(MailTable.Columns.AttachCount.Prefix(m_alias))
.SelectMax(MailTable.Columns.Importance.Prefix(m_alias))
.Where(MailTable.Columns.Tenant.Prefix(m_alias), tenant)
.Where(MailTable.Columns.User.Prefix(m_alias), user)
.Where(MailTable.Columns.IsRemoved.Prefix(m_alias), 0)
.Where(MailTable.Columns.ChainId.Prefix(m_alias), chainId)
.Where(MailTable.Columns.MailboxId.Prefix(m_alias), mailboxId)
.Where(MailTable.Columns.Folder.Prefix(m_alias), (int)folder);
var chainInfo = db.ExecuteList(getChainQuery)
.ConvertAll(x => new
{
length = Convert.ToInt32(x[0]),
date = Convert.ToDateTime(x[1]),
unread = Convert.ToBoolean(x[2]),
attach_count = Convert.ToInt32(x[3]),
importance = Convert.ToBoolean(x[4])
})
.FirstOrDefault();
if (chainInfo == null)
{
throw new InvalidDataException("Conversation is absent in MAIL_MAIL");
}
var daoChain = daoFactory.CreateChainDao(tenant, user);
var query = SimpleConversationsExp.CreateBuilder(tenant, user)
.SetMailboxId(mailboxId)
.SetChainId(chainId)
.SetFolder((int)folder)
.Build();
var storedChainInfo = daoChain.GetChains(query);
var chainUnreadFlag = storedChainInfo.Any(c => c.Unread);
if (0 == chainInfo.length)
{
var deletQuery = SimpleConversationsExp.CreateBuilder(tenant, user)
.SetFolder((int)folder)
.SetMailboxId(mailboxId)
.SetChainId(chainId)
.Build();
var result = daoChain.Delete(deletQuery);
Log.DebugFormat(
"UpdateChain() row deleted from chain table tenant='{0}', user_id='{1}', id_mailbox='{2}', folder='{3}', chain_id='{4}' result={5}",
tenant, user, mailboxId, folder, chainId, result);
var unreadConvDiff = chainUnreadFlag ? -1 : (int?)null;
engine.FolderEngine.ChangeFolderCounters(daoFactory, folder, userFolderId,
unreadConvDiff: unreadConvDiff, totalConvDiff: -1);
}
else
{
//var updateMailQuery = new SqlUpdate(MailTable.TABLE_NAME)
// .Where(MailTable.Columns.Tenant, tenant)
// .Where(MailTable.Columns.User, user)
// .Where(MailTable.Columns.IsRemoved, 0)
// .Where(MailTable.Columns.ChainId, chainId)
// .Where(MailTable.Columns.MailboxId, mailboxId)
// .Where(MailTable.Columns.Folder, (int) folder)
// // Folder condition important because chain has different dates in different folders(Ex: Sent and Inbox).
// .Set(MailTable.Columns.ChainDate, chainInfo.date);
//db.ExecuteNonQuery(updateMailQuery);
var updateQuery = SimpleMessagesExp.CreateBuilder(tenant, user)
.SetChainId(chainId)
.SetMailboxId(mailboxId)
.SetFolder((int)folder)
.Build();
daoMailInfo.SetFieldValue(updateQuery,
MailTable.Columns.ChainDate,
chainInfo.date);
var tags = GetChainTags(daoFactory, chainId, folder, mailboxId, tenant, user);
var chain = new Chain
{
Id = chainId,
Tenant = tenant,
User = user,
MailboxId = mailboxId,
Folder = folder,
Length = chainInfo.length,
Unread = chainInfo.unread,
HasAttachments = chainInfo.attach_count > 0,
Importance = chainInfo.importance,
Tags = tags
};
var result = daoChain.SaveChain(chain);
if (result <= 0)
{
throw new InvalidOperationException(string.Format("Invalid insert into {0}", ChainTable.TABLE_NAME));
}
Log.DebugFormat(
"UpdateChain() row inserted to chain table tenant='{0}', user_id='{1}', id_mailbox='{2}', folder='{3}', chain_id='{4}'",
tenant, user, mailboxId, folder, chainId);
var unreadConvDiff = (int?)null;
var totalConvDiff = (int?)null;
if (!storedChainInfo.Any())
{
totalConvDiff = 1;
unreadConvDiff = chainInfo.unread ? 1 : (int?)null;
}
else
{
if (chainUnreadFlag != chainInfo.unread)
{
unreadConvDiff = chainInfo.unread ? 1 : -1;
}
}
engine.FolderEngine.ChangeFolderCounters(daoFactory, folder, userFolderId,
unreadConvDiff: unreadConvDiff, totalConvDiff: totalConvDiff);
}
}
