public Task Execute()
{
using (ClientDbContext context = new ClientDbContext(
_connection.NameOrConnectionString, _connection.Prefix))
{
context.Database.Delete();
}
return Task.FromResult(true);
}
//методы
public IQueryable<Subscriber<Guid>> CreateQuery(SubscribtionParameters parameters
, UsersRangeParameters<Guid> usersRange, ClientDbContext context)
{
if(usersRange.UserIDRangeFromExcludingSelf != null
|| usersRange.UserIDRangeToIncludingSelf != null)
{
throw new NotImplementedException("Not supported for SQL DAL");
}
IQueryable<UserDeliveryTypeSettings<Guid>> typeQueryPart =
CreateDeliveryTypeQueryPart(parameters, usersRange, context);
if (parameters.SelectFromCategories)
{
IQueryable<UserCategorySettings<Guid>> categoryQueryPart = CreateCategoryQueryPart(parameters, context);
typeQueryPart = JoinWithCategories(parameters, typeQueryPart, categoryQueryPart);
}
if (parameters.SelectFromTopics)
{
IQueryable<UserTopicSettings<Guid>> topicQueryPart = CreateTopicQueryPart(parameters, context);
typeQueryPart = JoinWithTopics(parameters, typeQueryPart, topicQueryPart);
}
IQueryable<Subscriber<Guid>> subscribers = typeQueryPart.Select(d => new Subscriber<Guid>
{
UserID = d.UserID,
DeliveryType = d.DeliveryType,
Address = d.Address,
TimeZoneID = d.TimeZoneID,
Language = d.Language
});
if(usersRange.Limit != null)
{
subscribers = subscribers.Take(usersRange.Limit.Value);
}
return subscribers;
}
//DeliveryType
protected virtual IQueryable<UserDeliveryTypeSettings<Guid>> CreateDeliveryTypeQueryPart(
SubscribtionParameters parameters, UsersRangeParameters<Guid> usersRange, ClientDbContext context)
{
IQueryable<UserDeliveryTypeSettings<Guid>> query = context.UserDeliveryTypeSettings
.Where(p => p.Address != null);
if (parameters.DeliveryType != null)
{
query = query.Where(p => p.DeliveryType == parameters.DeliveryType.Value);
}
if (parameters.CheckBlockedOfNDR)
{
query = query.Where(p => p.IsBlockedOfNDR == false);
}
if (parameters.CheckDeliveryTypeEnabled)
{
query = query.Where(p => p.IsEnabled == true);
}
if (parameters.CheckDeliveryTypeLastSendDate)
{
query = query.Where(p => p.LastSendDateUtc == null ||
p.LastSendDateUtc < p.LastUserVisitUtc);
}
if (parameters.CheckDeliveryTypeSendCountNotGreater != null)
{
int sendCountLimitValue = parameters.CheckDeliveryTypeSendCountNotGreater.Value;
query = query.Where(p => p.SendCount <= sendCountLimitValue);
}
if (usersRange.FromUserIDs != null)
{
query = query.Where(p => usersRange.FromUserIDs.Contains(p.UserID));
}
return query;
}
//Topic
protected virtual IQueryable<UserTopicSettings<Guid>> CreateTopicQueryPart(
SubscribtionParameters parameters, ClientDbContext context)
{
IQueryable<UserTopicSettings<Guid>> query = context.UserTopicSettings;
query = query.Where(p => p.IsDeleted == false);
if (parameters.CheckTopicEnabled)
{
query = query.Where(p => p.IsEnabled == true);
}
if (parameters.CheckTopicSendCountNotGreater != null)
{
int sendCountLimitValue = parameters.CheckTopicSendCountNotGreater.Value;
query = query.Where(p => p.SendCount <= sendCountLimitValue);
}
return query;
}
