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));
}
