public async Task <IEnumerable <GetProjectByAccountIDResponseDTO> > GetProjectByAccountId(GetProjectByAccountIdRequestDTO getProjectByAccountIdRequestDTO)
{
try
{
return(await _unitOfWokDapper.ProjectQueries.GetProjectByAccountId(getProjectByAccountIdRequestDTO));
}
catch (Exception ex)
{
_logger.LogExceptionError(ex.ToString());
throw ex;
}
}
public async Task <IEnumerable <GetProjectByAccountIDResponseDTO> > GetProjectByAccountId(GetProjectByAccountIdRequestDTO getProjectByAccountIdRequestDTO)
{
var query = @$ "
SELECT P.*
FROM Project P
WHERE UserId = @AccountId
AND IsActive = @IsActive";
DynamicParameters param = new DynamicParameters();
param.Add("@AccountId", getProjectByAccountIdRequestDTO.AccountId);
param.Add("@IsActive", true);
return(await _db.QueryAsync <GetProjectByAccountIDResponseDTO>(sql : query, param : param, commandType : CommandType.Text));
}
public async Task <IEnumerable <GetProjectByAccountIDResponseDTO> > GetProjectByAccountId(GetProjectByAccountIdRequestDTO getProjectByAccountIdRequestDTO)
{
return(await _projectService.GetProjectByAccountId(getProjectByAccountIdRequestDTO));
}
