C#

var body = new
{
    No = tbNo.Text,
    First_name = tbFirstName.Text,
    Last_Name = tbLastName.Text,
    FunctionName = tbFunctionName.Text,
};

string json = JsonConvert.SerializeObject(body);
byte[] data = Encoding.UTF8.GetBytes(json);

WorkersClass _data = new WorkersClass();
_data.E_Tag = string.Empty;
_data.No = tbNo.Text;
_data.First_name = tbFirstName.Text;
_data.Last_Name = tbLastName.Text;
_data.FunctionName = tbFunctionName.Text;

var url = await CreateWorkerAsync(_data);

static async Task<Uri> CreateWorkerAsync(WorkersClass _worker)
{
    string _url = "https://api.businesscentral.dynamics.com/v2.0/SomeFunkyGuid/Sandbox/ODataV4/Company('CRONUS%20NL')/WorkersWebService";//Card Page
    string _userName = "UserName";
    string _wsKey = "Password";
    _client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue(_userName, _wsKey);
    HttpResponseMessage response = await _client.PostAsJsonAsync(_url, _worker);
    response.EnsureSuccessStatusCode();

    // return URI of the created resource.
    return response.Headers.Location;
}

var body = new
{
    E_Tag = string.Empty,     // Unique key
    No = tbNo.Text,
    First_name = tbFirstName.Text,
    Last_Name = tbLastName.Text,
    FunctionName = tbFunctionName.Text,
};


string json = JsonConvert.SerializeObject(body);
byte[] data = Encoding.UTF8.GetBytes(json);

var url = await CreateWorkerAsync(data);

Quote:

C#

string body = "{" + Environment.NewLine +
                    "\"No\":" + tbNo.Text + "," + Environment.NewLine +
                    "\"First_name\":\"" + tbFirstName.Text + "\"," + Environment.NewLine +
                    "\"Last_Name\":\"" + tbLastName.Text + "\"," + Environment.NewLine +
                    "\"FunctionName\":\"" + tbFunctionName.Text + "\"," + Environment.NewLine +
                  "}";

byte[] data = Encoding.ASCII.GetBytes(body);

try
{
    _request.ContentLength = data.Length;

    Stream requestStream = _request.GetRequestStream();
    requestStream.Write(data, 0, data.Length);
    requestStream.Close();

    HttpWebResponse _response = _request.GetResponse() as HttpWebResponse;//Here we get the exception errors 400 or 405
    Console.WriteLine(_response.StatusCode);
}
catch (Exception ex)
{

}

string _userName = "UserName";
string _wsKey = "Password";
byte[] authenticationParameter = Encoding.UTF8.GetBytes(_userName + ":" + _wsKey);
_client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic", Convert.ToBase64String(authenticationParameter));

static async Task<Uri> CreateWorkerAsync(WorkersClass _worker)
{
    string _url = "https://api.businesscentral.dynamics.com/v2.0/SomeFunkyGuid/Sandbox/ODataV4/Company('CRONUS%20NL')/WorkersWebService";//Card Page
    string _userName = "UserName";
    string _wsKey = "Password";
    byte[] _authenticationParameter = Encoding.UTF8.GetBytes(_userName + ":" + _wsKey);
    _client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Basic", Convert.ToBase64String(_authenticationParameter));
    HttpResponseMessage response = await _client.PostAsJsonAsync(_url, _worker);
    response.EnsureSuccessStatusCode();

    // return URI of the created resource.
    return response.Headers.Location;
}

listBox1.Items.Clear();
WorkersReadFromAlWebService = new List<WorkerClass>();
string _url = "https://api.businesscentral.dynamics.com/v2.0/SomeFunkyGuid/Sandbox/ODataV4/Company('CRONUS%20NL')/WorkersWebService";//CardPage
           HttpWebRequest _request = (HttpWebRequest)WebRequest.Create(_url);
_request.ContentType = "application/json; charset=utf-8";
_request.Headers["Authorization"] = "Basic " + Convert.ToBase64String(Encoding.GetEncoding("ISO-8859-1").GetBytes("UserName:Password"));
_request.PreAuthenticate = true;
HttpWebResponse _response = _request.GetResponse() as HttpWebResponse;
using (Stream _responseStream = _response.GetResponseStream())
{
    StreamReader _reader = new StreamReader(_responseStream, Encoding.UTF8);
    string _content = _reader.ReadToEnd();

    string _jasonPart = GetJsonPartMultiRecord(_content);

    List<WorkerClass> _jWorkers = JsonConvert.DeserializeObject<List<WorkerClass>>(_jasonPart);

    foreach (var _worker in _jWorkers)
    {
        WorkersReadFromAlWebService.Add(_worker);
        listBox1.Items.Add(_worker.Last_Name + " / " + _worker.First_name + " (No: " + _worker.No + ")");
    }
}

ClearWorker();

I am anoop
I Am anOop
I aM Anoop
I am anoOP
i AM anoop
I Am ANoOP
i aM anOop

auting82 wrote:

What are the real time requirements of this application?

 class Program
    {
        static void Main(string[] args)
        {           
         
            RunAsync().GetAwaiter().GetResult();
            Environment.Exit(0);
        }

static async Task RunAsync()
        {
            string httpReasonStatus = string.Empty;
            int reasoncode;

            using (var client = new HttpClient())
            {
                string baseURL = ConfigurationManager.AppSettings["APIURL"].ToString().Trim();
                client.BaseAddress = new Uri(baseURL);
                //client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("OAuth","xyz");
                client.DefaultRequestHeaders.Accept.Clear();
                client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));

                Console.WriteLine("Get");
                HttpResponseMessage response = await client.GetAsync("/api/SendBulkSMS");
                if (response.IsSuccessStatusCode)
                {
                    reasoncode = (int)response.StatusCode;
                    httpReasonStatus = response.ReasonPhrase;

                }
                else
                {
                    reasoncode = 0;
                    httpReasonStatus = "error";

                }

            }
        }
    }

static class Program
{
    static async Task<int> Main()
    {
        string baseURL = ConfigurationManager.AppSettings["APIURL"].Trim();
        if (!Uri.TryCreate(baseURL, UriKind.Absolute, out var baseAddress))
        {
            Console.Error.WriteLine("Invalid API URL: '{0}'", baseURL);
            return -1;
        }
        
        using (var client = new HttpClient())
        {
            client.BaseAddress = baseAddress;
            client.DefaultRequestHeaders.Accept.Clear();
            client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
            
            Console.WriteLine("Get");
            using (var response = await client.GetAsync("/api/SendBulkSMS"))
            {
                Console.WriteLine("{0}: {1}", response.StatusCode, response.ReasonPhrase);
                
                if (response.IsSuccessStatusCode) return 0;
                return (int)response.StatusCode;
            }
        }
    }
}

• Since C# 7.1, you can make the Main method async.
• You can return the exit code directly, rather than using Environment.Exit.
• You should avoid throwing an exception if the URL in the config file is invalid.
• You should wrap the HttpResponseMessage in a using block.
• There's no point in the reasoncode and httpReasonStatus variables, since you never use them.
• Console applications should generally return 0 if they succeed, and non-zero if they fail. The non-successful HTTP status code looks like a good candidate here.

Exoskeletor wrote:

but it's not working and i'm guessing it is not working because you cannot query with parameter "Images", in the database is stored as a blob. So im guessing i have to convert List to something else that is more easily supported in sqlite.

Exoskeletor wrote:

In my application every template has 5 images, but this might change in the future. What is the correct approach according to DB design, to have a TemplateImage object with 5 images or to have only one image for every TemplateImage object like this:

Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.