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);
}
}
}
}
}
}
