public void can_compare_model_and_entity() { ISingleCriterionBuilder<TestSearchModel, IMakesSound> criteria = new ListPropertyCriteria<TestSearchModel,IMakesSound> ( x => x.Says ); var model = new TestSearchModel { Says = new List<string> { new Cat().Says, new Person().Says } }; var list = new List<IMakesSound> { new Person (), new Dog (), new Cat () }; Assert.That ( criteria.CanProvideExpression (model)); var expr = criteria.GetPredicateExpression (model).Compile (); var filtered = list.Where(expr).ToList (); Assert.That(filtered.Count, Is.EqualTo(2)); Assert.That(filtered.Count(x => x is Dog), Is.EqualTo(0)); }
public PagedList <TestModel> GetListModel(TestSearchModel searchModel) { string sqlCount = @" SELECT count(1) FROM dbo.WmsRole (NOLOCK) WHERE 1 = 1 {0} "; string sqlPage = @" SELECT RoleNo , RoleName , RoleDescription , Status FROM dbo.WmsRole (NOLOCK) WHERE 1 = 1 {0} "; List <SqlParameter> parameterList = new List <SqlParameter>(); StringBuilder sbWhere = new StringBuilder(); SqlStringHelper.CreateSqlWhereAndPara(searchModel.RoleNo, SqlDbType.VarChar, "RoleNo", "RoleNo", ref sbWhere, ref parameterList); SqlStringHelper.CreateSqlWhereAndPara(searchModel.RoleName, SqlDbType.VarChar, "RoleName", "RoleName", ref sbWhere, ref parameterList); sqlPage = string.Format(sqlPage, sbWhere); sqlCount = string.Format(sqlCount, sbWhere); return(ExecPageSplit <TestModel>(sqlCount, sqlPage, "RoleName", searchModel, false, parameterList)); }
public async Task WhenSearchingByMultipleProperties_ThenObjectsAreFound_Test() { ///Arrange var item = new TestObject { Collection = new List <string> { "TestVal1", "TestVal2" }, Number = 7, Prop1 = "SomethingIShouldBeAbleToFind", ChildObject = new TestObject { Number = 8, Prop1 = "ChildObject" } }; var searchModel = new TestSearchModel { Num = 7, StrVal = item.Prop1 }; //Act var result = await _testRepo.Upsert(item); var resp = await _testRepo.Get(searchModel); //Assert resp.TotalResults.Should().BeGreaterThan(0); }
// // GET: /Test/Test/ public ActionResult Index() { ITestBLL bll = ServiceLocator.GetService <ITestBLL>(); TestSearchModel searchModel = new TestSearchModel(); var test = bll.GetModel(searchModel); return(View(test[0])); }
public async Task WhenSearchingByStringContains_ThenResultsAreReturned_Test() { //Arrange var item = new TestObject { Collection = new List <string> { "TestVal1", "TestVal2" }, Number = 5, Prop1 = "TestingString", ChildObject = new TestObject { Number = 8, Prop1 = "ChildTestObject" } }; var item2 = new TestObject { Collection = new List <string> { "TestVal3", "TestVal4" }, Number = 5, Prop1 = "TestingString", ChildObject = new TestObject { Number = 8, Prop1 = "ChildObject" } }; var searchModel = new TestSearchModel { ContainsStrTest = "Test" }; //Act try { var result = await _testRepo.Upsert(item); var result2 = await _testRepo.Upsert(item2); var searchResults = await _testRepo.Get(searchModel); //Assert searchResults.TotalResults.Should().BeGreaterOrEqualTo(1); } catch (Exception e) { var message = e.Message; } }
public JsonResult List(TestSearchModel param) { this.InicializaDados(); list = repo.List(param); ret.returns = list; return(Json(ret)); }
public async Task WhenGetDocumentsWithSearchModel_AndSearchingByAnArray_ThenItemIsReturned_Test() { //Arrange var item = new TestObject { Collection = new List <string> { "TestVal1", "TestVal2" }, Number = 5, Prop1 = "TestingString", ChildObject = new TestObject { Number = 8, Prop1 = "ChildObject" } }; var item2 = new TestObject { Collection = new List <string> { "TestVal3", "TestVal4" }, Number = 5, Prop1 = "TestingString", ChildObject = new TestObject { Number = 8, Prop1 = "ChildObject" } }; var searchModel = new TestSearchModel { CollectionValues = new List <string> { "TestVal3" } }; //Act var result = await _testRepo.Upsert(item); var result2 = await _testRepo.Upsert(item2); var searchResults = await _testRepo.Get(searchModel); //Assert searchResults.TotalResults.Should().BeGreaterThan(0); }
public async Task WhenSearchByPredicate_ThenResultsAreReturned_Test() { //Arrange var item = new TestObject { Collection = new List <string> { "TestVal1", "TestVal2" }, Number = 15, Prop1 = "TestingString", ChildObject = new TestObject { Number = 8, Prop1 = "ChildTestObject" } }; var item2 = new TestObject { Collection = new List <string> { "TestVal3", "TestVal4" }, Number = 5, Prop1 = "TestingString", ChildObject = new TestObject { Number = 8, Prop1 = "ChildObject" } }; var searchModel = new TestSearchModel { ContainsStrTest = "Test" }; //Act var result = await _testRepo.Upsert(item); var result2 = await _testRepo.Upsert(item2); var results = await _testRepo.Get(x => x.Number == 15 && x.Prop1 == "TestingString", new SearchModel()); //Assert results.TotalResults.Should().BeGreaterOrEqualTo(1); }
public IActionResult Search([FromBody] TestSearchModel model) { Guard.AgainstNull(model, nameof(model)); using (_databaseContextFactory.Create()) { return(Ok(new { Data = _dataRowMapper.MapObjects <TestModel>( _testQuery.Search(model.Specification())) })); } }
public async Task WhenSearchingByNumericProperty_ThenItemsAreFound_Test() { //Arrange var item = new TestObject { Collection = new List <string> { "TestVal1", "TestVal2" }, Number = 5, Prop1 = "TestingString", ChildObject = new TestObject { Number = 8, Prop1 = "ChildObject" } }; var item2 = new TestObject { Collection = new List <string> { "TestVal3", "TestVal4" }, Number = 5, Prop1 = "TestingString", ChildObject = new TestObject { Number = 8, Prop1 = "ChildObject" } }; var searchModel = new TestSearchModel { Num = 5 }; //Act var result = await _testRepo.Upsert(item); var result2 = await _testRepo.Upsert(item2); var searchResults = await _testRepo.Get(searchModel); //Assert searchResults.TotalResults.Should().BeGreaterThan(0); }
public void can_compare_model_and_entity() { ISingleCriterionBuilder<TestSearchModel, Person> criteria = new SinglePropertyCriteria<TestSearchModel, Person>(x => x.Name); var model = new TestSearchModel { Name = "Matt" }; var list = new List<Person> { new Person { Name = "Matt" }, new Person { Name = "Meredith" } }; var expr = criteria.GetPredicateExpression(model).Compile(); var filtered = list.Where(expr).ToList(); Assert.That(1, Is.EqualTo(filtered.Count)); Assert.That("Matt", Is.EqualTo(filtered.FirstOrDefault().Name)); }
public void GetModelTest() { try { ITestBLL bll = ServiceLocator.GetService <ITestBLL>(); TestSearchModel searchModel = new TestSearchModel(); var test = bll.GetModel(searchModel); foreach (var t in test) { } //Assert.Fail(); } catch (Exception ex) { throw new Exception(ex.Message); } }
public ActionResult TestList() { this.SetSearchListAjaxOptions(); TestSearchModel searchModel = new TestSearchModel(); int pageSize = Convert.ToInt32(Request["PageSize"] ?? "10"); int pageIndex = Convert.ToInt32(Request["page"] ?? "1"); searchModel.CurrentPageIndex = pageIndex; searchModel.PageSize = pageSize; if (!string.IsNullOrWhiteSpace(Request["RoleName"])) { searchModel.RoleName = Request["RoleName"]; } //else //{ // List<TestModel> bm = new List<TestModel>(); // PagedList<TestModel> l = new PagedList<TestModel>(bm, 0, 0); // if (Request.IsAjaxRequest()) // { // return PartialView("_PartialTestList", l); // } // return View(l); //} searchModel.Trim(); ITestBLL bll = ServiceLocator.GetService <ITestBLL>(); var pagelist = bll.GetListModel(searchModel); if (Request.IsAjaxRequest()) { return(PartialView("_PartialTestList", pagelist)); } return(View(pagelist)); }
public JsonResult Get(string id) { this.InicializaDados(); TestDataModel obj = null; TestSearchModel param = new TestSearchModel() { pID = id }; obj = repo.Get(param); if (obj == null) { ret.SetFailStatus("Item não encontrado."); } else { ret.returns = obj; } return(Json(ret, JsonRequestBehavior.AllowGet)); }
public PagedList <TestModel> GetListModel(TestSearchModel searchModel) { return(_testDal.GetListModel(searchModel)); }