public static List <string> GetSubjectsNameList()
{
List <string> subjectsList = new List <string>();
SQLiteDataReader reader = SubjectsProvider.GetSubjects();
while (reader.Read())
{
subjectsList.Add(reader["SubjectName"].ToString());
}
return(subjectsList);
}
public static List <ListViewItem> GetSubjectsListView()
{
List <ListViewItem> subjectsList = new List <ListViewItem>();
SQLiteDataReader reader = SubjectsProvider.GetSubjects();
while (reader.Read())
{
string[] row = { reader["Id"].ToString(), reader["SubjectName"].ToString() };
ListViewItem item = new ListViewItem(row);
subjectsList.Add(item);
}
return(subjectsList);
}