private void Query4MenuItem_Click(object sender, RoutedEventArgs e) { if (!DBUtils.IsAvailable()) { HideAllTabs(); MessageBox.Show("Для даного действия нужно подключение к серверу MySQL.\nПодключитесь к ссерверу используя \"Подключить к БД\" главного меню.", "Ошибка"); return; } HideAllTabs(); Result4TabItem.Visibility = Visibility.Visible; Result4TabItem.IsSelected = true; Result4DG.Items.Clear(); List <Res4Storage> DataList = new List <Res4Storage>(); string strQuery = "select SName, Surname, GName, Course " + "from Student s " + "join Groupz g on (s.SID = g.Starosta) " + "where GName = (select GName " + "from(select GName, COUNT(sg.SID) Num " + "from Stud_Group sg " + "join Groupz g on (sg.GID = g.GID) " + "group by GName " + "order by 2 DESC " + "Limit 1 " + ") tempTable " + ");"; DBUtils.GetFromDB(DataList, strQuery); foreach (Res4Storage res4 in DataList) { Result4DG.Items.Add(res4); } }
private void Query6MenuItem_Click(object sender, RoutedEventArgs e) { if (!DBUtils.IsAvailable()) { HideAllTabs(); MessageBox.Show("Для даного действия нужно подключение к серверу MySQL.\nПодключитесь к ссерверу используя \"Подключить к БД\" главного меню.", "Ошибка"); return; } HideAllTabs(); Result6TabItem.Visibility = Visibility.Visible; Result6TabItem.IsSelected = true; Result6DG.Items.Clear(); List <Res6Storage> DataList = new List <Res6Storage>(); string strQuery = "select Title, COUNT(sg.SID) Num " + "from Groupz g " + "join Stud_Group sg on (sg.GID = g.GID) " + "join Group_Disc gd on (gd.GID = g.GID) " + "join Disciple d on (d.DID = gd.DID) " + "group by Title " + "order by 2 DESC " + "Limit 3;"; DBUtils.GetFromDB(DataList, strQuery); foreach (Res6Storage res6 in DataList) { Result6DG.Items.Add(res6); } }
private void Query3MenuItem_Click(object sender, RoutedEventArgs e) { if (!DBUtils.IsAvailable()) { HideAllTabs(); MessageBox.Show("Для даного действия нужно подключение к серверу MySQL.\nПодключитесь к ссерверу используя \"Подключить к БД\" главного меню.", "Ошибка"); return; } HideAllTabs(); Result3TabItem.Visibility = Visibility.Visible; Result3TabItem.IsSelected = true; Result3DG.Items.Clear(); List <Res3Storage> DataList = new List <Res3Storage>(); string strQuery = "select FName, Course, GName, COUNT(s.SID) Num " + "from Student s " + "join Stud_Group sg on (s.SID = sg.SID) " + "join Groupz g on (sg.GID = g.GID) " + "join Faculty f on (f.FID = g.FID) " + "where IsTemp = false " + "group by FName, Course, Gname;"; DBUtils.GetFromDB(DataList, strQuery); foreach (Res3Storage res3 in DataList) { Result3DG.Items.Add(res3); } }
private void Result2ComBox_SelectionChanged(object sender, System.Windows.Controls.SelectionChangedEventArgs e) { Result2DG.Items.Clear(); string param = Result2ComBox.SelectedValue.ToString(); List <Res2Storage> DataList = new List <Res2Storage>(); string strQuery = "select SName, Surname, GName, FName, Course " + "from Student s " + "join Groupz g on (g.Starosta = s.SID) " + "join Faculty f on (f.FID = g.FID) " + "where FName = @Faculty;"; DBUtils.GetFromDB(DataList, strQuery, param); foreach (Res2Storage res2 in DataList) { Result2DG.Items.Add(res2); } }
private void Result1ComBox_SelectionChanged(object sender, System.Windows.Controls.SelectionChangedEventArgs e) { Result1DG.Items.Clear(); string param = Result1ComBox.SelectedValue.ToString(); List <Res1Storage> DataList = new List <Res1Storage>(); string strQuery = "select SName, Surname, GName, Course " + "from Student s " + "join Stud_Group sg on (s.SID = sg.SID) " + "join Groupz g on (sg.GID = g.GID) " + "where GName = @Group;"; DBUtils.GetFromDB(DataList, strQuery, param); foreach (Res1Storage res1 in DataList) { Result1DG.Items.Add(res1); } }
private void Result5ComBox_SelectionChanged(object sender, System.Windows.Controls.SelectionChangedEventArgs e) { Result5DG.Items.Clear(); string param = Result5ComBox.SelectedValue.ToString(); List <Res5Storage> DataList = new List <Res5Storage>(); string strQuery = "select GName, AVG(HoursCount) AvgHours " + "from Groupz g " + "join Group_Disc gd on (gd.GID = g.GID) " + "join Disciple d on (d.DID = gd.DID) " + "where GName = @Group " + "group by GName;"; DBUtils.GetFromDB(DataList, strQuery, param); foreach (Res5Storage res5 in DataList) { Result5DG.Items.Add(res5); } }
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); } }
private void FillGroupDiscList() { GDList.Clear(); GDList.Add(new Group_Disc("NULL", "Не выбрано")); DBUtils.GetFromDB(GDList, "select * from Group_Disc"); }
private void FillStudGroupList() { SGList.Clear(); SGList.Add(new Stud_Group("NULL", "Не выбрано")); DBUtils.GetFromDB(SGList, "select * from Stud_Group"); }
private void FillFacultyList() { FList.Clear(); FList.Add(new Faculty("NULL", "Не выбрано")); DBUtils.GetFromDB(FList, "select * from Faculty;"); }
private void FillDiscipleList() { DList.Clear(); DList.Add(new Disciple("NULL", "Не выбрано", "", "")); DBUtils.GetFromDB(DList, "select * from Disciple;"); }
private void FillGoupList() { GList.Clear(); GList.Add(new Groups("NULL", "", "", "Не выбрано", "")); DBUtils.GetFromDB(GList, "select * from Groupz;"); }
private void FillStudentList() { SList.Clear(); SList.Add(new Student("NULL", "Не выбрано", "", "")); DBUtils.GetFromDB(SList, "select * from Student;"); }