internal string buildGetRecordStatement(string securityToken, string encryptionKey)
{
if (_encrypt)
{
return("SELECT * FROM " + _tableName + " WHERE SessionId ='" +
escapeString(SSTCryptographer.Encrypt(securityToken, encryptionKey)) + "';");
}
else
{
return("SELECT * FROM " + _tableName + " WHERE SessionId ='" +
escapeString(securityToken) + "';");
}
}
internal Visitor toVisitor(SqlDataReader rdr, string encryptionKey)
{
Visitor result = new Visitor();
if (_encrypt)
{
result.SSN = SSTCryptographer.Decrypt(rdr.GetString(rdr.GetOrdinal("SSN")), encryptionKey);
result.Name = SSTCryptographer.Decrypt(rdr.GetString(rdr.GetOrdinal("Name")), encryptionKey);
result.UID = SSTCryptographer.Decrypt(rdr.GetString(rdr.GetOrdinal("DUZ")), encryptionKey);
result.SiteID = SSTCryptographer.Decrypt(rdr.GetString(rdr.GetOrdinal("SiteId")), encryptionKey);
result.SiteName = SSTCryptographer.Decrypt(rdr.GetString(rdr.GetOrdinal("SiteName")), encryptionKey);
result.Phone = SSTCryptographer.Decrypt(rdr.GetString(rdr.GetOrdinal("Phone")), encryptionKey);
}
else
{
result.SSN = rdr.GetString(rdr.GetOrdinal("SSN"));
result.Name = rdr.GetString(rdr.GetOrdinal("Name"));
result.UID = rdr.GetString(rdr.GetOrdinal("DUZ"));
result.SiteID = rdr.GetString(rdr.GetOrdinal("SiteId"));
result.SiteName = rdr.GetString(rdr.GetOrdinal("SiteName"));
result.Phone = rdr.GetString(rdr.GetOrdinal("Phone"));
}
return(result);
}
