public ActionResult DeleteConfirmed(int id) { string CurrentLoginID = User.Identity.GetUserId().ToString(); var usID101 = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType; int usID102 = usID101.First(); if (usID102 == 2) { connTypeDb connTypeDb = db.connTypeDbs.Find(id); db.connTypeDbs.Remove(connTypeDb); db.SaveChanges(); return(RedirectToAction("Index", "connType", new { projectID = 6, taskOrderID = 32, Int1 = 1 })); } else { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } }
// GET: connTypeDbs/Edit/5 public ActionResult Edit(int?id) { string CurrentLoginID = User.Identity.GetUserId().ToString(); var usID101 = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType; int usID102 = usID101.First(); if (usID102 == 2) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } connTypeDb connTypeDb = db.connTypeDbs.Find(id); if (connTypeDb == null) { return(HttpNotFound()); } ViewBag.clientsDb = new SelectList(db.clientsDbs, "ID", "clientName"); var int101 = from s in db.connTypeDbs where s.ID == id select s.clientID; int int102 = int101.Single(); var int201 = from s in db.connTypeDbs where s.ID == id select s.projectID; int int202 = int201.Single(); ViewBag.clientsProjectsDb = new SelectList(db.clientsProjectsDbs.Where(s => s.ID == 1 || s.clientID == int102) .OrderBy(s => s.ID), "ID", "projectName"); ViewBag.taskOrdersDb = new SelectList(db.taskOrdersDbs.Where(s => s.ID == 1 || (s.clientID == int102 && s.projectID == int202)) .OrderBy(s => s.ID), "ID", "taskOrder"); ViewBag.currentUserLoginID = User.Identity.GetUserId().ToString(); ViewBag.currentTimeDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); return(View(connTypeDb)); } else { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } }
public ActionResult Edit([Bind(Include = "ID, clientID, projectID, taskOrderID, connType, createdDT, editedDT, createdByUserID")] connTypeDb connTypeDb) { string CurrentLoginID = User.Identity.GetUserId().ToString(); var usID101 = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType; int usID102 = usID101.First(); if (usID102 == 2) { if (ModelState.IsValid) { db.Entry(connTypeDb).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", "connType", new { projectID = 6, taskOrderID = 32, Int1 = 1 })); } return(View(connTypeDb)); } else { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } }
// GET: connTypeDbs/Delete/5 public ActionResult Delete(int?id) { string CurrentLoginID = User.Identity.GetUserId().ToString(); var usID101 = from s in db.agentsDbs where s.userID == CurrentLoginID select s.userType; int usID102 = usID101.First(); if (usID102 == 2) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } connTypeDb connTypeDb = db.connTypeDbs.Find(id); if (connTypeDb == null) { return(HttpNotFound()); } return(View(connTypeDb)); } else { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } }