示例#1
0
        private bool PopulatedRole(RoleInfo role)
        {
            try
            {
                InstConn();

                SqlCommand roleCheck = Connection.CreateCommand();
                roleCheck.CommandText = "SELECT * FROM " + role.Table + " where " + role.IdType + " = @Id";

                roleCheck.Parameters.Add("@Id", System.Data.SqlDbType.Int).Value = role.Id;

                // Execute scalar returns null if role is empty
                // Connection.Open();
                bool rolePopd = !(roleCheck.ExecuteScalar() == null);
                ConnClose();

                return rolePopd;
            }
            catch
            {
                return false;
            }
        }
示例#2
0
        public bool IsUserInRole(int uId, RoleInfo role)
        {
            try
            {
                InstConn();
                SqlCommand comm = Connection.CreateCommand();
                comm.CommandText = "SELECT UserId FROM " + role.Table + " WHERE " + role.IdType + " = @RoleId AND UserId = @UserId";

                comm.Parameters.Add("@RoleId", System.Data.SqlDbType.Int).Value = role.Id;
                comm.Parameters.Add("@UserId", System.Data.SqlDbType.Int).Value = uId;

                // Connection.Open();

                if (comm.ExecuteScalar() == null)
                {
                    ConnClose();
                    return false;
                }

                ConnClose();
                return true;
            }
            catch
            {
                ConnClose();
                return false;
            }
        }