public void Negate_criterion_query() { var criterion = Criterions.Not(Criterions.Equals("Alexey")); var builder = new QueryBuilder(Criterions.Field <Person, string>(x => x.Name.Firstname, criterion)); AssertFoundPutin(builder); }
private void CreateCriterionMatrix(object sender, EventArgs e) { CriterionMatrixs.Children.Clear(); if (Criterions.Count == 0) { return; } var tmp = new ObservableCollection <DoubleContainer>(); Criterions.ToList().ForEach(x => tmp.Add(new DoubleContainer() { Value = 1 })); CriterionRatios = tmp; DataGrid dataGrid = GetDG(); dataGrid.ItemsSource = CriterionRatios; dataGrid.LoadingRow += DataGrid_LoadingRow1; dataGrid.AutoGeneratingColumn += DataGrid_AutoGeneratingColumn1; CriterionMatrixs.Children.Add(dataGrid); }
private JsonResponse CheckLogin() { if (Request.Query.ContainsKey("Login")) { return(new JsonResponse(true, new DefaultJsonSerializer())); } string login = Request.Query.Login; var byName = Criterions.Field <User, string>(x => x.Login, Criterions.Equals(login)); var builder = new QueryBuilder(byName); using (var query = _users.CreateQuery <User>(builder)) using (var cursor = query.Execute(QueryMode.Count)) { if (cursor.Count > 0) { var message = string.Format("Login '{0}' already exists", login); return(new JsonResponse(message, new DefaultJsonSerializer())); } } return(new JsonResponse(true, new DefaultJsonSerializer())); }
public void Starts_with_criterion_query() { var criterion = Criterions.StartsWith("Ale"); var builder = new QueryBuilder(Criterions.Field <Person, string>(x => x.Name.Firstname, criterion)); AssertFoundNavalny(builder); }
public void Greater_than_query() { var criterion = Criterions.GreaterThan(40); var builder = new QueryBuilder(Criterions.Field <Person, int>(x => x.Age, criterion)); AssertFoundPutin(builder); }
public void Lower_than_or_equal_query() { var criterion = Criterions.LowerThanOrEqual(36); var builder = new QueryBuilder(Criterions.Field <Person, int>(x => x.Age, criterion)); AssertFoundNavalny(builder); }
public void Not_in_criterion_query() { var criterion = Criterions.Field <Person, int>(x => x.Age, Criterions.NotIn(36, 52)); var builder = new QueryBuilder(criterion); AssertFoundPutin(builder); }
public void In_criterion_query() { var criterion = Criterions.Field <Person, int>(x => x.Age, Criterions.In(36, 52)); var builder = new QueryBuilder(criterion); AssertFoundNavalny(builder); }
public void String_all_query() { var criterion = Criterions.All("Patriotic", "speech"); var builder = new QueryBuilder(Criterions.Field <Person, string[]>(x => x.Hobbies, criterion)); AssertFoundPutin(builder); }
public void Match_criterion_query() { var criterion = Criterions.Equals("Alexey"); var builder = new QueryBuilder(Criterions.Field <Person, string>(x => x.Name.Firstname, criterion)); AssertFoundNavalny(builder); }
public void String_ignore_case_query() { var criterion = Criterions.IgnoreCase(Criterions.Any("PUTIN")); var builder = new QueryBuilder(Criterions.Field <Person, string>(x => x.Name.Surname, criterion)); AssertFoundPutin(builder); }
public void String_any_with_ignore_case_query() { var criterion = Criterions.IgnoreCase(Criterions.Any("patriotic")); var builder = new QueryBuilder(Criterions.Field <Person, string[]>(x => x.Hobbies, criterion)); AssertFoundPutin(builder); }
public void Between_query() { var criterion = Criterions.Between(30, 40); var builder = new QueryBuilder(Criterions.Field <Person, int>(x => x.Age, criterion)); AssertFoundNavalny(builder); }
private void Button_Click(object sender, RoutedEventArgs e) { var criterions = Criterions.Select(x => x.Value).ToList(); var objects = Objects.Select(x => x.Value).ToList(); var objectRatios = ObjectRatios.Select(x => x.Select(y => y.Value).ToList()).ToList(); var criterionRatios = CriterionRatios.Select(x => x.Value).ToList(); new ResultWindow(criterions, objects, objectRatios, criterionRatios, IsEquilibriumCheckBox.IsChecked ?? true).Show(); }
private void CleanCriterions() { for (int i = 0; i < Criterions.Count; i++) { if (String.IsNullOrWhiteSpace(Criterions[i].Name)) { Criterions.Remove(Criterions[i]); } } }
private static bool ThereIsNoDomainUsers(Collection users) { var byDomain = Criterions.Field <User, bool>(x => x.IsDomain, Criterions.Equals(true)); var queryBuilder = new QueryBuilder(byDomain); using (var query = users.CreateQuery <User>(queryBuilder)) using (var cursor = query.Execute(QueryMode.Count)) { return(cursor.Count == 0); } }
public void Element_match_criterion_simple_array_query() { var criterion = Criterions.Field <Person, string[]>( x => x.Hobbies, Criterions.MatchElement( Criterions.Equals("Power"))); var builder = new QueryBuilder(criterion); AssertFoundPutin(builder); }
public ServicesDecisionHendler(MusicalShopIdentityDbContext ctx) { _ctx = ctx; foreach (var enumcrit in Enum.GetValues(typeof(CriterionsEnum))) { Criterions.Add(new Criterion() { Name = enumcrit.ToString(), IsMax = (int)enumcrit > 0 ? true : false, Id = (int)enumcrit }); } }
public void And_criterion_query() { var byName = Criterions.Field <Person, string>(x => x.Name.Firstname, Criterions.Equals("Alexey")); var byAge = Criterions.Field <Person, int>(x => x.Age, Criterions.Equals(36)); var andCritertion = Criterions.And(byName, byAge); var builder = new QueryBuilder(andCritertion); AssertFoundNavalny(builder); }
private static User GetExistingUser(Collection users, string username) { var byLogin = Criterions.Field <User, string>(x => x.Login, Criterions.Equals(username)); var queryBuilder = new QueryBuilder(byLogin); using (var query = users.CreateQuery <User>(queryBuilder)) using (var cursor = query.Execute()) { return(cursor.Count != 0 ? cursor[0] : null); } }
public void Or_criterion_query() { var byName = Criterions.Field <Person, string>(x => x.Name.Firstname, Criterions.Equals("Alexey")); var byAge = Criterions.Field <Person, int>(x => x.Age, Criterions.Equals(61)); var criterion = Criterions.Or(byName, byAge); var builder = new QueryBuilder(criterion); AssertFoundBoth(builder); }
public void Not_exists_criterion_query() { var criterion = Criterions.FieldNotExists(); var builder = new QueryBuilder(Criterions.Field <Person, string>(x => x.Name.Firstname, criterion)); using (var query = Collection.CreateQuery <Person>(builder)) using (var cursor = query.Execute(QueryMode.Explain)) { Console.WriteLine(cursor.GetLog()); Assert.That(cursor.Count, Is.EqualTo(0)); } }
public void Element_match_criterion_complex_property_query() { var criterion = Criterions.Field <Person, Name>( x => x.Name, Criterions.MatchElement( Criterions.Object( Criterions.Field <Name, string>(x => x.Firstname, Criterions.Equals("Vladimir")), Criterions.Field <Name, string>(x => x.Surname, Criterions.Equals("Putin"))) )); var builder = new QueryBuilder(criterion); AssertFoundPutin(builder); }
public virtual IQuery Add(ICriterion criterion) { if (criterion != null) { if (!CheckValidCriterion(EntityDefinition, criterion.PropertyName)) { throw new QueryException(this, $"Unable to filter by {criterion.PropertyName} because {criterion.PropertyName} is not a valid property of {EntityDefinition} or it includes a relation."); } criterion.PropertyName = criterion.PropertyName; Criterions.Add(criterion); } return(this); }
public DeleteFeedResponse Handle(DeleteFeedRequest message) { var criterion = Criterions.Field(nameof(Domain.Deployment.FeedId), Criterions.Equals(message.Id)); var builder = new QueryBuilder(criterion); var feedInUse = _repository.Deployments.PerformQuery <Domain.Deployment>(builder).Length > 0; if (feedInUse) { return(new DeleteFeedResponse("Feed use. Remove it from deployments to delete")); } _repository.Feeds.Delete(message.Id); return(new DeleteFeedResponse(null)); }
/// <inheritdoc /> public virtual TQuery Where(params ICriterion[] criterions) { if (criterions == null) { throw new ArgumentNullException("criterions"); } foreach (ICriterion criterion in criterions.Where(x => x != null)) { Criterions.Add(criterion); } return(Query); }
public void Complex_criterion_combination_query() { var byName = Criterions.Field <Person, string>(x => x.Name.Firstname, Criterions.Equals("Alexey")); var byAge = Criterions.Field <Person, int>(x => x.Age, Criterions.Equals(36)); var andCriterion = Criterions.And(byName, byAge); var ignoreCaseHobby = Criterions.IgnoreCase(Criterions.Any("corruption")); var byHobbies = Criterions.Field <Person, string[]>(x => x.Hobbies, ignoreCaseHobby); var criterion = Criterions.Or(andCriterion, byHobbies); var builder = new QueryBuilder(criterion); AssertFoundBoth(builder); }
public HomepageModelResponse Handle(HomepageModelRequest message) { var notifications = _repository.Notifications; var now = DateTime.UtcNow; var thirtyDaysAgo = now.AddDays(-30); var greaterThan = Criterions.GreaterThanOrEqual(thirtyDaysAgo); var criterion = Criterions.Field(nameof(Notification.CreatedAt), greaterThan); var builder = new QueryBuilder(criterion); var last30Days = notifications .PerformQuery <Notification>(builder) .ToList(); //Sort in descending order last30Days.Sort((x, y) => y.CreatedAt.CompareTo(x.CreatedAt)); var model = new HomepageModel(last30Days); return(new HomepageModelResponse(model)); }
private void DataGrid_AutoGeneratingColumn1(object sender, DataGridAutoGeneratingColumnEventArgs e) { e.Column.Header = Criterions?.FirstOrDefault()?.Value; }
public IAuditQuery Add(IAuditCriterion criterion) { Criterions.Add(criterion); return(this); }