private void AllDataMenuItem_Click(object sender, RoutedEventArgs e)
{
if (!DBUtils.IsAvailable())
{
HideAllTabs();
MessageBox.Show("Для даного действия нужно подключение к серверу MySQL.\nПодключитесь к ссерверу используя \"Подключить к БД\" главного меню.", "Ошибка");
return;
}
HideAllTabs();
StudentTabItem.Visibility = Visibility.Visible;
GroupsTabItem.Visibility = Visibility.Visible;
DiscipleTabItem.Visibility = Visibility.Visible;
FacultyTabItem.Visibility = Visibility.Visible;
N_NTabItem.Visibility = Visibility.Visible;
StudentTabItem.IsSelected = true;
StudentDG.Items.Clear();
GroupsDG.Items.Clear();
DiscipleDG.Items.Clear();
FacultyDG.Items.Clear();
Stud_GroupDG.Items.Clear();
Group_DiscDG.Items.Clear();
List <Student> DataList1 = new List <Student>();
string strQuery = "select * from Student";
DBUtils.GetFromDB(DataList1, strQuery);
foreach (Student stud in DataList1)
{
StudentDG.Items.Add(stud);
}
List <Groups> DataList2 = new List <Groups>();
strQuery = "select * from Groupz";
DBUtils.GetFromDB(DataList2, strQuery);
foreach (Groups group in DataList2)
{
GroupsDG.Items.Add(group);
}
List <Disciple> DataList3 = new List <Disciple>();
strQuery = "select * from Disciple";
DBUtils.GetFromDB(DataList3, strQuery);
foreach (Disciple disc in DataList3)
{
DiscipleDG.Items.Add(disc);
}
List <Faculty> DataList4 = new List <Faculty>();
strQuery = "select * from Faculty";
DBUtils.GetFromDB(DataList4, strQuery);
foreach (Faculty facult in DataList4)
{
FacultyDG.Items.Add(facult);
}
List <Stud_Group> DataList5 = new List <Stud_Group>();
strQuery = "select * from Stud_Group";
DBUtils.GetFromDB(DataList5, strQuery);
foreach (Stud_Group s_g in DataList5)
{
Stud_GroupDG.Items.Add(s_g);
}
List <Group_Disc> DataList6 = new List <Group_Disc>();
strQuery = "select * from Group_Disc";
DBUtils.GetFromDB(DataList6, strQuery);
foreach (Group_Disc g_d in DataList6)
{
Group_DiscDG.Items.Add(g_d);
}
}
