Esempio n. 1
0
        // 03/07/2014 OCP 57515 RSNAP II: Jun Lee
        // Using Password Web Service, this routine returns the password for the database and user id passed
        protected internal static string GetPassword(string databaseName, string userID)
        {
            string dbPwd = "";

            try
            {
                //srDBPassword.ServiceClient myService = new srDBPassword.ServiceClient();

                srDBPassword.ServiceClient myService = new srDBPassword.ServiceClient();
                dbPwd = myService.GetData(userID.Trim().ToLower(), databaseName.Trim().ToLower(), "a0c88e69-4489-4bac-b563-b2ab63526223");
                myService.Close();
            }
            catch (Exception exp)
            {
                dbPwd = "ERROR: " + exp.Message;
                EventLog.AddWebErrors("R7BD.Utility", "SharedPassword", "GetPassword", exp.Message + " " + userID.ToString() + "' in Database '" + databaseName.ToString() + "'");
            }
            return(dbPwd.Trim());

            //string passwordResult = "";
            //StringBuilder connStr = new StringBuilder();
            ////string Filepath = "d:\\components\\MSCTL32.tlb";
            //StringBuilder FilePath = new StringBuilder();
            //FilePath.Append(GSA.R7BD.Utility.Utilities.getDrivePathByLetter("MSCTL32"));
            //FilePath.Append("\\MSCTL32.tlb");
            //try {
            //    DataSet dsXML = new DataSet();
            //    if (System.IO.File.Exists(FilePath.ToString())) {	//file exists)
            //        try {
            //            FileStream fsXML = new FileStream(FilePath.ToString(), FileMode.Open, FileAccess.Read);
            //            dsXML.ReadXml(fsXML);
            //            fsXML.Close();
            //            }
            //        catch (Exception e) {
            //            Console.Write(e.Message);
            //        }
            //    }
            //    //Now lets read the value from dataset
            //    if (dsXML.Tables["Stramboli"].Rows.Count > 0) {
            //        System.Data.DataRow[] DR = dsXML.Tables["Stramboli"].Select("Request='" + XMLEncode(userID.Trim()) + "' and Visit='" + XMLEncode(databaseName.Trim()) + "'");
            //        if (DR.Length == 1) {
            //            passwordResult = DR[0]["Hits"].ToString();
            //            passwordResult = XMLDecode(passwordResult);
            //            passwordResult = Decode(passwordResult);
            //        }
            //    }
            //    if (passwordResult == "")
            //    {
            //        EventLog.AddWebErrors("R7BD.Utility", "SharedPassword", "GetPassword", "Did not find password for userID '" + userID.ToString() + "' in Database '" + databaseName.ToString() + "'");
            //    }

            //}
            //catch (System.Exception e) {
            //    Console.Write(e.Message);
            //}
            ////if password is empty in XML file then look at SANBox
            //if (passwordResult.Length == 0) {
            //    System.Data.OleDb.OleDbDataReader passwordReader;
            //    System.Data.OleDb.OleDbConnection passwordConnection = new System.Data.OleDb.OleDbConnection();
            //    System.Data.OleDb.OleDbCommand passwordCommand = new System.Data.OleDb.OleDbCommand();

            //    //Set connection / command information
            //    //passwordConnection.ConnectionString = "Provider=VFPOLEDB.1;Data Source=M:\\finance;Mode=Share Deny None;Extended Properties='';User ID='';Password='';Mask Password=False;Cache Authentication=False;Encrypt Password=False;Collating Sequence=MACHINE";
            //    connStr.Append("Provider=VFPOLEDB.1;Data Source=");
            //    connStr.Append(GSA.R7BD.Utility.Utilities.getDrivePathByLetter("PASSWORDSTABLE:"));
            //    connStr.Append(";Mode=Share Deny None;Extended Properties='';User ID='';Password='';Mask Password=False;Cache Authentication=False;Encrypt Password=False;Collating Sequence=MACHINE");
            //    passwordConnection.ConnectionString = connStr.ToString();
            //    passwordCommand.CommandText = "select password from passwords.dbf where upper(database) == '" + databaseName.Trim().ToUpper() + "' and upper(userid) == '" + userID.Trim().ToUpper() + "'";
            //    //Open and execute the command
            //    try {
            //        passwordCommand.Connection = passwordConnection;
            //        passwordCommand.Connection.Open();
            //        passwordReader = passwordCommand.ExecuteReader();

            //        if (passwordReader.Read()) {
            //            passwordResult = Decode(passwordReader.GetString(0));
            //        }

            //        passwordCommand.Connection.Close();
            //    }

            //    catch (System.Exception e) {
            //        Console.Write(e.Message);
            //    }
            //}

            //return passwordResult;
        } //end of this method