public void GetByFriendlyUrl_when_schema_is_null_return_empty_list_of_datasetdetail()
        {
            //arrange
            var sut = new DataSetSchemaService(_repositoryDataSetSchema, _dataSetSchemaDefinitionService,
                                               _repositoryDataSetDetail, _sqlTableUtility);
            //act
            var result = sut.GetByFriendlyUrl("categoryurl", "schemaurl", false);

            //assert
            Assert.AreEqual(0, result.Count);
            //cleanup
        }
        public void GetByFriendlyUrl_show_all_is_false_return_only_online_schema_with_datasetdetail_ordered_by_desc_dateupdated()
        {
            //arrange
            var ds1 = new List <DataSetDetail>()
            {
                new DataSetDetail()
                {
                    DateUpdated = new DateTime(2011, 1, 1)
                }
                , new DataSetDetail()
                {
                    DateUpdated = new DateTime(2010, 1, 1)
                }
            };
            var schema1 = new DataSetSchema()
            {
                Category = new Category()
                {
                    Title = "categoryurl", IsDisabled = false
                }, Title = "schemaurl", DataSets = ds1, IsApproved = true
            };
            var ds2     = new List <DataSetDetail>();
            var schema2 = new DataSetSchema()
            {
                Category = new Category()
                {
                    Title = "categoryurl"
                }, Title = "schemaurl", IsDisabled = true, DataSets = ds2
            };

            _repositoryDataSetSchema.Add(schema1);
            _repositoryDataSetSchema.Add(schema2);
            var sut = new DataSetSchemaService(_repositoryDataSetSchema, _dataSetSchemaDefinitionService,
                                               _repositoryDataSetDetail, _sqlTableUtility);
            //act
            var result = sut.GetByFriendlyUrl("categoryurl", "schemaurl", false);

            //assert
            Assert.AreEqual(new DateTime(2011, 1, 1), result[0].DateUpdated);
            //cleanup
            _repositoryDataSetSchema.Delete(schema1);
            _repositoryDataSetSchema.Delete(schema2);
        }
        public void GetByFriendlyUrl_when_schema_datasets_is_null_return_empty_listof_datasetdetail()
        {
            //arrange
            var schema1 = new DataSetSchema()
            {
                Category = new Category()
                {
                    Title = "categoryurl", IsDisabled = false
                }, Title = "schemaurl", IsApproved = true
            };

            _repositoryDataSetSchema.Add(schema1);
            var sut = new DataSetSchemaService(_repositoryDataSetSchema, _dataSetSchemaDefinitionService,
                                               _repositoryDataSetDetail, _sqlTableUtility);
            //act
            var result = sut.GetByFriendlyUrl("categoryurl", "schemaurl", false);

            //assert
            Assert.AreEqual(0, result.Count);
            //cleanup
            _repositoryDataSetSchema.Delete(schema1);
        }
        public void GetByFriendlyUrl_show_all_return_all_datasetdetail_ordered_by_desc_dateupdated()
        {
            //arrange
            //var schema1 = new DataSetSchema() { Category = new Category() { Title = "categoryurl" }, Title = "schemaurl"};
            var ds = new List <DataSetDetail>()
            {
                new DataSetDetail()
                {
                    DateUpdated = new DateTime(1998, 1, 1)
                }
                , new DataSetDetail()
                {
                    DateUpdated = new DateTime(1999, 1, 1)
                }
            };
            var schema2 = new DataSetSchema()
            {
                Category = new Category()
                {
                    Title = "categoryurl"
                }, Title = "schemaurl", IsDisabled = true, DataSets = ds
            };

            //_repositoryDataSetSchema.Add(schema1);
            _repositoryDataSetSchema.Add(schema2);
            var sut = new DataSetSchemaService(_repositoryDataSetSchema, _dataSetSchemaDefinitionService,
                                               _repositoryDataSetDetail, _sqlTableUtility);
            //act
            var result = sut.GetByFriendlyUrl("categoryurl", "schemaurl", true);

            //assert
            Assert.AreEqual(new DateTime(1999, 1, 1), result[0].DateUpdated);
            //cleanup
            //_repositoryDataSetSchema.Delete(schema1);
            _repositoryDataSetSchema.Delete(schema2);
        }