// GET: taskOrdersDbs/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)); } taskOrdersDb taskOrdersDb = db.taskOrdersDbs.Find(id); if (taskOrdersDb == null) { return(HttpNotFound()); } ViewBag.clientsDb = new SelectList(db.clientsDbs, "ID", "clientName"); var Item31 = from s in db.taskOrdersDbs where s.ID == id select s.clientID; int Item311 = Item31.Single(); ViewBag.clientsProjectsDb = new SelectList(db.clientsProjectsDbs.Where(s => s.clientID == Item311), "ID", "projectName"); ViewBag.currentUserLoginID = User.Identity.GetUserId().ToString(); ViewBag.currentTimeDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); return(View(taskOrdersDb)); } else { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } }
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) { taskOrdersDb taskOrdersDb = db.taskOrdersDbs.Find(id); db.taskOrdersDbs.Remove(taskOrdersDb); db.SaveChanges(); return(RedirectToAction("Index", "taskOrders", new { projectID = 6, taskOrderID = 22, Int1 = 1 })); } { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } }
public ActionResult Edit([Bind(Include = "ID, clientID, projectID, taskOrder, createdDT, editedDT, createdByUserID")] taskOrdersDb taskOrdersDb) { 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(taskOrdersDb).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", "taskOrders", new { projectID = 6, taskOrderID = 22, Int1 = 1 })); } return(View(taskOrdersDb)); } else { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } }
// GET: taskOrdersDbs/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)); } taskOrdersDb taskOrdersDb = db.taskOrdersDbs.Find(id); if (taskOrdersDb == null) { return(HttpNotFound()); } return(View(taskOrdersDb)); } else { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } }