public void FindByZipcodeTest()
{
var instancePath = "xunit_tests/tax-stamper/TaxRatesRepoUSA";
var logger = GetLogger(instancePath, "FindByZipcodeTest");
ITaxRatesRepositoryUSA repository = new SqliteTaxRatesRepositoryUSA(logger, "FindByZipcode_TaxRateRepo", instancePath);
var record = new TaxRateUSA()
{
Zipcode = 68136
, ZipPlus4StartRange = 0
, ZipPlus4EndRange = 9999
, EffectiveDate = new DateTime(1960, 2, 10)
, TaxRateState = 0.07
, TaxRateCounty = 0.05
, TaxRateCity = 0.03
, TaxRateLocal1 = 0.02
, TaxRateLocal2 = 0.01
};
// create record
long id = repository.Create(record);
Assert.True(id > 0);
// fetch record
var fetchedRecord = repository.FetchByZipcode(68136, 1000, new DateTime(1960, 2, 20));
Assert.Equal(id, fetchedRecord.Id);
// fetch record
var fetchNullRecord = repository.FetchByZipcode(68136, 1000, new DateTime(1960, 1, 20));
Assert.Null(fetchNullRecord);
}
public void CreateFetchUpdateDeleteTest()
{
var instancePath = "xunit_tests/tax-stamper/TaxRatesRepoUSA";
var logger = GetLogger(instancePath, "CreateFetchUpdateDeleteTest");
ITaxRatesRepositoryUSA repository = new SqliteTaxRatesRepositoryUSA(logger, "CFUD_TaxRateRepo", instancePath);
var record = new TaxRateUSA()
{
Zipcode = 68136
, ZipPlus4StartRange = 0
, ZipPlus4EndRange = 9999
, EffectiveDate = new DateTime(1941, 1, 1)
, TaxRateState = 0.07
, TaxRateCounty = 0.05
, TaxRateCity = 0.03
, TaxRateLocal1 = 0.02
, TaxRateLocal2 = 0.01
};
// create record
long id = repository.Create(record);
Assert.True(id > 0);
// fetch record
var fetchedRecord = repository.FetchById(id);
Assert.Equal(id, fetchedRecord.Id);
// update object
fetchedRecord.TaxRateState = 0.077;
fetchedRecord.TaxRateCounty = 0.055;
// update record
var updatedRecords = repository.Update(fetchedRecord);
Assert.Equal(1, updatedRecords);
// confirm update
var updatedRecord = repository.FetchById(id);
Assert.Equal(fetchedRecord.TaxRateState, updatedRecord.TaxRateState);
Assert.Equal(fetchedRecord.TaxRateCounty, updatedRecord.TaxRateCounty);
// delete record
var deletedRecords = repository.Delete(updatedRecord);
Assert.Equal(1, deletedRecords);
// confirm deletion
var deletedRecord = repository.FetchById(id);
Assert.Null(deletedRecord);
}
private ITaxRatesRepositoryUSA GetSalesTaxRatesRepositoryUSA(ILogger logger, string name, string instancePath)
{
ITaxRatesRepositoryUSA repository = new SqliteTaxRatesRepositoryUSA(logger, name, instancePath);
var record = new TaxRateUSA()
{
Zipcode = 68136
, ZipPlus4StartRange = 0
, ZipPlus4EndRange = 9999
, EffectiveDate = new DateTime(1941, 1, 1)
, TaxRateState = 0.08
, TaxRateCounty = 0.06
, TaxRateCity = 0.04
, TaxRateLocal1 = 0.03
, TaxRateLocal2 = 0.02
};
repository.Create(record);
return(repository);
}
public void CreateTest()
{
var instancePath = "xunit_tests/tax-stamper/TaxRatesRepoUSA";
var logger = GetLogger(instancePath, "CreateTest");
ITaxRatesRepositoryUSA repository = new SqliteTaxRatesRepositoryUSA(logger, "CreateTest_TaxRateRepo", instancePath);
var record = new TaxRateUSA()
{
Zipcode = 68136
, ZipPlus4StartRange = 0
, ZipPlus4EndRange = 9999
, EffectiveDate = new DateTime(1941, 1, 1)
, TaxRateState = 0.07
, TaxRateCounty = 0.05
, TaxRateCity = 0.03
, TaxRateLocal1 = 0.02
, TaxRateLocal2 = 0.01
};
long id = repository.Create(record);
Assert.True(id > 0);
}
private ITaxRatesRepositoryUSA GetSalesTaxRatesRepositoryUSA(ILogger logger, string name, string instancePath)
{
ITaxRatesRepositoryUSA repository = new SqliteTaxRatesRepositoryUSA(logger, name, instancePath);
return(repository);
}
