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