public void TearDown()
        {
            // klase
            dbXmlConverter = null;

            // test get
            testXmlOne   = string.Empty;
            testXmlTwo   = string.Empty;
            testXmlThree = string.Empty;
            testXmlFour  = string.Empty;
            testXmlBreak = string.Empty;
            testResponse = null;

            // test post
            testXmlPostOne = string.Empty;

            // ocekivani get
            expectedDbFromXmlOne    = string.Empty;
            expectedDbFromXmlTwo    = string.Empty;
            expectedDbFromXmlThree  = string.Empty;
            expectedDbFromXmlFour   = string.Empty;
            expectedXmlBreak        = string.Empty;
            expectedXmlFromResponse = string.Empty;


            // ocekivani post
            expectedDbFromPostOne = string.Empty;

            // ocekivani patch
            expectedDbFromPatchOne = string.Empty;

            // ocekivani delete
            expectedDbFromDeleteOne = string.Empty;
            expectedDbFromDeleteTwo = string.Empty;
        }
        public void SetUp()
        {
            // klase
            dbXmlConverter = new DbXmlConverter();

            // test get
            testXmlOne   = "<Request>\r\n  <Verb>GET</Verb>\r\n  <Noun>/resource</Noun>\r\n  <Query>name='pera';type=1</Query>\r\n  <Fields>id;name;surname</Fields>\r\n</Request>";
            testXmlTwo   = "<Request>\r\n  <Verb>GET</Verb>\r\n  <Noun>/resource/2</Noun>\r\n   <Fields>id;name</Fields>\r\n</Request>";
            testXmlThree = "<Request>\r\n  <Verb>GET</Verb>\r\n  <Noun>/resource/3</Noun>\r\n</Request>";
            testXmlFour  = "<Request>\r\n  <Verb>GET</Verb>\r\n  <Noun>/resource</Noun>\r\n  <Query>name='nesto';type=2</Query>\r\n</Request>";
            testXmlBreak = "<Request>r\n  <Verb>BREAK</Verb>\r\n  <Noun>/resource/2</Noun>\r\n</Request>";

            // test post
            testXmlPostOne = "<Request>\r\n  <Verb>POST</Verb>\r\n  <Noun>/resource</Noun>\r\n  <Query>name='pera';type=1</Query>\r\n</Request>";

            // test patch
            testXmlPatchOne = "<Request>\r\n  <Verb>PATCH</Verb>\r\n  <Noun>/resource/3</Noun>\r\n  <Query>name='mladjo';type=2</Query>\r\n</Request>";

            // test delete
            testXmlDeleteOne = "<Request>\r\n  <Verb>DELETE</Verb>\r\n  <Noun>/resource/3</Noun>\r\n</Request>";
            testXmlDeleteTwo = "<Request>\r\n  <Verb>DELETE</Verb>\r\n  <Noun>/resource</Noun>\r\n  <Query>name='pera';type=2</Query>\r\n</Request>";

            // test response
            testResponse = new Response()
            {
                Status = Status.SUCCESS.ToString(), StatusCode = StatusCode.SUCCESS_CODE
            };
            testResponse.Payload          = new Payload();
            testResponse.Payload.Resource = new List <IResource>();
            testResponse.Payload.Resource.Add(new Resource()
            {
                ID = 1, Title = "Osoba", Name = "Pera", Description = "Test osoba", Type = new ResourceType()
                {
                    ID = 1, Title = "Osoba Tip"
                }
            });


            // ----------------------------------------------------
            // ocekivani
            expectedDbFromXmlOne   = "SELECT id,name,surname FROM resource WHERE name='pera' AND type=1;";
            expectedDbFromXmlTwo   = "SELECT id,name FROM resource WHERE id=2;";
            expectedDbFromXmlThree = "SELECT * FROM resource WHERE id=3;";
            expectedDbFromXmlFour  = "SELECT * FROM resource WHERE name='nesto' AND type=2;";

            // ocekivani post
            expectedDbFromPostOne = "INSERT INTO resource (name, type) VALUES ('pera', 1);";

            // ocekivani patch
            expectedDbFromPatchOne = "UPDATE resource SET name='mladjo', type=2 WHERE id=3;";

            // ocekivani delete
            expectedDbFromDeleteOne = "DELETE FROM resource WHERE id=3;";
            expectedDbFromDeleteTwo = "DELETE FROM resource WHERE name='pera' AND type=2;";

            // ocekivani response
            expectedXmlFromResponse = "<Response>\r\n  <Payload>\r\n    <Resource>\r\n      <ID>1</ID>\r\n      <Title>Osoba</Title>\r\n      <Name>Pera</Name>\r\n      <Description>Test osoba</Description>\r\n      <Type>\r\n        <ID>1</ID>\r\n        <Title>Osoba Tip</Title>\r\n      </Type>\r\n    </Resource>\r\n    <ErrorMessage />\r\n  </Payload>\r\n  <Status>SUCCESS</Status>\r\n  <StatusCode>2000</StatusCode>\r\n</Response>";
        }