/// <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); } }