/// <summary>
/// Inserts a new Role in the Roles table
/// </summary>
/// <param name="role">The role's name</param>
/// <returns></returns>
public int Insert(IdentityRole role)
{
const string commandText = @"INSERT INTO ANID2ROLES (ID, NAME) VALUES (:ID, :NAME)";
var parameters = new List<OracleParameter>
{
new OracleParameter {ParameterName = "ID", Value = role.Id, OracleDbType = OracleDbType.Varchar2 },
new OracleParameter {ParameterName = "NAME", Value = role.Name, OracleDbType = OracleDbType.Varchar2 },
};
return _database.Execute(commandText, parameters);
}
/// <summary>
/// Gets the IdentityRole given the role Id
/// </summary>
/// <param name="roleId"></param>
/// <returns></returns>
public IdentityRole GetRoleById(string roleId)
{
var roleName = GetRoleName(roleId);
IdentityRole role = null;
if(roleName != null)
{
role = new IdentityRole(roleName, roleId);
}
return role;
}
/// <summary>
/// Update Role's attributes
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public int Update(IdentityRole role)
{
const string commandText = @"UPDATE ANID2ROLES SET NAME = :NAME WHERE ID = :ID";
var parameters = new List<OracleParameter>
{
new OracleParameter {ParameterName = "NAME", Value = role.Name, OracleDbType = OracleDbType.Varchar2 },
new OracleParameter {ParameterName = "ID", Value = role.Id, OracleDbType = OracleDbType.Varchar2 },
};
return _database.Execute(commandText, parameters);
}
public async Task<ActionResult> Create(RoleViewModel roleViewModel)
{
if (ModelState.IsValid)
{
var role = new IdentityRole(roleViewModel.Name);
var roleresult = await RoleManager.CreateAsync(role);
if (!roleresult.Succeeded)
{
ModelState.AddModelError("", roleresult.Errors.First());
return View();
}
return RedirectToAction("Index");
}
return View();
}
