public void LogRequestToDb(string oldUrl, string referer, DateTime now)
{
Database.Execute<bool>(() =>
{
string sqlCommand = "INSERT INTO [dbo].[BVN.NotFoundRequests] (" +
"Requested, OldUrl, " +
"Referer" +
") VALUES (" +
"@requested, @oldurl, " +
"@referer" +
")";
try
{
// base.Database.Connection.Open();
// this.OpenConnection();
IDbCommand command = this.CreateCommand();
var requstedParam = this.CreateParameter("requested", DbType.DateTime, 0);
requstedParam.Value = now;
var refererParam = this.CreateParameter("referer", DbType.String, 4000);
refererParam.Value = referer;
var oldUrlParam = this.CreateParameter("oldurl", DbType.String, 4000);
oldUrlParam.Value = oldUrl;
command.Parameters.Add(requstedParam);
command.Parameters.Add(refererParam);
command.Parameters.Add(oldUrlParam);
command.CommandText = sqlCommand;
command.CommandType = CommandType.Text;
command.Connection = base.Database.Connection;
command.ExecuteNonQuery();
}
catch (Exception ex)
{
Logger.Error("An error occured while logging a 404 handler error. Ex:" + ex);
}
finally
{
// base.Database.Connection.Close();
}
return true;
});
}