Index: vhUnitTest/APPS/TRANSP/Offerte/impl/DHL/TariefRepository/Test.cls.xml
===================================================================
diff -u
--- vhUnitTest/APPS/TRANSP/Offerte/impl/DHL/TariefRepository/Test.cls.xml	(revision 0)
+++ vhUnitTest/APPS/TRANSP/Offerte/impl/DHL/TariefRepository/Test.cls.xml	(revision 34162)
@@ -0,0 +1,56 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<Export generator="Cache" version="24">
+<Class name="vhUnitTest.APPS.TRANSP.Offerte.impl.DHL.TariefRepository.Test">
+<Super>vhUnitTest.TestCase</Super>
+
+<Method name="Test: GeefViaLandEnPostCode gebruikt de juiste query en parameters.">
+<Implementation><![CDATA[
+	#dim LandCode As %String = "DE"
+	#dim PostCode As %String = "54122"
+	
+	#dim QueryAPISpy As vhTest.Spy.TECH.Query.QueryAPI = ..MaakQueryAPISpy(LandCode, PostCode)
+	
+	Set TransportduurRepository = ##class(APPS.TRANSP.Offerte.impl.DHL.TariefRepository).%New(..MaakGateWayDummy(), QueryAPISpy)
+	
+	Do TransportduurRepository.GeefViaLandEnPostCode(LandCode, PostCode)
+	
+	Do ..AssertQueryAndParameters(QueryAPISpy)
+]]></Implementation>
+</Method>
+
+<Method name="AssertQueryAndParameters">
+<FormalSpec>QueryAPISpy:vhTest.Spy.TECH.Query.QueryAPI</FormalSpec>
+<Private>1</Private>
+<Implementation><![CDATA[
+	Do $$$AssertEquals(QueryAPISpy.Statement,"SELECT ID FROM APPS_TRANSP_Offerte_impl_DHL.Tarief WHERE LandCode = ? AND ? %STARTSWITH Sleutel")
+	Do $$$AssertEquals(QueryAPISpy.Params ,$LB("DE","54122"))
+]]></Implementation>
+</Method>
+
+<Method name="MaakGateWayDummy">
+<Private>1</Private>
+<ReturnType>vhTest.Mock.TECH.Persistent.impl.Gateway</ReturnType>
+<Implementation><![CDATA[
+	#dim GateWayDummy As vhTest.Mock.TECH.Persistent.impl.Gateway = ##class(vhTest.Mock.TECH.Persistent.impl.Gateway).%New("APPS.TRANSP.Offerte.impl.DHL.Transportduur")
+	Do GateWayDummy.IndienMethodCall("OpenId",$$$ElkeWaarde).DanReturn(##class(APPS.TRANSP.Offerte.impl.DHL.Tarief).%New())
+	Quit GateWayDummy
+]]></Implementation>
+</Method>
+
+<Method name="MaakQueryAPISpy">
+<FormalSpec>LandCode:%String,PostCode:%String</FormalSpec>
+<Private>1</Private>
+<ReturnType>vhTest.Spy.TECH.Query.QueryAPI</ReturnType>
+<Implementation><![CDATA[
+	#dim ResultSetData As %ListOfDataTypes = ##class(TECH.ListUtils).CreateListOfDataTypes($LB(LandCode,PostCode))
+	#dim ResultSetColumns As %ListOfDataTypes = ##class(TECH.ListUtils).CreateListOfDataTypes($LB("LandCode","PostCode"))
+	
+	#dim QueryAPISpy As vhTest.Spy.TECH.Query.QueryAPI = ##class(vhTest.Spy.TECH.Query.QueryAPI).%New(ResultSetData,ResultSetColumns )
+	
+	Quit QueryAPISpy
+]]></Implementation>
+</Method>
+</Class>
+
+
+</Export>
Index: APPS/TRANSP/Offerte/impl/DHL/TariefRepository.cls.xml
===================================================================
diff -u
--- APPS/TRANSP/Offerte/impl/DHL/TariefRepository.cls.xml	(revision 0)
+++ APPS/TRANSP/Offerte/impl/DHL/TariefRepository.cls.xml	(revision 34162)
@@ -0,0 +1,20 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<Export generator="Cache" version="24">
+<Class name="APPS.TRANSP.Offerte.impl.DHL.TariefRepository">
+<Super>TECH.Persistentie.Repository</Super>
+
+<Parameter name="DataClassName">
+<Type>%String</Type>
+<Default>APPS.TRANSP.Offerte.impl.DHL.Tarief</Default>
+</Parameter>
+
+<Method name="GeefViaLandEnPostCode">
+<FormalSpec>LandCode:%String,PostCode:%String</FormalSpec>
+<ReturnType>TECH.Persistent</ReturnType>
+<Implementation><![CDATA[	Quit ..GeefViaFilter("LandCode = ? AND ? %STARTSWITH Sleutel", $LB(LandCode,PostCode))
+]]></Implementation>
+</Method>
+</Class>
+
+
+</Export>