private static void AppendToWorksheet(JObject queryResponse, JToken queryData)
{
if (validateQueryData("AppendToWorksheet", queryData, new string[] { "securities" }, new string[] { "name", "id" }, queryResponse))
{
List <string> securities = new List <string>();
foreach (string a in queryData["securities"])
{
securities.Add(a);
}
string worksheetId = resolveWorksheetId(queryData, queryResponse);
if (worksheetId != null)
{
BlpWorksheet worksheet = BlpTerminal.GetWorksheet(worksheetId);
if (worksheet != null)
{
worksheet.AppendSecurities(securities);
queryResponse.Add("status", true);
queryResponse.Add("worksheet", renderWorksheet(worksheet, true));
}
else
{
queryResponse.Add("status", false);
queryResponse.Add("message", "Worksheet with id '" + worksheetId + "' not found");
}
}
}
}
private static void CreateWorksheet(JObject queryResponse, JToken queryData)
{
if (validateQueryData("CreateWorksheet", queryData, new string[] { "securities", "name" }, null, queryResponse))
{
var _securities = new List <string>();
foreach (string a in queryData["securities"])
{
_securities.Add(a);
}
BlpWorksheet worksheet = BlpTerminal.CreateWorksheet(queryData["name"].ToString(), _securities);
queryResponse.Add("status", true);
queryResponse.Add("worksheet", renderWorksheet(worksheet, true));
}
}
private static JObject renderWorksheet(BlpWorksheet worksheet, bool includeSecurities = false)
{
JObject worksheetObj = new JObject {
{ "name", worksheet.Name },
{ "id", worksheet.Id },
{ "isActive", worksheet.IsActive }
};
if (includeSecurities)
{
var securities = worksheet.GetSecurities();
JArray securitiesArr = new JArray();
JObject obj = new JObject();
foreach (string a in securities)
{
securitiesArr.Add(a);
}
worksheetObj.Add("securities", securitiesArr);
}
return(worksheetObj);
}
private static void GetWorksheet(JObject queryResponse, JToken queryData)
{
if (validateQueryData("GetWorksheet", queryData, null, new string[] { "name", "id" }, queryResponse))
{
string worksheetId = resolveWorksheetId(queryData, queryResponse);
if (worksheetId != null)
{
BlpWorksheet worksheet = BlpTerminal.GetWorksheet(worksheetId);
if (worksheet != null)
{
queryResponse.Add("status", true);
queryResponse.Add("worksheet", renderWorksheet(worksheet, true));
}
else
{
queryResponse.Add("status", false);
queryResponse.Add("message", "Worksheet with id '" + worksheetId + "' not found");
}
}
}
}
