public IHttpActionResult GetLast(string meter) { if (GetRoles == string.Empty || User.IsInRole(GetRoles)) { try { using (AdoDataConnection connection = new AdoDataConnection(Connection)) { IEnumerable <MiMDDailyStatistic> result = new TableOperations <MiMDDailyStatistic>(connection).QueryRecordsWhere("Meter = {0}", meter); MiMDDailyStatistic statistic = null; if (result.Any()) { statistic = result.OrderBy(x => x.Date).Last(); } return(Ok(statistic)); } } catch (Exception ex) { return(InternalServerError(ex)); } } else { return(Unauthorized()); } }