public GradeControl(Grade grade) { InitializeComponent(); List <Lesson> lessonlist = duombaze.Getlesson(); List <Course> courselist = duombaze.GetCourse(); List <Grade> gradelist = duombaze.GetGrade(); string lessonname = ""; foreach (Lesson lesson in lessonlist) { if (grade.LessonId == lesson.Id) { foreach (Course course in courselist) { if (lesson.Courseid == course.Id) { lessonname = course.Name; } } } } labelCourseName.Text = lessonname.ToString(); labelGrade.Text = "Ivertinimas:" + " " + grade.Gradenumber.ToString(); }
private void button1_Click(object sender, EventArgs e) { string courseselected = this.comboBox1.GetItemText(this.comboBox1.SelectedItem); int courseid = 0; int lessonid = 0; List <Course> courselist = duombaze.GetCourse(); List <Lesson> lessonlist = duombaze.Getlesson(); foreach (Course course in courselist) { if (courseselected == course.Name) { courseid = course.Id; } } foreach (Lesson lesson in lessonlist) { if (lesson.Courseid == courseid) { lessonid = lesson.Id; } } duombaze.RemoveLesson(lessonid, courseid); MessageBox.Show("Paskaita sekmingai panaikinta"); this.Close(); }
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); }
public RemoveLesson() { InitializeComponent(); duombaze = new UserDB(); List <Course> courselist = duombaze.GetCourse(); List <Lesson> lessonlist = duombaze.Getlesson(); foreach (Course course in courselist) { foreach (Lesson lesson in lessonlist) { if (lesson.Courseid == course.Id) { comboBox1.Items.Add(course.Name); } } } }
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(); }