public async Task <ActionResult <ResumenStock> > PostResumenStock(ResumenStock resumenStock) { _context.ResumenStock.Add(resumenStock); await _context.SaveChangesAsync(); return(CreatedAtAction("GetResumenStock", new { id = resumenStock.Registro }, resumenStock)); }
public async Task <IActionResult> PutResumenStock(decimal id, ResumenStock resumenStock) { if (id != resumenStock.Registro) { return(BadRequest()); } _context.Entry(resumenStock).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!ResumenStockExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <ResumenStock> > GetByStock([FromQuery] ResumenStock resumenStock) { try { resumenStock.DESPACHO = resumenStock.DESPACHO == null ? "" : resumenStock.DESPACHO; resumenStock.LOTE = resumenStock.LOTE == null ? "" : resumenStock.LOTE; resumenStock.SERIE = resumenStock.SERIE == null ? "" : resumenStock.SERIE; return(await _context.ResumenStock.Where(r => r.CG_DEP == resumenStock.CG_DEP && r.CG_ART.ToUpper() == resumenStock.CG_ART.ToUpper() && r.LOTE.ToUpper() == resumenStock.LOTE.ToUpper() && r.DESPACHO.ToUpper() == resumenStock.DESPACHO.ToUpper() && r.SERIE.ToUpper() == resumenStock.SERIE.ToUpper() ).FirstAsync()); } catch (Exception ex) { return(BadRequest(ex)); } }
public async Task <ActionResult <Stock> > GetByResumenStock([FromQuery] ResumenStock resumenStock) { try { resumenStock.DESPACHO = resumenStock.DESPACHO == null ? "" : resumenStock.DESPACHO; resumenStock.LOTE = resumenStock.LOTE == null ? "" : resumenStock.LOTE; resumenStock.SERIE = resumenStock.SERIE == null ? "" : resumenStock.SERIE; return(await _context.Pedidos.Where(r => r.CG_DEP == resumenStock.CG_DEP && r.CG_ART.ToUpper() == resumenStock.CG_ART.ToUpper() && r.LOTE.ToUpper() == resumenStock.LOTE.ToUpper() && r.DESPACHO.ToUpper() == resumenStock.DESPACHO.ToUpper() && r.SERIE.ToUpper() == resumenStock.SERIE.ToUpper() ).Take(1).OrderByDescending(r => r.REGISTRO).FirstAsync()); } catch (Exception ex) { return(BadRequest(ex)); } }