// GET: Stock_items/Edit/5
        public ActionResult Edit(int?id)
        {
            if (Session["IDusuario"] != null)
            {
                int ID           = Convert.ToInt32(Session["IDusuario"]);
                var datosUsuario = (from c in db.Usuarios where (c.ID_usuario == ID) select c).FirstOrDefault();

                ViewBag.usuario       = datosUsuario.correo;
                ViewBag.nomusuarioSAP = datosUsuario.Empresas.nombre;



                if (id == null)
                {
                    return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
                }
                Stock_items stock_items = db.Stock_items.Find(id);
                if (stock_items == null)
                {
                    return(RedirectToAction("Index"));
                }

                ViewBag.itemCode = new SelectList(COM_MKdb.OITM.Where(x => x.ItmsGrpCod == 108 || x.ItmsGrpCod == 107).OrderBy(x => x.ItemName), "ItemCode", "ItemName", id);
                return(View(stock_items));
            }
            else
            {
                return(RedirectToAction("Index", "Home"));
            }
        }
        // GET: Stock_items/Delete/5
        public ActionResult Delete(int?id)
        {
            if (Session["IDusuario"] != null)
            {
                int ID           = Convert.ToInt32(Session["IDusuario"]);
                var datosUsuario = (from c in db.Usuarios where (c.ID_usuario == ID) select c).FirstOrDefault();

                ViewBag.usuario       = datosUsuario.correo;
                ViewBag.nomusuarioSAP = datosUsuario.Empresas.nombre;

                if (id == null)
                {
                    return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
                }
                Stock_items stock_items = db.Stock_items.Find(id);
                if (stock_items == null)
                {
                    return(RedirectToAction("Index"));
                }
                return(View(stock_items));
            }
            else
            {
                return(RedirectToAction("Index", "Home"));
            }
        }
        public ActionResult DeleteConfirmed(int id)
        {
            Stock_items stock_items = db.Stock_items.Find(id);

            db.Stock_items.Remove(stock_items);
            db.SaveChanges();
            TempData["exito"] = "Stock receipt deleted successfully.";
            return(RedirectToAction("Index"));
        }
        // GET: Stock_items/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            Stock_items stock_items = db.Stock_items.Find(id);

            if (stock_items == null)
            {
                return(HttpNotFound());
            }
            return(View(stock_items));
        }
        public ActionResult Edit([Bind(Include = "ID_stock,itemCode,itemName,quantity,odate,ID_usuario,comment")] Stock_items stock_items)
        {
            int ID = Convert.ToInt32(Session["IDusuario"]);

            stock_items.ID_usuario = ID.ToString();
            stock_items.odate      = DateTime.UtcNow;
            stock_items.comment    = stock_items.comment + " - " + "PROVIENE DE MODULO INVENTARIO";
            if (ModelState.IsValid)
            {
                db.Entry(stock_items).State = EntityState.Modified;
                db.SaveChanges();
                TempData["exito"] = "Stock receipt saved successfully.";
                return(RedirectToAction("Index"));
            }
            return(View(stock_items));
        }