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;
}