Nebulae Spiral

USE [ContentRatingExample]
GO
/****** Object:  Table [dbo].[Users]    Script Date: 12/06/2008 18:45:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Users](
	[ID] [uniqueidentifier] NOT NULL,
	[UserName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[DateCreated] [datetime] NOT NULL,
 CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

USE [ContentRatingExample]
GO
/****** Object:  Table [dbo].[Content]    Script Date: 12/06/2008 18:45:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Content](
	[ID] [uniqueidentifier] NOT NULL,
	[CreatedBy] [uniqueidentifier] NOT NULL,
	[Content] [nvarchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[Title] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
	[DateCreated] [datetime] NOT NULL,
	[DateModified] [datetime] NOT NULL,
	[Parent] [uniqueidentifier] NULL,
 CONSTRAINT [PK_content] PRIMARY KEY CLUSTERED
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

USE [ContentRatingExample]
GO
/****** Object:  Table [dbo].[Ratings]    Script Date: 12/06/2008 18:46:44 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Ratings](
	[ID] [uniqueidentifier] NOT NULL,
	[UserID] [uniqueidentifier] NOT NULL,
	[ContentID] [uniqueidentifier] NOT NULL,
	[Rating] [tinyint] NOT NULL,
	[DateCreated] [datetime] NOT NULL,
 CONSTRAINT [PK_Ratings] PRIMARY KEY CLUSTERED
(
	[ID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

        [Table(Name="dbo.Content")]
	[DataContract()]
	public partial class Content : INotifyPropertyChanging, INotifyPropertyChanged
	{
                .
                .
                .
                [Column(Storage="_ID", DbType="UniqueIdentifier NOT NULL", IsPrimaryKey=true)]
		[DataMember(Order=1)]
		public System.Guid ID
		{
                    .
                    .
                    .

using System;
using System.Collections.Generic;
using System.ServiceModel;
using System.ServiceModel.Web;
using ContentRating.Common;
 
namespace ContentRating.Service
{
    [ServiceContract]
    public interface IService
    {
        [OperationContract]
        [WebInvoke(ResponseFormat = WebMessageFormat.Xml,
            BodyStyle = WebMessageBodyStyle.WrappedRequest)]
        List GetUsers();
 
        [OperationContract]
        [WebInvoke(ResponseFormat = WebMessageFormat.Xml,
            BodyStyle = WebMessageBodyStyle.WrappedRequest)]
        User GetUser(Guid id);
 
        [OperationContract]
        [WebInvoke(ResponseFormat = WebMessageFormat.Xml,
            BodyStyle = WebMessageBodyStyle.WrappedRequest)]
        void AddUser(string username);
 
        [OperationContract]
        [WebInvoke(ResponseFormat = WebMessageFormat.Xml,
            BodyStyle = WebMessageBodyStyle.WrappedRequest)]
        List GetMainContent();
 
        [OperationContract]
        [WebInvoke(ResponseFormat = WebMessageFormat.Xml,
            BodyStyle = WebMessageBodyStyle.WrappedRequest)]
        List GetChildContent(Guid ParentID);
 
        [OperationContract]
        [WebInvoke(ResponseFormat = WebMessageFormat.Xml,
            BodyStyle = WebMessageBodyStyle.WrappedRequest)]
        void AddContent(Guid userID, string title, string text);
 
        [OperationContract]
        [WebInvoke(ResponseFormat = WebMessageFormat.Xml,
            BodyStyle = WebMessageBodyStyle.WrappedRequest)]
        void AddComment(Guid userID, string title, string text, Guid contentID);
 
        [OperationContract]
        [WebInvoke(ResponseFormat = WebMessageFormat.Xml,
            BodyStyle = WebMessageBodyStyle.WrappedRequest)]
        List GetRatingsForContent(Guid ContentID);
 
        [OperationContract]
        [WebInvoke(ResponseFormat = WebMessageFormat.Xml,
            BodyStyle = WebMessageBodyStyle.WrappedRequest)]
        List GetRatingsFromUser(Guid UserID);
 
        [OperationContract]
        [WebInvoke(ResponseFormat = WebMessageFormat.Xml,
            BodyStyle = WebMessageBodyStyle.WrappedRequest)]
        void AddRating(Guid contentID, Guid userID, byte rated);
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using ContentRating.Common;
 
namespace ContentRating.Service
{
    public class Service : IService
    {
        public List GetUsers()
        {
            using (ContentRatingClassesDataContext ctx
                = new ContentRatingClassesDataContext())
            {
                var users = (from u in ctx.Users
                             select u).ToList();
                return users;
            }
        }
 
        public User GetUser(Guid id)
        {
            using (ContentRatingClassesDataContext ctx
                = new ContentRatingClassesDataContext())
            {
                var user = (from u in ctx.Users
                            where u.ID == id
                             select u).Single();
                return user;
            }
        }
 
        public void AddUser(String username)
        {
            using (ContentRatingClassesDataContext ctx
                = new ContentRatingClassesDataContext())
            {
                User user =new User {DateCreated = DateTime.Now, ID = Guid.NewGuid(), UserName = username};
 
                ctx.Users.InsertOnSubmit(user);
                ctx.SubmitChanges();
            }
        }
 
        public List GetMainContent()
        {
            using (ContentRatingClassesDataContext ctx
                = new ContentRatingClassesDataContext())
            {
                var mainContent = (from content in ctx.Contents
                                   where content.Parent == null
                                   select content).ToList();
                return mainContent;
            }
        }
 
        public List GetChildContent(Guid ParentID)
        {
            using (ContentRatingClassesDataContext ctx
                = new ContentRatingClassesDataContext())
            {
                var childContent = (from content in ctx.Contents
                                   where content.Parent == ParentID
                                   select content).ToList();
                return childContent;
            }
        }
 
        public void AddContent(Guid userID, string title, string text)
        {
            using (ContentRatingClassesDataContext ctx
                = new ContentRatingClassesDataContext())
            {
                Content content = new Content
                                      {
                                          ID = Guid.NewGuid(),
                                          DateModified = DateTime.Now,
                                          DateCreated = DateTime.Now,
                                          CreatedBy = userID,
                                          Title = title,
                                          Content1 = text
                                      };
                ctx.Contents.InsertOnSubmit(content);
                ctx.SubmitChanges();
            }
        }
 
        public void AddComment(Guid userID, string title, string text, Guid contentID)
        {
            using (ContentRatingClassesDataContext ctx
                = new ContentRatingClassesDataContext())
            {
                Content content = new Content
                                      {
                                          ID = Guid.NewGuid(),
                                          DateModified = DateTime.Now,
                                          DateCreated = DateTime.Now,
                                          CreatedBy = userID,
                                          Title = title,
                                          Parent = contentID,
                                          Content1 = text
                                      };
                ctx.Contents.InsertOnSubmit(content);
                ctx.SubmitChanges();
            }
        }
 
        public List GetRatingsForContent(Guid ContentID)
        {
            using (ContentRatingClassesDataContext ctx
                = new ContentRatingClassesDataContext())
            {
                var ratings = (from rating in ctx.Ratings
                                    where rating.ContentID == ContentID
                                    select rating).ToList();
                return ratings;
            }
        }
 
        public List GetRatingsFromUser(Guid UserID)
        {
            using (ContentRatingClassesDataContext ctx
                = new ContentRatingClassesDataContext())
            {
                var ratings = (from rating in ctx.Ratings
                               where rating.UserID == UserID
                               select rating).ToList();
                return ratings;
            }
        }
 
        public void AddRating(Guid contentID, Guid userID, byte rated)
        {
            using (ContentRatingClassesDataContext ctx
                = new ContentRatingClassesDataContext())
            {
                Rating rating = new Rating
                                    {
                                        ID = Guid.NewGuid(),
                                        DateCreated = DateTime.Now,
                                        ContentID = contentID,
                                        UserID = userID,
                                        Rating1 = rated
                                    };
                ctx.Ratings.InsertOnSubmit(rating);
                ctx.SubmitChanges();
            }
        }
    }
}

function AddUser(username) {
<code>
        var client = new XMLHttpRequest;
 
        var data = '' + username + '';
        client.open('POST', 'http://localhost/ContentRatingService/Service.svc/ajaxEndpoint/AddUser', true);
        client.setRequestHeader("Content-length", data.length);
 
        client.setRequestHeader("Content-type", "text/xml");
        client.onreadystatechange = function() {
            if (client.readyState == 4 || client.readyState == XMLHttpRequest.DONE) {
                alert(client.responseText);
            }
        }
 
        client.send(data);
 
    }
 
    function GetUsers() {
        var client = new XMLHttpRequest;
 
        var data = '';
        client.open('POST', 'http://localhost/ContentRatingService/Service.svc/ajaxEndpoint/GetUsers', true);
        client.setRequestHeader("Content-length", data.length);
 
        client.setRequestHeader("Content-type", "text/xml");
        client.onreadystatechange = function() {
            if (client.readyState == 4 || client.readyState == XMLHttpRequest.DONE) {
                alert(client.responseText);
            }
        }
 
        client.send(data);
 
    }
 
</code>

<input type=button onclick="GetUsers()" value="Get Users" />
<br /><br /><input type=text id='username' />
<input type=button onclick="AddUser(document.getElementById('username').value)" value="Add User" />

using System;
using System.Linq;
using System.Runtime.Serialization;
 
namespace ContentRating.Common
{
    public partial class Content
    {
        [DataMember]
        public decimal AverageRating
        {
            get; set;
        }
 
        partial void OnLoaded()
        {
            using( ContentRatingClassesDataContext ctx = new ContentRatingClassesDataContext() )
            {
                var ratings = from r in ctx.Ratings
                              where r.ContentID == this.ID
                              select r;
 
                var number = ratings.Count();
                int total = 0;
                foreach(var rate in ratings)
                {
                    total += rate.Rating1;
                }
                decimal average = 0;
                if(decimal.TryParse((total/number).ToString(), out average))
                {
                    AverageRating = average;
                }
                AverageRating = 0;
 
            }
        }
    }
}

        function SendRequest(data, postUrl, callBack, args) {
            var client = new XMLHttpRequest;
            client.open('POST', postUrl, true);
            client.setRequestHeader("Content-length", data.length);
 
            client.setRequestHeader("Content-type", "text/xml");
            client.onreadystatechange = function() {
                if (client.readyState == 4 || client.readyState == XMLHttpRequest.DONE) {
                    callBack(client.responseXML, args);
                }
            }
 
            client.send(data);
        }
 
        function AddComment(title, comment, userID, contentID) {
 
            var data = '<AddComment xmlns="http://tempuri.org/"><userID>' + userID + '</userID><title>' + title + '</title><text>' + comment + '</text><contentID>' + contentID + '</contentID></AddComment>';
            var postUrl = 'http://localhost/ContentRatingService/Service.svc/ajaxEndpoint/AddComment';
            var args = new Array();
            args[0] = contentID;
            SendRequest(data, postUrl, GetAllMainContent, args);
        }
 
        function GetAllMainContent() {
 
            document.getElementById('content').innerHTML = '';
            var data = '<GetMainContent xmlns="http://tempuri.org/"></GetMainContent>';
            var postUrl = 'http://localhost/ContentRatingService/Service.svc/ajaxEndpoint/GetMainContent';
            SendRequest(data, postUrl, DrawContent, null);
        }
 
        function GetChildContent(parentID) {
 
            var data = '<GetChildContent xmlns="http://tempuri.org/"><ParentID>' + parentID + '</ParentID></GetChildContent>';
            var postUrl = 'http://localhost/ContentRatingService/Service.svc/ajaxEndpoint/GetChildContent';
            var args = new Array();
            args[0] = parentID;
            SendRequest(data, postUrl, DrawContent, args);
 
        }
 
        function SubmitRating(contentID) {
            RateContent(contentID,
                document.getElementById('users').options[document.getElementById('users').selectedIndex].value,
                document.getElementById('rating_' + contentID).options[document.getElementById('rating_' + contentID).selectedIndex].text);
        }
 
 
        function RateContent( contentID, userID, rated ) {
 
            var data = '<AddRating xmlns="http://tempuri.org/"><contentID>' + contentID + '</contentID><userID>' + userID + '</userID><rated>' + rated + '</rated></AddRating>';
            var postUrl = 'http://localhost/ContentRatingService/Service.svc/ajaxEndpoint/AddRating';
            SendRequest(data, postUrl, DrawContent, null);
 
        }
 
        function AddContent(title, content, userID) {
 
            var data = '<AddContent xmlns="http://tempuri.org/"><userID>' + userID.toUpperCase() + '</userID><title>' + title + '</title><text>' + content + '</text></AddContent>';
            var postUrl = 'http://localhost/ContentRatingService/Service.svc/ajaxEndpoint/AddContent';
 
            SendRequest(data, postUrl, GetAllMainContent, null);
        }
 
        function SubmitComment(contentID) {
            AddComment(document.getElementById('title_' + contentID).value,
                document.getElementById('reply_' + contentID).value,
                document.getElementById('users').options[document.getElementById('users').selectedIndex].value,
                contentID);
        }
 
 
    function AddUser(username) {
 
        var data = '<AddUser xmlns="http://tempuri.org/"><username>' + username + '</username></AddUser>';
        var postUrl = 'http://localhost/ContentRatingService/Service.svc/ajaxEndpoint/AddUser';
        SendRequest(data, postUrl, GetUsers, null);
    }
 
    function GetUsers() {
 
        var data = '<GetUsers xmlns="http://tempuri.org/"></GetUsers>';
        var postUrl = 'http://localhost/ContentRatingService/Service.svc/ajaxEndpoint/GetUsers';
        SendRequest(data, postUrl, PopulateUsers, null);
    }
 
 
 
    function DrawContent(responseXML, args) {
 
        var contentNodes = responseXML.getElementsByTagName('Content');
 
        if (!!contentNodes && contentNodes.length > 0) {
            for (var i = 0; i < contentNodes.length; i++) {
 
                var id = contentNodes[i].getElementsByTagName('ID')[0].firstChild.nodeValue;
 
                var div = document.createElement('div');
                div.style.border = '1px solid #CCCCCC';
                div.setAttribute('id', id);
                div.style.margin = '25px';
                div.style.padding = '5px';
 
                var b = document.createElement('b');
                b.innerHTML = contentNodes[i].getElementsByTagName('Title')[0].firstChild.nodeValue;
                div.appendChild(b);
 
                div.innerHTML += " - rating: " + contentNodes[i].getElementsByTagName('AverageRating')[0].firstChild.nodeValue;
 
                div.innerHTML += " - rate: ";
 
                var select = document.createElement('select');
                select.setAttribute('id', 'rating_' + id);
                for (var x = 1; x < 11; x++) {
                    var option = new Option(x, x);
                    select.options[select.options.length]= option;
                }
 
                div.appendChild(select);
 
 
 
                div.innerHTML += '<a href="javascript:SubmitRating(\'' + id + '\')">submit</a><br />';
                div.innerHTML += "<p>" + contentNodes[i].getElementsByTagName('Content1')[0].firstChild.nodeValue + "</p>";
 
                div.innerHTML += '<br /><br />reply to this:<br /><input type="text" id="title_' + id + '" /><br /><textarea id="reply_' + id + '"></textarea><br />';
                div.innerHTML += '<a href="javascript:SubmitComment(\'' + id + '\')">submit</a>';
 
                if (args == null) {
                    document.getElementById('content').appendChild(div);
                    GetChildContent(id);
                } else {
                    var parentID = args[0];
                    document.getElementById(parentID).appendChild(div);
                    GetChildContent(id);
                }
 
 
            }
        } 
    }
 
    function PopulateUsers(responseXML, args) {
 
        var userNodes = responseXML.getElementsByTagName('User');
        if (!!userNodes && userNodes.length > 0) {
            document.getElementById('users').innerHTML = '';
 
            for (var i = 0; i < userNodes.length; i++) {
 
                var option = new Option(userNodes[i].getElementsByTagName('UserName')[0].firstChild.nodeValue, userNodes[i].getElementsByTagName('ID')[0].firstChild.nodeValue);
                var count = document.getElementById('users').options.length;
                document.getElementById('users').options[count] = option;
            }
        } 
    }
 
    function PrepPage() {
        GetUsers();
        GetAllMainContent();
    }

<body onload="PrepPage()">
    be user: <select id='users'></select>
    <input type="text" id='username' />
    <input type="button" onclick="AddUser(document.getElementById('username').value)" value="Add User" />
 
    <div id='content'>
 
    </div>
    <br />
    <br /><br />new content:<br />
    <input type="text" id="title" />
    <br /><textarea cols='30' rows='3' id="reply"></textarea>
    <br /><input type="button" onclick="AddContent(document.getElementById('title').value, document.getElementById('reply').value,document.getElementById('users').options[document.getElementById('users').selectedIndex].value)" value="Add" />
 
 
</body>

class SPDataAdapter
{
    public static T GetObject(string location)
    {
        object obj = null;
        SPSecurity.RunWithElevatedPrivileges(delegate
        {
            using (var site = new SPSite(location))
            {
                obj = site.OpenWeb().GetObject(location);
            }
        });
        return (T)obj;
    }
 
    public static T GetObject(string location, bool useElevatedPrivs)
    {
        if (useElevatedPrivs) return GetObject(location);
        using (var site = new SPSite(location))
        {
            return (T)site.OpenWeb().GetObject(location);
        }
    }
 
    public static SPList GetList(string location, bool useElevatedPrivs)
    {
        if (useElevatedPrivs) return GetList(location);
        using (var site = new SPSite(location))
        {
            return site.OpenWeb().GetList(location);
        }
    }
 
    public static SPList GetList(string location)
    {
        SPList list = null;
        SPSecurity.RunWithElevatedPrivileges(delegate
       {
            using (var site = new SPSite(location))
            {
                list = site.OpenWeb().GetList(location);
            }
        });
 
        return list;
 
   }
 
}

 
[TestMethod()]
public void GetObjectTest1()
{
    GetObjectTest1Helper<SPFolder>();
}
 
public void GetObjectTest1Helper<T>()
{
    const string location = "http://spiral/Lists/Tasks";
    const bool useElevatedPrivs = true;
    var actual = SPDataAdapter.GetObject<T>(location, useElevatedPrivs);
    Assert.IsNotNull(actual);
}
 
[TestMethod()]
public void GetObjectTest()
{
    GetObjectTestHelper<SPFile>();
}
 
public void GetObjectTestHelper<T>()
{
    const string location = "http://spiral/Lists/Tasks/Attachments/1/nebulae.jpg";
    T actual = SPDataAdapter.GetObject<T>(location);
    Assert.IsNotNull(actual);
}