public IList<Sys_Role> GetAllRole(string applicationName)
{
String stmtId = "Sys_Role.GetAllRole";
Sys_Role r = new Sys_Role();
r.ApplicationName = applicationName;
IList<Sys_Role> result = SqlMapper.QueryForList<Sys_Role>(stmtId, r);
return result;
}
public Sys_Role Find(string applicationName, string roleName)
{
String stmtId = "Sys_Role.FindByName";
Sys_Role r = new Sys_Role();
r.ApplicationName = applicationName;
r.RoleName = roleName;
Sys_Role result = SqlMapper.QueryForObject<Sys_Role>(stmtId, r);
return result;
}
public bool Delete(string applicationName, string roleName)
{
String stmtId = "Sys_Role.DeleteByName";
Sys_Role role = new Sys_Role();
role.ApplicationName = applicationName;
role.RoleName = roleName;
if (SqlMapper.Update(stmtId, role) > 0) {
return true;
}
else return false;
}
public override void CreateRole(string rolename)
{
if (rolename.IndexOf(',') > 0) {
throw new ArgumentException("Role names cannot contain commas.");
}
if (RoleExists(rolename)) {
throw new ProviderException("Role name already exists.");
}
Sys_Role role = new Sys_Role();
role.ApplicationName = ApplicationName;
role.RoleName = rolename;
_roleRepository.Insert(role);
}
public bool Insert(Sys_Role obj)
{
if (obj == null) throw new ArgumentNullException("obj");
String stmtId = "Sys_Role.Insert";
if (SqlMapper.Update(stmtId, obj) > 0) {
return true;
}
else return false;
}
