public void SearchSchema_will_return_view_controller_data_object_with_total_pages_if_not_zero_will_return_value_of_total_pages() { //arrange IList <FilterCriteria> filter = null; DataSetSchema schema = null; int currentPage = 0; int pageSize = 10; string orderByColumn = ""; string orderDirection = "DESC"; bool getTotals = false; var ds = new DataSet(); ds.Tables.Add(ReturnDataTable(null, 50)); ds.Tables.Add(new DataTable()); ds.Tables.Add(new DataTable()); var mock = new Mock <IDataSetDetailSqlRepo>(); mock.Setup( x => x.ExecuteQuerySearchSchema(_repositoryDataSetDetail.DbConnectionString, filter, schema, currentPage, pageSize, orderByColumn, orderDirection)).Returns(ds); _sqlRepo = mock.Object; var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter); //act var result = sut.SearchSchema(filter, schema, currentPage, pageSize, orderByColumn, orderDirection, getTotals); //assert Assert.AreEqual(5, result.TotalPages); //cleanup }
public void SearchSchema_when_orderdirection_is_null_empty_will_set_order_direction_to_asc() { //arrange IList <FilterCriteria> filter = null; DataSetSchema schema = null; int currentPage = 0; int pageSize = 10; string orderByColumn = ""; string orderDirection = "ASC"; bool getTotals = false; var mock = new Mock <IDataSetDetailSqlRepo>(); var ds = new DataSet(); ds.Tables.Add(ReturnDataTable(null, 2)); ds.Tables.Add(new DataTable()); ds.Tables.Add(new DataTable()); mock.Setup( x => x.ExecuteQuerySearchSchema(_repositoryDataSetDetail.DbConnectionString, filter, schema, currentPage, pageSize, orderByColumn, orderDirection)).Returns(ds); _sqlRepo = mock.Object; var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter); //act var result = sut.SearchSchema(filter, schema, currentPage, pageSize, orderByColumn, "", getTotals); //assert Assert.AreEqual(2, result.Count); //cleanup }