public async Task <ActionResult <ResultResponse> > InsertAsync([FromServices] IInsertOccupationUseCaseAsync updateOccupation,
[FromBody] OccupationRequest request)
{
var result = await updateOccupation.RunAsync(request);
return(Created("api/v1/occupation", result));
}
public async Task <ResultResponse> RunAsync(OccupationRequest request)
{
var result = await _unitOfWork.OccupationRepository.InsertAsync(request);
_unitOfWork.Transaction();
return(result);
}
public async Task <ResultResponse> InsertAsync(OccupationRequest request)
{
var query = $"INSERT INTO Occupation (LEVEL_OCCUPATION, NOM_OCCUPATION) VALUES('{request.LevelOccupation}','{request.NameOccupation}')";
var result = await _dbConnection.QueryAsync(query, null, _dbTransaction);
return(new ResultResponse {
Data = result, Message = "Insert success", Success = true
});
}
