using System;

using System.Collections.Generic;

using System.Data.SqlClient;

using System.Linq;

using System.Text;

​

  public class Program

    {

       public static void Main()

        {

            // Question 1

            ReverseString("hello world"); 

            // Question 2

            ReverseWordOrder("Diviso at job a like would I");

            // Question 3

            RotateRight(new int[]{ 1, 2, 3, 4, 5 });

            // Question 4

            FindSecondLargeInArray(new int[] { 1, 2, 3, 4, 5 });

            // Question 5

            SingleToMulti(new int[] { 1, 2, 3, 4, 5, 6 }, 2, 3);

            // Please output everything to console

            BonusQuestionSql();

            Console.ReadLine();

        }

​

        // Q.1: How to reverse a string?

        internal static void ReverseString(string str)

        {

            /* input:- hello world ; output:- dlrow olleh

             * 

             * */

            Console.WriteLine(str);

        }

​

        // Q.2: How to reverse the order of words in a given string?

        internal static void ReverseWordOrder(string str)

        {

            /* input:- Welcome to Csharp corner ; output:- corner Csharp to Welcome

            * 

            * */

​

​

            Console.WriteLine(str);

        }

​

        // Q.3: How to perform Right circular rotation of an array?

        internal static void RotateRight(int[] array)

        {

            /* input :- 1 2 3 4 5 output :- 5 1 2 3 4 

             * */

​

            //Logic 1 :- Iterate loop from 0 to size-1 and swap each elements with first element 

​

        }

​

        // Q.4: How to find second largest integer in an array using only one loop?

        internal static void FindSecondLargeInArray(int[] arr)

        {

            /* input :- 1 2 3 4 5 output :- 4 

            * */

​

​

        }

​

        // Q.5: How to convert a one-dimensional array to a two-dimensional array?

        internal static void SingleToMulti(int[] array, int row, int column)

        {

            //convert 1-D array to 2-D array

​

            /* input: 1, 2, 3, 4, 5, 6

             * output: 1 2 3

             *         4 5 6

             * 

             * */

        }

        internal static void BonusQuestionSql()

        {

            /*

This is a bonus question, where you can show your data-skills

We have created 3 tables for the assignment:

tblCustomer: Contains customers

tblOrder: Contains orders

tblOrderLine: Contains orderlines for each order

​

Tables looks like:

​

  SELECT

       [ID]

      ,[firstname]

      ,[lastname]

      ,[address1]

      ,[address2]

      ,[zip]

      ,[city]

      ,[deletedOn]

  FROM [tblCustomer]

​

​

  SELECT

       [ID]

      ,[customerID]

      ,[createDate]

      ,[deletedOn]

  FROM [tblOrder]

​

  SELECT

       [ID]

      ,[orderID]

      ,[itemText]

      ,[price]

      ,[quantity]

      ,[deletedOn]

      ,[productID]

  FROM [tblOrderLine]

​

1) 

Please create a SQL-query containing OrderID, Customer name (first- and last in same column), Order Date and a Order Total (subquery on orderlines).

Result should be ordered by OrderID ascending.

Result shouldnt contain deleted rows from tblOrder and tblCustomer

2)

When you have the query, output data in console in this form

OrderID|Customer name|Order Date|Order Total

​

example:

5|Ahmad Nielsen|2020-01-01|33786.35

6|Aleksandra Hansen|2020-01-01|62670.20

7|Ali Jensen|2020-01-01|43041.88

8|Allan Nielsen|2020-01-01|26617.03

9|Allan Hansen|2020-01-01|38887.12

​

​

*/

​

            string connectionString = "Server=mssql-23833-0.cloudclusters.net,23833;Database=devtest;TrustServerCertificate=True;user=devtest;Password=devtest1234";

            using (var _connection = new SqlConnection(connectionString))

            {

                _connection.Open();

​

                using (SqlCommand command = new SqlCommand("SELECT * FROM [tblOrder]", _connection))

                {

​

                    SqlDataReader sqlDataReader = command.ExecuteReader();

                    if (sqlDataReader.HasRows)

                    {

                        while (sqlDataReader.Read())

                        {

                            Console.WriteLine(sqlDataReader["id"].ToString());

                        }

                    }

                    sqlDataReader.Close();

                }

                _connection.Close();

            }

​

        }

        }

​