public Subject(int aID, string aName, SubjectGroup aGroup)
{
ID = aID;
Name = aName;
ShortName = Name.Substring(0, 3);
Group = aGroup;
}
private void ImportSubjects(ref OleDbConnection connection)
{
string SubjectGroupsSelect = "SELECT * FROM [Code SubjectGroup]";
OleDbCommand ClassesQuery = new OleDbCommand(SubjectGroupsSelect, connection);
Dictionary<int, SubjectGroup> d = new Dictionary<int, SubjectGroup>() { };
using (OleDbDataReader GroupsReader = ClassesQuery.ExecuteReader())
{
while (GroupsReader.Read())
{
int id = int.Parse(GroupsReader["SubjGroup ID"].ToString());
int norma;
if (int.TryParse(GroupsReader["NormaBasic"].ToString(), out norma) == false)
{
norma = 0;
}
SubjectGroup group = new SubjectGroup(
id,
GroupsReader["SubjGroup Name"].ToString(),
norma);
d.Add(id, group);
}
}
string SubjectsSelect = "SELECT * FROM [Code Subject] WHERE [Subject Name] IS NOT NULL";
OleDbCommand SubjectsQuery = new OleDbCommand(SubjectsSelect, connection);
using (OleDbDataReader SubjectsReader = SubjectsQuery.ExecuteReader())
{
while (SubjectsReader.Read())
{
int id = int.Parse(SubjectsReader["Subject ID"].ToString());
int group_id = int.Parse(SubjectsReader["SubjectGroup"].ToString());
string name = SubjectsReader["Subject Name"].ToString();
SubjectGroup gr = d[group_id];
Subject s = new Subject(id, name, gr);
this.mSubjects.Add(s);
}
}
}