Skip to main content
Home  ›  Blog

New in 2sxc 7: #7 Re-Design DNN-Events with Razor

This is a part of my series The New Features of 2sxc 7 and introduces you to using SQL-Data from DNN in the Visual Query to Re-Template / Re-Design any DNN-Module. In this case I prepared a demo using DNN Events. 

So Imagine you have DNN Events and you want to customize the output - either to

  1. Create a very special design requiring conditions (if ... else ...)
  2. Using additional functionality like Gravatars or something which the default templating doesn't provide
  3. Add additional logic like Video-Parsing, view-counting
  4. Use DNN-Events-Data in JSON for animated output in jQuery, knockoutJS or AngularJS

This Concept Works for All Modules

Remember that this is just a simple demo and will focus on DNN Events. But in general it can be used for any kind of module.

The Basic Principle

In general we always use the following pattern to visualize 3rd-party data:

  1. Request the data from SQL using the DnnSqlDataSource
  2. Optionally provide various parameters - either from the URL (to create lists showing items based on a category or similar) or from Module-Settings (so that the editor can say things like "Show all events here which I created")
  3. Visualize it using Tokens, Razor on WebAPI / JSON (and then any kind of JavaScript)

Get the Demo-App

To show all this I created a simple App for you. Download it here. It shows many functionalities like:

  1. Visual Query using the DnnSqlDataSource
  2. Using Tokens in Queries (both PortalId as well as Url-Parameters)
  3. Using editor-configuration to affect queries using the In-ValueProvider (that's where the content-editor says "Show Events of Module X"
  4. Templating the results with Tokens
  5. Details-View which automatically get shown when the word "Details" appears in the Url
  6. Accessing the list of queries in Razor

Give it a Try

Download, mess around, have fun!

With love from Switzerland,

Daniel Mettler grew up in the jungles of Indonesia and is founder and CEO of 2sic internet solutions in Switzerland and Liechtenstein, an 20-head web specialist with over 800 DNN projects since 1999. He is also chief architect of 2sxc (see github), an open source module for creating attractive content and DNN Apps.

Read more posts by Daniel Mettler