| private buildGetUserByIcnQuery ( string icn ) : OracleQuery | ||
| icn | string | |
| return | OracleQuery | |
public void testGetUserByIcnSqlStatement()
{
UserDao dao = new UserDao(_cxn);
OracleQuery query = dao.buildGetUserByIcnQuery("1");
Assert.IsTrue(String.Equals(query.Command.CommandText, "SELECT USER_ID, FIRST_NAME, LAST_NAME, USER_TYPE, STATUS, EMAIL_ADDRESS, OPLOCK, ACTIVE, DOB, ICN, SSN, STATION_NO, DUZ, EMAIL_NOTIFICATION, DEFAULT_MESSAGE_FILTER, LAST_EMAIL_NOTIFICATION, NSSN, PROVIDER, EXTERNAL_USER_NAME FROM SMS.sms_user WHERE ICN = :icn"));
}
public void testGetUserByIcnSqlStatement()
{
UserDao dao = new UserDao(_cxn);
OracleQuery query = dao.buildGetUserByIcnQuery("1");
Assert.IsTrue(String.Equals(query.Command.CommandText, "SELECT USER_ID, FIRST_NAME, LAST_NAME, USER_TYPE, STATUS, EMAIL_ADDRESS, OPLOCK, ACTIVE, DOB, ICN, SSN, STATION_NO, DUZ, EMAIL_NOTIFICATION, DEFAULT_MESSAGE_FILTER, LAST_EMAIL_NOTIFICATION, NSSN, PROVIDER, EXTERNAL_USER_NAME FROM SMS.sms_user WHERE ICN = :icn"));
}
