//insert role permission
public async Task insertRolePerm(insert_role_permission result)
{
using var cmd = Db.Connection.CreateCommand();
cmd.CommandText = @"insert into db_final.role_to_permission(role_id,permission_id) values(@role,@permission);";
BindId5(cmd, result.Role_Id, result.Permission_id);
cmd.CommandText = cmd.CommandText;
await cmd.ExecuteNonQueryAsync();
}
public async Task <IActionResult> insertnewRolePermission([FromBody] insert_role_permission body)
{
await Db.Connection.OpenAsync();
var query = new BlogPostQuery(Db);
var result = new insert_role_permission();
result.Role_Id = body.Role_Id;
result.Permission_id = body.Permission_id;
await query.insertRolePerm(result);
return(new OkObjectResult(result));
}
