public static void CreateContentViews(DbConnection cnn, int id, bool withUnited = true)
{
var dbType = GetDbType(cnn);
var idStr = id.ToString();
if (dbType == DatabaseType.SqlServer)
{
if (withUnited)
{
var unitedSql = SqlQuerySyntaxHelper.SpCall(dbType, "qp_content_united_view_recreate", idStr);
ExecuteSql(cnn, unitedSql);
}
var feSql = SqlQuerySyntaxHelper.SpCall(dbType, "qp_content_frontend_views_recreate", idStr);
ExecuteSql(cnn, feSql);
}
else
{
if (withUnited)
{
var unitedSql = SqlQuerySyntaxHelper.SpCall(dbType, "qp_content_united_view_create", idStr);
ExecuteSql(cnn, unitedSql);
}
var feSql = SqlQuerySyntaxHelper.SpCall(dbType, "qp_content_frontend_views_create", idStr);
ExecuteSql(cnn, feSql);
var newSql = SqlQuerySyntaxHelper.SpCall(dbType, "qp_content_new_views_create", idStr);
ExecuteSql(cnn, newSql);
}
}
public static void UpdateChildDelayedSchedule(DbConnection connection, int articleId)
{
var databaseType = DatabaseTypeHelper.ResolveDatabaseType(connection);
var sql = SqlQuerySyntaxHelper.SpCall(databaseType, "qp_copy_schedule_to_child_delays", articleId.ToString());
ExecuteSql(connection, sql);
}
public static void DropLinkView(DbConnection connection, ContentToContentDAL item)
{
var dbType = GetDbType(connection);
var spName = dbType == DatabaseType.SqlServer ? "qp_drop_link_view" : "qp_link_view_drop";
var sql = SqlQuerySyntaxHelper.SpCall(dbType, spName, item.LinkId.ToString(CultureInfo.InvariantCulture));
ExecuteSql(connection, sql);
}
public static void CreateArticleVersions(DbConnection connection, int userId, int[] ids)
{
var databaseType = DatabaseTypeHelper.ResolveDatabaseType(connection);
var sql = SqlQuerySyntaxHelper.SpCall(databaseType, "qp_create_content_item_versions", "@ids, @last_modified_by");
using (var cmd = DbCommandFactory.Create(sql, connection))
{
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add(GetIdsDatatableParam("@ids", ids, databaseType));
cmd.Parameters.AddWithValue("@last_modified_by", userId);
cmd.ExecuteNonQuery();
}
}
public static void DropContentViews(DbConnection cnn, int id)
{
var dbType = GetDbType(cnn);
var idStr = id.ToString();
if (dbType != DatabaseType.SqlServer)
{
var newSql = SqlQuerySyntaxHelper.SpCall(dbType, "qp_content_new_views_drop", idStr);
ExecuteSql(cnn, newSql);
var feSql = SqlQuerySyntaxHelper.SpCall(dbType, "qp_content_frontend_views_drop", idStr);
ExecuteSql(cnn, feSql);
var unitedSql = SqlQuerySyntaxHelper.SpCall(dbType, "qp_content_united_view_drop", idStr);
ExecuteSql(cnn, unitedSql);
}
}
public static void RecreateNewViews(DbConnection cnn, int id)
{
var dbType = GetDbType(cnn);
var idStr = id.ToString();
if (dbType == DatabaseType.SqlServer)
{
var recreateSql = SqlQuerySyntaxHelper.SpCall(dbType, "qp_content_frontend_views_recreate", idStr);
ExecuteSql(cnn, recreateSql);
}
else
{
var dropSql = SqlQuerySyntaxHelper.SpCall(dbType, "qp_content_new_views_drop", idStr);
ExecuteSql(cnn, dropSql);
var createSql = SqlQuerySyntaxHelper.SpCall(dbType, "qp_content_new_views_create", idStr);
ExecuteSql(cnn, createSql);
}
}
