Esempi in C# (CSharp) per Profiles.Profile.Utilities DataIO.GetSQLDataReader

Esempio n. 1

File: CustomViewPersonGeneralInfo.ascx.cs Progetto: CTSIatUCSF/ProfilesRNS

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

Esempio n. 2

File: CustomViewPersonGeneralInfo.ascx.cs Progetto: erinquigley/ProfilesRNS

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