コード例 #1
0
        private static void getDetails(string sname)
        {
            SqlConnection DaConnection = new SqlConnection(_cnConn);

            DaConnection.Open();
            SqlCommand    DaCommand = new SqlCommand();
            SqlDataReader DaDataReader;


            DaCommand.CommandType = CommandType.Text;
            DaCommand.CommandText = "SELECT TOP 1 * FROM VIP_EXPANDED..VIEW_GOVERNMENT_STRUCTURE WHERE DEPT_SHORT_NAME='" + sname + "' ORDER BY FINYEAR DESC";
            DaCommand.Connection  = DaConnection;

            DaDataReader = DaCommand.ExecuteReader();

            if (DaDataReader.HasRows)
            {
                while (DaDataReader.Read())
                {
                    mvarDepartmentSName  = sname;
                    mvarDepartment       = DaDataReader.GetValue(DaDataReader.GetOrdinal("DEPT_DESCRIPTION")).ToString();
                    mvarDepartmentID     = DaDataReader.GetValue(DaDataReader.GetOrdinal("DEPT_ID")).ToString();
                    mvarDepartmentTypeID = DaDataReader.GetValue(DaDataReader.GetOrdinal("DEPT_LEVEL_ID")).ToString();
                    mvarProvinceSName    = DaDataReader.GetValue(DaDataReader.GetOrdinal("NATPROV_SHORT_NAME")).ToString();
                    mvarProvince         = DaDataReader.GetValue(DaDataReader.GetOrdinal("NATPROV_DESCRIPTION")).ToString();
                    mvarProvinceID       = DaDataReader.GetValue(DaDataReader.GetOrdinal("NAT_PROV_ID")).ToString();
                    mvarProvinceTypeID   = DaDataReader.GetValue(DaDataReader.GetOrdinal("PROVINCE_FLAG")).ToString();
                }
            }

            DaDataReader.Close();
        }
コード例 #2
0
        internal void getADServer(string ServerShortName)
        {
            /* Issue a Command to get the IPADDRESS and DC Back from teh Database  */

            SqlConnection DaConnection;
            SqlCommand    DaCommand;
            SqlDataReader DaDataReader;

            DaConnection = new SqlConnection();
            DaConnection.ConnectionString = _cnConn;  /* As set by the user */
            DaConnection.Open();

            DaCommand = new SqlCommand();
            /* Setting the connecction like this is just for test now!!! */
            DaCommand.Connection  = DaConnection;
            DaCommand.CommandText = "SELECT * FROM VIP..SERVER_TRANSLATION WHERE SHORT_NAME='" + ServerShortName.ToUpper() + "'";
            DaCommand.CommandType = System.Data.CommandType.Text;
            DaDataReader          = DaCommand.ExecuteReader();

            if (DaDataReader.HasRows)
            {
                // Set the Privare Variables of the class
                DaDataReader.Read();
                IP_ADDRESS = DaDataReader.GetValue(DaDataReader.GetOrdinal("IP")).ToString();
                DC         = DaDataReader.GetValue(DaDataReader.GetOrdinal("DC")).ToString();
            }
            else
            {
                IP_ADDRESS = "";
                DC         = "";
                mvarsError = "SERVER_TRANSLATION FAILED";
            }

            /* Close the objects before we release them */
            DaConnection.Close();
            DaDataReader.Close();
        }
コード例 #3
0
        private static void add2Application(string AppID, string AppShortName, string rigntsEntry)
        {
            // On Error GoTo AppAlreadyAdded
            Microsoft.VisualBasic.Collection xxx              = new Microsoft.VisualBasic.Collection();
            Microsoft.VisualBasic.Collection colRights        = new Microsoft.VisualBasic.Collection();;
            Microsoft.VisualBasic.Collection colExtendedDepts = new Microsoft.VisualBasic.Collection();;
            Microsoft.VisualBasic.Collection colAppDetails    = new Microsoft.VisualBasic.Collection();;
            string line = "";

            try
            {
                xxx.Add(colRights, "APPLICATION_RIGHTS", null, null);
                xxx.Add(colExtendedDepts, "EXTENDED_DEPARTMENTS", null, null);
                xxx.Add(new string[2] {
                    AppID, AppShortName
                }, "APPLICATION_DETAILS", null, null);

                mvarCol_AppRights.Add(xxx, AppShortName, null, null);
            }

            catch (Exception)
            {
                // Do The Finally part Here then!!!
                // MessageBox.Show(ex.Message);
            }
            finally
            {
                // AppAlreadyAdded

                SqlConnection DaConnection;
                SqlCommand    DaCommand;
                SqlDataReader DaDataReader;

                DaConnection = new SqlConnection();
                DaConnection.ConnectionString = _cnConn;  /* As set by the user */
                DaConnection.Open();

                DaCommand = new SqlCommand();
                /* Setting the connecction like this is just for test now!!! */
                DaCommand.Connection  = DaConnection;
                DaCommand.CommandType = System.Data.CommandType.Text;

                // line = Right(rightsEntry, Len(rightsEntry) - InStr(1, rigntsEntry, ","));
                line = rigntsEntry.Remove(0, rigntsEntry.IndexOf(",") + 1);

                if (rigntsEntry.ToUpper().Contains("APPLICATION_RIGHTS"))
                {
                    DaCommand.CommandText = "SELECT APPLICATION_ID, APPLICATION_SHORT_NAME FROM VIP_EXPANDED..APPLICATIONS WHERE APPLICATION_GROUP_ID=" + AppID + " ORDER BY APPLICATION_ID";
                    DaDataReader          = DaCommand.ExecuteReader();

                    if (DaDataReader.HasRows)
                    {
                        while (DaDataReader.Read())
                        {
                            mvarsRights = mvarsRights + "," + DaDataReader.GetValue(DaDataReader.GetOrdinal("APPLICATION_ID")).ToString();
                        }
                    }


                    // Dis 'n moeilike ene die!!

                    // SOLUTION!!!
                    Microsoft.VisualBasic.Collection b = (Microsoft.VisualBasic.Collection)((Microsoft.VisualBasic.Collection)mvarCol_AppRights[AppShortName])["APPLICATION_RIGHTS"];
                    b.Add(new string[2] {
                        AppID, line.ToString().Replace("'", "")
                    }, null, null, null);

                    DaDataReader.Close();
                }
                else
                {
                    DaCommand.CommandText = "SELECT DEPT_ID as SQL_ID, DEPT_DESCRIPTION as Description, DEPT_SHORT_NAME as SOURCE_ID FROM VIP_EXPANDED..VIEW_GOVERNMENT_STRUCTURE WHERE FINYEAR=" + getFinYear() + " AND DEPT_SHORT_NAME IN(" + line + "') ORDER BY SQL_ID";
                    DaCommand.Connection  = DaConnection;
                    DaDataReader          = DaCommand.ExecuteReader();

                    if (DaDataReader.HasRows)
                    {
                        while (DaDataReader.Read())
                        {
                            // Dis moeilike ene die!!
                            // mvarCol_AppRights(AppShortName)("EXTENDED_DEPARTMENTS").Add(Array(DaDataReader.GetValue(DaDataReader.GetOrdinal("SQL_ID")).ToString(), DaDataReader.GetValue(DaDataReader.GetOrdinal("DESCRIPTION")).ToString(), DaDataReader.GetValue(DaDataReader.GetOrdinal("SOURCE_ID")).ToString()));


                            // SOLUTION!!
                            Microsoft.VisualBasic.Collection b = (Microsoft.VisualBasic.Collection)((Microsoft.VisualBasic.Collection)mvarCol_AppRights[AppShortName])["EXTENDED_DEPARTMENTS"];
                            b.Add(new string[3] {
                                DaDataReader.GetValue(DaDataReader.GetOrdinal("SQL_ID")).ToString(), DaDataReader.GetValue(DaDataReader.GetOrdinal("DESCRIPTION")).ToString(), DaDataReader.GetValue(DaDataReader.GetOrdinal("SOURCE_ID")).ToString()
                            }, null, null, null);
                        }
                    }

                    DaDataReader.Close();
                }
            }
        }
コード例 #4
0
        internal static string AuthenticateIt(string Username, string ADSPassword)
        {
            PrincipalContext DaContext = new PrincipalContext(ContextType.Domain,
                                                              IP_ADDRESS,
                                                              "CN=" + Username + ",OU=USERS,OU=Vulindlela3," + DC,
                                                              ADSMasterUsername,
                                                              ADSMasterPassword);

            UserPrincipal ObjUser = UserPrincipal.FindByIdentity(DaContext, Username);

            // Get the users details and extract it.
            SAMAccountName = ObjUser.SamAccountName;
            Title          = ObjUser.DistinguishedName;
            Name           = ObjUser.Name;
            SurName        = ObjUser.Surname;
            GivenName      = ObjUser.GivenName;
            EmailAddress   = ObjUser.EmailAddress;


            // Now get the collection's details (The RIGHTS OF THE USER!!!)
            string app;
            string entry;

            DirectorySearcher dsSearcher;
            DirectoryEntry    dsDirectoryEntry;

            dsDirectoryEntry = new DirectoryEntry("LDAP://" + IP_ADDRESS + "/CN=" + Username + ",OU=USERS,OU=Vulindlela3," + DC, ADSMasterUsername, ADSMasterPassword);

            dsSearcher = new DirectorySearcher(dsDirectoryEntry);

            dsSearcher.Filter = "saMAccountName=" + Username;
            dsSearcher.PropertiesToLoad.Add("memberOf");

            SearchResult dsResult = dsSearcher.FindOne();

            int ColCount = dsResult.Properties["memberOf"].Count;

            for (byte bytCounter = 0; bytCounter <= (ColCount - 1); bytCounter++)
            {
                entry = dsResult.Properties["memberOf"][bytCounter].ToString(); entry = entry.Replace("OU=", ""); entry = entry.Replace("CN=", "");
                string xas = entry.Replace("DC=", "");

                string[] tempArray  = xas.Split(','); // 100!!!
                string[] temparray2 = tempArray[0].Split('.');

                if (tempArray[1] == "GOVERNMENT_STRUCTURE") // It's either the department or extended departments for an app.
                {
                    if (tempArray[0].IndexOf(".") >= 1)     //  It's an extended dept.
                    {
                        // On error resume next
                        app = temparray2[0].ToString() + "=EXTENDED_DEPARTMENTS|";
                        mvarCol_MemberOf2.Add(app, app, null, null);


                        try
                        {
                            xas = mvarCol_MemberOf2[app] + "','" + temparray2[1];
                            mvarCol_MemberOf2.Remove(app);
                            mvarCol_MemberOf2.Add(xas, app, null, null);
                        }
                        catch (Exception ex)
                        {
                            // On Error GoTo err_handler
                            mvarsError = "{ADS6.authenticate} authenticate: (" + ex.Message + ") " + ex.Source;
                            return("false");

                            // Release Objects befor quitting
                        }
                    }
                    else // Own dept.
                    {
                        getDetails(tempArray[0].ToString());
                    }
                }
                else if (tempArray[1] == "APPLICATION_RIGHTS") //  It's app right assignment
                {
                    app = temparray2[0] + "=APPLICATION_RIGHTS|";

                    try
                    {
                        mvarCol_MemberOf2.Add(app, app, null, null);
                    }
                    catch (Exception)
                    {
                        // On Error Resume Next
                        // Soos in Richard se VB6 DLL
                    }


                    try
                    {
                        xas = mvarCol_MemberOf2[app] + "','" + temparray2[1];
                        mvarCol_MemberOf2.Remove(app);
                        mvarCol_MemberOf2.Add(xas, app, null, null);  // THEY ARE key / value PAIRS.
                    }
                    catch (Exception ex)
                    {
                        //  On Error GoTo err_handler
                        mvarsError = "{ADS6.authenticate} authenticate: (" + ex.Message + ") " + ex.Source;
                        return("false");
                        // Release Objects befor quitting
                    }
                }

                // Create a Collection of Arrays!!
                mvarCol_MemberOf.Add(tempArray, entry, null, null);
            }

            SqlConnection DaConnection = new SqlConnection(_cnConn); DaConnection.Open();
            SqlCommand    DaCommand    = new SqlCommand();
            SqlDataReader DaDataReader;

            foreach (string DaEntry in mvarCol_MemberOf2)
            {
                Console.WriteLine(DaEntry);

                DaCommand.Connection  = DaConnection;
                DaCommand.CommandType = CommandType.Text;
                DaCommand.CommandText = "SELECT APPLICATION_GROUP_ID, GROUP_SHORT_NAME FROM VIP_EXPANDED..APPLICATION_GROUPS WHERE UPPER(GROUP_SHORT_NAME)='" + DaEntry.Substring(0, DaEntry.IndexOf("=")) + "'";

                DaDataReader = DaCommand.ExecuteReader();

                if (DaDataReader.HasRows)
                {
                    DaDataReader.Read();  // Advances to da first Row......
                    add2Application(DaDataReader.GetValue(DaDataReader.GetOrdinal("APPLICATION_GROUP_ID")).ToString(), DaDataReader.GetValue(DaDataReader.GetOrdinal("GROUP_SHORT_NAME")).ToString(), DaEntry.ToString());
                }
                DaDataReader.Close();
            }


            if (mvarsRights.Length > 0)
            {
                mvarsRights = mvarsRights.Substring(1, mvarsRights.Length - 1); //  Right(mvarsRights, (mvarsRights.Length) - 1);
            }

            return("true");
        }