Views: 4349
Number of votes: 4
Average rating:

Implement a comment system using EPiServers datastore by using Paul Smith's DynamicDataStoreSession class

Hi!

First I would want to start this post by thanking Paul Smith for taking the time to point out the mistakes I had done in the last post I did about this, I learned a lot how to use the datastore in a correct way from his help! Thanks Paul!

This post is about how we can use Paul Smith's DynamicDataStoreSession class with very little code to implement a comment system for our EPi pages using the EPiServer datastore.

The idea is that I will create an Usercontrol that I can place on a page where I want people to be able to comment the content.


I start off with creating my entity class:


     public class Comment
    {
        public Identity Id { get; set; }
        [EPiServerDataIndex]
        public Guid PageGuid { get; set; } 
        public string UserName { get; set; }
        public string Location { get; set; }
        public string UserComment { get; set; }
        public DateTime Date { get; set; }
    }


Note that my PageGuid property has the attribute [EPiServerDataIndex], it will tell the DDS to map the property to an indexed database column, which will speed up retrieving the data.

I then make a factory class were I will add my datastore methods:


     public static IEnumerable<Comment> GetComments(Guid pageGuid)
        {
            var session = new DynamicDataStoreSession<Comment>();
            return session.Find().Where(p => p.PageGuid).Equals(pageGuid).Go().OrderByDescending(p => p.Date);
        }

        public static void SubmitComment(string comment, Guid pageGuid)
        {
            var store = new DynamicDataStoreSession<Comment>();
            var newComment = new Comment
            {
                Id = Identity.NewIdentity(Guid.NewGuid()),
                UserName = Membership.GetUser().UserName,
                Location = "Stockholm, Sweden",
                UserComment = comment,
                Date = DateTime.Now,
                PageGuid = pageGuid
            };
            store.Save(newComment); 
           

        }


My usercontrol looks like this:

<asp:Repeater ID="repComments" runat="server">
                <ItemTemplate>
                   <tr>
                   <td><%# DataBinder.Eval(Container.DataItem, "UserName")%> (<%# DataBinder.Eval(Container.DataItem, "Location")%>) </td>
                   <td><br /><%# DataBinder.Eval(Container.DataItem, "UserComment")%></td><br /><br />
                 </tr> 
                </ItemTemplate>
                </asp:Repeater>


and in the code behind:

  protected void Page_Load(object sender, EventArgs e)
        {
           repComments.DataSource = ArticleComment.GetComments(CurrentPage.PageGuid);
           repComments.DataBind();
       }

        protected void btnComment_Click(object sender, EventArgs e)
        {
            if (tbComment.Text == "")
                return;
            ArticleComment.SubmitComment(tbComment.Text, CurrentPage.PageGuid);
            repComments.DataSource = ArticleComment.GetComments(CurrentPage.PageGuid);
            repComments.DataBind();
            tbComment.Text = "";
        }


I hope you had fun and found this post useful :)

Aug 18, 2011

toni
(By toni, 8/18/2011 5:54:49 PM)

Hi Patrick, nice blog post. I learned some stuff! :)

But doesn't the code below mean that the [EPIServerDataIndex] is an attribute to UserName, not PageGuid?

public Guid PageGuid { get; set; }
[EPiServerDataIndex]
public string UserName { get; set; }

Maybe it's my c# skills that isn't up to par when it comes to attributes.

smithsson68
(By smithsson68, 8/18/2011 6:12:21 PM)

Hi Patrick!

Your code is looking great now except for the small mistake that Toni has pointed out. You need to declare the attribute on top on the member. When you change this you will find that your app crashes as the class definition no longer matches the DDS store definition. You get around this easily by adding the following attribute to your Comment class:

[EPiServerDataStore(AutomaticallyRemapStore=true)]

With this added your store will automatically align to the class the first time the store is accessed.

Thanks for sharing!

/Paul

Patrick Ibert
(By Patrick Ibert, 8/18/2011 7:03:01 PM)

Hi!
Oh Yea I thought about that before if it wasent wrong, I guess I missunderstood that part some.
Thanks for pointing it out, updated the post with it.

/Patrick

Please login to comment.