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 RemarkForm_Load(object sender, EventArgs e) { duombaze = new UserDB(); int studentid = 0; List <Student> studentlist = duombaze.GetStudent(); List <Grade> gradelist = duombaze.GetGrade(); int gradetest = 0; foreach (Student student in studentlist) { if (MainWindow.LoggedInUser.GetFullName() == student.Name + " " + student.Surname) { studentid = student.Id; } } foreach (Grade grade in gradelist) { if (studentid == grade.StudentId) // jeigu prisijungusio sutdenot id sutampa su pazymio id esancio studento { gradetest = grade.Gradenumber; GradeControl gg = new GradeControl(grade); flowLayoutPanel1.Controls.Add(gg); } } }
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(); }
private void RemarkForm_Load(object sender, EventArgs e) { duombaze = new UserDB(); int studentid = 0; List <Student> studentlist = duombaze.GetStudent(); List <Grade> gradelist = duombaze.GetGrade(); int gradetest = 0; foreach (Student student in studentlist) { if (MainWindow.LoggedInUser.GetFullName() == student.Name + " " + student.Surname) { studentid = student.Id; } } foreach (Grade grade in gradelist) { if (studentid == grade.StudentId) // jeigu prisijungusio sutdenot id sutampa su pazymio id esancio studento { gradetest = grade.Gradenumber; GradeControl gg = new GradeControl(grade); flowLayoutPanel1.Controls.Add(gg); } } Console.WriteLine(gradetest); /* var select = "SELECT * FROM grade"; * conn = new SqlConnection(@"Server=.;Database=AcademicDB;Trusted_Connection=true;"); * var dataAdapter = new SqlDataAdapter(select, conn); * var commandBuilder = new SqlCommandBuilder(dataAdapter); * var ds = new DataSet(); * dataAdapter.Fill(ds); * dataGridView1.ReadOnly = true; * dataGridView1.DataSource = ds.Tables[0]; */ }