// ReSharper disable PossibleMultipleEnumeration
public async Task RunAsync(IRestContext context)
{
ISystemApi systemApi = context.Factory.CreateSystemApi();
IEnumerable <ScriptResponse> scripts = await systemApi.GetScriptsAsync(true);
Console.WriteLine("GetScriptsAsync(): {0}", scripts.Select(x => x.script_id).ToStringList());
if (scripts.Any(x => x.script_id == ScriptId))
{
await DeleteDummyScript(systemApi);
}
const string scriptText = @"return Number(event.n1) + Number(event.n2);";
ScriptResponse response = await systemApi.WriteScriptAsync(ScriptId, scriptText);
Console.WriteLine("WriteScriptAsync(): id={0}", response.script_id);
Dictionary <string, object> p = new Dictionary <string, object> {
{ "n1", 3 }, { "n2", 5 }
};
string output = await systemApi.RunScriptAsync(ScriptId, p);
Console.WriteLine("RunScriptAsync(): {0}", context.ContentSerializer.Serialize(output));
await DeleteDummyScript(systemApi);
}
public IScriptReponse Execute(AbstractConnection connection, string script, int timeOut = 0)
{
var response = new ScriptResponse();
var server = new Server();
var logger = connection.Logger;
try {
logger.Debug("Connecting to {0} on {1}.", connection.Database, connection.Server);
server.Connect(connection.GetConnectionString());
var results = server.Execute(script);
foreach (XmlaResult result in results)
{
foreach (XmlaMessage message in result.Messages)
{
response.Messages.Add(message.Description);
}
}
response.Success = response.Messages.Count == 0;
} catch (Exception e) {
logger.Debug(e.Message + (e.InnerException != null ? " " + e.InnerException.Message : string.Empty));
response.Messages.Add(e.Message);
} finally {
if (server.Connected)
{
logger.Debug("Disconnecting from {0} on {1}.", connection.Database, connection.Server);
server.Disconnect();
}
}
return(response);
}
public ResponseModel <ScriptResponse> UpdateScript(AddScriptRequest objupdateRequest)
{
try
{
ScriptProvider objScriptProvider = new ScriptProvider(_context);
Script updatedScript = objScriptProvider.UpdateScript(objupdateRequest.ScriptDetails);
List <ScriptContent> scriptContents = objScriptProvider.UpdateScriptContents(objupdateRequest.ScriptContents, objupdateRequest.ScriptDetails.ScriptId);
ScriptResponse objScriptResponse = new ScriptResponse
{
Script = updatedScript,
ScriptContents = scriptContents
};
ResponseModel <ScriptResponse> objResponseModel = new ResponseModel <ScriptResponse>
{
Message = "Successfully Updated",
StatusCode = 1,
ResponseObject = objScriptResponse
};
return(objResponseModel);
}
catch (Exception ex)
{
ResponseModel <ScriptResponse> objResponseModel = new ResponseModel <ScriptResponse>
{
Message = ex.Message,
StatusCode = 0
};
return(objResponseModel);
}
}
private ScriptResponse RunScript(ScriptFile Script)
{
var resp = new ScriptResponse
{
ScriptFile = Script,
Successful = true,
Sql = File.ReadAllText(Script.FilePath)
};
var sw = new Stopwatch();
sw.Start();
try
{
using (var conn = new SqlConnection(this.connString))
{
conn.Open();
resp.ExecutedAt = DateTime.UtcNow;
conn.Execute(resp.Sql);
sw.Stop();
}
}
catch (Exception er)
{
sw.Stop();
resp.Successful = false;
resp.ErrorMessage = er.Message;
}
resp.Duration = sw.Elapsed.TotalSeconds;
return(resp);
}
public IScriptReponse Execute(AbstractConnection connection, string script, int timeOut = 0) {
var response = new ScriptResponse();
var server = new Server();
var logger = connection.Logger;
try {
logger.Debug("Connecting to {0} on {1}.", connection.Database, connection.Server);
server.Connect(connection.GetConnectionString());
var results = server.Execute(script);
foreach (XmlaResult result in results) {
foreach (XmlaMessage message in result.Messages) {
response.Messages.Add(message.Description);
}
}
response.Success = response.Messages.Count == 0;
} catch (Exception e) {
logger.Debug(e.Message + (e.InnerException != null ? " " + e.InnerException.Message : string.Empty));
response.Messages.Add(e.Message);
} finally {
if (server.Connected) {
logger.Debug("Disconnecting from {0} on {1}.", connection.Database, connection.Server);
server.Disconnect();
}
}
return response;
}
private void webView_NavigationFailed(object sender, WebViewNavigationFailedEventArgs e)
{
busy = false;
dialogLoadComplete = false;
lastUri = null;
webViewFB.Visibility = Windows.UI.Xaml.Visibility.Collapsed;
ScriptResponse sr = ErrorHandler.setupErrorResponse(ErrorsEnum.E000204);
string js = string.Format("javascript: var e = document.createEvent('Events');e.initEvent('appMobi.facebook.request.response',true,true);e.success=false;e.error='{0}';e.raw='';e.data={{}};document.dispatchEvent(e);", sr.Message);
InjectJS(js);
}
private async void GetUserData(Dictionary <string, string> param)
{
if (busy)
{
sendBusyEvent();
}
busy = true;
try
{
string path = "/me";
dynamic parameters = new ExpandoObject();
//if (param.Keys.Contains<string>("name")) { parameters.name = param["name"]; }
//if (param.Keys.Contains<string>("caption")) { parameters.caption = param["caption"]; }
//if (param.Keys.Contains<string>("link")) { parameters.link = param["link"]; }
//if (param.Keys.Contains<string>("picture")) { parameters.picture = param["picture"]; }
if (param.Keys.Contains <string>("path"))
{
path = param["path"];
}
Facebook.JsonObject result = await _fb.GetTaskAsync(path, parameters);
string js = "javascript: var e = document.createEvent('Events');e.initEvent('appMobi.facebook.request.response',true,true);e.success=true;e.raw='" + result.ToString() + "';e.data={};try{e.data=JSON.parse(e.raw);}catch(ex){}e.error='';document.dispatchEvent(e);";
InjectJS(js);
}
catch (FacebookApiException ex)
{
// handle error message
if (ex.ErrorCode == 2500)
{
// user not logged in.
ScriptResponse sr = ErrorHandler.setupErrorResponse(ErrorsEnum.E000203);
//string js = "(function(){ AppMobi.facebook.internal.handleResponse('request.response',false," + sr.ToJson() + ")})();";
string js = string.Format("javascript: var e = document.createEvent('Events');e.initEvent('appMobi.facebook.request.response',true,true);e.success=false;e.error='{0}';e.raw='';e.data={{}};document.dispatchEvent(e);", sr.Message);
InjectJS(js);
}
else
{
// user not logged in.
ScriptResponse sr = ErrorHandler.setupErrorResponse(ErrorsEnum.E000202);
//string js = "(function(){ AppMobi.facebook.internal.handleResponse('request.response',false," + sr.ToJson() + ")})();";
string js = string.Format("javascript: var e = document.createEvent('Events');e.initEvent('appMobi.facebook.request.response',true,true);e.success=false;e.error='{0}';e.raw='';e.data={{}};document.dispatchEvent(e);", sr.Message);
InjectJS(js);
}
}
finally
{ busy = false; }
}
public ScriptResponse Execute(ContextData context, Entity document, Dictionary <string, object> parameters)
{
var fields = $"Code:{document.PersonCode}";
var response = new ScriptResponse();
response.Actions = new Dictionary <string, object>();
var urlAction = new Dictionary <string, string>();
urlAction.Add("Location", $"../../Entity/Create/?EntityTypeCode=Person&MisEntityKind=Agent&View=Default&Attributes={HttpUtility.UrlEncode(HttpUtility.UrlEncode(fields))}");
urlAction.Add("Target", "CURRENT");
response.Actions.Add("URL", urlAction);
return(response);
}
public ScriptResponse Execute(ContextData context, Entity document, Dictionary <string, object> parameters)
{
var externalSystem = context.ExternalSystems.FirstOrDefault().Value;
ApiClient api = new ApiClient(context.Api.Endpoint, context.Tenant);
api.Authenticate(externalSystem.Parameters["omniaEmail"].ToString(), externalSystem.Parameters["omniaPassword"].ToString());
var documentToCopy = api.ProcessInteraction.GetByID("PurchasesManagement", "PurchaseOrder", Convert.ToInt64(document["ID"]));
var fields = $"CompanyCode:{documentToCopy.CompanyCode}";
var response = new ScriptResponse();
response.Actions = new Dictionary <string, object>();
var urlAction = new Dictionary <string, string>();
urlAction.Add("Location", $"../../ProcessInteraction/Create/?ProcessTypeCode=PurchasesManagement&InteractionTypeCode=PurchaseOrder&Attributes={HttpUtility.UrlEncode(HttpUtility.UrlEncode(fields))}");
urlAction.Add("Target", "CURRENT");
response.Actions.Add("URL", urlAction);
return(response);
}
private async void PostUserData(Dictionary <string, string> param)
{
if (busy)
{
sendBusyEvent();
}
busy = true;
try
{
string path = "/me/feed";
dynamic parameters = new ExpandoObject();
if (param.Keys.Contains <string>("name"))
{
parameters.name = param["name"];
}
if (param.Keys.Contains <string>("caption"))
{
parameters.caption = param["caption"];
}
if (param.Keys.Contains <string>("link"))
{
parameters.link = param["link"];
}
if (param.Keys.Contains <string>("picture"))
{
parameters.picture = param["picture"];
}
if (param.Keys.Contains <string>("message"))
{
parameters.message = param["message"];
}
if (param.Keys.Contains <string>("path"))
{
path = param["path"];
}
dynamic result = await _fb.PostTaskAsync(path, parameters);
lastMessageId = result.id;
ScriptResponse sr = new ScriptResponse {
Message = "Facebook Post Successful", ResponseCode = ""
};
string js = "(function(){ AppMobi.facebook.internal.handleResponse('dialog.complete',true," + sr.ToJson() + ")})();";
InjectJS(js);
}
catch (FacebookApiException ex)
{
// handle error message
if (ex.ErrorCode == 2500)
{
// user not logged in.
ScriptResponse sr = ErrorHandler.setupErrorResponse(ErrorsEnum.E000201);
string js = string.Format("javascript: var e = document.createEvent('Events');e.initEvent('appMobi.facebook.request.response',true,true);e.success=false;e.error='{0}';e.raw='';e.data={{}};document.dispatchEvent(e);", sr.Message);
InjectJS(js);
}
else
{
ScriptResponse sr = ErrorHandler.setupErrorResponse(ErrorsEnum.E000200);
//ScriptResponse sr = new ScriptResponse { Message = "Facebook Post Failed", ResponseCode = "" };
string js = string.Format("javascript: var e = document.createEvent('Events');e.initEvent('appMobi.facebook.request.response',true,true);e.success=false;e.error='{0}';e.raw='';e.data={{}};document.dispatchEvent(e);", sr.Message);
InjectJS(js);
}
}
finally
{ busy = false; }
}
//---------------------------------------------------------------------------------------------
// アプリ起動時に呼ばれる関メソッド(初期化)
//---------------------------------------------------------------------------------------------
void Start()
{
clickedGachaCube = null;
scriptResponse = new ScriptResponse();
}
