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 RemoveTeacher() { InitializeComponent(); duombaze = new UserDB(); List <Teacher> teacherlist = duombaze.GetTeacher(); foreach (Teacher teacher in teacherlist) { comboBox1.Items.Add(teacher.Name + " " + teacher.Surname); } }
public LessonControl(Course course) { InitializeComponent(); labelCousename.Text = course.Name; List <Teacher> teacherlist = duombaze.GetTeacher(); foreach (Teacher teacher in teacherlist) { if (teacher.Id == course.Teacherid) { string teachername = teacher.Name + " " + teacher.Surname; labelteachername.Text = teachername; } } }
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 teacherelected = this.comboBox1.GetItemText(this.comboBox1.SelectedItem); int teacherid = 0; string teachername = ""; string teachersurname = ""; List <Teacher> teacherlist = duombaze.GetTeacher(); foreach (Teacher teacher in teacherlist) { if (teacherelected == teacher.Name + " " + teacher.Surname) { teacherid = teacher.Id; teachername = teacher.Name; teachersurname = teacher.Surname; } } duombaze.RemoveTeacher(teacherid, teachername, teachersurname); }
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(); }
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); } } } } } }