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 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 InitView()
{
MY_COURSES_LISTVIEW.Items.Clear();
AVAIL_COURSES_CB.Items.Clear();
Student s = StudentTable.SelectOne(idStudent);
Collection <ZapsanyKurz> signedCourses = ZapsanyKurzTable.SelectCoursesByIdStudent(idStudent);
Collection <Kurz> activeCourses = KurzTable.SelectByStudentAndOngoing(idStudent.ToString());
foreach (var c in activeCourses)
{
AVAIL_COURSES_CB.Items.Add(c.Nazev);
}
if (signedCourses.Count > 0)
{
ZapsanyKurz firstCourse = signedCourses[0];
foreach (var c in signedCourses)
{
ListViewItem i = new ListViewItem(c.IdRegistrace.ToString());
i.SubItems.Add(c.Kurz.Nazev);
MY_COURSES_LISTVIEW.Items.Add(i);
}
InitCourse(firstCourse);
}
}
private void MY_COURSES_LISTVIEW_SelectedIndexChanged(object sender, EventArgs e)
{
if (MY_COURSES_LISTVIEW.SelectedItems.Count == 1)
{
this.idSelectedCourse = Convert.ToInt32(MY_COURSES_LISTVIEW.SelectedItems[0].Text);
Kurz course = KurzTable.SelectOne(idSelectedCourse);
InitCourse(course);
PrefillUpdateData(course);
}
}
private void END_COURSE_BUTTON_Click(object sender, EventArgs e)
{
if (MY_COURSES_LISTVIEW.SelectedItems.Count == 1)
{
this.idSelectedCourse = Convert.ToInt32(MY_COURSES_LISTVIEW.SelectedItems[0].Text);
Kurz course = KurzTable.SelectOne(idSelectedCourse);
course.Ukoncen = DateTime.Now;
KurzTable.Update(course);
InitCourse(course);
}
}
private void InitCourses()
{
MY_COURSES_LISTVIEW.Items.Clear();
Collection <Kurz> courses = KurzTable.SelectByTeacherId(idTeacher);
foreach (var c in courses)
{
ListViewItem i = new ListViewItem(c.IdKurz.ToString());
i.SubItems.Add(c.Nazev);
MY_COURSES_LISTVIEW.Items.Add(i);
}
}
private void InitView()
{
MY_COURSES_LISTVIEW.Items.Clear();
Collection <Kurz> myCourses = KurzTable.SelectByTeacherId(idTeacher);
if (myCourses.Count > 0)
{
Kurz firstCourse = myCourses[0];
foreach (var c in myCourses)
{
ListViewItem i = new ListViewItem(c.IdKurz.ToString());
i.SubItems.Add(c.Nazev);
MY_COURSES_LISTVIEW.Items.Add(i);
}
InitCourse(firstCourse);
}
}
private void SIGN_COURSE_BUTTON_Click(object sender, EventArgs e)
{
string courseName = AVAIL_COURSES_CB.Text;
int studentsCount = 0, capacity = 0;
if (courseName != null && courseName != "")
{
ZapsanyKurz zk = new ZapsanyKurz();
Kurz k = KurzTable.SelectByCourseName(courseName);
if (k == null)
{
k = KurzTable.SelectLastCourseByName(courseName);
}
zk.IdKurz = k.IdKurz;
studentsCount = KurzTable.GetStudentsCount(k.IdKurz);
capacity = k.Kapacita;
zk.IdStudent = idStudent;
ZapsanyKurzTable.Insert(zk);
if (studentsCount < capacity)
{
InitView();
}
else
{
MessageBox.Show("J*z neni misto. Budete zapsan do fronty na tento kurz. " +
"Jakmile se otevre kurz, budete zapsan do kurzu.");
}
}
else
{
MessageBox.Show("Vyberte kurz z combo boxu!");
}
}
