private static void UpdateVersionNumber(DataAccessBaseEx dba)
{
var versionSp =
$@"ALTER PROCEDURE [dbo].[bvn_notfoundversion] AS RETURN {Configuration.Configuration.CurrentVersion}";
Valid = dba.ExecuteNonQuery(versionSp);
}
private static bool AddRedirectTypeColumnToRedirectsTable(DataAccessBaseEx dba)
{
Logger.Information("Alter 404 handler redirects table to add RedirectType column START");
var alterTableScript = @"ALTER TABLE [dbo].[404Handler.Redirects]
ADD [RedirectType] int NOT NULL
DEFAULT (301)
WITH VALUES";
var created = dba.ExecuteNonQuery(alterTableScript);
Logger.Information("Alter 404 handler redirects table to add RedirectType column END");
return(created);
}
private static bool CreateSuggestionsTableIndex(DataAccessBaseEx dba)
{
Log.Information("Create suggestions table clustered index START");
var clusteredIndex =
"CREATE CLUSTERED INDEX NotFoundRequests_ID ON [dbo].[BVN.NotFoundRequests] (ID)";
var created = dba.ExecuteNonQuery(clusteredIndex);
if (!created)
{
Log.Error("An error occurred during the creation of the 404 handler redirects clustered index. Canceling.");
}
Log.Information("Create suggestions table clustered index END");
return(created);
}
private static bool CreateVersionNumberSp(DataAccessBaseEx dba)
{
Log.Information("Create 404 handler version SP START");
var versionSp =
$@"CREATE PROCEDURE [dbo].[bvn_notfoundversion] AS RETURN {Configuration.Configuration.CurrentVersion}";
var created = dba.ExecuteNonQuery(versionSp);
if (!created)
{
Log.Error("An error occured during the creation of the 404 handler version stored procedure. Canceling.");
}
Log.Information("Create 404 handler version SP END");
return(created);
}
private static bool CreateRedirectsTable(DataAccessBaseEx dba)
{
Log.Information("Create 404 handler redirects table START");
var createTableScript = @"CREATE TABLE [dbo].[404Handler.Redirects](
[Id] [uniqueidentifier] NOT NULL,
[OldUrl] [nvarchar](2000) NOT NULL,
[NewUrl] [nvarchar](2000) NOT NULL,
[State] [int] NOT NULL,
[WildCardSkipAppend] [bit] NOT NULL,
CONSTRAINT [PK_404HandlerRedirects] PRIMARY KEY CLUSTERED ([Id] ASC) ON [PRIMARY]
) ON [PRIMARY]";
var created = dba.ExecuteNonQuery(createTableScript);
Log.Information("Create 404 handler redirects table END");
return(created);
}
private static bool CreateSuggestionsTable(DataAccessBaseEx dba)
{
Log.Information("Create 404 handler suggestions table START");
var createTableScript = @"CREATE TABLE [dbo].[BVN.NotFoundRequests](
[ID] [int] IDENTITY(1,1) NOT NULL,
[OldUrl] [nvarchar](2000) NOT NULL,
[Requested] [datetime] NULL,
[Referer] [nvarchar](2000) NULL
) ON [PRIMARY]";
var created = dba.ExecuteNonQuery(createTableScript);
Log.Information("Create 404 handler suggestions table END");
if (created)
{
created = CreateSuggestionsTableIndex(dba);
}
return(created);
}