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