private void InitCourse(Kurz course)
{
COURSE_NAME.Text = course.Nazev;
COURSE_DESC.Text = "Description: " + course.Popis;
COURSE_CAPACITY.Text = "Capacity: " + course.Kapacita.ToString();
COURSE_SPECIALIZATION.Text = "Specialization: " + OborTable.SelectOne(course.IdObor).Nazev;
AVG_MARK.Text = "Average mark: " + PisemkaTable.GetAvgMark(course.IdKurz).ToString();
ENDED.Text = "Ended: " + course.Ukoncen.ToString();
Collection <Pisemka> upcomingTests = PisemkaTable.SelectUpcomingTestsByCourse(course.IdKurz);
Collection <Pisemka> pastTests = PisemkaTable.SelectPastTestsByCourse(course.IdKurz);
UPCOMING_TESTS_LISTVIEW.Items.Clear();
PAST_TESTS_LISTVIEW.Items.Clear();
foreach (var t in pastTests)
{
ListViewItem i = new ListViewItem(t.IdPisemka.ToString());
i.SubItems.Add(t.DatumPisemky.ToShortDateString());
i.SubItems.Add(t.Znamka.ToString());
PAST_TESTS_LISTVIEW.Items.Add(i);
}
foreach (var t in upcomingTests)
{
ListViewItem i = new ListViewItem(t.IdPisemka.ToString());
i.SubItems.Add(t.DatumPisemky.ToShortDateString());
UPCOMING_TESTS_LISTVIEW.Items.Add(i);
}
}
private void CREATE_BUTTON_Click(object sender, EventArgs e)
{
Kurz k = new Kurz();
k.IdVyucujici = this.idTeacher;
if (int.TryParse(CAPACITY_VALUE.Text, out int n) &&
NAME_VALUE.Text.Length > 1 &&
DETAIL_VALUE.Text.Length > 0 &&
SPECIALIZATION_CB.Text != "")
{
k.Kapacita = Convert.ToInt32(CAPACITY_VALUE.Text);
k.IdObor = OborTable.SelectOneByName(SPECIALIZATION_CB.Text).IdObor;
k.Nazev = NAME_VALUE.Text;
k.Popis = DETAIL_VALUE.Text;
k.Vytvoren = DateTime.Parse(START_DATE_DP.Text);
KurzTable.Insert(k);
SPECIALIZATION_CB.Text = "";
NAME_VALUE.Text = "";
CAPACITY_VALUE.Text = "";
DETAIL_VALUE.Text = "";
InitCourses();
}
else
{
MessageBox.Show("Vypln vsechny udaje spravne!");
}
}
private void UPDATE_BUTTON_Click(object sender, EventArgs e)
{
Kurz course = new Kurz();
course.IdKurz = this.idSelectedCourse;
course.Nazev = NAME_VALUE.Text;
course.Kapacita = Convert.ToInt32(CAPACITY_VALUE.Text);
course.Popis = DETAIL_VALUE.Text;
course.Vytvoren = START_DATE_DP.Value;
course.IdVyucujici = this.idTeacher;
if (SPECIALIZATION_CB.Text != null && SPECIALIZATION_CB.Text != "")
{
course.IdObor = OborTable.SelectOneByName(SPECIALIZATION_CB.Text).IdObor;
}
else
{
MessageBox.Show("Vyber obor!");
return;
}
if (course.Nazev != "" && course.Kapacita > 0 && course.Popis != "")
{
KurzTable.Update(course);
}
InitView();
InitCourse(course);
}
private void InitSpecialization()
{
Collection <Obor> specs = OborTable.SelectAll();
foreach (var s in specs)
{
SPECIALIZATION_CB.Items.Add(s.Nazev);
}
}
