public List <ModulePermission> ModulePermission_SelectModulePerByRoleGid(string rgid, string mgid) { DbCommand dbCmd = db.GetStoredProcCommand("Proc_ModulePermission_SelectModulePerByRoleGid"); db.AddInParameter(dbCmd, "@rgid", DbType.String, rgid); db.AddInParameter(dbCmd, "@mgid", DbType.String, mgid); List <ModulePermission> list = new List <ModulePermission>(); try { using (IDataReader reader = db.ExecuteReader(dbCmd)) { while (reader.Read()) { //属性赋值 ModulePermission obj = this.Obj2Model <ModulePermission>(reader); list.Add(obj); } } } catch (Exception e) { throw new Exception(e.Message); } return(list); }
public static int ModulePermission_UpdateByp_gid(ModulePermission obj) { using (SystemDAL access = new SystemDAL()) { return(access.ModulePermission_UpdateByp_gid(obj)); } }
public List <ModulePermission> ModulePermission_SelectPage(string cloumns, int pageIndex, int pageSize, string orderBy, string where, out int rowCount) { DbCommand dbCmd = db.GetStoredProcCommand("Proc_ModulePermission_SelectPage"); db.AddOutParameter(dbCmd, "@rowCount", DbType.Int32, 4); db.AddInParameter(dbCmd, "@cloumns", DbType.String, cloumns); db.AddInParameter(dbCmd, "@pageIndex", DbType.Int32, pageIndex); db.AddInParameter(dbCmd, "@pageSize", DbType.Int32, pageSize); db.AddInParameter(dbCmd, "@orderBy", DbType.String, orderBy); db.AddInParameter(dbCmd, "@where", DbType.String, where); List <ModulePermission> list = new List <ModulePermission>(); try { using (IDataReader reader = db.ExecuteReader(dbCmd)) { while (reader.Read()) { //属性赋值 ModulePermission obj = Obj2Model <ModulePermission>(reader); list.Add(obj); } reader.NextResult(); } rowCount = (int)dbCmd.Parameters["@rowCount"].Value; return(list); } catch (Exception e) { throw new Exception(e.Message); } }
public static int ModulePermission_Insert(ModulePermission obj) { using (SystemDAL access = new SystemDAL()) { return(access.ModulePermission_Insert(obj)); } }
private SqlCommand Get(ModulePermission permission, SqlConnection connection, SqlTransaction transaction = default) => connection.CreateProcedureCommand(PROCEDURE, transaction) .AddInOutParameter(PARAM_ID, permission.Id, PARAMTYPE_ID) .AddInParameter(PARAM_NAME, permission.Name) .AddInParameter(PARAM_CODE, permission.Code) .AddInParameter(PARAM_MODULEID, permission.ModuleId) .AddSessionIdParameter(_sessionProvider);
public JsonResult SaveEditPermission(ModulePermission permission) { permission.ModifyBy = UserId; var sr = new ModuleBLL().SaveEditPermission(permission, UserId, UserName); return(Json(sr.toJson())); }
private string InstallModulesPermissions(IModule module) { StringBuilder info = new StringBuilder(); info.Append("<ul>"); ModulePermission mp = new ModulePermission() { Available = module.Requirements.Permissions != null?module.Requirements.Permissions.ToArray() : new string[0], ModuleID = module.Id, ModuleName = module.Name }; var q = new EntityQuery2(ModulePermission.ENTITY); q.AddProperty("Available"); q.WhereIs("moduleId", module.Id); using (var dbContext = _dbService.GetDatabaseContext(true)) { var ex = _repository.Read(q); if (ex == null) { _repository.Create(mp.Entity); foreach (var p in mp.Available) { info.AppendFormat("<li>{0} - added.</li>", p); } } else if (ex.GetData <string>("Available") != mp.Entity.GetData <string>("Available")) { var oldRaw = ex.GetData <string>("Available"); string[] old = null; if (string.IsNullOrEmpty(oldRaw)) { old = new string[0]; } else { old = oldRaw.Split(";".ToCharArray(), StringSplitOptions.RemoveEmptyEntries); } ex.SetData <string>("Available", mp.Entity.GetData <string>("Available")); _repository.Update(ex); foreach (var p in mp.Available) { if (!old.Contains(p)) { info.AppendFormat("<li>{0} - added.</li>", p); } } foreach (var p in old) { if (!mp.Available.Contains(p)) { info.AppendFormat("<li>{0} - removed.</li>", p); } } } dbContext.Complete(); } info.Append("</ul>"); return(info.ToString()); }
public ActionResult UserPermission(Permissionviewmodel vm, string Search, string Save) { List <string> result = new List <string>(); PermissionMaster _master = new PermissionMaster(); List <ModulePermission> p = new List <ModulePermission>(); Permissionviewmodel searchmodel = new Permissionviewmodel(); Guid CompanyId = new Guid(); if (Request.Cookies["CompanyId"] != null) { CompanyId = new Guid(Commonhelper.GetCookie("CompanyId")); } if (vm.PermissionMaster != null) { _master.Id = Guid.NewGuid().ToString(); _master.CompanyId = CompanyId.ToString(); _master.UserId = vm.PermissionMaster.UserId; _master.CreatedBy = User.Identity.GetUserId(); _master.DateCreated = DateTime.Now; _master.Workstation = Commonhelper.GetStation(); } if (vm.Menumaster.Count() > 0) { foreach (var item in vm.Menumaster) { foreach (var child in item._SubMenumaster) { if (child.IsAdd == true || child.IsEdit == true || child.Isview == true || child.Isdelete == true) { ModulePermission mp = new ModulePermission(); mp.Id = Guid.NewGuid().ToString(); mp.MenuId = item.MenuId; mp.SubMenuId = child.SubMenumasterId; mp.IsAdd = child.IsAdd; mp.IsEdit = child.IsEdit; mp.Isview = child.Isview; mp.Isdelete = child.Isdelete; mp.DisplayOrder = child.order; mp.Displayclass = child.Displayclass; mp.DisplayName = child.DisplayName; _master._ModulePermission.Add(mp); } } } try { Commonhelper.SavePermission(_master); return(Content("<script language='javascript' type='text/javascript'>alert('permission saved successfully!');</script>")); } catch (Exception ex) { } } return(Json(result, JsonRequestBehavior.AllowGet)); ///return View(); }
public ModulePermission GetModulePermissionById(int id) { ModulePermission modulePermission = new ModulePermission(); try { DataSet ds = new DataSet(); List <DbParameter> param = new List <DbParameter>(); param.Add(new DbParameter() { Name = "p_ModulePermissionId", Direction = ParameterDirection.Input, Value = id, Type = DbType.Int32 }); ds = db.LoadDataSetAgainstQuery("pr_GetModulePermissionById", CommandType.StoredProcedure, ref param); if (ds != null && ds.Tables.Count > 0) { modulePermission = ds.Tables[0].AsEnumerable().Select(a => new ModulePermission() { ModulePermissionId = Convert.ToInt32(a["iModulePermissionId"]), ModulePermissionCode = a["vModulePermissionCode"].ToString(), Desription = a["vDescription"].ToString(), ModuleId = Convert.ToInt32(a["iModuleId"].ToString()) }).FirstOrDefault(); } } catch (Exception ex) { throw ex; } return(modulePermission); }
public SaveResult SaveAddPermission(ModulePermission permission, int userId, string userName) { var module = BoDB.ModuleDb.GetById(permission.ModuleId); if (!module.ParentId.HasValue) { return(new SaveResult(false, "Can't add permission for root module")); } var hasSameCode = BoDB.ModulePermissionDb.IsAny(t => t.Code == permission.Code); if (hasSameCode) { return(new SaveResult(false, string.Format("The code {0} is exist", permission.Code))); } permission.CreateTime = DateTime.UtcNow; permission.IsDefault = false; BoDB.ModulePermissionDb.Insert(permission); // Create ActionLog ActionLog actionLog = new ActionLog(); actionLog.AccountId = userId; actionLog.CreateTime = DateTime.UtcNow; actionLog.ModuleCode = typeof(ModuleBLL).FullName + ".SaveAddPermission"; actionLog.Username = userName; actionLog.LogContent = string.Format("Create ModulePermission,ID:{0},Code:{1} ", permission.Id, permission.Code); ActionLogBLL ab = new ActionLogBLL(); ab.Create(actionLog); return(new SaveResult()); }
private DataTable TranslateToTable(ModulePermissionSet set) { DataTable table = new DataTable(set.ModuleName); ModulePermission firstOne = set.ModulePermissions[0]; table.Columns.Add("Module", typeof(string)); table.Columns.Add("Action", typeof(string)); foreach (string key in firstOne.Permissions.Keys) { table.Columns.Add(key, typeof(bool)); } int lineNumber = 0; foreach (ModulePermission line in set.ModulePermissions) { DataRow row = table.Rows.Add(); if (lineNumber == 0) { row[0] = line.ModuleName; } row["Action"] = line.ActionName; foreach (string key in line.Permissions.Keys) { row[key] = line.Permissions[key]; } lineNumber++; } return(table); }
internal static void Init(IUsage <ModulePermission> permission) { Permission = permission; Instance = permission.Instance; DefaultGroup = Instance.Groups.FirstOrDefault(p => p.Id == Instance.DefaultGroupId); AdminGroup = Instance.Groups.FirstOrDefault(p => p.Id == Instance.AdminGroup); }
public PartialViewResult PerimissCreate(int moduleId) { ModulePermission permission = new ModulePermission() { ModuleId = moduleId }; return(PartialView(permission)); }
public async Task <ModulePermission> ExecuteAsync(ModulePermission permission, SqlConnection connection, SqlTransaction transaction = default, CancellationToken cancellationToken = default) { using var command = Get(permission, connection, transaction); if (await command.ExecuteNonQueryAsync(cancellationToken) == ALLOWEDAFFECTEDROWS) { permission.Id = command.Parameters.GetInt32(PARAM_ID); return(permission); } return(default);
public static Permission ToCoreModel(this ModulePermission source, string moduleId, string groupName) { return(new Permission { Id = source.Id, Name = source.Name, Description = source.Description, ModuleId = moduleId, GroupName = groupName, }); }
public ActionResult PermissionEdit() { string p_name = Request["p_name"] ?? string.Empty; string p_path = Request["p_path"] ?? string.Empty; string m_gid = Request["m_gid"] ?? string.Empty; string p_gid = Request["p_gid"] ?? string.Empty; ModulePermission info = null; if (string.IsNullOrEmpty(p_gid)) { info = new ModulePermission(); //新增 string guid = Guid.NewGuid().ToString().Substring(0, 8); info.p_gid = guid; info.p_createTime = DateTime.Now; info.p_createUser = SiteHelp.CurrentUserName; } else { info = SystemSeviceClass.ModulePermission_SelectByp_gid(p_gid); } info.p_name = p_name; info.p_path = p_path; info.p_m_gid = m_gid; if (string.IsNullOrEmpty(p_gid)) { int result = SystemSeviceClass.ModulePermission_Insert(info); if (result > 0) { return(Json(new { success = true, errors = new { text = "新增成功" } })); } else { return(Json(new { success = false, errors = new { text = "新增失败" } })); } } else { int result = SystemSeviceClass.ModulePermission_UpdateByp_gid(info); if (result > 0) { return(Json(new { success = true, errors = new { text = "修改成功" } })); } else { return(Json(new { success = false, errors = new { text = "修改失败" } })); } } }
public void SetButton(SetButtonDto model) { foreach (var permissionId in model.SelectedPermissionIds) { var entity = new ModulePermission() { PermissionId = permissionId, ModuleId = model.ModuleId }; _modulePermissionRepository.Insert(entity); } }
public void GetModulePermissionSetReturnsSingleActionAndSingleRolePermission() { MockRolesCatalog catalog = new MockRolesCatalog(); MockAuthorizationService authSerivce = new MockAuthorizationService(); IPermissionsCatalog permissionsService = new MockPermissionCatalog(); AdminController controller = new AdminController(authSerivce, permissionsService, catalog); ModulePermissionSet set = controller.GetModulePermissionSet("TestModule"); ModulePermission singleModulePermission = set.ModulePermissions[0]; Assert.AreEqual("TestModule", singleModulePermission.ModuleName); Assert.AreEqual("Friendly", singleModulePermission.ActionName); Assert.IsTrue(singleModulePermission.Permissions is Dictionary <string, bool>); Assert.IsFalse(singleModulePermission.Permissions["Mock01"]); }
public Permission Add(Permission entity, int moduleId) { entity.IsVisible = true; _unitOfWork.RegisterNew(entity); var modulePermission = new ModulePermission { ModuleId = moduleId, PermissionId = entity.Id }; _unitOfWork.RegisterNew(modulePermission); _unitOfWork.Commit(); return(entity); }
public async Task <MessageModel <string> > Post([FromBody] ModulePermission request) { var data = new MessageModel <string>(); var id = await _modulePermissionServices.Add(request); data.success = id > 0; if (data.success) { data.response = id.ObjToString(); data.msg = "添加成功"; } return(data); }
/// <summary> /// Convert ModulePermission to ModulePermissionInfo. /// </summary> /// <param name="modulePermission">Module permission</param> /// <returns>Module permission info</returns> public static ModulePermissionInfo ToModulePermissionInfo(this ModulePermission modulePermission) { if (modulePermission is null) { return(null); } return(new ModulePermissionInfo() { ModulePermissionId = modulePermission.ModulePermissionId, ModuleId = modulePermission.ModuleId, PermissionId = modulePermission.PermissionId, Module = modulePermission.Module.ToModuleInfo(), Permission = modulePermission.Permission.ToPermissionInfo(), }); }
public async Task <MessageModel <string> > Put([FromBody] ModulePermission request) { var data = new MessageModel <string>(); if (request.Id > 0) { data.success = await _modulePermissionServices.Update(request); if (data.success) { data.msg = "更新成功"; data.response = request?.Id.ObjToString(); } } return(data); }
public SaveResult SaveCreate(Module module, int userId, string userName) { var sameCodeEnity = BoDB.ModuleDb.IsAny(t => t.Code == module.Code); if (sameCodeEnity) { return new SaveResult() { Result = false, Message = string.Format("Code {0} is exist", module.Code) } } ; var result = BoDB.DB.Ado.UseTran(() => { module.CreateTime = DateTime.UtcNow; int moduleId = BoDB.ModuleDb.InsertReturnIdentity(module); ModulePermission mp = new ModulePermission() { CreateBy = module.CreateBy, CreateTime = DateTime.UtcNow, ModuleId = moduleId, Code = module.Code + "Menu", Description = "Menu Entrance", IsDefault = true }; BoDB.ModulePermissionDb.Insert(mp); }); // Create ActionLog ActionLog actionLog = new ActionLog(); actionLog.IPAddress = GetClientIPAddress(); actionLog.AccountId = userId; actionLog.CreateTime = DateTime.UtcNow; actionLog.ModuleCode = typeof(ModuleBLL).FullName + ".SaveCreate"; actionLog.Username = userName; actionLog.LogContent = string.Format("Create Module,ID :{0},Name:{1}", module.Id, module.Name); ActionLogBLL ab = new ActionLogBLL(); ab.Create(actionLog); return(new SaveResult(result)); }
public ActionResult ModulePermissionForm(ModulePermission modulePermission) { if (!ModelState.IsValid) { return(new AjaxableViewResult(modulePermission)); } // TODO : assign user id from session to created user id.. bool saved = _module.SaveModulePermission(modulePermission); AjaxResponse response = new AjaxResponse() { Type = saved ? "success" : "error", Message = saved ? "Data has been processed successfully" : "Unable to process data", Heading = "Module Permission", RedirectUrl = Url.Action("ModulePermissionList", "Module") }; return(Json(response)); }
protected void BtnCommand_Click(object sender, EventArgs e) { List<ModulePermission> permlist = new List<ModulePermission>(); int count = 0; for (int i = 0; i < ModuleList.Items.Count; i++) { CheckBox SelectTime = ((CheckBox)ModuleList.Items[i].FindControl("chkSelected")); if (SelectTime.Checked == true) { ModulePermission mp = new ModulePermission(); count++; Label lblModuleID = ((Label)ModuleList.Items[i].FindControl("lblModuleID")); mp.ModuleID = lblModuleID.Text; CheckBox chkadd = ((CheckBox)ModuleList.Items[i].FindControl("chkadd")); mp.hasAdd = (chkadd.Checked)? 1:0; CheckBox chkedit = ((CheckBox)ModuleList.Items[i].FindControl("chkedit")); mp.hasEdit = (chkedit.Checked)?1:0; CheckBox chkview = ((CheckBox)ModuleList.Items[i].FindControl("chkview")); mp.hasView = (chkview.Checked)?1:0; CheckBox chkdelete = ((CheckBox)ModuleList.Items[i].FindControl("chkdelete")); mp.hasDelete = (chkdelete.Checked)?1:0; mp.RoleName = (Session["pickRoleName"] != null) ? Session["pickRoleName"].ToString() : string.Empty; permlist.Add(mp); } else { } } if (count == 0) { ShowWarningMessage(" Please select at least a Module for this role!"); } else { if(DataService.Provider.AddModulePermissions(permlist, lblRoleName.Text)>0) ShowMessage("Module Permissions Saved Successfully for Role!"); else ShowError("Error Occurred Saving Permission for Role!"); } }
/// <inheritdoc cref="ISecurityManager.SaveModulePermissionAsync(ModulePermissionInfo)" /> public async Task <bool> SaveModulePermissionAsync(ModulePermissionInfo modulePermissionInfo) { ModulePermission modulePermission = modulePermissionInfo.ToModulePermission(); if (modulePermissionInfo.ModulePermissionId > 0) { _dbContext.KastraModulePermissions.Update(modulePermission); } else { _dbContext.KastraModulePermissions.Add(modulePermission); } await _dbContext.SaveChangesAsync(); // Clear cache _cacheEngine.ClearCacheContains("Module"); return(true); }
public int ModulePermission_UpdateByp_gid(ModulePermission obj) { DbCommand dbCmd = db.GetStoredProcCommand("Proc_ModulePermission_UpdateByp_gid"); db.AddInParameter(dbCmd, "@p_gid", DbType.String, obj.p_gid); db.AddInParameter(dbCmd, "@p_m_gid", DbType.String, obj.p_m_gid); db.AddInParameter(dbCmd, "@p_name", DbType.String, obj.p_name); db.AddInParameter(dbCmd, "@p_path", DbType.String, obj.p_path); db.AddInParameter(dbCmd, "@p_createTime", DbType.String, obj.p_createTime); db.AddInParameter(dbCmd, "@p_createUser", DbType.String, obj.p_createUser); try { int returnValue = db.ExecuteNonQuery(dbCmd); return(returnValue); } catch (Exception e) { throw new Exception(e.Message); } }
public SaveResult SaveEditPermission(ModulePermission permission, int userId, string userName) { var oldEnt = BoDB.ModulePermissionDb.GetById(permission.Id); if (oldEnt.IsDefault) { return(new SaveResult(false, "This permission can't be updated")); } bool codeChanged = oldEnt.Code != permission.Code; if (codeChanged) { var hasSameCode = BoDB.ModulePermissionDb.IsAny(t => t.Code == permission.Code); if (hasSameCode) { return(new SaveResult(false, string.Format("The code {0} is exist", permission.Code))); } } oldEnt.Code = permission.Code; oldEnt.Description = permission.Description; oldEnt.Remark = permission.Remark; oldEnt.ModifyBy = permission.ModifyBy; oldEnt.ModifyTime = DateTime.UtcNow; BoDB.ModulePermissionDb.Update(oldEnt); // Create ActionLog ActionLog actionLog = new ActionLog(); actionLog.AccountId = userId; actionLog.CreateTime = DateTime.UtcNow; actionLog.ModuleCode = typeof(ModuleBLL).FullName + ".SaveEditPermission"; actionLog.Username = userName; actionLog.LogContent = string.Format("Update ModulePermission,ID:{0},Code:{1} ", permission.Id, permission.Code); ActionLogBLL ab = new ActionLogBLL(); ab.Create(actionLog); return(new SaveResult(true)); }
public OperationResult SetButton(ButtonModel model) { #region Add & Update var oldDataList = ModulePermissions.Where(t => t.ModuleId == model.ModuleId && t.IsDeleted == false).Select(t => t.PermissionId); var newDataList = model.SelectedButtonList.ToList(); var intersectIds = oldDataList.Intersect(newDataList).ToList(); // Same Ids var updateIds = oldDataList.Except(intersectIds).ToList(); // Remove Ids var addIds = newDataList.Except(oldDataList).ToList(); // Add Ids //逻辑删除 ->物理删除0321 foreach (var removeId in updateIds) { //var updateEntity = ModulePermissions.FirstOrDefault(t => t.ModuleId == model.ModuleId && t.PermissionId == removeId && t.IsDeleted == false); //if (updateEntity != null) //{ // updateEntity.IsDeleted = true; // ModulePermissionRepository.Update(updateEntity); //} ModulePermissionRepository.Delete(t => t.ModuleId == model.ModuleId && t.PermissionId == removeId && t.IsDeleted == false); } //插入 & 更新 foreach (var addId in addIds) { var updateEntity = ModulePermissions.FirstOrDefault(t => t.ModuleId == model.ModuleId && t.PermissionId == addId && t.IsDeleted == true); if (updateEntity != null) { updateEntity.IsDeleted = false; ModulePermissionRepository.Update(updateEntity); } else { var addEntity = new ModulePermission { ModuleId = model.ModuleId, PermissionId = addId }; ModulePermissionRepository.Insert(addEntity); } } #endregion return(new OperationResult(OperationResultType.Success, "设置成功")); }
public int ModulePermission_Insert(ModulePermission obj) { DbCommand dbCmd = db.GetStoredProcCommand("Proc_ModulePermission_Insert"); db.AddOutParameter(dbCmd, "@p_id", DbType.Int32, 4); db.AddInParameter(dbCmd, "@p_gid", DbType.String, obj.p_gid); db.AddInParameter(dbCmd, "@p_m_gid", DbType.String, obj.p_m_gid); db.AddInParameter(dbCmd, "@p_name", DbType.String, obj.p_name); db.AddInParameter(dbCmd, "@p_path", DbType.String, obj.p_path); db.AddInParameter(dbCmd, "@p_createTime", DbType.String, obj.p_createTime); db.AddInParameter(dbCmd, "@p_createUser", DbType.String, obj.p_createUser); try { int returnValue = db.ExecuteNonQuery(dbCmd); int p_id = (int)dbCmd.Parameters["@p_id"].Value; return(p_id); } catch (Exception e) { throw new Exception(e.Message); } }
public void GetModulePermissionSetWorksForTwoModules() { MockRolesCatalog catalog = new MockRolesCatalog(); MockAuthorizationService authSerivce = new MockAuthorizationService(); IPermissionsCatalog permissionsService = new MockPermissionCatalog(); AdminController controller = new AdminController(authSerivce, permissionsService, catalog); ModulePermissionSet testModuleSet = controller.GetModulePermissionSet("TestModule"); ModulePermission testModulePermission = testModuleSet.ModulePermissions[0]; Assert.AreEqual("TestModule", testModulePermission.ModuleName); Assert.AreEqual("Friendly", testModulePermission.ActionName); Assert.IsTrue(testModulePermission.Permissions is Dictionary <string, bool>); Assert.IsFalse(testModulePermission.Permissions["Mock01"]); ModulePermissionSet testModule02Set = controller.GetModulePermissionSet("TestModule"); ModulePermission testModule02Permission = testModule02Set.ModulePermissions[0]; Assert.AreEqual("TestModule", testModule02Permission.ModuleName); Assert.AreEqual("Friendly", testModule02Permission.ActionName); Assert.IsTrue(testModule02Permission.Permissions is Dictionary <string, bool>); Assert.IsFalse(testModule02Permission.Permissions["Mock01"]); }