public async Task <List <PrPromocionCuponesDTO> > Handle(ListCupomQuery request, CancellationToken cancellationToken)
{
return(await _contextService.GetContextInitials(request.Ambiente)
.PrPromocionCupones
.ProjectTo <PrPromocionCuponesDTO>(_mapper.ConfigurationProvider)
.ToListAsync());
}
public async Task <List <PareportAtlas> > Handle(GetPareportQuery request, CancellationToken cancellationToken)
{
var where = (request.Inicio == request.Fim ? null : " Where ") + (request.Inicio == null ? null : "Dt_Emissao >= '" + request.Inicio + "' ") + (request.Inicio != null && request.Fim != null ? "AND " : null) + (request.Fim == null ? null : "Dt_Emissao < '" + request.Fim + "'");
List <PareportAtlas> resultado = new List <PareportAtlas>();
foreach (var ambiente in request.Ambientes)
{
var pagination = "";
if (request.Page.HasValue && request.PageSize.HasValue)
{
if (resultado.Count >= request.PageSize.Value)
{
break;
}
pagination = " Order by Dt_Emissao OFFSET " + request.PageSize.Value * (request.Page.Value - 1) + " ROWS FETCH NEXT " + (request.PageSize.Value - resultado.Count) + " ROWS ONLY";
}
var context = contextService.GetContextInitials(ambiente);
var retorno = await context.PareportAtlas.FromSqlRaw("Select * from dbo.PareportAtlas" + where + pagination).ToListAsync();
resultado.AddRange(retorno);
}
return(resultado);
}
public async Task <Unit> Handle(CreateCupomCommand request, CancellationToken cancellationToken)
{
var context = _contextService.GetContextInitials(request.Ambiente);
context.PrPromocionCupones.Update(_mapper.Map <PrPromocionCuponesDTO, PrPromocionCupones>(request.Cupom));
await context.SaveChangesAsync(cancellationToken);
return(Unit.Value);
}
public async Task <Unit> Handle(DeleteCupomCommand request, CancellationToken cancellationToken)
{
var context = contextService.GetContextInitials(request.Ambiente);
var prPromocionCupones = await context.PrPromocionCupones.FindAsync(request.Id);
context.PrPromocionCupones.Remove(prPromocionCupones);
await context.SaveChangesAsync(cancellationToken);
return(Unit.Value);
}
public async Task <int> Handle(CreateCupomCommand request, CancellationToken cancellationToken)
{
var context = _contextService.GetContextInitials(request.Ambiente);
var cupom = _mapper.Map <PrPromocionCupones>(request.Cupom);
context.PrPromocionCupones.Add(cupom);
await context.SaveChangesAsync(cancellationToken);
return(cupom.IdCuponesPromocion);
}
public async Task <bool> CupomExists(DeleteCupomCommand request, CancellationToken cancellationToken)
{
var context = contextService.GetContextInitials(request.Ambiente);
var prPromocionCupones = await context.PrPromocionCupones.FindAsync(request.Id);
if (prPromocionCupones == null)
{
return(false);
}
return(true);
}
public async Task <PrPromocionCuponesDTO> Handle(GetCupomQuery request, CancellationToken cancellationToken)
{
return(_mapper.Map <PrPromocionCuponesDTO>(await _contextService.GetContextInitials(request.Ambiente).PrPromocionCupones
.FindAsync(request.Id)));
}
