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