public async Task DelAutoRoles(SocketRole name)
{
await Context.Channel.TriggerTypingAsync();
var autoRoles = await _autoRolesHelperClass.GetAutoRolesAsync(Context.Guild);
var role = Context.Guild.Roles.FirstOrDefault(x => x.Id == name.Id);
if (role == null)
{
await ReplyAsync("Role does not exist!!");
return;
}
if (role.Position > Context.Guild.CurrentUser.Hierarchy)
{
await ReplyAsync("Role is higher than bot's!!!!");
return;
}
if (autoRoles.Any(x => x.Id != role.Id))
{
await ReplyAsync("That role isn't set as auto role yet!");
return;
}
await _autoRoles.RemoveAutoRolesAsync(Context.Guild.Id, role.Id);
await RoleExtension.RemoveAutoRoleEmbed(Context.Channel, role);
}
public async Task DelRank(SocketRole name)
{
await Context.Channel.TriggerTypingAsync();
var ranks = await _ranksHelperClass.GetRankAsync(Context.Guild);
var role = Context.Guild.Roles.FirstOrDefault(x =>
x.Id == name.Id);
if (role == null)
{
await ReplyAsync("Role does not exist!!");
return;
}
if (role.Position > Context.Guild.CurrentUser.Hierarchy)
{
await ReplyAsync("Role is higher than bot's!!!!");
return;
}
if (ranks.Any(roleRank => roleRank.Id == role.Id))
{
await _ranks.RemoveRankAsync(Context.Guild.Id, role.Id);
await RoleExtension.RevokeRankRoleEmbed(Context.Channel, role);
return;
}
await ReplyAsync("Role is not set in roles list!");
}
public List <RoleExtension> GetRoleExtensions()
{
List <RoleExtension> data = new List <RoleExtension>();
using (DataCommand cmd = DataCommandManager.GetDataCommand("GetRolePermission"))
{
using (IDataReader dr = cmd.ExecuteDataReader())
{
while (dr.Read())
{
RoleExtension model = new RoleExtension();
if (!Convert.IsDBNull(dr["RoleId"]))
{
model.RoleId = Convert.ToInt32(dr["RoleId"]);
}
if (!Convert.IsDBNull(dr["RoleName"]))
{
model.RoleName = dr["RoleName"].ToString();
}
if (!Convert.IsDBNull(dr["PermissionId"]))
{
model.PermissionId = Convert.ToInt32(dr["PermissionId"]);
}
if (!Convert.IsDBNull(dr["Fullname"]))
{
model.PermissionName = dr["Fullname"].ToString();
}
if (!Convert.IsDBNull(dr["Code"]))
{
model.PermissionCode = dr["Code"].ToString();
}
data.Add(model);
}
}
}
return(data);
}
public RoleExtension GetRoleExtensionByRoleId(int roleId)
{
RoleExtension model = new RoleExtension();
using (DataCommand cmd = DataCommandManager.GetDataCommand("GetRolePermissionByRoleId"))
{
cmd.SetParameterValue("@RoleId", roleId);
using (IDataReader dr = cmd.ExecuteDataReader())
{
while (dr.Read())
{
if (Convert.IsDBNull(dr["RoleId"]))
{
model.RoleId = Convert.ToInt32(dr["RoleId"]);
}
if (Convert.IsDBNull(dr["RoleName"]))
{
model.RoleName = dr["RoleName"].ToString();
}
if (Convert.IsDBNull(dr["PermissionId"]))
{
model.PermissionId = Convert.ToInt32(dr["PermissionId"]);
}
if (Convert.IsDBNull(dr["Fullname"]))
{
model.PermissionName = dr["Fullname"].ToString();
}
if (Convert.IsDBNull(dr["Code"]))
{
model.PermissionCode = dr["Code"].ToString();
}
}
}
}
return(model);
}
