public ActionResult DeleteConfirmed(int id)
{
TBL_STOCK tBL_STOCK = db.TBL_STOCK.Find(id);
db.TBL_STOCK.Remove(tBL_STOCK);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "ID_STOCK,STOCK,PEDIDO,COMPROMETIDO,ID_PRODUCT,ID_ALMAC,ULTIMA_FECHA_ACTUALIZACION")] TBL_STOCK tBL_STOCK)
{
if (ModelState.IsValid)
{
db.Entry(tBL_STOCK).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ID_ALMAC = new SelectList(db.TBL_ALMACENES, "ID_ALMACEN", "NOM_ALMACEN", tBL_STOCK.ID_ALMAC);
ViewBag.ID_PRODUC = new SelectList(db.TBL_PRODUCTOS, "ID_PRODUCTO", "DESCRIPCION", tBL_STOCK.ID_PRODUC);
return(View(tBL_STOCK));
}
public ActionResult Edit([Bind(Include = "ID_DETALLE,CANTIDAD")] TBL_DETALLE_LOTE tBL_DETALLE_LOTE)
{
var original = db.TBL_DETALLE_LOTE.AsNoTracking().Where(x => x.ID_DETALLE == tBL_DETALLE_LOTE.ID_DETALLE).ToList();
if (original.Count > 0)
{
tBL_DETALLE_LOTE.ID_LOTE = original[0].ID_LOTE;
tBL_DETALLE_LOTE.FECHA_REGISTRO = DateTime.Now;
tBL_DETALLE_LOTE.DISPONIBLE = false;
tBL_DETALLE_LOTE.VEDIDOS = original[0].VEDIDOS;
tBL_DETALLE_LOTE.ID_USER_ASP = HttpContext.User.Identity.Name;
//tBL_DETALLE_LOTE.TBL_LOTE_PRODUCCION = original[0].TBL_LOTE_PRODUCCION;
if (ModelState.IsValid)
{
db.Entry(tBL_DETALLE_LOTE).State = EntityState.Modified;
//se general carga la entrada de mercancia en la tabla STOCK
var idProducto = (db.TBL_LOTE_PRODUCCION.AsNoTracking().Where(x => x.ID_LOTE == tBL_DETALLE_LOTE.ID_LOTE).Select(x => x.ID_PRODUC).ToList());
int idAlmacen = 2;
string produc = idProducto[0];
var originalStock = (db.TBL_STOCK.Where(x => x.ID_PRODUC.Equals(produc)).Where(x => x.ID_ALMAC == idAlmacen)).ToList();
if (originalStock.Count == 0)
{
TBL_STOCK nuevoStock = new TBL_STOCK()
{
ID_PRODUC = produc, ID_ALMAC = idAlmacen, STOCK = tBL_DETALLE_LOTE.CANTIDAD, PEDIDO = 0, COMPROMETIDO = 0, ULTIMA_FECHA_ACTUALIZACION = DateTime.Now
};
db.TBL_STOCK.Add(nuevoStock);
db.SaveChanges();
}
else if (originalStock.Count == 1)
{
originalStock[0].STOCK += tBL_DETALLE_LOTE.CANTIDAD;
//db.Entry(originalStock[0]).State = EntityState.Modified;
db.SaveChanges();
}
else
{
TempData["Mensaje"] = "<div class=\"alert alert-danger\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button><strong>No se pudo generar STOCK, favor de intentarlo de nuevo..</strong> </div>";
return(RedirectToAction("Index", "Lote"));
}
TempData["Mensaje"] = "<div class=\"alert alert-success\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button><strong>STOCK del LOTE generado exitosamente.</strong> </div>";
return(RedirectToAction("Index", "Lote"));
}
TempData["Mensaje"] = "<div class=\"alert alert-danger\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button><strong>No se pudo generar STOCK, favor de intentarlo de nuevo.</strong> </div>";
return(RedirectToAction("Index", "Lote"));
}
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
// GET: Stock/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TBL_STOCK tBL_STOCK = db.TBL_STOCK.Find(id);
if (tBL_STOCK == null)
{
return(HttpNotFound());
}
return(View(tBL_STOCK));
}
// GET: Stock/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TBL_STOCK tBL_STOCK = db.TBL_STOCK.Find(id);
if (tBL_STOCK == null)
{
return(HttpNotFound());
}
ViewBag.ID_ALMAC = new SelectList(db.TBL_ALMACENES, "ID_ALMACEN", "NOM_ALMACEN", tBL_STOCK.ID_ALMAC);
ViewBag.ID_PRODUC = new SelectList(db.TBL_PRODUCTOS, "ID_PRODUCTO", "DESCRIPCION", tBL_STOCK.ID_PRODUC);
return(View(tBL_STOCK));
}
public ActionResult Create([Bind(Include = "ID_PRODUC,STOCK,ID_ALMAC")] TBL_STOCK tBL_STOCK)
{
List <string> id_product = db.TBL_PRODUCTOS.Where(x => x.DESCRIPCION.Equals(tBL_STOCK.ID_PRODUC)).Where(x => x.ESTATUS == true).Select(x => x.ID_PRODUCTO).ToList();
if (id_product.Count == 1)
{
if (tBL_STOCK.STOCK == null)
{
ViewBag.ID_ALMAC = new SelectList(db.TBL_ALMACENES, "ID_ALMACEN", "NOM_ALMACEN", tBL_STOCK.ID_ALMAC);
ViewBag.ID_PRODUC = new SelectList(db.TBL_PRODUCTOS, "ID_PRODUCTO", "DESCRIPCION", tBL_STOCK.ID_PRODUC);
ViewBag.Confirma = "<div class=\"alert alert-danger\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button><strong>El STOCK no fue ingresado.</strong> </div>";
return(View(tBL_STOCK));
}
tBL_STOCK.ID_PRODUC = id_product.ToArray()[0];
var valida = db.TBL_STOCK.AsNoTracking().Where(x => x.ID_PRODUC.Equals(tBL_STOCK.ID_PRODUC)).Where(x => x.ID_ALMAC.Equals(tBL_STOCK.ID_ALMAC)).ToList();
if (valida.Count() == 0 && valida != null)
{
tBL_STOCK.COMPROMETIDO = 0;
tBL_STOCK.PEDIDO = 0;
tBL_STOCK.ULTIMA_FECHA_ACTUALIZACION = DateTime.Now;
if (ModelState.IsValid)
{
db.TBL_STOCK.Add(tBL_STOCK);
db.SaveChanges();
ViewBag.ID_ALMAC = new SelectList(db.TBL_ALMACENES, "ID_ALMACEN", "NOM_ALMACEN", tBL_STOCK.ID_ALMAC);
ViewBag.ID_PRODUC = new SelectList(db.TBL_PRODUCTOS, "ID_PRODUCTO", "DESCRIPCION", tBL_STOCK.ID_PRODUC);
ViewBag.Confirma = "<div class=\"alert alert-success\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button><strong>Stock GENERADO exitosamente.</strong> </div>";
return(View(tBL_STOCK));
}
}
else if (valida.Count() == 1)
{
tBL_STOCK.COMPROMETIDO = 0;
tBL_STOCK.PEDIDO = 0;
tBL_STOCK.ID_ALMAC = (int)valida[0].ID_ALMAC;
tBL_STOCK.ID_PRODUC = valida[0].ID_PRODUC.ToString();
tBL_STOCK.ULTIMA_FECHA_ACTUALIZACION = DateTime.Now;
tBL_STOCK.STOCK = tBL_STOCK.STOCK + (int)valida[0].STOCK;
tBL_STOCK.ID_STOCK = (int)valida[0].ID_STOCK;
db.Entry(tBL_STOCK).State = EntityState.Modified;
db.SaveChanges();
ViewBag.ID_ALMAC = new SelectList(db.TBL_ALMACENES, "ID_ALMACEN", "NOM_ALMACEN", tBL_STOCK.ID_ALMAC);
ViewBag.ID_PRODUC = new SelectList(db.TBL_PRODUCTOS, "ID_PRODUCTO", "DESCRIPCION", tBL_STOCK.ID_PRODUC);
ViewBag.Confirma = "<div class=\"alert alert-success\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button><strong>Stock AGREGADO exitosamente.</strong> </div>";
return(View(tBL_STOCK));
}
else
{
ViewBag.ID_ALMAC = new SelectList(db.TBL_ALMACENES, "ID_ALMACEN", "NOM_ALMACEN", tBL_STOCK.ID_ALMAC);
ViewBag.ID_PRODUC = new SelectList(db.TBL_PRODUCTOS, "ID_PRODUCTO", "DESCRIPCION", tBL_STOCK.ID_PRODUC);
ViewBag.Confirma = "<div class=\"alert alert-danger\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button><strong>Error al procesar la solicitud.</strong> </div>";
return(View(tBL_STOCK));
}
}
ViewBag.ID_ALMAC = new SelectList(db.TBL_ALMACENES, "ID_ALMACEN", "NOM_ALMACEN", tBL_STOCK.ID_ALMAC);
ViewBag.ID_PRODUC = new SelectList(db.TBL_PRODUCTOS, "ID_PRODUCTO", "DESCRIPCION", tBL_STOCK.ID_PRODUC);
ViewBag.Confirma = "<div class=\"alert alert-danger\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button><strong>El producto no existe en la base de datos.</strong> </div>";
return(View(tBL_STOCK));
}
