public static RolesPrivilegeInfo PopulateRolesPrivilege(IDataRecord reader) { if (reader == null) { return(null); } RolesPrivilegeInfo rolesPrivilegeInfo = new RolesPrivilegeInfo(); rolesPrivilegeInfo.RoleId = (int)reader["RoleId"]; rolesPrivilegeInfo.Privilege = (int)reader["Privilege"]; return(rolesPrivilegeInfo); }
public List <RolesPrivilegeInfo> GetRolesPrivilegeByPrivilege(int privilege) { DbCommand sqlStringCommand = base.database.GetSqlStringCommand("SELECT [Privilege],[RoleId] FROM [dbo].[aspnet_RolesPrivileges] WHERE Privilege=@Privilege"); base.database.AddInParameter(sqlStringCommand, "Privilege", DbType.Int32, privilege); List <RolesPrivilegeInfo> list = new List <RolesPrivilegeInfo>(); using (IDataReader dataReader = base.database.ExecuteReader(sqlStringCommand)) { while (dataReader.Read()) { RolesPrivilegeInfo item = RolesPrivilegeDao.PopulateRolesPrivilege(dataReader); list.Add(item); } } return(list); }
public static int AddPrivilegeInRoles(int roleId, string strPermissions) { string[] array = strPermissions.Split(','); RolesPrivilegeDao rolesPrivilegeDao = new RolesPrivilegeDao(); RolesPrivilegeInfo rolesPrivilegeInfo = null; int num = 0; string[] array2 = array; foreach (string s in array2) { rolesPrivilegeInfo = new RolesPrivilegeInfo(); rolesPrivilegeInfo.RoleId = roleId; rolesPrivilegeInfo.Privilege = int.Parse(s); if (rolesPrivilegeDao.Add(rolesPrivilegeInfo, null) > 0) { num++; } } return(num); }