public async Task <Unit> Handle(DeleteMaestroDataCommand request, CancellationToken cancellationToken) { TMaestro obsM = _context.TMaestro.Find(request.CodTabla, request.CodMaestro); obsM.Estado = false; _context.TMaestro.Update(obsM); await _context.SaveChangesAsync(cancellationToken); return(Unit.Value); }
public async Task <int> Handle(UpdateMaestroDataCommand request, CancellationToken cancellationToken) { TMaestro obsM = _context.TMaestro.Find(request.CodTabla, request.CodMaestro); if (obsM == null || obsM.Estado == false) { throw new NotFoundException(request.CodTabla, request.CodMaestro); } obsM.Descripcion = request.Descripcion; _context.TMaestro.Update(obsM); await _context.SaveChangesAsync(cancellationToken); return(0); }
public async Task <int> Handle(CreateMaestroDataCommand request, CancellationToken cancellationToken) { TMaestro obsM = _mapper.Map <TMaestro>(request); var maxCod = _context.TMaestro.Where(t => t.CodTabla.Equals("ControlCriticoPF")).Max(m => m.CodTipo); if (maxCod == null) { maxCod = "CCPF0000001"; } else { int id = int.Parse(maxCod.Substring(4, 7)) + 1; maxCod = "CCPF" + id.ToString("D7"); } obsM.CodTipo = maxCod; _context.TMaestro.Add(obsM); await _context.SaveChangesAsync(cancellationToken); return(0); }