// 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); }