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