private void RegistrationForm_Load(object sender, EventArgs e) { duombaze = new UserDB(); List <Group> grouplist = duombaze.GetGroup(); foreach (Group group in grouplist) { comboBox2.Items.Add(group.GroupName); } }
public RemoveGroup() { duombaze = new UserDB(); InitializeComponent(); List <Group> grouplist = duombaze.GetGroup(); foreach (Group group in grouplist) { comboBox1.Items.Add(group.GroupName); } }
public AddNewCourse() { InitializeComponent(); duombaze = new UserDB(); List <Teacher> teacherList = duombaze.GetTeacher(); foreach (Teacher teacher in teacherList) { comboBox1.Items.Add(teacher.Name + " " + teacher.Surname); } List <Group> grouplist = duombaze.GetGroup(); foreach (Group group in grouplist) { comboBox2.Items.Add(group.GroupName); } }
private void button1_Click(object sender, EventArgs e) { string groupselected = this.comboBox1.GetItemText(this.comboBox1.SelectedItem); int groupid = 0; List <Group> grouplist = duombaze.GetGroup(); foreach (Group group in grouplist) { if (groupselected == group.GroupName) { groupid = group.Id; } } duombaze.RemoveGroup(groupid, groupselected); }
private void LessonList_Load(object sender, EventArgs e) { List <Group> grouplist = duombaze.GetGroup(); List <Course> courselist = duombaze.GetCourse(); int groupid = 0; int courseid = 0; foreach (Group group in grouplist) { if (MainWindow.LoggedInUser.GetGroupName() == group.GroupName) { groupid = group.Id; } } List <Lesson> lessonlist = duombaze.Getlesson(); Console.WriteLine(duombaze.Getlesson()); foreach (Lesson lesson in lessonlist) { if (groupid == lesson.Groupid) { courseid = lesson.Courseid; foreach (Course course in courselist) { if (courseid == course.Id) { LessonControl lol = new LessonControl(course); flowLayoutPanel1.Controls.Add(lol); } } } } string coursename = null; foreach (Course course in courselist) { if (courseid == course.Id) { coursename = course.Name; } } Console.WriteLine(courseid); Console.WriteLine(coursename); }
private void button1_Click(object sender, EventArgs e) { string groupselected = this.comboBox1.GetItemText(this.comboBox1.SelectedItem); int groupid = 0; List <Group> grouplist = duombaze.GetGroup(); foreach (Group group in grouplist) { if (groupselected == group.GroupName) { groupid = group.Id; } } duombaze.RemoveGroup(groupid, groupselected); MessageBox.Show("Grupe sekmingai panaikinta"); this.Close(); }
private void buttonAddCourse_Click(object sender, EventArgs e) { string courseName = textBoxCourseName.Text; string teacherselected = this.comboBox1.GetItemText(this.comboBox1.SelectedItem); int teacherid = 0; int groupid = 0; int courseid = 0; List <Teacher> teacherlist = duombaze.GetTeacher(); foreach (Teacher teacher in teacherlist) { if (teacherselected == teacher.Name + " " + teacher.Surname) { teacherid = teacher.Id; } } duombaze.AddNewCourse(courseName, teacherid); string groupselected = this.comboBox2.GetItemText(this.comboBox2.SelectedItem); List <Group> grouplist = duombaze.GetGroup(); foreach (Group group in grouplist) { if (groupselected == group.GroupName) { groupid = group.Id; } } List <Course> courselist = duombaze.GetCourse(); foreach (Course course in courselist) { if (courseName == course.Name) { courseid = course.Id; } } duombaze.AddNewLesson(teacherid, groupid, courseid); this.Close(); }
public ChangeGrade() { InitializeComponent(); duombaze = new UserDB(); List <Student> studentlist = duombaze.GetStudent(); List <Group> grouplist = duombaze.GetGroup(); List <Lesson> lessonlist = duombaze.Getlesson(); List <Teacher> teacherlist = duombaze.GetTeacher(); int studentgroupid = 0; int teacherid = 0; foreach (Teacher teacher in teacherlist) { if (MainWindow.LoggedInUser.GetFullName() == teacher.Name + " " + teacher.Surname) { teacherid = teacher.Id; } } foreach (Student student in studentlist) { foreach (Group group in grouplist) { if (student.GroupName == group.GroupName) { studentgroupid = group.Id; foreach (Lesson lesson in lessonlist) { if (teacherid == lesson.Teacherid && studentgroupid == lesson.Groupid) { comboBox1.Items.Add(student.Name + " " + student.Surname); } } } } } }