public void Search_when_todate_is_not_null_and_date_is_more_than_min_datevalue_returns_datasetdetail_with_correct_filtered_smaller_than_todate_list_of_DataSetDetail()
{
//arrange
string to = "01/01/2010";// new DateTime(2010, 1, 1);
string from = null;
var searchText = "dstitle";
int schemaId = 0;
var schema = new DataSetSchema()
{
Title = "dstitle", Id = 0
};
var dsd1 = new DataSetDetail()
{
DateUpdated = new DateTime(2010, 11, 1), Schema = schema
};
var dsd2 = new DataSetDetail()
{
DateUpdated = new DateTime(2009, 12, 2), Schema = schema
};
_repositoryDataSetDetail.Add(dsd1);
_repositoryDataSetDetail.Add(dsd2);
var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter);
//act
var result = sut.Search(schemaId, searchText, from, to);
//assert
Assert.AreEqual(new DateTime(2009, 12, 2), result[0].DateUpdated);
//cleanup
_repositoryDataSetDetail.Delete(dsd1);
_repositoryDataSetDetail.Delete(dsd2);
}
public void Search_when_fromdate_and_todate_isemptyString_returns_all_datasetdetail()
{
//arrange
var searchText = "dstitle";
int schemaId = 0;
var schema = new DataSetSchema()
{
Title = "dstitle", Id = 0
};
var dsd1 = new DataSetDetail()
{
DateUpdated = new DateTime(2010, 11, 1), Schema = schema
};
var dsd2 = new DataSetDetail()
{
DateUpdated = new DateTime(2009, 12, 2), Schema = schema
};
_repositoryDataSetDetail.Add(dsd1);
_repositoryDataSetDetail.Add(dsd2);
var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter);
//act
var result = sut.Search(schemaId, searchText, "", "");
//assert
Assert.AreEqual(2, result.Count);
//cleanup
_repositoryDataSetDetail.Delete(dsd1);
_repositoryDataSetDetail.Delete(dsd2);
}
public void Search_returns_type_of_ListDataSetDetail()
{
//arrange
string to = null;
string from = null;
var searchText = "";
int schemaId = 0;
var mock = new Mock <IRepository <DataSetDetail> >();
_repositoryDataSetDetail = mock.Object;
var sut = new DataSetDetailService(_systemConfigurationService, _repositoryDataSetDetail, _dataSetSchemaService, _sqlRepo, _sqlColumnTextFormatter);
//act
var result = sut.Search(schemaId, searchText, from, to);
//assert
Assert.AreEqual(typeof(List <DataSetDetail>), result.GetType());
//cleanup
}
