jMoo's amazing placeholder data in razor magic unicorn wizardry - Example of getting placeholder data in razor

GetPLaceholderDataInRazor.cshtml

@using System.Data;
@using Contensis.Framework.Web;
@using Contensis.Framework.Web.Search;
@using Contensis.Core.Utilities.DataAccess;

@{
    var relatedContent = CurrentNode.RelatedNodes();
    var dal = new SqlDataAccess(Contensis.Framework.Web.AppContext.Current.Server.ConnectionString);
}



     
<div class="cycle-slideshow cycle-slideshow-manual"
            data-cycle-fx=parallax
            data-cycle-speed="1600"
            data-cycle-timeout=3000
            data-cycle-pager=".adv-custom-pager"
            data-cycle-pager-template=""
            data-cycle-slides="> div"
            data-cycle-caption-plugin=caption2
            data-cycle-overlay-fx-out="slideUp"
            data-cycle-update-view=0
            data-cycle-overlay-fx-in="slideDown">


	
    @foreach(var relatedNode in relatedContent){
    
        var brandColourClass = relatedNode.Data.MD_BrandColour.ToString().ToLower().Replace(" ","");
        var title = relatedNode.Title;
        var description = relatedNode.Data.Description.ToString();
        var charCount = description.Length; 
        var ellipsis = ""; 
        var desc2 = description;
        if(charCount >= 300) {
            ellipsis = "&hellip;";
            desc2 = description.Substring(0, 300) + ellipsis;
        }
        
        var pageContentId = relatedNode.Data.Property_C_ID;
        var eventImage = dal.GetDataRows("SELECT * FROM website_data_preview.dbo.eventCarouselImage WHERE Property_C_ID = '"+pageContentId+"'");
        
        
            <div class="cycle-slideshow-manual-item">
                @Html.Raw(eventImage[0]["eventImage"].ToString())
                <div class="cycle-overlay @brandColourClass">
                    <h2>@title</h2>
                    <p>@desc2</p>
                    <a href="@relatedNode.Path" class="button buttonArrow">Read more</a>
                </div>
            </div>
    
       
                        
                       
    }  

            <span class="cycle-slideshow-manual-pagerWrapper">
                <span class="cycle-pager-activePointer icon-left-triangle"></span>
                <span class="adv-custom-pager cycle-slideshow-manual-pager cf"> 
                @foreach(var relatedNode in relatedContent){    
                    <a href="#"><img src="@relatedNode.ThumbnailUrl" width="89" height="67" alt=""></a>
                }
                </span>
            </span>

 </div>