public void ShouldBeAbleToReadAddressFiles()
{
this.mainfileBuilder.AddFile(string.Empty, ExamplePafFileData.MainAddress);
Mainfile mainfile = this.mainfileBuilder.Create();
using (IDataReader reader = mainfile.CreateReader(MainfileType.Address))
{
Assert.That(reader.Read(), Is.True);
Assert.That(reader["Key"], Is.EqualTo(2572775));
Assert.That(reader["Postcode"], Is.EqualTo("CF30AA"));
Assert.That(reader["LocalityKey"], Is.EqualTo(24904));
Assert.That(reader["ThoroughfareKey"], Is.EqualTo(21479));
Assert.That(reader["ThoroughfareDescriptorKey"], Is.EqualTo(6));
Assert.That(reader["DependentThoroughfareKey"], Is.EqualTo(DBNull.Value));
Assert.That(reader["DependentThoroughfareDescriptorKey"], Is.EqualTo(DBNull.Value));
Assert.That(reader["BuildingNumber"], Is.EqualTo(1));
Assert.That(reader["BuildingNameKey"], Is.EqualTo(DBNull.Value));
Assert.That(reader["SubBuildingNameKey"], Is.EqualTo(DBNull.Value));
Assert.That(reader["NumberOfHouseholds"], Is.EqualTo(1));
Assert.That(reader["OrganisationKey"], Is.EqualTo(DBNull.Value));
Assert.That(reader["PostcodeType"], Is.EqualTo((int)DeliveryPointType.SmallUser));
Assert.That(reader["IsBuildingNumberConcatenated"], Is.False);
Assert.That(reader["DeliveryPointSuffix"], Is.EqualTo("1A"));
Assert.That(reader["IsSmallUserOrganisation"], Is.False);
Assert.That(reader.IsDBNull(reader.GetOrdinal("POBoxNumber")), Is.True);
Assert.That(reader.Read(), Is.False);
}
}
private Task SaveThoroughfares(Mainfile data)
{
TableInformation info = new TableInformation
{
ColumnMappings = DefaultMappings,
ColumnsToConvert = new[] { 1 },
Name = "Thoroughfares"
};
return(this.BulkCopy(data.CreateReader(MainfileType.Thoroughfares), info));
}
private Task SaveOrganisations(Mainfile data)
{
TableInformation info = new TableInformation
{
ColumnMappings = DefaultMappings,
ColumnsToConvert = new[] { 1, 2 },
Name = "Organisations"
};
return(this.BulkCopy(data.CreateReader(MainfileType.Organisations), info));
}
public void ShouldBeAbleToReadSubBuildingNameFiles()
{
this.mainfileBuilder.AddFile(string.Empty, ExamplePafFileData.SubBuildingName);
Mainfile mainfile = this.mainfileBuilder.Create();
using (IDataReader reader = mainfile.CreateReader(MainfileType.SubBuildingNames))
{
Assert.That(reader.Read(), Is.True);
Assert.That(reader["Key"], Is.EqualTo(2));
Assert.That(reader["Name"], Is.EqualTo("1"));
Assert.That(reader.Read(), Is.False);
}
}
public void ShouldBeAbleToReadThoroughfareDescriptorFiles()
{
this.mainfileBuilder.AddFile(string.Empty, ExamplePafFileData.ThoroughfareDescriptors);
Mainfile mainfile = this.mainfileBuilder.Create();
using (IDataReader reader = mainfile.CreateReader(MainfileType.ThoroughfareDescriptors))
{
Assert.That(reader.Read(), Is.True);
Assert.That(reader["Key"], Is.EqualTo(1));
Assert.That(reader["Descriptor"], Is.EqualTo("ROAD"));
Assert.That(reader.Read(), Is.False);
}
}
public void ShouldBeAbleToReadOrganisationFiles()
{
this.mainfileBuilder.AddFile(string.Empty, ExamplePafFileData.Organisations);
Mainfile mainfile = this.mainfileBuilder.Create();
using (IDataReader reader = mainfile.CreateReader(MainfileType.Organisations))
{
Assert.That(reader.Read(), Is.True);
Assert.That(reader["Key"], Is.EqualTo(122173));
Assert.That(reader["PostcodeType"], Is.EqualTo((int)DeliveryPointType.SmallUser));
Assert.That(reader["Name"], Is.EqualTo("H M COASTGUARD"));
Assert.That(reader["Department"], Is.EqualTo("M R S C HUMBER"));
Assert.That(reader.Read(), Is.False);
}
}
public void ShouldBeAbleToReadLocalityFiles()
{
this.mainfileBuilder.AddFile(string.Empty, ExamplePafFileData.Localities);
Mainfile mainfile = this.mainfileBuilder.Create();
using (IDataReader reader = mainfile.CreateReader(MainfileType.Localities))
{
Assert.That(reader.Read(), Is.True);
Assert.That(reader["Key"], Is.EqualTo(3658));
Assert.That(reader["PostTown"], Is.EqualTo("BODMIN"));
Assert.That(reader["DependentLocality"], Is.EqualTo("CARDINHAM"));
Assert.That(reader["DoubleDependentLocality"], Is.EqualTo("LITTLE DOWNS"));
Assert.That(reader.Read(), Is.False);
}
}
private Task SaveAddressesToTable(Mainfile data, MainfileType type, DataTable table)
{
return(Task.Run(() =>
{
using (IDataReader reader = data.CreateReader(type))
{
CopyColumns(reader, table);
CopyRows(
reader,
table,
values =>
{
string postcode = values[11] as string;
if ((postcode != null) && (postcode.Length > 3))
{
values[11] = postcode.Insert(postcode.Length - 3, " ");
}
});
}
}));
}
