public ActionResult DeleteConfirmed(int id)
        {
            UserGroupRoll userGroupRoll = db.UserGroupRolls.Find(id);

            db.UserGroupRolls.Remove(userGroupRoll);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        public void DeleteAllbyGroupID(int id)
        {
            List <UserGroupRoll> userGroupRolls = db.UserGroupRolls.Where(c => c.UserGroupID == id).ToList();

            foreach (UserGroupRoll ugr in userGroupRolls)
            {
                UserGroupRoll userGroupRoll = db.UserGroupRolls.Find(ugr.UserGroupRollID);
                db.UserGroupRolls.Remove(userGroupRoll);
                db.SaveChanges();
            }
        }
 public ActionResult Edit([Bind(Include = "UserGroupRollID,IsRead,IsEdit,IsDelete,IsAll,UserGroupID,PrivilageID,IsActive,Status,CreateBy,CreateOn,UpdateBy,UpdateOn,IsDeleted,DeleteBy,DeleteOn")] UserGroupRoll userGroupRoll)
 {
     if (ModelState.IsValid)
     {
         db.Entry(userGroupRoll).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.PrivilageID = new SelectList(db.Privilages, "PrivilageID", "PrivilageName", userGroupRoll.PrivilageID);
     ViewBag.UserGroupID = new SelectList(db.UserGroups, "UserGroupID", "GroupName", userGroupRoll.UserGroupID);
     return(View(userGroupRoll));
 }
        public ActionResult CreateGroupRoll()
        {
            UserGroupRoll ugr        = new UserGroupRoll();
            var           userGroups = from d in db.UserGroups
                                       select d;
            var privilages = from d in db.Privilages
                             select d;
            UserGroupRollIndexData ugrid = new UserGroupRollIndexData(ugr, userGroups.ToList(), privilages.ToList());

            ViewBag.PrivilageID = new SelectList(db.Privilages, "PrivilageID", "PrivilageName");
            ViewBag.UserGroupID = new SelectList(db.UserGroups, "UserGroupID", "GroupName");
            return(View(ugrid));
        }
        // GET: UserGroupRoll/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            UserGroupRoll userGroupRoll = db.UserGroupRolls.Find(id);

            if (userGroupRoll == null)
            {
                return(HttpNotFound());
            }
            return(View(userGroupRoll));
        }
        // GET: UserGroupRoll/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            UserGroupRoll userGroupRoll = db.UserGroupRolls.Find(id);

            if (userGroupRoll == null)
            {
                return(HttpNotFound());
            }
            ViewBag.PrivilageID = new SelectList(db.Privilages, "PrivilageID", "PrivilageName", userGroupRoll.PrivilageID);
            ViewBag.UserGroupID = new SelectList(db.UserGroups, "UserGroupID", "GroupName", userGroupRoll.UserGroupID);
            return(View(userGroupRoll));
        }
 public bool CreateUserGroupRoll([Bind(Include = "UserGroupRollID,IsRead,IsEdit,IsDelete,IsAll,UserGroupID,PrivilageID,IsActive,Status,CreateBy,CreateOn,UpdateBy,UpdateOn,IsDeleted,DeleteBy,DeleteOn")] UserGroupRoll userGroupRoll)
 {
     if (ModelState.IsValid)
     {
         db.UserGroupRolls.Add(userGroupRoll);
         int res = db.SaveChanges();
         if (res > 0)
         {
             return(true);
         }
         else
         {
             return(false);
         }
     }
     else
     {
         return(false);
     }
 }
 public UserGroupRollIndexData(UserGroupRoll userGroupRoll, List <UserGroup> userGroups, List <Privilage> privilages)
 {
     UserGroupRoll = userGroupRoll;
     UserGroups    = userGroups;
     Privilages    = privilages;
 }
        public ActionResult CreateGroupRoll(UserGroupRoll ugr, FormCollection form)
        {
            UserGroupRoll userGroupRoll = new UserGroupRoll();
            BindingList <UserGroupRoll> userGroupRolls = new BindingList <UserGroupRoll>();

            //First Delete all Group Roll
            DeleteAllbyGroupID(Convert.ToInt32(ugr.UserGroupID));
            ///////////////////////////////////
            var selectedprivilages = form.GetValues("hidChekedPrivilage");

            string[] privilages = Regex.Split(selectedprivilages[0].ToString(), "/");
            foreach (var itemSection in privilages)
            {
                if (itemSection.Contains("read="))
                {
                    string   val     = itemSection.Replace("read=", string.Empty);
                    string[] readVal = Regex.Split(val.ToString(), ",");
                    foreach (var item in readVal)
                    {
                        if (!string.IsNullOrEmpty(item))
                        {
                            var any = userGroupRolls.Where(c => c.PrivilageID == Convert.ToInt32(item)).FirstOrDefault();
                            if (any == null)
                            {
                                userGroupRoll = new UserGroupRoll();
                                userGroupRoll.UserGroupRollID = 0;
                                userGroupRoll.UserGroupID     = Convert.ToInt32(ugr.UserGroupID);
                                userGroupRoll.PrivilageID     = Convert.ToInt32(item);
                                userGroupRoll.IsRead          = true;
                                userGroupRolls.Add(userGroupRoll);
                            }
                            else
                            {
                                foreach (var roll in userGroupRolls)
                                {
                                    if (roll.PrivilageID == Convert.ToInt32(item))
                                    {
                                        roll.IsRead = true;
                                    }
                                }
                            }
                        }
                    }
                }
                if (itemSection.Contains("edit="))
                {
                    string   val     = itemSection.Replace("edit=", string.Empty);
                    string[] editVal = Regex.Split(val.ToString(), ",");
                    foreach (var item in editVal)
                    {
                        if (!string.IsNullOrEmpty(item))
                        {
                            var any = userGroupRolls.Where(c => c.PrivilageID == Convert.ToInt32(item)).FirstOrDefault();
                            if (any == null)
                            {
                                userGroupRoll = new UserGroupRoll();
                                userGroupRoll.UserGroupRollID = 0;
                                userGroupRoll.UserGroupID     = Convert.ToInt32(ugr.UserGroupID);
                                userGroupRoll.PrivilageID     = Convert.ToInt32(item);
                                userGroupRoll.IsEdit          = true;
                                userGroupRolls.Add(userGroupRoll);
                            }
                            else
                            {
                                foreach (var roll in userGroupRolls)
                                {
                                    if (roll.PrivilageID == Convert.ToInt32(item))
                                    {
                                        roll.IsEdit = true;
                                    }
                                }
                            }
                        }
                    }
                }
                if (itemSection.Contains("delete="))
                {
                    string   val       = itemSection.Replace("delete=", string.Empty);
                    string[] deleteVal = Regex.Split(val.ToString(), ",");
                    foreach (var item in deleteVal)
                    {
                        if (!string.IsNullOrEmpty(item))
                        {
                            var any = userGroupRolls.Where(c => c.PrivilageID == Convert.ToInt32(item)).FirstOrDefault();
                            if (any == null)
                            {
                                userGroupRoll = new UserGroupRoll();
                                userGroupRoll.UserGroupRollID = 0;
                                userGroupRoll.UserGroupID     = Convert.ToInt32(ugr.UserGroupID);
                                userGroupRoll.PrivilageID     = Convert.ToInt32(item);
                                userGroupRoll.IsDelete        = true;
                                userGroupRolls.Add(userGroupRoll);
                            }
                            else
                            {
                                foreach (var roll in userGroupRolls)
                                {
                                    if (roll.PrivilageID == Convert.ToInt32(item))
                                    {
                                        roll.IsDelete = true;
                                    }
                                }
                            }
                        }
                    }
                }
                if (itemSection.Contains("all="))
                {
                    string   val    = itemSection.Replace("all=", string.Empty);
                    string[] allVal = Regex.Split(val.ToString(), ",");
                    foreach (var item in allVal)
                    {
                        if (!string.IsNullOrEmpty(item))
                        {
                            var any = userGroupRolls.Where(c => c.PrivilageID == Convert.ToInt32(item)).FirstOrDefault();
                            if (any == null)
                            {
                                userGroupRoll = new UserGroupRoll();
                                userGroupRoll.UserGroupRollID = 0;
                                userGroupRoll.UserGroupID     = Convert.ToInt32(ugr.UserGroupID);
                                userGroupRoll.PrivilageID     = Convert.ToInt32(item);
                                userGroupRoll.IsAll           = true;
                                userGroupRolls.Add(userGroupRoll);
                            }
                            else
                            {
                                foreach (var roll in userGroupRolls)
                                {
                                    if (roll.PrivilageID == Convert.ToInt32(item))
                                    {
                                        roll.IsAll = true;
                                    }
                                }
                            }
                        }
                    }
                }
            }
            ////////////////////////////////
            bool ret = false;

            foreach (UserGroupRoll userGrpRoll in userGroupRolls)
            {
                ret = CreateUserGroupRoll(userGrpRoll);
            }
            if (ret)
            {
                return(Json("success", JsonRequestBehavior.AllowGet));
            }
            else
            {
                return(Json("error", JsonRequestBehavior.AllowGet));
            }
            //return RedirectToAction("CreateGroupRoll");
        }