private buildUpdateLastEmailNotificationQuery ( domain user ) : OracleQuery | ||
user | domain | |
Résultat | OracleQuery |
public void testUpdateLastNotificationSqlStatement() { UserDao dao = new UserDao(_cxn); OracleQuery query = dao.buildUpdateLastEmailNotificationQuery( new domain.sm.User() { Email = "[email protected]", EmailNotification = domain.sm.enums.EmailNotificationEnum.EACH_MESSAGE, Id = 1, LastNotification = DateTime.Now }); Assert.IsTrue(String.Equals(query.Command.CommandText, "UPDATE SMS.SMS_USER SET LAST_EMAIL_NOTIFICATION=:lastEmailNotification, OPLOCK=:oplockPlusOne WHERE USER_ID=:userId and OPLOCK=:oplock")); }
public void testUpdateLastNotificationSqlStatement() { UserDao dao = new UserDao(_cxn); OracleQuery query = dao.buildUpdateLastEmailNotificationQuery( new domain.sm.User() { Email = "[email protected]", EmailNotification = domain.sm.enums.EmailNotificationEnum.EACH_MESSAGE, Id = 1, LastNotification = DateTime.Now }); Assert.IsTrue(String.Equals(query.Command.CommandText, "UPDATE SMS.SMS_USER SET LAST_EMAIL_NOTIFICATION=:lastEmailNotification, OPLOCK=:oplockPlusOne WHERE USER_ID=:userId and OPLOCK=:oplock")); }