private static void UpdateTaskTest()
        {
            var taskRepository = new AdoNetTasksDbRepository();

            Console.WriteLine("Enter existing task id");
            var id = int.Parse(Console.ReadLine());

            var task = taskRepository.GetByIdAsync(id).GetAwaiter().GetResult();

            if (task == null)
            {
                Console.WriteLine($"Task with id: {id} does not exist");
                return;
            }

            Console.WriteLine("Enter task title");
            task.Title = Console.ReadLine();

            Console.WriteLine("Enter task description");
            task.Description = Console.ReadLine();

            Console.WriteLine("Enter task status");
            task.Status = (DataLayer.Enums.Status) int.Parse(Console.ReadLine());

            Console.WriteLine("Enter task type");
            task.Type = (DataLayer.Enums.TaskType) int.Parse(Console.ReadLine());

            Console.WriteLine("Enter task priority");
            task.Priority = (DataLayer.Enums.Priority) int.Parse(Console.ReadLine());

            taskRepository.UpdateAsync(task).GetAwaiter().GetResult();
            Console.WriteLine("Successful update");

            Console.ReadLine();
        }
        private static void DeleteTaskTest()
        {
            var taskRepository = new AdoNetTasksDbRepository();

            Console.WriteLine("Enter existing task id");
            var id = int.Parse(Console.ReadLine());

            var task = taskRepository.GetByIdAsync(id).GetAwaiter().GetResult();

            if (task == null)
            {
                Console.WriteLine($"Task with id: {id} does not exist");
                return;
            }


            taskRepository.RemoveAsync(task).GetAwaiter().GetResult();
            Console.WriteLine("Successful delete");

            Console.ReadLine();
        }