public int GetInsertedData(AgentExecution agent) { using (var connection = new SqlConnection(_connectionString)) { var sql = "insert into AgentExecution(Command, Result, ExecutionTime) Values(@Command, @Result, @ExecutionTime)"; return(connection.Execute(sql, agent)); } }
public AgentHistoryModule(IAgentDataService agentDataService) { Post["/api/agentHistory"] = p => { AgentExecution agentExecution = this.Bind <AgentExecution>(); if (agentExecution == null) { return(HttpStatusCode.BadRequest); } agentDataService.GetInsertedData(agentExecution); return(HttpStatusCode.OK); }; Get["/api/agentHistory"] = p => { var x = agentDataService.GetExecutedListAgentDetails(); return(Negotiate .WithContentType("aplication/json") .WithModel(x)); }; }