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