public static GetUrlTrackerTableExists ( ) : bool | ||
return | bool |
public static void UpdateUrlTrackerTable() { if (UrlTrackerRepository.GetUrlTrackerTableExists()) { var folderName = GetFolderName(); for (var i = 1; i <= 3; i++) { var alreadyAdded = false; if (DatabaseProvider == DatabaseProviders.SqlServerCE) { //Check if columns exists var query = EmbeddedResourcesHelper.GetString(string.Concat(folderName, "check-table-" + i + ".sql")); if (!string.IsNullOrEmpty(query)) { var ex = ApplicationContext.Current.DatabaseContext.Database.ExecuteScalar <int?>(query); alreadyAdded = ex == 1; } } if (!alreadyAdded) { var query = EmbeddedResourcesHelper.GetString(string.Concat(folderName, "update-table-" + i + ".sql")); if (!string.IsNullOrEmpty(query)) { ApplicationContext.Current.DatabaseContext.Database.Execute(query); } } } } }
public static void UpdateUrlTrackerTable() { if (UrlTrackerRepository.GetUrlTrackerTableExists()) { string updateTableQuery = EmbeddedResourcesHelper.GetString("InfoCaster.Umbraco.UrlTracker.SQL.update-table-1.sql"); _sqlHelper.ExecuteNonQuery(updateTableQuery); updateTableQuery = EmbeddedResourcesHelper.GetString("InfoCaster.Umbraco.UrlTracker.SQL.update-table-2.sql"); _sqlHelper.ExecuteNonQuery(updateTableQuery); } }
public static void CreateUrlTrackerTable() { if (UrlTrackerRepository.GetUrlTrackerTableExists()) { throw new Exception("Table already exists."); } var folderName = GetFolderName(); var createTableQuery = EmbeddedResourcesHelper.GetString(string.Concat(folderName, "create-table-1.sql")); _sqlHelper.ExecuteNonQuery(createTableQuery); }
public static void CreateUrlTrackerTable() { if (UrlTrackerRepository.GetUrlTrackerTableExists()) { throw new Exception("Table already exists."); } string createTableQuery = EmbeddedResourcesHelper.GetString("InfoCaster.Umbraco.UrlTracker.SQL.create-table-1.sql"); _sqlHelper.ExecuteNonQuery(createTableQuery); createTableQuery = EmbeddedResourcesHelper.GetString("InfoCaster.Umbraco.UrlTracker.SQL.create-table-2.sql"); _sqlHelper.ExecuteNonQuery(createTableQuery); }
public static void UpdateUrlTrackerTable() { if (UrlTrackerRepository.GetUrlTrackerTableExists()) { var folderName = GetFolderName(); for (var i = 1; i <= 3; i++) { var alreadyAdded = false; if (DatabaseProvider == DatabaseProviders.SqlServerCE) { //Check if columns exists var query = EmbeddedResourcesHelper.GetString(string.Concat(folderName, "check-table-" + i + ".sql")); if (!string.IsNullOrEmpty(query)) { var reader = _sqlHelper.ExecuteReader(query); while (reader.Read()) { alreadyAdded = true; } } } if (!alreadyAdded) { var query = EmbeddedResourcesHelper.GetString(string.Concat(folderName, "update-table-" + i + ".sql")); if (!string.IsNullOrEmpty(query)) { _sqlHelper.ExecuteNonQuery(query); } } } } }