public override async Task <ActionResponse> ExecuteActionAsync(ActionRequest request)
{
var azureToken = request.DataStore.GetJson("AzureTokenAS");
string serverUrl = request.DataStore.GetValue("ASServerUrl");
string xmla = request.DataStore.GetValue("xmlaFilePath");
string asDatabase = request.DataStore.GetValue("ASDatabase");
string sqlConnectionString = request.DataStore.GetValue("SqlConnectionString");
var connectionStringObj = SqlUtility.GetSqlCredentialsFromConnectionString(sqlConnectionString);
string connectionString = ValidateConnectionToAS.GetASConnectionString(request, azureToken, serverUrl);
string xmlaContents = File.ReadAllText(request.Info.App.AppFilePath + "/" + xmla);
Server server = null;
try
{
server = new Server();
server.Connect(connectionString);
// Delete existing
Database db = server.Databases.FindByName(asDatabase);
db?.Drop();
// Deploy database definition
var obj = JsonUtility.GetJsonObjectFromJsonString(xmlaContents);
obj["create"]["database"]["name"] = asDatabase;
XmlaResultCollection response = server.Execute(obj.ToString());
if (response.ContainsErrors)
{
return(new ActionResponse(ActionStatus.Failure, response[0].Value));
}
// Reload metadata and update connection string
server.Refresh(true);
db = server.Databases.FindByName(asDatabase);
((ProviderDataSource)db.Model.DataSources[0]).ConnectionString = $"Provider=SQLNCLI11;Data Source=tcp:{connectionStringObj.Server};Persist Security Info=True;User ID={connectionStringObj.Username};Password={connectionStringObj.Password};Initial Catalog={connectionStringObj.Database}";
db.Update(UpdateOptions.ExpandFull);
// Process if there's a tag requesting it
if (db.Model.DataSources[0].Annotations.ContainsName("MustProcess"))
{
db.Model.RequestRefresh(AnalysisServices.Tabular.RefreshType.Full);
db.Model.SaveChanges();
}
server.Disconnect(true);
return(new ActionResponse(ActionStatus.Success));
}
catch (Exception e)
{
return(new ActionResponse(ActionStatus.Failure, string.Empty, e, null));
}
finally
{
server?.Dispose();
}
}
public override async Task <ActionResponse> ExecuteActionAsync(ActionRequest request)
{
var azureToken = request.DataStore.GetJson("AzureToken");
string serverUrl = request.DataStore.GetValue("ASServerUrl");
string asDatabase = request.DataStore.GetValue("ASDatabase");
string user = request.DataStore.GetValue("UserToAdd");
string connectionString = ValidateConnectionToAS.GetASConnectionString(request, azureToken, serverUrl);
Server server = null;
try
{
server = new Server();
server.Connect(connectionString);
Database db = server.Databases.FindByName(asDatabase);
if (db == null)
{
return(new ActionResponse(ActionStatus.Failure, string.Empty, null, null, "Unable to find model"));
}
var role = new ModelRole()
{
Name = "ProcessOnlyRole"
};
role.ModelPermission = ModelPermission.Administrator;
ExternalModelRoleMember member = new ExternalModelRoleMember();
member.IdentityProvider = "AzureAD";
member.MemberName = user;
//AzureAD
role.Members.Add(member);
db.Model.Roles.Add(role);
db.Model.SaveChanges();
server.Disconnect(true);
return(new ActionResponse(ActionStatus.Success));
}
catch (Exception e)
{
return(new ActionResponse(ActionStatus.Failure, string.Empty, e, null, "Unable to assign permissions"));
}
finally
{
server?.Dispose();
}
}