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(); }
public RemoveStudent() { InitializeComponent(); duombaze = new UserDB(); List <Student> studentlist = duombaze.GetStudent(); foreach (Student student in studentlist) { comboBox1.Items.Add(student.Name + " " + student.Surname); } }
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 button1_Click(object sender, EventArgs e) { string studentselected = this.comboBox1.GetItemText(this.comboBox1.SelectedItem); int studentid = 0; string studentname = ""; string studentsurname = ""; List <Student> studentlist = duombaze.GetStudent(); foreach (Student student in studentlist) { if (studentselected == student.Name + " " + student.Surname) { studentid = student.Id; studentname = student.Name; studentsurname = student.Surname; } } Console.WriteLine(studentid); duombaze.RemoveStudent(studentid, studentname, studentsurname); }
private void button1_Click(object sender, EventArgs e) { string studentselected = this.comboBox1.GetItemText(this.comboBox1.SelectedItem); int studentid = 0; string studentname = ""; string studentsurname = ""; List <Student> studentlist = duombaze.GetStudent(); foreach (Student student in studentlist) { if (studentselected == student.Name + " " + student.Surname) { studentid = student.Id; studentname = student.Name; studentsurname = student.Surname; } } duombaze.RemoveStudent(studentid, studentname, studentsurname); MessageBox.Show("Studentas sekmingai pasalintas"); 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]; */ }
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); } } } } } }