public void Tear_down()
 {
     OrganisationCategoryOrgTypeProviderTypeHandler.DeleteAllRecords();
     OrganisationCategoryHandler.DeleteAllRecords();
     ProviderTypeHandler.DeleteAllRecords();
     OrganisationTypeHandler.DeleteAllRecords();
 }
        public void Before_the_tests()
        {
            _lookupRepository = new LookupDataRepository(_databaseService.WebConfiguration, _cacheHelper);
            _providerTypeId1  = 1;
            _providerTypeId2  = 2;
            _organisationTypeId1WithProviderTypeId1CategoryId1 = 10;
            _organisationTypeId2WithProviderTypeId1CategoryId1 = 20;
            _organisationTypeId3WithProviderTypeId1CategoryId1 = 30;
            _organisationTypeId3WithProviderTypeId2CategoryId1 = 40;
            _organisationTypeId4WithProviderTypeId2            = 100;
            _cacheHelper.PurgeAllCaches();
            _categoryId1 = 1;
            _categoryId2 = 2;

            OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
                Id = _organisationTypeId1WithProviderTypeId1CategoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", Type = "a"
            });
            OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
                Id = _organisationTypeId2WithProviderTypeId1CategoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", Type = "b"
            });
            OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
                Id = _organisationTypeId3WithProviderTypeId1CategoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", Type = "c"
            });
            OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
                Id = _organisationTypeId3WithProviderTypeId2CategoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", Type = "c"
            });
            OrganisationTypeHandler.InsertRecord(new OrganisationTypeModel {
                Id = _organisationTypeId4WithProviderTypeId2, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", Type = "d"
            });
            ProviderTypeHandler.InsertRecord(new ProviderTypeModel {
                Id = _providerTypeId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", ProviderType = "a"
            });
            ProviderTypeHandler.InsertRecord(new ProviderTypeModel {
                Id = _providerTypeId2, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x", ProviderType = "b"
            });
            OrganisationCategoryHandler.InsertRecord(new OrganisationCategoryModel {
                Id = _categoryId1, Category = "category 1", CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x"
            });
            OrganisationCategoryHandler.InsertRecord(new OrganisationCategoryModel {
                Id = _categoryId2, Category = "category 2", CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x"
            });
            OrganisationCategoryOrgTypeProviderTypeHandler.InsertRecord(new OrganisationCategoryOrgTypeProviderTypeModel {
                Id = 1, OrganisationTypeId = _organisationTypeId1WithProviderTypeId1CategoryId1, ProviderTypeId = _providerTypeId1, OrganisationCategoryId = _categoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x"
            });
            OrganisationCategoryOrgTypeProviderTypeHandler.InsertRecord(new OrganisationCategoryOrgTypeProviderTypeModel {
                Id = 2, OrganisationTypeId = _organisationTypeId2WithProviderTypeId1CategoryId1, ProviderTypeId = _providerTypeId1, OrganisationCategoryId = _categoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x"
            });
            OrganisationCategoryOrgTypeProviderTypeHandler.InsertRecord(new OrganisationCategoryOrgTypeProviderTypeModel {
                Id = 3, OrganisationTypeId = _organisationTypeId3WithProviderTypeId1CategoryId1, ProviderTypeId = _providerTypeId1, OrganisationCategoryId = _categoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x"
            });
            OrganisationCategoryOrgTypeProviderTypeHandler.InsertRecord(new OrganisationCategoryOrgTypeProviderTypeModel {
                Id = 4, OrganisationTypeId = _organisationTypeId3WithProviderTypeId2CategoryId1, ProviderTypeId = _providerTypeId2, OrganisationCategoryId = _categoryId1, CreatedAt = DateTime.Now, CreatedBy = "system", Status = "x"
            });
        }