public void Should_be_able_to_Search_by_SQL()
{
//arrange
var advCrit = new AdvancedSearchCriteria();
var crit = new SearchCriteria();
crit.Compare = ComparisonType.SqlExp;
crit.Value = "Condition = 1";
advCrit.SearchFilter = new List<SearchCriteria> { crit };
advCrit.OrderBy = new List<OrderCriteria>();
var expectedTitle = "The Hobbit";
var expectedRecords = 2;
//act
var books = _repo.Search(advCrit);
var actualTitle = books[0].Title;
var actualRecords = books.Count;
//assert
Assert.AreEqual(expectedRecords, actualRecords);
Assert.AreEqual(expectedTitle, actualTitle);
}
public void Should_be_able_to_Search_and_Sort()
{
//arrange
var advCrit = new AdvancedSearchCriteria();
advCrit.SearchFilter = new List<SearchCriteria>();
advCrit.OrderBy = new List<OrderCriteria> { new OrderCriteria { PropertyName = "Title" } };
advCrit.StartingIndex = 2;
advCrit.TotalRecords = 1;
var expectedTitle = "The Hobbit";
var expectedRecords = 1;
//act
var books = _repo.Search(advCrit);
var actualTitle = books[0].Title;
var actualRecords = books.Count;
//assert
Assert.AreEqual(expectedRecords, actualRecords);
Assert.AreEqual(expectedTitle, actualTitle);
}
public void Should_be_able_to_Search_by_InGuid()
{
//arrange
var advCrit = new AdvancedSearchCriteria();
var crit = new SearchCriteria();
crit.Compare = ComparisonType.InGUID;
crit.PropertyName = "BookGuid";
crit.Value = new List<Guid> { new Guid("11111111-1111-1111-1111-111111111111"), new Guid(), new Guid("33333333-3333-3333-3333-333333333333") };
advCrit.SearchFilter = new List<SearchCriteria> { crit };
advCrit.OrderBy = new List<OrderCriteria>();
var expectedTitle = "The Hobbit";
var expectedRecords = 2;
//act
var books = _repo.Search(advCrit);
var actualTitle = books[0].Title;
var actualRecords = books.Count;
//assert
Assert.AreEqual(expectedRecords, actualRecords);
Assert.AreEqual(expectedTitle, actualTitle);
}
public void Should_be_able_to_Search_by_InInt()
{
//arrange
var advCrit = new AdvancedSearchCriteria();
var crit = new SearchCriteria();
crit.Compare = ComparisonType.InInt;
crit.PropertyName = "Condition";
crit.Value = new List<int> { 2, 3, 4 };
advCrit.SearchFilter = new List<SearchCriteria> { crit };
advCrit.OrderBy = new List<OrderCriteria>();
var expectedTitle = "Fellowship of the Ring";
var expectedRecords = 1;
//act
var books = _repo.Search(advCrit);
var actualTitle = books[0].Title;
var actualRecords = books.Count;
//assert
Assert.AreEqual(expectedRecords, actualRecords);
Assert.AreEqual(expectedTitle, actualTitle);
}
public void Should_be_able_to_Search_by_InString()
{
//arrange
var advCrit = new AdvancedSearchCriteria();
var crit = new SearchCriteria();
crit.Compare = ComparisonType.InString;
crit.PropertyName = "Title";
crit.Value = new List<String> { "The Hobbit", "Starship Troopers", "The Two Towers" };
advCrit.SearchFilter = new List<SearchCriteria> { crit };
advCrit.OrderBy = new List<OrderCriteria>();
var expectedTitle = "The Hobbit";
var expectedRecords = 2;
//act
var books = _repo.Search(advCrit);
var actualTitle = books[0].Title;
var actualRecords = books.Count;
//assert
Assert.AreEqual(expectedRecords, actualRecords);
Assert.AreEqual(expectedTitle, actualTitle);
}
public void Should_be_able_to_Search_by_LikeAnywhere()
{
//arrange
var advCrit = new AdvancedSearchCriteria();
var crit = new SearchCriteria();
crit.Compare = ComparisonType.LikeAnywhere;
crit.PropertyName = "Title";
crit.Value = "The";
advCrit.SearchFilter = new List<SearchCriteria> { crit };
advCrit.OrderBy = new List<OrderCriteria>();
var expectedTitle = "The Hobbit";
var expectedRecords = 4;
//act
var books = _repo.Search(advCrit);
var actualTitle = books[0].Title;
var actualRecords = books.Count;
//assert
Assert.AreEqual(expectedRecords, actualRecords);
Assert.AreEqual(expectedTitle, actualTitle);
}
public void Should_be_able_to_Sort_Descending()
{
//arrange
var advCrit = new AdvancedSearchCriteria();
advCrit.SearchFilter = new List<SearchCriteria>();
advCrit.OrderBy = new List<OrderCriteria> { new OrderCriteria { PropertyName = "Title", Order = OrderType.DESC } };
advCrit.StartingIndex = 0;
advCrit.TotalRecords = 2;
var expectedTitle = "The Two Towers";
var expectedRecords = 2;
//act
var books = _repo.Search(advCrit);
var actualTitle = books[0].Title;
var actualRecords = books.Count;
//assert
Assert.AreEqual(expectedRecords, actualRecords);
Assert.AreEqual(expectedTitle, actualTitle);
}