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); }
private void button1_Click(object sender, EventArgs e) { string studentselected = this.comboBox1.GetItemText(this.comboBox1.SelectedItem); int studentid = 0; int studentgrade = 0; int lessonid = 0; int teacherid = 0; List <Student> studenlist = duombaze.GetStudent(); foreach (Student student in studenlist) { if (studentselected == student.Name + " " + student.Surname) { studentid = student.Id; } } List <Grade> gradelist = duombaze.GetGrade(); foreach (Grade grade in gradelist) { if (studentid == grade.StudentId) { studentgrade = grade.Gradenumber; } } Console.WriteLine(studentgrade); studentgrade = Int32.Parse(this.comboBox2.GetItemText(this.comboBox2.SelectedItem)); List <Teacher> teacherlist = duombaze.GetTeacher(); foreach (Teacher teacher in teacherlist) { if (MainWindow.LoggedInUser.GetFullName() == teacher.Name + " " + teacher.Surname) { teacherid = teacher.Id; } } List <Lesson> lessonlist = duombaze.Getlesson(); foreach (Grade grade in gradelist) { if (teacherid == grade.TeacherId) { foreach (Lesson lesson in lessonlist) { if (teacherid == lesson.Teacherid) { lessonid = lesson.Id; } } } } duombaze.ChangeGrade(studentgrade, studentid, teacherid, lessonid); MessageBox.Show("Sekmingai pakeistas pazymis!"); this.Close(); }
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 button1_Click(object sender, EventArgs e) { string studentselected = this.comboBox1.GetItemText(this.comboBox1.SelectedItem); string gradetext = this.comboBox2.GetItemText(this.comboBox2.SelectedItem); int grade = Int32.Parse(gradetext); int studentid = 0; int teacherid = 0; List <Teacher> teacherlist = duombaze.GetTeacher(); foreach (Teacher teacher in teacherlist) { if (MainWindow.LoggedInUser.GetFullName() == teacher.Name + " " + teacher.Surname) { teacherid = teacher.Id; } } int lessonid = 0; List <Student> studentlist = duombaze.GetStudent(); foreach (Student student in studentlist) { if (studentselected == student.Name + " " + student.Surname) { studentid = student.Id; } } List <Lesson> lessonlist = duombaze.Getlesson(); foreach (Lesson lesson in lessonlist) { if (lesson.Teacherid == teacherid) { lessonid = lesson.Id; } } duombaze.AddNewGrade(grade, studentid, teacherid, lessonid); MessageBox.Show("Pazymis sekmingai pridetas"); 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); } } } } } }