Breaking News: Grepper is joining You.com. Read the official announcement!

OFS means Open Financial System, it uses tc server to communicate and doesnot need sql server

theenescresta answered on August 10, 2023 Popularity 1/10 Helpfulness 1/10

answer OFS means Open Financial System, it uses tc server to communicate and doesnot need sql server

OFS means Open Financial System, it uses tc server to communicate and doesnot need sql server

Comment

using System;
using System.Collections.Generic;
using System.Net;
using System.Net.Http;
using System.Net.Http.Headers;
using System.Text;
using Newtonsoft.Json;

[HttpGet]
public async Task<IActionResult> ExecuteQuery(string requestType, string parameter)
{
    string serverUrl = Configuration.GetValue<string>("ServerUrl");
    string ofsQuery;

    // Retrieve the OFS query for the specified request type from the configuration settings
    ofsQuery = Configuration.GetSection("OFSQueries").GetValue<string>(requestType);

    if (string.IsNullOrEmpty(ofsQuery))
    {
        return BadRequest("Invalid requestType parameter");
    }

    // Build the OFS request payload using the query and parameter
    string payload = BuildOFSRequestPayload(ofsQuery, parameter);

    // Send the OFS request to the T24 server and retrieve the response
    string response = await SendOFSRequest(serverUrl, payload);

    // Deserialize the JSON response to a list of dictionaries
    List<Dictionary<string, string>> resultList = JsonConvert.DeserializeObject<List<Dictionary<string, string>>>(response);

    // Convert the list of dictionaries to a JSON string and return it as the response
    string jsonResult = JsonConvert.SerializeObject(resultList, Formatting.Indented);
    return Ok(jsonResult);
}

private string BuildOFSRequestPayload(string query, string parameter)
{
    // Build the OFS request payload using the query and parameter
    string payload = "{\"input\": {";
    payload += "\"service\": \"EXECUTEQUERY\",";
    payload += "\"control\": {";
    payload += "\"operation\": \"EXECUTEQUERY\",";
    payload += "\"parameter\": \"" + parameter + "\"";
    payload += "},";
    payload += "\"data\": {";
    payload += "\"Query\": \"" + query + "\"";
    payload += "}";
    payload += "}}";
    return payload;
}

private async Task<string> SendOFSRequest(string serverUrl, string payload)
{
    // Send the OFS request to the T24 server and retrieve the response
    using (HttpClient httpClient = new HttpClient())
    {
        httpClient.BaseAddress = new Uri(serverUrl);
        httpClient.DefaultRequestHeaders.Accept.Clear();
        httpClient.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));

        StringContent content = new StringContent(payload, Encoding.UTF8, "application/json");
        HttpResponseMessage response = await httpClient.PostAsync("ofs/core/v1/service/ExecuteQuery", content);

        if (response.StatusCode != HttpStatusCode.OK)
        {
            throw new Exception("OFS request failed with status code " + response.StatusCode);
        }

        string responseContent = await response.Content.ReadAsStringAsync();
        return responseContent;
    }
}

Popularity 1/10 Helpfulness 1/10 Language typescript

Source: chat.openai.com

Tags: communicate financial server sql-server typescript uses

Link to this answer
Share Copy Link

Contributed on Aug 10 2023

theenescresta

0 Answers Avg Quality 2/10

OFS means Open Financial System, it uses tc server to communicate and doesnot need sql server

Contents

More Related Answers

OFS means Open Financial System, it uses tc server to communicate and doesnot need sql server

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.