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