private void button_Click_2(object sender, RoutedEventArgs e)
 {
     if (sql.isBlackList(mID, tID))
     {
         sql.Action(mID, tID, 3, false);
         BL.Content = "Add to black list";
     }
     else
     {
         sql.Action(mID, tID, 3, true);
         sql.Action(mID, tID, 2, false);
         BL.Content = "Remove from black List";
     }
 }
        private void Button_Click_1(object sender, RoutedEventArgs e)
        {
            sql = new SqlAction();
            sql.Action(mID, tID, 1, true);
            Messages msg = new Messages(mID, tID);

            //MessageBox.Show("ID" + Convert.ToString(ID), Convert.ToString(LBP.SelectedIndex));
            msg.Show();
        }
        public void newChat(object sender, EventArgs e)//обновление окна сообщений
        {
            LBA.Items.Clear();
            sql              = new SqlAction();
            Persons          = new List <Pers>();
            IDofExistMembers = new List <System.Windows.Controls.Label>();
            Tmp              = sql.StateOf(ID, 2);
            //sql.GetPeople();
            for (int i = 0; i < Tmp.Length; i++)
            {
                Persons.Add(Tmp[i]);
            }
            Array.Sort(Tmp);
            AvaOfPers   = new List <Image>();
            NameOfPers  = new List <TextBlock>();
            SP          = new List <StackPanel>();
            IDofMembers = new List <System.Windows.Controls.Label>();
            for (int i = 0; i < Persons.Count; i++)
            {
                if (sql.isBlackList(ID, Persons[i].id) || sql.isBlackList(Persons[i].id, ID))
                {
                    sql.Action(ID, Persons[i].id, 2, false);
                }

                if (Persons[i].id != ID && (!sql.isBlackList(ID, Persons[i].id) && !sql.isBlackList(Persons[i].id, ID)))
                {
                    SP.Add(new StackPanel());
                    AvaOfPers.Add(new Image());
                    NameOfPers.Add(new TextBlock());
                    IDofMembers.Add(new System.Windows.Controls.Label());

                    NameOfPers[i].Text = " " + Persons[i].FullNameToStr;
                    try
                    {
                        AvaOfPers[i].Source = (new BitmapImage(new Uri(sql.GetData(Convert.ToInt32(Persons[i].id))[5])));
                    }
                    catch
                    {
                        AvaOfPers[i].Source = (new BitmapImage(new Uri("pack://siteoforigin:,,,/Resources/Empty.png")));
                    }
                    IDofMembers[i].Content     = Convert.ToString(Persons[i].id);
                    IDofMembers[i].Visibility  = Visibility.Hidden;
                    SP[i].Orientation          = System.Windows.Controls.Orientation.Horizontal;
                    AvaOfPers[i].Height        = 30;
                    AvaOfPers[i].Width         = 50;
                    AvaOfPers[i].Margin        = new Thickness(0, 0, 0, 0);
                    NameOfPers[i].Width        = 200;
                    NameOfPers[i].Height       = Double.NaN;
                    NameOfPers[i].TextWrapping = TextWrapping.Wrap;
                    SP[i].Children.Add(AvaOfPers[i]);
                    SP[i].Children.Add(NameOfPers[i]);
                    SP[i].Children.Add(IDofMembers[i]);
                    LBA.Items.Add(SP[i]);
                }
            }
        }
        //Стоит сделать ее 1-й фнкцией т к повторяется 4 раза
        public void Refresh(object sender, EventArgs e)//обновление окна сообщений
        {
            LBF.Items.Clear();
            sql = new SqlAction();
            Pers[] Persons = sql.StateOf(ID, 2);
            Array.Sort(Persons);
            Ava        = new List <Image>();
            NameOfPers = new List <TextBlock>();
            SP         = new List <StackPanel>();
            image1     = new List <BitmapImage>();
            KeepID     = new List <System.Windows.Controls.Label>();
            for (int i = 0; i < Persons.Length; i++)
            {
                if (sql.isBlackList(ID, Persons[i].id) || sql.isBlackList(Persons[i].id, ID))
                {
                    sql.Action(ID, Persons[i].id, 2, false);
                }

                if (Persons[i].id != ID && (!sql.isBlackList(ID, Persons[i].id) && !sql.isBlackList(Persons[i].id, ID)))
                {
                    SP.Add(new StackPanel());
                    Ava.Add(new Image());
                    NameOfPers.Add(new TextBlock());
                    KeepID.Add(new System.Windows.Controls.Label());

                    NameOfPers[i].Text = " " + Persons[i].FullNameToStr;
                    try
                    {
                        image1.Add(new BitmapImage(new Uri(sql.GetData(Convert.ToInt32(Persons[i].id))[5])));
                    }
                    catch
                    {
                        image1.Add(new BitmapImage(new Uri("pack://siteoforigin:,,,/Resources/Empty.png")));
                    }
                    Ava[i].Source              = image1[i];
                    KeepID[i].Content          = Convert.ToString(Persons[i].id);
                    SP[i].Orientation          = System.Windows.Controls.Orientation.Horizontal;
                    Ava[i].Height              = 30;
                    Ava[i].Width               = 50;
                    Ava[i].Margin              = new Thickness(0, 0, 0, 0);
                    NameOfPers[i].Width        = 200;
                    NameOfPers[i].Height       = Double.NaN;
                    NameOfPers[i].TextWrapping = TextWrapping.Wrap;
                    SP[i].Children.Add(Ava[i]);
                    SP[i].Children.Add(NameOfPers[i]);
                    LBF.Items.Add(SP[i]);
                }
            }
        }