Зміст курсу

Introduction to .NET with C#

1. Introduction

What is the .NET Platform exactly?Creating a Console Application Taking input from the User Task - Building a Simple Calculator Dealing with Exceptions caused by User Input Task - Improving the Calculator Reading Files Writing Files Task - File Based Calculator

2. Asynchronous Programming and Introduction to Web Services

What is Asynchronous Programming?Implementing an Asynchronous Method Task - Asynchronously Reading Files Introduction to APIs Making a GET Request Task - Using an API Handling Exceptions caused by HTTP Request Task - Exception Handling for API Response

3. Introduction to Databases with .NET

What is a Database?Structure of a Relational Database Setting Up A MySQL Server Connecting to the MySQL Server Task - Writing Connection Strings Executing Commands Task - Executing MySQL Commands MySqlCommand Methods Task - Connecting to a MySQL Database and Executing Commands

4. CRUD Operations with MySQL

Introduction to CRUD Operations Installing & Using MySQL Workbench CREATE - Part I Task - Using CREATE CREATE - Part II Task - Using INSERT Read Task - Using SELECT Update Task - Using UPDATE Delete - Part I Delete - Part II Task - Using DELETE

5. Optimizing Database Operations

Stored Procedures Task - Executing Stored Procedures DataReader vs DataSet DataAdapter & DataSet Task - Reading Tables using MySqlDataAdapter What's Next?

Introduction to .NET with C#

Task - Exception Handling for API Response

The task is to work on the code from the previous task, and add error checking, exactly the way we did in the video.

You don't need to add error checking for int.Parse methods.

Note
This task does not have test cases. You can verify your solution by comparing it to the given solution code.

Link to the Task: GitHub

1. Enclose the request code inside a try-catch block to ensure it doesn't fail in case the url is wrong. This is because the url can be wrong in case the user gives some abnormal input.
2. Check if the request was successful by using the IsSuccessStatusCode attribute of the response class.


class NumbersFact
{
    static async Task Main()
    {
        Console.WriteLine(">> This program gives you a random fact about any day of the year. ");

        Console.Write("Enter the number of month (1-12): ");
        int month = int.Parse(Console.ReadLine());

        Console.Write("Enter the number of day: ");
        int day = int.Parse(Console.ReadLine());

        // Write code below this line
        try
        {
            string url = $"http://numbersapi.com/{month}/{day}/date";
            HttpClient client = new HttpClient();
            HttpResponseMessage response = await client.GetAsync(url);

            if (response.IsSuccessStatusCode)
            {
                string responseContent = await response.Content.ReadAsStringAsync();
                Console.WriteLine("Fact: " + responseContent);
            }
            else
            {
                Console.WriteLine($"API request failed: {response.StatusCode}");
            }
        }
        catch(Exception ex)
        {
            Console.WriteLine(ex);
        }
        // Write code above this line
    }
}

Все було зрозуміло?

Секція 2. Розділ 8

Зміст курсу

Introduction to .NET with C#

1. Introduction

2. Asynchronous Programming and Introduction to Web Services

3. Introduction to Databases with .NET

4. CRUD Operations with MySQL

5. Optimizing Database Operations

Stored Procedures Task - Executing Stored Procedures DataReader vs DataSet DataAdapter & DataSet Task - Reading Tables using MySqlDataAdapter What's Next?

Introduction to .NET with C#

Task - Exception Handling for API Response

The task is to work on the code from the previous task, and add error checking, exactly the way we did in the video.

You don't need to add error checking for int.Parse methods.

Note
This task does not have test cases. You can verify your solution by comparing it to the given solution code.

Link to the Task: GitHub


class NumbersFact
{
    static async Task Main()
    {
        Console.WriteLine(">> This program gives you a random fact about any day of the year. ");

        Console.Write("Enter the number of month (1-12): ");
        int month = int.Parse(Console.ReadLine());

        Console.Write("Enter the number of day: ");
        int day = int.Parse(Console.ReadLine());

        // Write code below this line
        try
        {
            string url = $"http://numbersapi.com/{month}/{day}/date";
            HttpClient client = new HttpClient();
            HttpResponseMessage response = await client.GetAsync(url);

            if (response.IsSuccessStatusCode)
            {
                string responseContent = await response.Content.ReadAsStringAsync();
                Console.WriteLine("Fact: " + responseContent);
            }
            else
            {
                Console.WriteLine($"API request failed: {response.StatusCode}");
            }
        }
        catch(Exception ex)
        {
            Console.WriteLine(ex);
        }
        // Write code above this line
    }
}

Все було зрозуміло?

Секція 2. Розділ 8