示例#1
0
        public override bool RoleExists(string roleName)
        {
            /*bool exists = false;

            System.Data.SqlClient.SqlConnection objConn = new System.Data.SqlClient.SqlConnection(connStr);
            System.Data.SqlClient.SqlCommand objComm = new System.Data.SqlClient.SqlCommand("SELECT COUNT(*) FROM ULOGA WHERE NAZIV = @NAZIV", objConn);

            objComm.Parameters.Add("@NAZIV", SqlDbType.NVarChar, 256).Value = roleName;

            objConn.Open();

            int numRecs = (int)objComm.ExecuteScalar();

            if (numRecs > 0)
            {
                exists = true;
            }

            objConn.Close();

            return exists;*/
            UserRoleBL userRoleBL = new UserRoleBL();
            return userRoleBL.UserRoleExists(roleName);
        }
示例#2
0
        public override void RemoveUsersFromRoles(string[] usernames, string[] roleNames)
        {
            foreach (string rolename in roleNames)
            {
                if (!RoleExists(rolename))
                {
                    throw new System.Configuration.Provider.ProviderException("Naziv uloge nije pronadjen.");
                }
            }

            foreach (string username in usernames)
            {
                foreach (string rolename in roleNames)
                {
                    if (!IsUserInRole(username, rolename))
                    {
                        throw new System.Configuration.Provider.ProviderException("Korisnik ne pripada ulozi.");
                    }
                }
            }

            UserRoleBL userRoleBL = new UserRoleBL();
            userRoleBL.RemoveUserFromUserRole(usernames[0], roleNames[0]);
            /*System.Data.SqlClient.SqlConnection objConn = new System.Data.SqlClient.SqlConnection(connStr);
            System.Data.SqlClient.SqlCommand objComm = new System.Data.SqlClient.SqlCommand("DELETE FROM KORISNIKULOGE WHERE ID_KORISNIK = @ID_KORISNIK AND ID_ULOGA = @ID_ULOGA", objConn);

            System.Data.SqlClient.SqlParameter userParam = objComm.Parameters.Add("@ID_KORISNIK", SqlDbType.Int);
            System.Data.SqlClient.SqlParameter roleParam = objComm.Parameters.Add("@ID_ULOGA", SqlDbType.Int);

            System.Data.SqlClient.SqlTransaction tran = null;

            try
            {
                objConn.Open();
                tran = objConn.BeginTransaction();
                objComm.Transaction = tran;

                foreach (string username in usernames)
                {
                    foreach (string rolename in roleNames)
                    {
                        userParam.Value = GetUserID(username);
                        roleParam.Value = GetRoleID(rolename);
                        objComm.ExecuteNonQuery();
                    }
                }

                tran.Commit();
            }
            catch (System.Data.SqlClient.SqlException)
            {
                tran.Rollback();
            }
            finally
            {
                objConn.Close();
            }*/
        }
示例#3
0
        public override bool IsUserInRole(string username, string roleName)
        {
            UserRoleBL userRoleBL = new UserRoleBL();
            return userRoleBL.IsUserInRole(username, roleName);
            /*bool userIsInRole = false;

            System.Data.SqlClient.SqlConnection objConn = new System.Data.SqlClient.SqlConnection(connStr);
            System.Data.SqlClient.SqlCommand objComm = new System.Data.SqlClient.SqlCommand("SELECT COUNT(*) FROM KORISNIKULOGE WHERE ID_KORISNIK = @ID_KORISNIK AND ID_ULOGA = @ID_ULOGA", objConn);

            objComm.Parameters.Add("@ID_ULOGA", SqlDbType.Int).Value = GetRoleID(roleName);
            objComm.Parameters.Add("@ID_KORISNIK", SqlDbType.Int).Value = GetUserID(username);

            objConn.Open();

            int numRecs = (int)objComm.ExecuteScalar();

            if (numRecs > 0)
            {
                userIsInRole = true;
            }

            objConn.Close();

            return userIsInRole;*/
        }
示例#4
0
        public override string[] GetRolesForUser(string username)
        {
            UserRoleBL userRoleBL=new UserRoleBL();
            string[] userRoles = userRoleBL.GetUserRolesForUsername(username);
            string roles=string.Empty;
            /*foreach (UserRole userRole in userRoles)
                roles += userRole.Name + ",";*/
            return userRoles;
            //return roles.Substring(roles.Length - 1, 1).Split(',');

            /*string tmpRoleNames = "";

            System.Data.SqlClient.SqlConnection objConn = new System.Data.SqlClient.SqlConnection(connStr);
            System.Data.SqlClient.SqlCommand objComm = new System.Data.SqlClient.SqlCommand("SELECT ID_ULOGA FROM KORISNIKULOGE WHERE ID_KORISNIK = @ID_KORISNIK", objConn);

            int id=GetUserID(username);
            objComm.Parameters.Add("@ID_KORISNIK", SqlDbType.Int).Value = id;

            System.Data.SqlClient.SqlDataReader reader = null;

            try
            {
            objConn.Open();

            reader = objComm.ExecuteReader();

            while (reader.Read())
            {
                tmpRoleNames += GetRoleName(reader.GetInt32(0)) + ",";
            }
            }
            finally
            {
            if (reader != null)
                reader.Close();
            objConn.Close();
            }

            if (tmpRoleNames.Length > 0)
            {
            tmpRoleNames = tmpRoleNames.Substring(0, tmpRoleNames.Length - 1);
            return tmpRoleNames.Split(',');
            }

            return new string[0];*/
        }
示例#5
0
        public override string[] GetAllRoles()
        {
            UserRoleBL userRoleBL = new UserRoleBL();
            System.Collections.Generic.List<UserRole> userRoles = userRoleBL.GetAllUserRoles(false);
            string roles=string.Empty;

            foreach (UserRole userRole in userRoles)
                roles += userRole.Name + ",";

            return roles.Substring(roles.Length - 1, 1).Split(',');
            /*string tmpRoleNames = "";

            System.Data.SqlClient.SqlConnection objConn = new System.Data.SqlClient.SqlConnection(connStr);
            System.Data.SqlClient.SqlCommand objComm = new System.Data.SqlClient.SqlCommand("SELECT NAZIV FROM ULOGA", objConn);

            System.Data.SqlClient.SqlDataReader reader = null;

            try
            {
                objConn.Open();

                reader = objComm.ExecuteReader();

                while (reader.Read())
                {
                    tmpRoleNames += reader.GetString(0) + ",";
                }
            }
            finally
            {
                if (reader != null)
                    reader.Close();
                objConn.Close();
            }

            if (tmpRoleNames.Length > 0)
            {
                tmpRoleNames = tmpRoleNames.Substring(0, tmpRoleNames.Length - 1);
                return tmpRoleNames.Split(',');
            }

            return new string[0];*/
        }
示例#6
0
        public override void CreateRole(string roleName)
        {
            if (roleName.IndexOf(',') > 0)
            {
                throw new ArgumentException("Naziv uloge ne moze da sadrzi podvlake.");
            }

            if (RoleExists(roleName))
            {
                throw new System.Configuration.Provider.ProviderException("Naziv uloge vec postoji.");
            }

            UserRoleBL userRoleBL = new UserRoleBL();
            UserRole userRole = new UserRole();
            userRole.Name = roleName;
            //userRole._InsertDate = DateTime.Now;
            //userRole._UpdateDate = DateTime.Now;
            //userRole._UserIDInsert = int.Parse(Membership.GetUser().ProviderUserKey.ToString());
            //userRole._UserIDUpdate = int.Parse(Membership.GetUser().ProviderUserKey.ToString());

            userRoleBL.Save(userRole);
            /*System.Data.SqlClient.SqlConnection objConn = new System.Data.SqlClient.SqlConnection(connStr);
            System.Data.SqlClient.SqlCommand objComm = new System.Data.SqlClient.SqlCommand("INSERT INTO ULOGA (NAZIV) VALUES(@NAZIV)", objConn);

            objComm.Parameters.Add("@NAZIV", SqlDbType.NVarChar, 256).Value = roleName;

            objConn.Open();
            objComm.ExecuteNonQuery();
            objConn.Close();*/
        }