// UCSF internal static string getEmailPlainText(String emailEncrypted) { Utilities.DataIO data = new Profiles.Profile.Utilities.DataIO(); SqlDataReader reader; SqlCommand cmd = new SqlCommand("SELECT [Utility.Application].[fnDecryptBase64RC4] ( '" + emailEncrypted + "', (Select [value] from [Framework.].parameter with(nolock) where ParameterID = 'RC4EncryptionKey'))"); reader = data.GetSQLDataReader(cmd); reader.Read(); string emailPlain = reader[0].ToString(); reader.Close(); return emailPlain; }
// UCSF static internal string getEmailPlainText(String emailEncrypted) { Utilities.DataIO data = new Profiles.Profile.Utilities.DataIO(); SqlDataReader reader; SqlCommand cmd = new SqlCommand("SELECT [Utility.Application].[fnDecryptBase64RC4] ( '" + emailEncrypted + "', (Select [value] from [Framework.].parameter with(nolock) where ParameterID = 'RC4EncryptionKey'))"); reader = data.GetSQLDataReader(cmd); reader.Read(); string emailPlain = reader[0].ToString(); reader.Close(); return(emailPlain); }