/// <summary>
/// Inserts a new Role in the Roles table
/// </summary>
/// <param name="roleName">The role's name</param>
/// <returns></returns>
public int Insert(IdentityRole role)
{
string commandText = "Insert into Roles (Id, Name) values (@id, @name)";
Dictionary<string, object> parameters = new Dictionary<string, object>();
parameters.Add("@name", role.Name);
parameters.Add("@id", role.Id);
return _database.Execute(commandText, parameters);
}
/// <summary>
/// Gets the IdentityRole given the role name
/// </summary>
/// <param name="roleName"></param>
/// <returns></returns>
public IdentityRole GetRoleByName(string roleName)
{
var roleId = GetRoleId(roleName);
IdentityRole role = null;
if (roleId != null)
{
role = new IdentityRole(roleName, roleId);
}
return role;
}
public int Update(IdentityRole role)
{
string commandText = "Update Roles set Name = @name where Id = @id";
Dictionary<string, object> parameters = new Dictionary<string, object>();
parameters.Add("@id", role.Id);
return _database.Execute(commandText, parameters);
}
public async Task<ActionResult> CreateRole()
{
var role = new IdentityRole() { Name = "Admin" };
var roleManger = await RoleManager.CreateAsync(role);
//roleManger.CreateAsync(role);
return View("ResetPassword");
}
/// <summary>
/// Gets the IdentityRole given the role Id
/// </summary>
/// <param name="roleId"></param>
/// <returns></returns>
public IdentityRole GetRoleById(int roleId)
{
var roleName = GetRoleName(roleId);
IdentityRole role = null;
if (roleName != null)
{
role = new IdentityRole(roleName, roleId);
}
return role;
}
public IEnumerable<IdentityRole> GetAllRoles()
{
List<IdentityRole> roles = new List<IdentityRole>();
string commandText = "Select * from Roles ";
var rows = _database.Query(commandText);
foreach (var row in rows)
{
var identityRole = new IdentityRole();
identityRole.Id = Int32.Parse(row["Id"]);
identityRole.Name = row["Name"];
roles.Add(identityRole);
}
return roles;
}
private void createRolesandUsers()
{
ApplicationDbContext context = new ApplicationDbContext();
var roleManager = new RoleManager <IdentityRole>(new RoleStore <IdentityRole>(context));
var UserManager = new UserManager <ApplicationUser>(new UserStore <ApplicationUser>(context));
var branchManager = new BranchManager <IdentityBranch>(new BranchStore <IdentityBranch>(context));
var bankManager = new BankManager <IdentityBank>(new BankStore <IdentityBank>(context));
var user = new ApplicationUser();
//branchManager.CreateUploadStatus();
if (!roleManager.RoleExists("Admin"))
{
var role = new AspNet.Identity.MySQL.IdentityRole();
role.Name = "Admin";
roleManager.Create(role);
user.UserName = "******";
user.Email = "*****@*****.**";
string userPWD = "password77$";
var chkUser = UserManager.Create(user, userPWD);
if (chkUser.Succeeded)
{
var result1 = UserManager.AddToRole(user.Id, "Admin");
}
}
if (!roleManager.RoleExists("BranchOperator"))
{
var role = new AspNet.Identity.MySQL.IdentityRole();
role.Name = "BranchOperator";
roleManager.Create(role);
}
if (!roleManager.RoleExists("BranchVerifier"))
{
var role = new AspNet.Identity.MySQL.IdentityRole();
role.Name = "BranchVerifier";
roleManager.Create(role);
}
if (!roleManager.RoleExists("HeadOfficeOperator"))
{
var role = new AspNet.Identity.MySQL.IdentityRole();
role.Name = "HeadOfficeOperator";
roleManager.Create(role);
}
if (!branchManager.BranchExists("Head Office"))
{
user = UserManager.FindByName("administrator");
var bank = new AspNet.Identity.MySQL.IdentityBank();
bank.Name = ConfigurationManager.AppSettings["OwnerBankName"];
bankManager.Create(bank);
var branch = new AspNet.Identity.MySQL.IdentityBranch();
branch.Name = "Head Office";
branch.BranchCode = "HeadOffice";
//branch.GLAccount = ConfigurationManager.AppSettings["DefaultGLAccount"];
branchManager.Create(branch);
branchManager.AddUserToBranch(user.Id, branch.Id);
//branchManager.CreateUploadStatus();
}
}