public override TUObjectsDTO Select(int id)
{
TUObjectsDTO tuObject = base.Select(id);
UniversityLearnersDTO universityLearner = (UniversityLearnersDTO)tuObject;
AspirantsDTO aspirant = new AspirantsDTO(universityLearner);
dbCommand.CommandText = string.Format("Select Teacher, DesertationTopic, Scolarship From Aspirants Where Id = {0}", id);
dataReader = dbCommand.ExecuteReader();
dataReader.Read();
aspirant.Teacher = dataReader.GetInt32(0);
aspirant.DesertationTopic = dataReader.GetString(1);
aspirant.Scolarship = dataReader.GetDouble(2);
dataReader.Close();
return aspirant;
}
public AspirantsDTO(AspirantsDTO aspirant)
: base(aspirant)
{
LabelsText.Add("Teacher");
LabelsText.Add("DesertationTopic");
LabelsText.Add("Scolarship");
Teacher = aspirant.Teacher;
DesertationTopic = aspirant.DesertationTopic;
Scolarship = aspirant.Scolarship;
ReferenceInfo refInfo = new ReferenceInfo()
{
Major = Id,
FieldNumber = 10,
FilteredIds = new List<int>() { 11 }
};
ReferencedField.Add(refInfo);
}
