Patrick Ibert
Aug 18, 2011
  4581
(4 votes)

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

Comments

Aug 18, 2011 03:54 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@gmail.com
smithsson68@gmail.com Aug 18, 2011 04:12 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
Patrick Ibert Aug 18, 2011 05:03 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.
Latest blogs
Content Delivery API – The Case of the Duplicate API Refresh Token

Creating a custom refresh provider to resolve the issues with duplicate tokens in the DXC The post Content Delivery API – The Case of the Duplicate...

David Lewis | Sep 29, 2022 | Syndicated blog

New Optimizely certifications - register for beta testing before November 1st

In January 2023, Optimizely is making updates to the current versions of our certification exams to make sure that each exam covers the necessary...

Jamilia Buzurukova | Sep 28, 2022

Optimizely community meetup - Sept 29 (virtual + Melbourne)

Super excited to be presenting this Thursday the 29th of September at the Optimizely community meetup. For the full details and RSVP's see the...

Ynze | Sep 27, 2022 | Syndicated blog

Preview multiple Visitor Groups directly while browsing your Optimizely site

Visitor groups are great - it's an easy way to add personalization towards market segments to your site. But it does come with it's own set of...

Allan Thraen | Sep 26, 2022 | Syndicated blog