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