public ActionResult Create([Bind(Include = "ROLEID,STATUSID,ROLENAME,ROLEDESCRIPTION")] ROLETABLE rOLETABLE)
        {
            //cek session login
            if (Session["userId"] == null)
            {
                return(RedirectToAction("Login", "USERTABLEs", new { area = "" }));
            }

            //cek role user
            if (Session["userRole"].ToString() != "admin")
            {
                return(RedirectToAction("Index", "CONTENTTABLEs", new { area = "" }));
            }
            rOLETABLE.STATUSID = 1;

            //cek ketersediaan role name
            if (db.ROLETABLEs.Where(m => m.ROLENAME == rOLETABLE.ROLENAME).FirstOrDefault() != null)
            {
                //role name tidak tersedia
                ViewBag.ROLENAMENOT = "Role Name exists";
                ViewBag.STATUSID    = new SelectList(db.STATUSTABLEs, "STATUSID", "STATUSNAME");
                return(View());
            }
            if (ModelState.IsValid)
            {
                //menambahkan role ke database
                db.ROLETABLEs.Add(rOLETABLE);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.STATUSID = new SelectList(db.STATUSTABLEs, "STATUSID", "STATUSNAME", rOLETABLE.STATUSID);
            return(View(rOLETABLE));
        }
        // GET: ROLETABLEs/Details/5
        public ActionResult Details(int?id)
        {
            //cek session login
            if (Session["userId"] == null)
            {
                return(RedirectToAction("Login", "USERTABLEs", new { area = "" }));
            }

            //cek role user
            if (Session["userRole"].ToString() != "admin")
            {
                return(RedirectToAction("Index", "CONTENTTABLEs", new { area = "" }));
            }

            //cek id di parameter
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ROLETABLE rOLETABLE = db.ROLETABLEs.Find(id);

            //cek id di database
            if (rOLETABLE == null)
            {
                return(HttpNotFound());
            }
            return(View(rOLETABLE));
        }
        // GET: ROLETABLEs/Edit/5
        public ActionResult Edit(int?id)
        {
            //cek session login
            if (Session["userId"] == null)
            {
                return(RedirectToAction("Login", "USERTABLEs", new { area = "" }));
            }

            //cek role user
            if (Session["userRole"].ToString() != "admin")
            {
                return(RedirectToAction("Index", "CONTENTTABLEs", new { area = "" }));
            }

            //cek id di parameter
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            ROLETABLE rOLETABLE = db.ROLETABLEs.Find(id);

            //cek id di database
            if (rOLETABLE == null)
            {
                return(HttpNotFound());
            }

            //hanya super admin yang bisa mengedit akun ber-ID 1
            if (Convert.ToInt32(Session["userId"]) != 1 && id == 1)
            {
                return(RedirectToAction("Index", "USERTABLEs"));
            }
            ViewBag.STATUSID = new SelectList(db.STATUSTABLEs, "STATUSID", "STATUSNAME", rOLETABLE.STATUSID);
            return(View(rOLETABLE));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            //hapus role di database
            ROLETABLE rOLETABLE = db.ROLETABLEs.Find(id);

            db.ROLETABLEs.Remove(rOLETABLE);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "ROLEID,STATUSID,ROLENAME,ROLEDESCRIPTION")] ROLETABLE rOLETABLE)
 {
     //cek ketersediaan role name
     if (db.ROLETABLEs.Where(m => m.ROLENAME == rOLETABLE.ROLENAME && m.ROLEID != rOLETABLE.ROLEID).FirstOrDefault() != null)
     {
         ViewBag.ROLENAMENOT = "Role Name exists";
         ViewBag.STATUSID    = new SelectList(db.STATUSTABLEs, "STATUSID", "STATUSNAME");
         return(View(rOLETABLE));
     }
     if (ModelState.IsValid)
     {
         //save perubahan ke database
         db.Entry(rOLETABLE).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.STATUSID = new SelectList(db.STATUSTABLEs, "STATUSID", "STATUSNAME", rOLETABLE.STATUSID);
     return(View(rOLETABLE));
 }