public async Task <IActionResult> ZoneAreaGetByIdAsync(int id) { var req = new ZoneAreaGetByIdRequest { Id = id }; var result = await _zoneAreaManager.GetZoneAreaByIdAsync(req); return(Ok(result)); }
public async Task <ZoneAreaGetByIdResponse> GetZoneAreaByIdAsync(ZoneAreaGetByIdRequest req) { using (var conn = new SqlConnection(_connectionSettings.DefaultConnection)) { var result = new ZoneAreaGetByIdResponse(); const string storeproc = @"[dbo].[uspAreasGetById_New]"; await conn.OpenAsync(); var dynParm = new { ID = req.Id }; var rawResult = await conn.QueryAsync <ZoneAreaDTO>(storeproc, dynParm, null, null, CommandType.StoredProcedure); result.Data = rawResult.FirstOrDefault(); return(result); } }
public async Task <ZoneAreaGetByIdResponse> GetZoneAreaByIdAsync(ZoneAreaGetByIdRequest req) { var result = await _repos.GetZoneAreaByIdAsync(req); return(result); }