public static string GetPercentage(UpdateSearch i)
{
var total = i.LogUpdateSteps.Count();
var count = i.LogUpdateSteps.Where(x => x.Progress == "Done" || x.Progress == "Skip").Count();
return(string.Format("{0:0.0%}", (float)count / total));
}
public object Get(UpdateSearch request) => GetSearchResultWithCache <Update, DocEntityUpdate, UpdateSearch>(DocConstantModelName.UPDATE, request, _ExecSearch);
private IQueryable <DocEntityUpdate> _ExecSearch(UpdateSearch request, DocQuery query)
{
request = InitSearch <Update, UpdateSearch>(request);
IQueryable <DocEntityUpdate> entities = null;
query.Run(session =>
{
entities = query.SelectAll <DocEntityUpdate>();
if (!DocTools.IsNullOrEmpty(request.FullTextSearch))
{
var fts = new UpdateFullTextSearch(request);
entities = GetFullTextSearch <DocEntityUpdate, UpdateFullTextSearch>(fts, entities);
}
if (null != request.Ids && request.Ids.Any())
{
entities = entities.Where(en => en.Id.In(request.Ids));
}
if (!DocTools.IsNullOrEmpty(request.Updated))
{
entities = entities.Where(e => null != e.Updated && e.Updated.Value.Date == request.Updated.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedBefore))
{
entities = entities.Where(e => null != e.Updated && e.Updated <= request.UpdatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.UpdatedAfter))
{
entities = entities.Where(e => null != e.Updated && e.Updated >= request.UpdatedAfter);
}
if (!DocTools.IsNullOrEmpty(request.Created))
{
entities = entities.Where(e => null != e.Created && e.Created.Value.Date == request.Created.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.CreatedBefore))
{
entities = entities.Where(e => null != e.Created && e.Created <= request.CreatedBefore);
}
if (!DocTools.IsNullOrEmpty(request.CreatedAfter))
{
entities = entities.Where(e => null != e.Created && e.Created >= request.CreatedAfter);
}
if (true == request.Archived?.Any() && currentUser.HasProperty(DocConstantModelName.UPDATE, nameof(Reference.Archived), DocConstantPermission.VIEW))
{
entities = entities.Where(en => en.Archived.In(request.Archived));
}
else
{
entities = entities.Where(en => !en.Archived);
}
if (true == request.Locked?.Any())
{
entities = entities.Where(en => en.Locked.In(request.Locked));
}
if (!DocTools.IsNullOrEmpty(request.Body))
{
entities = entities.Where(en => en.Body.Contains(request.Body));
}
if (!DocTools.IsNullOrEmpty(request.Bodys))
{
entities = entities.Where(en => en.Body.In(request.Bodys));
}
if (!DocTools.IsNullOrEmpty(request.DeliveryStatus))
{
entities = entities.Where(en => en.DeliveryStatus.Contains(request.DeliveryStatus));
}
if (!DocTools.IsNullOrEmpty(request.DeliveryStatuss))
{
entities = entities.Where(en => en.DeliveryStatus.In(request.DeliveryStatuss));
}
if (request.EmailAttempts.HasValue)
{
entities = entities.Where(en => request.EmailAttempts.Value == en.EmailAttempts);
}
if (!DocTools.IsNullOrEmpty(request.EmailSent))
{
entities = entities.Where(en => null != en.EmailSent && request.EmailSent.Value.Date == en.EmailSent.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.EmailSentBefore))
{
entities = entities.Where(en => en.EmailSent <= request.EmailSentBefore);
}
if (!DocTools.IsNullOrEmpty(request.EmailSentAfter))
{
entities = entities.Where(en => en.EmailSent >= request.EmailSentAfter);
}
if (true == request.EventsIds?.Any())
{
entities = entities.Where(en => en.Events.Any(r => r.Id.In(request.EventsIds)));
}
if (!DocTools.IsNullOrEmpty(request.Link))
{
entities = entities.Where(en => en.Link.Contains(request.Link));
}
if (!DocTools.IsNullOrEmpty(request.Links))
{
entities = entities.Where(en => en.Link.In(request.Links));
}
if (request.Priority.HasValue)
{
entities = entities.Where(en => request.Priority.Value == en.Priority);
}
if (!DocTools.IsNullOrEmpty(request.Read))
{
entities = entities.Where(en => null != en.Read && request.Read.Value.Date == en.Read.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.ReadBefore))
{
entities = entities.Where(en => en.Read <= request.ReadBefore);
}
if (!DocTools.IsNullOrEmpty(request.ReadAfter))
{
entities = entities.Where(en => en.Read >= request.ReadAfter);
}
if (!DocTools.IsNullOrEmpty(request.SlackSent))
{
entities = entities.Where(en => null != en.SlackSent && request.SlackSent.Value.Date == en.SlackSent.Value.Date);
}
if (!DocTools.IsNullOrEmpty(request.SlackSentBefore))
{
entities = entities.Where(en => en.SlackSent <= request.SlackSentBefore);
}
if (!DocTools.IsNullOrEmpty(request.SlackSentAfter))
{
entities = entities.Where(en => en.SlackSent >= request.SlackSentAfter);
}
if (!DocTools.IsNullOrEmpty(request.Subject))
{
entities = entities.Where(en => en.Subject.Contains(request.Subject));
}
if (!DocTools.IsNullOrEmpty(request.Subjects))
{
entities = entities.Where(en => en.Subject.In(request.Subjects));
}
if (!DocTools.IsNullOrEmpty(request.Team) && !DocTools.IsNullOrEmpty(request.Team.Id))
{
entities = entities.Where(en => en.Team.Id == request.Team.Id);
}
if (true == request.TeamIds?.Any())
{
entities = entities.Where(en => en.Team.Id.In(request.TeamIds));
}
if (!DocTools.IsNullOrEmpty(request.User) && !DocTools.IsNullOrEmpty(request.User.Id))
{
entities = entities.Where(en => en.User.Id == request.User.Id);
}
if (true == request.UserIds?.Any())
{
entities = entities.Where(en => en.User.Id.In(request.UserIds));
}
entities = ApplyFilters <DocEntityUpdate, UpdateSearch>(request, entities);
if (request.Skip > 0)
{
entities = entities.Skip(request.Skip.Value);
}
if (request.Take > 0)
{
entities = entities.Take(request.Take.Value);
}
if (true == request?.OrderBy?.Any())
{
entities = entities.OrderBy(request.OrderBy);
}
if (true == request?.OrderByDesc?.Any())
{
entities = entities.OrderByDescending(request.OrderByDesc);
}
});
return(entities);
}
public object Post(UpdateSearch request) => Get(request);
