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]);
}
}
}
List <System.Windows.Controls.Label> KeepID;//невидимый лейбл, который будет хранить айди
public Peoples(int id)
{
SqlAction sql = new SqlAction();
ID = id;
InitializeComponent();
//Стоит сделать ее 1-й фнкцией т к повторяется 3 раза
Pers[] Persons = sql.StateOf(ID, 1);
Array.Sort(Persons);
//for (int i = 0; i < Persons.Length; i++)
//{
// if(Persons[i].id!= ID)
// {
// LBP.Items.Add(Persons[i]);
// //Persons[i].FullNameToStr = Persons[i].FirstName + " " + Persons[i].LastName;
// LBP.DisplayMemberPath = "FullNameToStr";
// }
//}
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 (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;
//time[i].Foreground = new SolidColorBrush(Colors.Red);
//time[i].HorizontalAlignment = Left;
//time[i].Color = "grey";
SP[i].Children.Add(Ava[i]);
SP[i].Children.Add(NameOfPers[i]);
LBP.Items.Add(SP[i]);
//LBP.Items.Add(Persons[i]);
// LBP.DisplayMemberPath = "FullNameToStr";
}
//for (int i = 0; i < Persons.Length; i++)
// {
// LBS.Items.Add(Persons[i]);
// LBS.DisplayMemberPath = "FullNameToStr";
// }
}
//ListCollectionView view = new ListCollectionView(Persons);
//view.SortDescriptions.Add(new System.ComponentModel.SortDescription("FirstName",
// System.ComponentModel.ListSortDirection.Ascending));
//view.SortDescriptions.Add(new System.ComponentModel.SortDescription("LastName",
// System.ComponentModel.ListSortDirection.Ascending));
//view.Refresh();
}
void Refresh(object sender, EventArgs e)
{
LBC.Items.Clear();
LBP.Items.Clear();
Persons = sql.StateOf(ID, 1);
Array.Sort(Persons);
chats = sql.GetChats(ID);
Array.Sort(chats);
//for (int i = 0; i < Persons.Length; i++)
//{
// if(Persons[i].id!= ID)
// {
// LBP.Items.Add(Persons[i]);
// //Persons[i].FullNameToStr = Persons[i].FirstName + " " + Persons[i].LastName;
// LBP.DisplayMemberPath = "FullNameToStr";
// }
//}
Ava = new List <Image>();
NameOfPers = new List <TextBlock>();
SP = new List <StackPanel>();
image = new List <BitmapImage>();
KeepID = new List <System.Windows.Controls.Label>();
ChatAva = new List <Image>();
ChatName = new List <TextBlock>();
SP2 = new List <StackPanel>();
ChatId = new List <System.Windows.Controls.Label>();
for (int i = 0; i < Persons.Length; i++)
{
//
if (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
{
image.Add(new BitmapImage(new Uri(sql.GetData(Convert.ToInt32(Persons[i].id))[5])));
}
catch
{
image.Add(new BitmapImage(new Uri("pack://siteoforigin:,,,/Resources/Empty.png")));
}
Ava[i].Source = image[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;
//time[i].Foreground = new SolidColorBrush(Colors.Red);
//time[i].HorizontalAlignment = Left;
//time[i].Color = "grey";
SP[i].Children.Add(Ava[i]);
SP[i].Children.Add(NameOfPers[i]);
LBP.Items.Add(SP[i]);
//LBP.Items.Add(Persons[i]);
// LBP.DisplayMemberPath = "FullNameToStr";
}
//for (int i = 0; i < Persons.Length; i++)
// {
// LBS.Items.Add(Persons[i]);
// LBS.DisplayMemberPath = "FullNameToStr";
// }
}
//ListCollectionView view = new ListCollectionView(Persons);
//view.SortDescriptions.Add(new System.ComponentModel.SortDescription("FirstName",
// System.ComponentModel.ListSortDirection.Ascending));
//view.SortDescriptions.Add(new System.ComponentModel.SortDescription("LastName",
// System.ComponentModel.ListSortDirection.Ascending));
//view.Refresh();
SP2.Add(new StackPanel());
ChatAva.Add(new Image());
ChatName.Add(new TextBlock());
ChatId.Add(new System.Windows.Controls.Label());
image = new List <BitmapImage>();
for (int i = 0; i < chats.Length; i++)
{
ChatName[i].Text = " " + chats[i].Name;
try
{
image.Add(new BitmapImage(new Uri(chats[i].PathToPhoto)));
}
catch
{
image.Add(new BitmapImage(new Uri("pack://siteoforigin:,,,/Resources/Empty.png")));
}
ChatAva[i].Source = image[i];
ChatId[i].Content = Convert.ToString(chats[i].ID);
SP2[i].Orientation = System.Windows.Controls.Orientation.Horizontal;
ChatAva[i].Height = 30;
ChatAva[i].Width = 50;
ChatAva[i].Margin = new Thickness(0, 0, 0, 0);
ChatName[i].Width = 200;
ChatName[i].Height = Double.NaN;
ChatName[i].TextWrapping = TextWrapping.Wrap;
SP2[i].Children.Add(ChatAva[i]);
SP2[i].Children.Add(ChatName[i]);
LBC.Items.Add(SP2[i]);
}
}
