// GET: clientsDbs/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));
                }
                clientsProjectsDb clientsProjectsDb = db.clientsProjectsDbs.Find(id);
                if (clientsProjectsDb == null)
                {
                    return(HttpNotFound());
                }

                ViewBag.clientsDb106 = new SelectList(db.clientsDbs, "ID", "clientName");

                ViewBag.currentUserLoginID106 = User.Identity.GetUserId().ToString();
                ViewBag.currentTimeDate106    = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");

                return(View(clientsProjectsDb));
            }
            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)
            {
                clientsProjectsDb clientsProjectsDb = db.clientsProjectsDbs.Find(id);
                db.clientsProjectsDbs.Remove(clientsProjectsDb);
                db.SaveChanges();
                return(RedirectToAction("Index", "clientsProjects", new { projectID = 6, taskOrderID = 21, Int1 = 1 }));
            }
            else
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
        }
        public ActionResult Edit([Bind(Include = "ID, projectName, clientID, createdDT, editedDT, createdByUserID")] clientsProjectsDb clientsProjectsDb)
        {
            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(clientsProjectsDb).State = EntityState.Modified;
                    db.SaveChanges();
                    return(RedirectToAction("Index", "clientsProjects", new { projectID = 6, taskOrderID = 21, Int1 = 1 }));
                }
                return(View(clientsProjectsDb));
            }
            else
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
        }
        // GET: clientsProjectsDbs/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));
                }
                clientsProjectsDb clientsProjectsDb = db.clientsProjectsDbs.Find(id);
                if (clientsProjectsDb == null)
                {
                    return(HttpNotFound());
                }
                return(View(clientsProjectsDb));
            }
            else
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
        }