private void SetInvalidBulkEmailCounters(Guid bulkEmailId, int invalidAddresseeCount)
{
var actualInvalidAdresseeExpression =
MailingDbUtilities.GetAddCountColumnExpression("InvalidAddresseeCount", invalidAddresseeCount);
BulkEmailQueryHelper.UpdateBulkEmail(bulkEmailId, UserConnection,
new KeyValuePair <string, object>("SendDueDate", Column.Const(null)),
new KeyValuePair <string, object>("InvalidAddresseeCount", actualInvalidAdresseeExpression));
}
/// <summary>
/// Updates StartDate, SendStartDate, SendDueDate, RecipientCount and CommonError count columns.
/// </summary>
/// <param name="userConnection">User connection instance.</param>
/// <param name="isError">Indicates whether there is sending error.</param>
public void UpdateMessageInfo(UserConnection userConnection, bool isError = false)
{
int count = Recipients.Count();
var update = new Update(userConnection, "BulkEmail")
.Set("StartDate", Column.Parameter(SendDate))
.Set("SendStartDate", Column.Parameter(SendDate))
.Set("SendDueDate", Column.Parameter(SendDate))
.Set("RecipientCount", QueryColumnExpression.Add(new QueryColumnExpression("RecipientCount"),
Column.Parameter(count)));
if (isError)
{
update.Set("CommonErrorCount", QueryColumnExpression.Add(new QueryColumnExpression("CommonErrorCount"),
Column.Parameter(count)));
}
else
{
QueryColumnExpression actualSentExpression
= MailingDbUtilities.GetAddCountColumnExpression("SendCount", count);
update.Set("SendCount", actualSentExpression);
}
update.Where("Id").IsEqual(Column.Parameter(MessageId));
(update as Update).Execute();
}