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