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); }