private static void UpdateTestStartDate(int dayspan, string dbName)
{
var connectionString = Settings.GetConnectionString(dbName);
var dataApi = new Sitecore.Data.SqlServer.SqlServerDataApi(connectionString);
const string sql = "EXEC [dbo].[sp_sc_Update_TestStartDate] @testItemID='{0}', @dayspan={1};";
var db = Sitecore.Configuration.Factory.GetDatabase(dbName);
var testsRoot = db.GetItem(ItemIDs.Analytics.MarketingCenter.TestLaboratory);
var tests =
testsRoot.Axes.GetDescendants()
.Where(x => x.TemplateID == new ID("{45FB02E9-70B3-4CFE-8050-06EAD4B5DB3E}")); // Tests
foreach (var test in tests)
{
var command = string.Format(sql, test.ID.Guid, dayspan);
dataApi.ExecuteNoResult(command);
using (new EditContext(test, false, false))
{
var dateStr = test.Fields["__Updated"].Value;
var date = DateUtil.ParseDateTime(dateStr, DateTime.MinValue);
date = date.AddDays(dayspan);
var updateddateStr = DateUtil.ToIsoDate(date);
test.Fields["__Updated"].Value = updateddateStr;
}
}
}
private static void RefreshSqlAnalytics(DateTime lastUpdate)
{
var connectionString = Settings.GetConnectionString("reporting");
var dataApi = new Sitecore.Data.SqlServer.SqlServerDataApi(connectionString);
const string sql = "EXEC [dbo].[sp_sc_Refresh_Analytics] {2}lastUpdate{3};";
dataApi.Execute(sql, new object[] { "lastUpdate", lastUpdate });
}
