Exemple #1
0
        private void CheckUserGroupForModule(Guid obj, Guid grKey)
        {
            var t = from x in db.UserGroupForm where x.ModuleKey == obj && x.UserGroupKey == grKey select x;

            if (!(t.Count() > 0))
            {
                var ts = from x in db.UserGroupModule where x.ModuleKey == obj && x.UserGroupKey == grKey select x;
                foreach (var item in ts)
                {
                    UserGroupModule a = db.UserGroupModule.SingleOrDefault(x => x.UserGroupModuleKey == item.UserGroupModuleKey);
                    db.UserGroupModule.Remove(a);
                    db.SaveChanges();
                }
            }
        }
        private void CheckForModuleBeforDelete(UserGroupForm f)
        {
            HasanHoutoneEntities ac = new HasanHoutoneEntities();
            var temp = from x in ac.UserGroupForm where x.UserGroupKey == f.UserGroupKey && x.ModuleKey == f.ModuleKey && x.CompanyKey == GlobalClass.Company.CompanyKey select x;

            if (temp.Count() > 0)
            {
            }
            else
            {
                UserGroupModule obj = db.UserGroupModule.FirstOrDefault(x => x.UserGroupKey == f.UserGroupKey && x.ModuleKey == f.ModuleKey && x.CompanyKey == GlobalClass.Company.CompanyKey);
                ac.UserGroupModule.Remove(obj);
                ac.SaveChanges();
            }
        }
 public ActionResult Delete(Guid?id)
 {
     if (GlobalClass.SystemSession)
     {
         Usergroup company = db.Usergroup.Find(id);
         var       temp    = from x in db.UserGroupForm where x.UserGroupKey == id select x;
         var       temp2   = from x in db.UserGroupModule where x.UserGroupKey == id select x;
         var       temp3   = from x in db.StaffList where x.Usergr == id select x;
         if (temp.Count() > 0)
         {
             foreach (var a in temp)
             {
                 HasanHoutoneEntities ac   = new HasanHoutoneEntities();
                 UserGroupForm        form = db.UserGroupForm.Find(a.UserGroupFormKey);
                 ac.UserGroupForm.Remove(form);
                 ac.SaveChanges();
             }
         }
         if (temp3.Count() > 0)
         {
             foreach (var a in temp3)
             {
                 HasanHoutoneEntities ac   = new HasanHoutoneEntities();
                 StaffList            form = db.StaffList.Find(a.PersonnelKey);
                 form.Usergr = null;
                 ac.SaveChanges();
             }
         }
         if (temp2.Count() > 0)
         {
             foreach (var a in temp2)
             {
                 HasanHoutoneEntities ac   = new HasanHoutoneEntities();
                 UserGroupModule      form = db.UserGroupModule.Find(a.UserGroupModuleKey);
                 ac.UserGroupModule.Remove(form);
                 ac.SaveChanges();
             }
         }
         db.Usergroup.Remove(company);
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     else
     {
         Exception e = new Exception("Sorry, your Session has Expired");
         return(View("Error", new HandleErrorInfo(e, "UserHome", "Logout")));
     }
 }
        private void CheckForModule(Guid moduleID, Guid UserGroupKey)
        {
            HasanHoutoneEntities ac = new HasanHoutoneEntities();
            var temp = from x in ac.UserGroupModule where x.UserGroupKey == UserGroupKey && x.ModuleKey == moduleID && x.CompanyKey == GlobalClass.Company.CompanyKey select x;

            if (temp.Count() > 0)
            {
            }
            else
            {
                UserGroupModule obj = new UserGroupModule();
                obj.CompanyKey         = GlobalClass.Company.CompanyKey;
                obj.ModuleKey          = moduleID;
                obj.UserGroupKey       = UserGroupKey;
                obj.UserGroupModuleKey = Guid.NewGuid();
                ac.UserGroupModule.Add(obj);
                ac.SaveChanges();
            }
        }