/// <summary>
        /// Обновление listview с Клиентами. Каждому клиенту ставится в соответствие его бонусная карта
        /// </summary>
        /// <returns></returns>
        private async Task Update_ListView_Clients()
        {
            List <Client_Card> lClient_Card = new List <Client_Card>();

            List <Clients> lClients = await oClientsRepository.Select_All_Clients_Async();

            foreach (var c in lClients)
            {
                Client_Card client_card = new Client_Card();

                client_card.client = c;
                client_card.card   = await conn.GetAsync <Cards>(c.cards_id);

                lClient_Card.Add(client_card);
            }

            listview_Clients.ItemsSource = lClient_Card;
        }
        /// <summary>
        /// Обновление listview с Клиентами с фильтром поисковой строки по ФИО, Телефону или Email. Каждому клиенту ставится в соответствие его бонусная карта
        /// </summary>
        /// <param name="full_name"></param>
        /// <returns></returns>
        private async Task Update_ListView_Clients(string text)
        {
            List <Client_Card> lClient_Card = new List <Client_Card>();

            List <Clients> lClients = await oClientsRepository.Select_All_Clients_Async();

            foreach (var c in lClients)
            {
                Client_Card client_card = new Client_Card();

                if (c.full_name.ToLower().Contains(text.ToLower()) || c.phone_number.ToLower().Contains(text.ToLower()) || c.email.ToLower().Contains(text.ToLower()))
                {
                    client_card.client = c;
                    client_card.card   = await conn.GetAsync <Cards>(c.cards_id);

                    lClient_Card.Add(client_card);
                }
            }

            listview_Clients.ItemsSource = lClient_Card;
        }
        /// <summary>
        /// Выделение клиента ЛКМ
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void listview_Clients_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
        {
            try
            {
                oClient_Card = (Client_Card)listview_Clients.SelectedItem;

                textbox_Address.IsEnabled = true;

                label_Cost.IsEnabled       = true;
                label_Discount.IsEnabled   = true;
                label_Total_Cost.IsEnabled = true;

                textbox_Search_Cart.IsEnabled    = true;
                textbox_Search_Bouquet.IsEnabled = true;

                listview_Carts.IsEnabled    = true;
                listview_Bouquets.IsEnabled = true;
            }
            catch
            {
                System.Windows.Forms.MessageBox.Show("Клиент не выбран!");
            }
        }