public ActionResult DeleteConfirmed(string id) { string CurrentLoginID = User.Identity.GetUserId().ToString(); var userIDselectVar = from s in db.agentsDbs where s.userID == CurrentLoginID select s.ID; int userIDselectInt = userIDselectVar.Single(); List <int> returnProjectIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt) .Select(s => s.projectID) .ToList(); List <int> returnTaskOrdersIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt) .Select(s => s.taskOrderID) .ToList(); var userTypeSelect = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType; int userTypeInt = userTypeSelect.First(); if (userTypeInt == 2 || (CurrentLoginID == User.Identity.GetUserId().ToString() && returnProjectIDlist.Contains(6) && returnTaskOrdersIDlist.Contains(61))) { UHSUSAT1B360Db UHSUSAT1B360Db = opa.UHSUSAT1B360Dbs.Find(id); opa.UHSUSAT1B360Dbs.Remove(UHSUSAT1B360Db); opa.SaveChanges(); return(RedirectToAction("Index", "uhsuserB360", new { projectID = 6, taskOrderID = 61, Int1 = 1 })); } { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } }
//[ValidateAntiForgeryToken] public ActionResult EditEx(UHSUSAT1B360Db model) { //System.Diagnostics.Debug.WriteLine(model.ID); //System.Diagnostics.Debug.WriteLine(item2); string CurrentLoginID = User.Identity.GetUserId().ToString(); var userIDselectVar = from s in db.agentsDbs where s.userID == CurrentLoginID select s.ID; int userIDselectInt = userIDselectVar.Single(); List <int> returnProjectIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt) .Select(s => s.projectID) .ToList(); List <int> returnTaskOrdersIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt) .Select(s => s.taskOrderID) .ToList(); var userTypeSelect = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType; int userTypeInt = userTypeSelect.First(); if (userTypeInt == 2 || (CurrentLoginID == User.Identity.GetUserId().ToString() && returnProjectIDlist.Contains(6) && returnTaskOrdersIDlist.Contains(61))) { if (ModelState.IsValid) { try { opa.Entry(model).State = EntityState.Modified; opa.SaveChanges(); int resp = 1; return(Json(resp, JsonRequestBehavior.AllowGet)); } catch (Exception e) { int resp = 2; return(Json(resp, JsonRequestBehavior.AllowGet)); throw (e); } } else { int resp = 3; return(Json(resp, JsonRequestBehavior.AllowGet)); } } else { int resp = 4; return(Json(resp, JsonRequestBehavior.AllowGet)); } }
//[ValidateAntiForgeryToken] public ActionResult CreateNew(UHSUSAT1B360Db UHSUSAT1B360Db) { string CurrentLoginID = User.Identity.GetUserId().ToString(); var userIDselectVar = from s in db.agentsDbs where s.userID == CurrentLoginID select s.ID; int userIDselectInt = userIDselectVar.Single(); List <int> returnProjectIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt) .Select(s => s.projectID) .ToList(); List <int> returnTaskOrdersIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt) .Select(s => s.taskOrderID) .ToList(); var userTypeSelect = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType; int userTypeInt = userTypeSelect.First(); if (userTypeInt == 2 && CurrentLoginID == User.Identity.GetUserId().ToString() && returnProjectIDlist.Contains(6) && returnTaskOrdersIDlist.Contains(61)) { if (UHSUSAT1B360Db.MGRID == 0 || UHSUSAT1B360Db.IDc == 0) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } else { if (ModelState.IsValid) { try { opa.UHSUSAT1B360Dbs.Add(UHSUSAT1B360Db); opa.SaveChanges(); var conf = 1; return(Json(conf, JsonRequestBehavior.AllowGet)); } catch (Exception e) { return(View(UHSUSAT1B360Db)); throw (e); } } return(View(UHSUSAT1B360Db)); } } return(View(UHSUSAT1B360Db)); }
// GET: UHSUSAT1A360Db/Delete/5 public ActionResult Delete(string id) { string CurrentLoginID = User.Identity.GetUserId().ToString(); var userIDselectVar = from s in db.agentsDbs where s.userID == CurrentLoginID select s.ID; int userIDselectInt = userIDselectVar.Single(); List <int> returnProjectIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt) .Select(s => s.projectID) .ToList(); List <int> returnTaskOrdersIDlist = db.agentsTaskOrdersDbs.Where(s => s.agentID == userIDselectInt) .Select(s => s.taskOrderID) .ToList(); var userTypeSelect = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType; int userTypeInt = userTypeSelect.First(); if (userTypeInt == 2 && CurrentLoginID == User.Identity.GetUserId().ToString() && returnProjectIDlist.Contains(6) && returnTaskOrdersIDlist.Contains(61)) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } UHSUSAT1B360Db UHSUSAT1B360Db = opa.UHSUSAT1B360Dbs.Find(id); if (UHSUSAT1B360Db == null) { return(HttpNotFound()); } return(View(UHSUSAT1B360Db)); } else { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } }