public JsonResult DeleteItem(location_has_item modal) { location_has_item dbItem = db.location_has_item.Find(modal.ID); var currentSessionUser = Convert.ToString(HttpContext.Session["UserID"]); if (dbItem == null) { return(Json(new ResultJson { Success = false, Message = "Item Doesnt Fınd !" })); } try { db.location_has_item.Remove(dbItem); db.SaveChanges(); return(Json(new ResultJson { Success = true, Message = "Item Deleted Succesfully" })); } catch (Exception ex) { return(Json(new ResultJson { Success = false, Message = "Error Occured please Try Again!" })); } }
public ActionResult LocationsItem(LocationItemVM model, int locaid, int lhtid) { item it = db.item.Find(lhtid); it.ITEM_NAME = model.ITEM_NAME; location_has_item lht = db.location_has_item.Find(locaid); lht.ItemQuantity = model.ITEMQUANTITY; db.SaveChanges(); return(View(model)); }
public ActionResult LocationEditItem(location_has_item model, int?id) { location_has_item lci = db.location_has_item.Find(id); lci.ItemQuantity = model.ItemQuantity; db.location_has_item.Attach(lci); var entry = db.Entry(lci); entry.Property(x => x.ItemQuantity).IsModified = true; db.SaveChanges(); TempData["info"] = "Item added succesfuly"; return(RedirectToAction("Index")); }
public ActionResult AddNewItem(location_has_item modal) { try { } catch (Exception ex) { TempData["error"] = "Error Occured while creating a new item."; ViewBag.ITEMTYPE = new SelectList(db.itemtype, "ID", "Item_Type"); return(View()); } ViewBag.ITEMTYPE = new SelectList(db.itemtype, "ID", "Item_Type"); return(RedirectToAction("Index")); }
public ActionResult LocationEditItem(int?id) { location_has_item lci = db.location_has_item.Find(id); return(View(lci)); }
public ActionResult AddItem(ItemVM model, int?id) { var SessionControl = Convert.ToInt32(HttpContext.Session["RoleID"]); if (SessionControl != 5) { return(HttpNotFound()); } if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ViewBag.ITEMTYPE = new SelectList(db.itemtype, "ID", "Item_Type"); ViewBag.ITEM = new SelectList(db.item, "ID", "ITEM_NAME"); int locid = id ?? 0; var query = (from l in db.location join lc in db.location_has_item on l.ID equals lc.location_ID join i in db.item on lc.item_ID equals i.ID where l.ID == id orderby(i.ITEM_NAME) select new LocationItemVM { ID = l.ID, iID = lc.item_ID, ITEM_NAME = i.ITEM_NAME, ITEMQUANTITY = lc.ItemQuantity }).ToList(); //var lcd = db.location_has_item.Where(x => x.location_ID == id); var locationitems = db.location.Where(x => x.ID == id); try { model.LocationID = locid; if (model != null) { item items = new item(); itemtype itemtypes = new itemtype(); location_has_item location_has_items = new location_has_item(); if (db.location_has_item.Any(x => x.location_ID == id && x.item_ID == items.ID)) { TempData["info"] = "This location already have that item " + locationitems.Select(x => x.ROOM_ID); return(RedirectToAction("Index")); } else { location_has_items.location_ID = locid; location_has_items.item_ID = Convert.ToInt32(model.ItemName); location_has_items.ItemQuantity = model.ItemQuantity; db.location_has_item.Add(location_has_items); db.SaveChanges(); TempData["info"] = "Adding Item Succesfull "; return(RedirectToAction("Index")); } } } catch (Exception ex) { TempData["info"] = ex.Message; return(RedirectToAction("Index", "Location")); } TempData["info"] = "Adding Item Succesfull"; ViewBag.ITEMTYPE = new SelectList(db.itemtype, "ID", "Item_Type"); return(View("Index", "Location")); }