buildCreateAddresseeQuery() private method

private buildCreateAddresseeQuery ( domain addressee, Int32 messageId ) : OracleQuery
addressee domain
messageId System.Int32
return OracleQuery
Exemplo n.º 1
0
        public void testBuildCreateAddresseeSqlStatementExpectedException()
        {
            AddresseeDao dao   = new AddresseeDao(_cxn);
            OracleQuery  query = dao.buildCreateAddresseeQuery(new domain.sm.Addressee(), 1);

            Assert.Fail("Previous line should have thrown exception");
        }
Exemplo n.º 2
0
        public void testBuildCreateAddresseeSqlStatement()
        {
            AddresseeDao dao   = new AddresseeDao(_cxn);
            OracleQuery  query = dao.buildCreateAddresseeQuery(new domain.sm.Addressee()
            {
                Folder = new domain.sm.Folder(), Owner = new domain.sm.User()
            }, 1);

            Assert.IsTrue(String.Equals(query.Command.CommandText, "INSERT INTO SMS.ADDRESSEE (ADDRESSEE_ROLE, SECURE_MESSAGE_ID, USER_ID, FOLDER_ID) VALUES (:addresseeRole, :smId, :userId, :folderId) RETURNING ADDRESSEE_ID INTO :outId"));
        }
Exemplo n.º 3
0
 public void testBuildCreateAddresseeSqlStatementExpectedException()
 {
     AddresseeDao dao = new AddresseeDao(_cxn);
     OracleQuery query = dao.buildCreateAddresseeQuery(new domain.sm.Addressee(), 1);
     Assert.Fail("Previous line should have thrown exception");
 }
Exemplo n.º 4
0
 public void testBuildCreateAddresseeSqlStatement()
 {
     AddresseeDao dao = new AddresseeDao(_cxn);
     OracleQuery query = dao.buildCreateAddresseeQuery(new domain.sm.Addressee() { Folder = new domain.sm.Folder(), Owner = new domain.sm.User() }, 1);
     Assert.IsTrue(String.Equals(query.Command.CommandText, "INSERT INTO SMS.ADDRESSEE (ADDRESSEE_ROLE, SECURE_MESSAGE_ID, USER_ID, FOLDER_ID) VALUES (:addresseeRole, :smId, :userId, :folderId) RETURNING ADDRESSEE_ID INTO :outId"));
 }