/// <summary>
        /// Выделение заказа в listview Заказов ЛКМ. Включение управления соответствующих элементов. Обновление listview Корзины, соответствующей выделенному заказу
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private async void listview_Orders_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
        {
            try
            {
                oClients_Orders = (Clients_Orders)listview_Orders.SelectedItem;

                switch (oClients_Orders.order.status)
                {
                case "В обработке":
                {
                    combobox_Status.SelectedIndex = 0;

                    grid_Status.IsEnabled = true;
                }
                break;

                case "Готовится к отправке":
                {
                    combobox_Status.SelectedIndex = 1;

                    grid_Status.IsEnabled = true;
                }
                break;

                case "Отправлен":
                {
                    combobox_Status.SelectedIndex = 2;

                    grid_Status.IsEnabled = true;
                }
                break;

                case "Завершён":
                {
                    combobox_Status.SelectedIndex = 3;

                    grid_Payments.IsEnabled = false;
                }
                break;
                }

                await Update_ListView_Payments();

                await Update_ListView_Carts();

                button_Delete.IsEnabled = true;
            }
            catch
            {
                System.Windows.Forms.MessageBox.Show("Клиент не выбран!");
            }
        }
        /// <summary>
        /// Обновление listview с Заказами. Ставим в соответствие каждому заказу его клиента.
        /// </summary>
        /// <returns></returns>
        private async Task Update_ListView_Orders()
        {
            List <Clients_Orders> lClients_Orders = new List <Clients_Orders>();
            List <Orders>         lOrders         = new List <Orders>();

            lOrders = await oOrdersRepository.Select_All_Orders_Async();

            foreach (var o in lOrders)
            {
                Clients_Orders clients_orders = new Clients_Orders();

                clients_orders.order  = o;
                clients_orders.client = await conn.GetAsync <Clients>(o.clients_id);

                lClients_Orders.Add(clients_orders);
            }

            listview_Orders.ItemsSource = lClients_Orders;
        }
        /// <summary>
        ///
        /// </summary>
        /// <param name="name"></param>
        /// <returns></returns>
        private async Task Update_ListView_Orders(string name)
        {
            List <Clients_Orders> lClients_Orders = new List <Clients_Orders>();
            List <Orders>         lOrders         = new List <Orders>();

            lOrders = await oOrdersRepository.Select_All_Orders_Async();

            foreach (var o in lOrders)
            {
                Clients_Orders clients_orders = new Clients_Orders();

                clients_orders.order  = o;
                clients_orders.client = await conn.GetAsync <Clients>(o.clients_id);

                if (clients_orders.client.full_name.ToLower().Contains(textbox_Search_Orders.Text.ToLower()))
                {
                    lClients_Orders.Add(clients_orders);
                }
            }

            listview_Orders.ItemsSource = lClients_Orders;
        }