public async Task <IActionResult> PlanningOfficeGetByIdAsync(int id)
{
var req = new PlanningOfficeGetByIdRequest {
Id = id
};
var result = await _planningOfficeManager.GetPlanningOfficeByIdAsync(req);
return(Ok(result));
}
public async Task <PlanningOfficeGetByIdResponse> GetPlanningOfficeByIdAsync(PlanningOfficeGetByIdRequest req)
{
using (var conn = new SqlConnection(_connectionSettings.DefaultConnection))
{
var result = new PlanningOfficeGetByIdResponse();
const string storeproc = @"[dbo].[uspPlanningOfficeGetById_New]";
await conn.OpenAsync();
var dynParm = new
{
ID = req.Id
};
var rawResult = await conn.QueryAsync <PlanningOfficeDTO>(storeproc, dynParm, null, null, CommandType.StoredProcedure);
result.Data = rawResult.FirstOrDefault();
return(result);
}
}
public async Task <PlanningOfficeGetByIdResponse> GetPlanningOfficeByIdAsync(PlanningOfficeGetByIdRequest req)
{
var result = await _repos.GetPlanningOfficeByIdAsync(req);
return(result);
}
