| private buildUpdateLastEmailNotificationQuery ( domain user ) : OracleQuery | ||
| user | domain | |
| return | 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"));
}
