public async Task <long> Get()
{
decimal result = 0;
string status = "OK";
long start = DateTimeOffset.Now.ToUnixTimeMilliseconds();
long end = 0;
await QueryMapper
.OnError(ex => status = ex.Message)
.ExecuteReader("EXEC dbo.report 7", reader => {
result = reader.GetDecimal(0);
end = DateTimeOffset.Now.ToUnixTimeMilliseconds();
});
//return "{\"x\":\"" + DateTime.Now.ToUniversalTime().ToString() + "\",\"y\":" + (end - start) + ",\"start\":" + start + ",\"end\":" + end + ",\"result\":" + result + ",\"status\":\"" + status + "\"}";
return(end - start);
}
public static async Task <HttpResponseMessage> CreateSqlResponse(
this HttpRequestMessage req,
IQueryMapper mapper,
SqlCommand sql
)
{
var httpStatus = HttpStatusCode.OK;
string body = await mapper
.OnError(ex => { httpStatus = HttpStatusCode.InternalServerError; })
.GetStringAsync(sql);
return(new HttpResponseMessage()
{
Content = new StringContent(body), StatusCode = httpStatus
});
}
