public async Task <ICollection <TurmaViewModel> > Listar(TurmaRequest request)
{
var query = new StringBuilder();
query.AppendLine(" SELECT \"Escola\".\"Nome\" AS \"NomeEscola\", \"Turma\".* FROM \"Turma\" ");
query.AppendLine(" INNER JOIN \"Escola\" ON \"Escola\".\"Id\" = \"Turma\".\"EscolaId\" ");
query.AppendLine(" LEFT JOIN \"AlunoTurma\" ON \"AlunoTurma\".\"TurmaId\" = \"Turma\".\"Id\" ");
bool flagWhere = false;
var parameters = new DynamicParameters();
if (request.AlunoId.HasValue)
{
query.AppendLine(" WHERE \"AlunoTurma\".\"AlunoId\" = @alunoId ");
parameters.Add("@alunoId", request.AlunoId, DbType.Guid);
flagWhere = true;
}
if (request.EscolaId.HasValue)
{
if (flagWhere)
{
query.AppendLine(" AND \"EscolaId\" = @escolaId ");
}
else
{
query.AppendLine(" WHERE \"EscolaId\" = @escolaId ");
}
parameters.Add("@escolaId", request.EscolaId, DbType.Guid);
}
var turmas = await this._conexao.QueryAsync <TurmaViewModel>(query.ToString(), parameters);
return(turmas?.ToList());
}
public async Task <List <TurmaViewModel> > Listar(TurmaRequest request)
{
var restRequest = new RestRequest("Turma/Listar", DataFormat.Json);
restRequest.AddJsonBody(request);
return(await this._client.PostAsync <List <TurmaViewModel> >(restRequest));
}
public async Task Create(TurmaRequest request)
{
var results = _validator.Validate(request);
if (!results.IsValid)
{
throw new ValidationException(results.Errors);
}
await _turmaRepository.InsertAsync(_mapper.Map <TurmaEntity>(request));
}
public async Task <IActionResult> Listar([FromBody] TurmaRequest request)
{
return(this.DefaultResponse(await this._turmaApplication.Listar(request)));
}
public async Task <IActionResult> Create([FromServices] ITurmaCreateFacade turmaFacade, TurmaRequest request)
{
await turmaFacade.Create(request);
return(Ok());
}
public async Task <ICollection <TurmaViewModel> > Listar(TurmaRequest request)
{
return(await this._turmaReadRepository.Listar(request));
}
public async Task <IActionResult> Post(TurmaRequest request)
{
var escola = Mapper.Map <Turma>(request);
return(Ok(await TurmaCreator.AddAsync(escola)));
}
public async Task Create(TurmaRequest request)
{
await _turmaService.Create(request);
await _unitOfWork.SaveChangesAsync();
}