C#

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.

Exoskeletor wrote:

i would have to retrieve all the images and check them one by one