MerrittMelker

/****** Script for SelectTopNRows command from SSMS  ******/
begin tran
declare @start bigint, @end bigint
--STUFF ([xml], 
SELECT 
	@start = PATINDEX('%calendarLink"%', [xml]),
	@end = PATINDEX('%}%', Substring([xml], PATINDEX('%calendarLink%', [xml]), datalength([xml])))
FROM [cmsContentXml] where  nodeId = 1098

select substring([xml], @start + 14, @end) from cmsContentXml where nodeid = 1098 

MerrittMelker

        private List<ItemViewModel> GetSponsorViewModels()
        {
            var sponsorGuids = JsonSerializer.DeserializeFromString<IList<Guid>>(SelectedSponsorIds);
            var type = TypeResolutionService.ResolveType(SponsorType);
            var sponsorDataItems = DynamicModuleManager.GetManager().GetDataItems(type).Where(x => x.Status == ContentLifecycleStatus.Live && x.Visible && sponsorGuids.Contains(x.Id));
            var sponsorViewModels = new List<ItemViewModel>();
            foreach (var spi in sponsorDataItems)
            {
                spi.GetRelatedItems<Image>("Image");
                sponsorViewModels.Add(new ItemViewModel(spi));

MerrittMelker

using System;
using System.Collections.Generic;
using System.Configuration;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace Tribune
{
    public abstract class Tribune

MerrittMelker

using System.Collections.Generic;
using System.Linq;
using Ks.Sf.Modules.Dynamic;
using Telerik.Sitefinity;
using Telerik.Sitefinity.Data.Events;
using Telerik.Sitefinity.DynamicModules;
using Telerik.Sitefinity.DynamicModules.Events;
using Telerik.Sitefinity.DynamicModules.Model;
using Telerik.Sitefinity.GenericContent.Model;
using Telerik.Sitefinity.Model;

MerrittMelker

@model Ks.Sf.Web.Model.OpaHeaderController.OpaHeaderView

@using Telerik.Sitefinity.Services;
@using Telerik.Sitefinity.Modules.Pages;
@using Telerik.Sitefinity.Frontend.Mvc.Helpers;
@using Ks.Sf.Web.Mvc.Controllers;
@using ServiceStack
@using Telerik.Sitefinity.Frontend.Navigation.Mvc.Models

@{

MerrittMelker

using System.Reflection;
using System.Runtime.InteropServices;
using System.Web;
using Ks.Sf.Web.Bootstrap;
using Telerik.Sitefinity.Frontend.Mvc.Infrastructure.Controllers.Attributes;

[assembly: ControllerContainer]

// General Information about an assembly is controlled through the following 
// set of attributes. Change these attribute values to modify the information

MerrittMelker

using System;
using System.Linq;
using Ks.Sf.Web;
using Ks.Tessitura;
using Telerik.Sitefinity.Model;
using Telerik.Sitefinity.Security.Claims;
using Telerik.Sitefinity.Security.Data;
using Telerik.Sitefinity.Security.Model;

namespace SitefinityWebApp.Providers

MerrittMelker

public ActionResult Sync1()
{
  using (var soapClient = MySoapClient())
  {
    var task = soapClient.Method1Async().ConfigureAwait(false);
    ViewBag.Result = task.GetAwaiter().GetResult();
  }
  return View();
}

MerrittMelker

using System.Web.Mvc;
using Telerik.Sitefinity.Mvc;

namespace Ks.Sf.Web.Mvc.Controllers
{
    [ControllerToolboxItem(Name = "TestDataLoader_MVC", Title = "Test Data Loader",
        SectionName = "Dashboard", CssClass = "sfListitemsIcn sfMvcIcn")]
    public class TestDataLoaderController : Controller
    {
        public ViewResult Index()

MerrittMelker

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using System.Linq;
using System.Linq.Expressions;
using System.ServiceModel;
using System.ServiceModel.Activation;
using Ks.Sf.Config;