/// <summary>
/// Gets filters for Exchange data query.
/// </summary>
/// <returns>Filter instance.</returns>
private Exchange.SearchFilter.SearchFilterCollection GetItemsSearchFilters()
{
var itemsFilter = new Exchange.SearchFilter.SearchFilterCollection(Exchange.LogicalOperator.And)
{
new Exchange.SearchFilter.IsEqualTo(Exchange.ItemSchema.ItemClass, ExchangeConsts.TaskItemClassName)
};
DateTime lastSyncDateUtc = TimeZoneInfo.ConvertTimeToUtc(UserSettings.LastSyncDate, TimeZone);
DateTime importActivitiesFromDate = UserSettings.ImportActivitiesFrom;
if (UserSettings.ImportActivitiesFrom != DateTime.MinValue)
{
itemsFilter.Add(new Exchange.SearchFilter.IsGreaterThanOrEqualTo(
Exchange.TaskSchema.LastModifiedTime, importActivitiesFromDate));
}
if (UserSettings.LastSyncDate != DateTime.MinValue)
{
var lastSyncDateUtcFilter = new Exchange.SearchFilter.IsGreaterThan(
Exchange.ItemSchema.LastModifiedTime, lastSyncDateUtc.ToLocalTime());
var filterCollection = new Exchange.SearchFilter.SearchFilterCollection(Exchange.LogicalOperator.Or);
var customPropSetFilter = new Exchange.SearchFilter.Exists(ExchangeUtilityImpl.LocalIdProperty);
var notCustomPropSetFilter = new Exchange.SearchFilter.Not(customPropSetFilter);
filterCollection.AddRange(new List <Exchange.SearchFilter> {
lastSyncDateUtcFilter,
notCustomPropSetFilter
});
itemsFilter.Add(filterCollection);
}
return(itemsFilter);
}
/// <summary>
/// <see cref="ExchangeSyncProvider.FillItemsFilterCollection"/>
/// </summary>
protected override void FillItemsFilterCollection()
{
_itemsFilterCollection = new Exchange.SearchFilter.SearchFilterCollection(Exchange.LogicalOperator.And);
var draftFilter = new Exchange.SearchFilter.IsNotEqualTo(Exchange.ItemSchema.IsDraft, true);
_itemsFilterCollection.Add(draftFilter);
if (_userConnection.GetIsFeatureEnabled("SetEmailSynchronizedInExchange"))
{
var customPropSetFilter = new Exchange.SearchFilter.Exists(ExchangeUtilityImpl.LocalIdProperty);
var notCustomPropSetFilter = new Exchange.SearchFilter.Not(customPropSetFilter);
_itemsFilterCollection.Add(notCustomPropSetFilter);
}
DateTime loadEmailsFromDate = LoadEmailsFromDate != DateTime.MinValue
? LoadEmailsFromDate
: UserSettings.LastSyncDate;
LogError($"LoadEmailsFromDate = '{LoadEmailsFromDate}', LastSyncDate = '{UserSettings.LastSyncDate}', result = '{loadEmailsFromDate}'");
if (loadEmailsFromDate != DateTime.MinValue)
{
var localLastSyncDate = GetLastSyncDate(loadEmailsFromDate);
var itemsFilter = new Exchange.SearchFilter.IsGreaterThan(Exchange.ItemSchema.LastModifiedTime,
localLastSyncDate);
_itemsFilterCollection.Add(itemsFilter);
LogError($"LoadEmailsFromDate filter adedd, filter date '{localLastSyncDate}'");
}
}
public List <ExchangeMailFolder> GetMailboxFolders(string mailServerId, string mailboxName,
string mailboxPassword, string senderEmailAddress, string folderClassName)
{
if (string.IsNullOrEmpty(mailboxPassword))
{
mailboxPassword = GetExistingMailboxPassword(senderEmailAddress, UserConnection);
}
var credentials = new Mail.Credentials {
UserName = mailboxName,
UserPassword = mailboxPassword,
ServerId = Guid.Parse(mailServerId),
UseOAuth = GetSettingsHasOauth(senderEmailAddress, UserConnection)
};
SetServerCertificateValidation();
var exchangeUtility = new ExchangeUtilityImpl();
Exchange.ExchangeService service = exchangeUtility.CreateExchangeService(UserConnection, credentials,
senderEmailAddress, true);
var filterCollection = new Exchange.SearchFilter.SearchFilterCollection(Exchange.LogicalOperator.Or);
var filter = new Exchange.SearchFilter.IsEqualTo(Exchange.FolderSchema.FolderClass, folderClassName);
var nullfilter = new Exchange.SearchFilter.Exists(Exchange.FolderSchema.FolderClass);
filterCollection.Add(filter);
filterCollection.Add(new Exchange.SearchFilter.Not(nullfilter));
string[] selectedFolders = null;
var idPropertySet = new Exchange.PropertySet(Exchange.BasePropertySet.IdOnly);
Exchange.Folder draftFolder = null;
if (folderClassName == ExchangeConsts.NoteFolderClassName)
{
Exchange.Folder inboxFolder = Exchange.Folder.Bind(service, Exchange.WellKnownFolderName.Inbox,
idPropertySet);
if (inboxFolder != null)
{
selectedFolders = new[] { inboxFolder.Id.UniqueId };
}
draftFolder = Exchange.Folder.Bind(service, Exchange.WellKnownFolderName.Drafts, idPropertySet);
}
List <ExchangeMailFolder> folders = exchangeUtility.GetHierarhicalFolderList(service,
Exchange.WellKnownFolderName.MsgFolderRoot, filterCollection, selectedFolders);
if (folders != null && folders.Any())
{
folders[0] = new ExchangeMailFolder {
Id = folders[0].Id,
Name = mailboxName,
ParentId = string.Empty,
Path = string.Empty,
Selected = false
};
if (draftFolder != null)
{
folders.Remove(folders.FirstOrDefault(e => e.Path == draftFolder.Id.UniqueId));
}
}
return(folders);
}
/// <summary>
/// Get folder filters.
/// </summary>
/// <returns>Folder filters.</returns>
private Exchange.SearchFilter getFolderFilters()
{
var filterCollection = new Exchange.SearchFilter.SearchFilterCollection(Exchange.LogicalOperator.Or);
var filter = new Exchange.SearchFilter.IsEqualTo(Exchange.FolderSchema.FolderClass, ExchangeConsts.NoteFolderClassName);
var nullfilter = new Exchange.SearchFilter.Exists(Exchange.FolderSchema.FolderClass);
filterCollection.Add(filter);
filterCollection.Add(new Exchange.SearchFilter.Not(nullfilter));
return(filterCollection);
}
/// <summary>
/// Gets filters for Exchange data query.
/// </summary>
/// <returns>Filter instance.</returns>
private Exchange.SearchFilter GetItemsSearchFilters(SyncContext context = null)
{
Exchange.SearchFilter filter = null;
DateTime lastSyncDateUtc = TimeZoneInfo.ConvertTimeToUtc(UserSettings.LastSyncDate, TimeZone);
DateTime importActivitiesFromDate = UserSettings.ImportActivitiesFrom;
context?.LogInfo(SyncAction.None, SyncDirection.Download, "lastSyncDateUtc = {0}, importActivitiesFromDate = {1}",
lastSyncDateUtc, importActivitiesFromDate);
if (lastSyncDateUtc != DateTime.MinValue && UserSettings.ImportActivitiesFrom != DateTime.MinValue)
{
var lastSyncDateUtcFilter = new Exchange.SearchFilter.IsGreaterThan(
Exchange.ItemSchema.LastModifiedTime, lastSyncDateUtc.ToLocalTime());
var filterCollection = new Exchange.SearchFilter.SearchFilterCollection(Exchange.LogicalOperator.Or);
var customPropSetFilter = new Exchange.SearchFilter.Exists(ExchangeUtilityImpl.LocalIdProperty);
var notCustomPropSetFilter = new Exchange.SearchFilter.Not(customPropSetFilter);
filterCollection.AddRange(new List <Exchange.SearchFilter> {
lastSyncDateUtcFilter,
notCustomPropSetFilter
});
if (context != null && GetExchangeRecurringAppointmentsSupported(context.UserConnection))
{
return(filterCollection);
}
var allFilterCollection = new Exchange.SearchFilter.SearchFilterCollection(Exchange.LogicalOperator.And);
var importActivitiesFromDateFilter = new Exchange.SearchFilter.IsGreaterThanOrEqualTo(
Exchange.AppointmentSchema.Start, importActivitiesFromDate);
allFilterCollection.AddRange(new List <Exchange.SearchFilter> {
importActivitiesFromDateFilter,
filterCollection
});
filter = allFilterCollection;
}
else if (lastSyncDateUtc != DateTime.MinValue && UserSettings.ImportActivitiesFrom == DateTime.MinValue)
{
filter = new Exchange.SearchFilter.IsGreaterThan(
Exchange.ItemSchema.LastModifiedTime, lastSyncDateUtc.ToLocalTime());
}
else if (lastSyncDateUtc == DateTime.MinValue && UserSettings.ImportActivitiesFrom != DateTime.MinValue)
{
filter = new Exchange.SearchFilter.IsGreaterThanOrEqualTo(
Exchange.AppointmentSchema.Start, importActivitiesFromDate);
}
return(filter);
}
public Exchange.SearchFilter GetContactsFilters()
{
if (UserSettings.LastSyncDate != DateTime.MinValue)
{
DateTime lastSyncDateUtc =
TimeZoneInfo.ConvertTimeToUtc(UserSettings.LastSyncDate, TimeZone);
var lastSyncDateUtcFilter = new Exchange.SearchFilter.IsGreaterThan(
Exchange.ItemSchema.LastModifiedTime, lastSyncDateUtc.ToLocalTime());
var filterCollection = new Exchange.SearchFilter.SearchFilterCollection(Exchange.LogicalOperator.Or);
var customPropSetFilter = new Exchange.SearchFilter.Exists(ExchangeUtilityImpl.LocalIdProperty);
var notCustomPropSetFilter = new Exchange.SearchFilter.Not(customPropSetFilter);
filterCollection.AddRange(new List <Exchange.SearchFilter> {
lastSyncDateUtcFilter,
notCustomPropSetFilter
});
return(filterCollection);
}
return(null);
}
