public PartialViewResult crearInvent([Bind(Include = "ID_ALMACEN")] TBL_INVENTARIOS tBL_INVENTARIOS) { try { tBL_INVENTARIOS.FECHA = DateTime.Now; tBL_INVENTARIOS.ESTATUS = true; tBL_INVENTARIOS.ID_USER_ASP = HttpContext.User.Identity.Name; var valida = db.TBL_INVENTARIOS.Where(x => x.ID_ALMACEN == tBL_INVENTARIOS.ID_ALMACEN && x.ESTATUS == true).ToList(); if (ModelState.IsValid && valida.Count() == 0) { db.TBL_INVENTARIOS.Add(tBL_INVENTARIOS); db.SaveChanges(); ViewBag.ID_ALMACEN = new SelectList(db.TBL_ALMACENES.Where(x => x.ESTATUS == true), "ID_ALMACEN", "NOM_ALMACEN"); ViewBag.Mensaje = "<div class=\"alert alert-success\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button><strong>Nuevo inventario generado exitosamente.</strong> </div>"; return(PartialView("_nuevoInvent")); } else { ViewBag.ID_ALMACEN = new SelectList(db.TBL_ALMACENES.Where(x => x.ESTATUS == true), "ID_ALMACEN", "NOM_ALMACEN"); ViewBag.Mensaje = "<div class=\"alert alert-warning\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button><strong>No se ha cerrado otro inventario sobre este almacenn</strong> </div>"; return(PartialView("_nuevoInvent")); } } catch (Exception) { ViewBag.ID_ALMACEN = new SelectList(db.TBL_ALMACENES.Where(x => x.ESTATUS == true), "ID_ALMACEN", "NOM_ALMACEN"); ViewBag.Mensaje = "<div class=\"alert alert-danger\"><button type=\"button\" class=\"close\" data-dismiss=\"alert\">×</button><strong>Error al generar Nuevo Inventario, favor de intentar de nuevo.</strong> </div>"; return(PartialView("_nuevoInvent")); } }
public ActionResult DeleteConfirmed(int id) { TBL_INVENTARIOS tBL_INVENTARIOS = db.TBL_INVENTARIOS.Find(id); db.TBL_INVENTARIOS.Remove(tBL_INVENTARIOS); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create([Bind(Include = "ID_INVENTARIO,FECHA,OBSERVACIONES,ESTATUS,ID_ALMACEN,ID_USER_ASP")] TBL_INVENTARIOS tBL_INVENTARIOS) { if (ModelState.IsValid) { db.TBL_INVENTARIOS.Add(tBL_INVENTARIOS); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tBL_INVENTARIOS)); }
public ActionResult Edit([Bind(Include = "ID_INVENTARIO,OBSERVACIONES")] TBL_INVENTARIOS tBL_INVENTARIOS) { var original = db.TBL_INVENTARIOS.Find(tBL_INVENTARIOS.ID_INVENTARIO); original.OBSERVACIONES = tBL_INVENTARIOS.OBSERVACIONES; if (ModelState.IsValid) { db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tBL_INVENTARIOS)); }
// GET: Inventarios/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } TBL_INVENTARIOS tBL_INVENTARIOS = db.TBL_INVENTARIOS.Find(id); if (tBL_INVENTARIOS == null) { return(HttpNotFound()); } return(View(tBL_INVENTARIOS)); }
public ActionResult CargaInventario() { //Creamos variable alm para almacenar el id_almacen que se le asigno al usuario. usamos USING para recuperar dicho almacen del usuario int idAlm; using (ApplicationDbContext user = new ApplicationDbContext()) { idAlm = user.Users.AsNoTracking().Where(x => x.UserName.Equals(HttpContext.User.Identity.Name)).Select(x => x.ID_ALMACEN).ToArray()[0]; } var inventActivo = db.TBL_INVENTARIOS.AsNoTracking().Where(x => x.ID_ALMACEN == idAlm && x.ESTATUS == true).ToList(); if (inventActivo.Count == 1) { TBL_INVENTARIOS tBL_INVENTARIOS = db.TBL_INVENTARIOS.Find(inventActivo[0].ID_INVENTARIO); return(View("CargaInventario", tBL_INVENTARIOS)); //return View("CargaInventario",db.TBL_DETALLES_INVENT.Where( x => x.ID_INVENTARIO == inventActivo[0].ID_INVENTARIO).ToList()); } else { return(RedirectToAction("Index", "Home")); } }