private void updateExamSessions()
{
sessions = ExamSessionDAL.SelectAll();
if (sessions.Count != 0)
{
sessionsComboBox.Items.Clear();
for (int i = 0; i < sessions.Count; i++)
{
ComboboxItem item = new ComboboxItem();
item.Text = sessions[i].Id.ToString();
item.Value = sessions[i].Id;
sessionsComboBox.Items.Add(item);
sessionsComboBox.SelectedIndex = 0;
}
}
}
public static ExamSessionCollection SelectAll()
{
DataTable dt = DBLayer.ExecuteQuery("select * from ExamSession");
ExamSessionCollection result = new ExamSessionCollection();
for (int i = 0; i < dt.Rows.Count; i++)
{
Exam exam = new Exam();
Admin adm = new Admin();
int sessionID = Convert.ToInt32(dt.Rows[i]["session_ID"]);
DateTime dateTime = Convert.ToDateTime(dt.Rows[i]["session_date"]);
exam.Id = Convert.ToInt32(dt.Rows[i]["FK_ExamID"]);
adm.Id = Convert.ToInt32(dt.Rows[i]["FK_AdminID"]);
ExamSession session = new ExamSession(sessionID, dateTime, exam, adm);
result.Add(session);
}
return(result);
}
public AssignStudentToExamSession()
{
InitializeComponent();
students = StudentDAL.SelectAll();
for (int i = 0; i < students.Count; i++)
{
ComboboxItem item = new ComboboxItem();
item.Text = students[i].Name;
item.Value = students[i].Id;
StudentsComboBox.Items.Add(item);
StudentsComboBox.SelectedIndex = 0;
}
sessions = ExamSessionDAL.SelectAll();
for (int i = 0; i < sessions.Count; i++)
{
ComboboxItem item = new ComboboxItem();
item.Text = sessions[i].Id.ToString();
item.Value = sessions[i].Id;
ExamSessionsComboBox.Items.Add(item);
ExamSessionsComboBox.SelectedIndex = 0;
}
}
