/// <inheritdoc/>
public bool SaveToLog(ILoggerEntry loggerEntry)
{
try
{
SetColumnNames(loggerEntry);
var query = $"INSERT INTO {Settings.LogSqlTable} " +
$"({columnNames["LogDate"]}, {columnNames["LogTag"]}, {columnNames["LogMessage"]}, {columnNames["LogSeverity"]}) " +
"VALUES (@LogDate, @LogTag, @LogMessage, @LogSeverity)";
parameters.Add(new SqlParameter("@LogDate", SqlDbType.DateTime2)
{
Value = loggerEntry.Timestamp
});
parameters.Add(new SqlParameter("@LogTag", SqlDbType.VarChar)
{
Value = loggerEntry.Tag
});
parameters.Add(new SqlParameter("@LogMessage", SqlDbType.VarChar)
{
Value = loggerEntry.Message
});
parameters.Add(new SqlParameter("@LogSeverity", SqlDbType.Int)
{
Value = loggerEntry.Severity
});
return(sql.ExecuteNonQuery(query, parameters) == 1);
}
catch
{
return(false);
}
}
private void Delete(object id)
{
ApiConfiguration apiConfiguration = RouteData.DataTokens["apiConfiguration"] as ApiConfiguration;
RouteConfiguration route = RouteData.DataTokens["routeConfiguration"] as RouteConfiguration;
ActionConfiguration action = RouteData.DataTokens["actionConfiguration"] as ActionConfiguration;
if (route.Enabled && action.Enabled)
{
string sqlQuery = ControllerService.GetStringReplacedQuery(Request, route, action, id);
SqlServerService sqlServerService = new SqlServerService(apiConfiguration.ConnectionString, route);
sqlServerService.ExecuteNonQuery(sqlQuery);
}
}
public void Post()
{
ApiConfiguration apiConfiguration = RouteData.DataTokens["apiConfiguration"] as ApiConfiguration;
RouteConfiguration route = RouteData.DataTokens["routeConfiguration"] as RouteConfiguration;
ActionConfiguration action = RouteData.DataTokens["actionConfiguration"] as ActionConfiguration;
if (route.Enabled && action.Enabled)
{
string json;
using (StreamReader streamReader = new StreamReader(Request.Body))
{
json = streamReader.ReadToEnd();
}
string sqlQuery = ControllerService.GetStringReplacedQuery(Request, route, action, json);
SqlServerService sqlServerService = new SqlServerService(apiConfiguration.ConnectionString, route);
sqlServerService.ExecuteNonQuery(sqlQuery);
}
}
