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