// Filters Ledgers by LRN (uses student_id for testing purposes -> change this to LRN later)
private void LoadStudentLedgerByLRN(SQLiteConnection conn)
{
SQLiteCommand sqlite_cmd;
sqlite_cmd = new SQLiteCommand("SELECT * FROM Enrolment_tbl WHERE lrn = @lrn", conn);
sqlite_cmd.Parameters.AddWithValue("@lrn", FilterTextBox.Text);
SQLiteDataReader read = sqlite_cmd.ExecuteReader();
StudentFlowPanel.SuspendLayout();
StudentFlowPanel.Controls.Clear();
while (read.Read())
{
sc = new StudentItemControl();
sc.StudentLrn = read.GetInt64(read.GetOrdinal("lrn")).ToString(); // LRN
sc.StudentName = read.GetString(read.GetOrdinal("first_name")) + " " + read.GetString(read.GetOrdinal("middle_name")) + " " + read.GetString(read.GetOrdinal("surname")); // fullname
sc.StudentIDLabel.Text = read.GetInt64(read.GetOrdinal("lrn")).ToString(); // LRN
sc.StudentNameLabel.Text = read.GetString(read.GetOrdinal("first_name")) + " " + read.GetString(read.GetOrdinal("middle_name")) + " " + read.GetString(read.GetOrdinal("surname")); // fullname
sc.StudentSectionLabel.Text = "Section: " + read.GetString(read.GetOrdinal("section")); // section
sc.StudentLevelLabel.Text = "Level: " + read.GetInt32(read.GetOrdinal("level")).ToString(); // level
sc.StudentSection = read.GetString(read.GetOrdinal("section")); // section gettersetter
sc.StudentLevel = read.GetInt32(read.GetOrdinal("level")).ToString(); // level gettersetter
StudentFlowPanel.Controls.Add(sc);
}
StudentFlowPanel.ResumeLayout();
}
// Loads All Ledger data (this is public)
public void LoadStudentLedger(SQLiteConnection conn)
{
SQLiteCommand sqlite_cmd;
sqlite_cmd = new SQLiteCommand("SELECT * FROM Student_tbl", conn); //
SQLiteDataReader read = sqlite_cmd.ExecuteReader();
StudentFlowPanel.SuspendLayout();
StudentFlowPanel.Controls.Clear();
while (read.Read())
{
sc = new StudentItemControl();
sc.StudentLrn = read.GetInt64(0).ToString(); // LRN
sc.StudentName = read.GetString(1) + " " + read.GetString(2) + " " + read.GetString(3); // fullname
sc.StudentIDLabel.Text = read.GetInt64(0).ToString(); // LRN
sc.StudentNameLabel.Text = read.GetString(1) + " " + read.GetString(2) + " " + read.GetString(3); // fullname
sc.StudentSectionLabel.Text = "Section: " + read.GetString(5); // section
sc.StudentLevelLabel.Text = "Level: " + read.GetInt32(6).ToString(); // level
StudentFlowPanel.Controls.Add(sc);
}
StudentFlowPanel.ResumeLayout();
}
