// check if a postcode is contained within a region
private static bool PostcodeInRegion(string APostcode, string APostalRegion)
{
// Regions datatable should only be loaded once per extract generation
if (FPostalRegion != APostalRegion)
{
TDBTransaction ReadTransaction = null;
DBAccess.GDBAccessObj.GetNewOrExistingAutoReadTransaction(
MCommonConstants.CACHEABLEDT_ISOLATIONLEVEL, TEnforceIsolationLevel.eilMinimum, ref ReadTransaction,
delegate
{
FPostcodeRangeTable = PPostcodeRangeAccess.LoadViaPPostcodeRegion(APostalRegion, ReadTransaction);
FPostalRegion = APostalRegion;
});
}
foreach (PPostcodeRangeRow Row in FPostcodeRangeTable.Rows)
{
if ((ComparePostcodes(Row.From.ToLower(), APostcode.ToLower()) <= 0) &&
(ComparePostcodes(Row.To.ToLower(), APostcode.ToLower()) >= 0))
{
return(true);
}
}
return(false);
}
// check if a postcode is contained within a region
private bool PostcodeInRegion(string APostcode, string APostalRegion)
{
// Regions datatable should only be loaded once per extract generation
if (FPostalRegion != APostalRegion)
{
TDBTransaction ReadTransaction = new TDBTransaction();
DBAccess.ReadTransaction(
ref ReadTransaction,
delegate
{
FPostcodeRangeTable = PPostcodeRangeAccess.LoadViaPPostcodeRegion(APostalRegion, ReadTransaction);
FPostalRegion = APostalRegion;
});
}
foreach (PPostcodeRangeRow Row in FPostcodeRangeTable.Rows)
{
if ((ComparePostcodes(Row.From.ToLower(), APostcode.ToLower()) <= 0) &&
(ComparePostcodes(Row.To.ToLower(), APostcode.ToLower()) >= 0))
{
return(true);
}
}
return(false);
}
