public Cursus GetCursusFromId(int cursusId)
{
SqlCommand cmd = new SqlCommand("sp_GetCursusFromId", Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CursusId", SqlDbType.VarChar).Value = cursusId;
string name = "";
DateTime startDate = DateTime.Now;
DateTime endDate = DateTime.Now;
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
name = reader.GetString(0);
startDate = reader.GetDateTime(1);
endDate = reader.GetDateTime(2);
}
reader.Close();
List <Expedition> expeditions = Database.GetInstance().GetAllExpeditionsFromCursusId(cursusId);
Calendar calendar = Database.GetInstance().GetCalendarFromCursusId(cursusId);
Cursus cursus = new Cursus(calendar, name, startDate, endDate, expeditions);
return(cursus);
}
static void ShowCursus(Cursus options)
{
if (options.Students)
{
Display.DisplayCursusStudents(options.Cursusname);
}
if (options.Quests)
{
Display.DisplayCursusQuests(options.Cursusname);
}
}
public List <AbstractPerson> DisplayAllStudentsFromACursusId(int cursusId)
{
List <AbstractPerson> studentsOfASameCursus = new List <AbstractPerson>();
SqlCommand cmd = new SqlCommand("sp_DisplayAllStudentsFromACursus", Connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@CursusId", SqlDbType.VarChar).Value = cursusId;
Cursus cursus = Database.GetInstance().GetCursusFromId(cursusId);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
int personId = reader.GetInt32(0);
string personFirstName = reader.GetString(1);
string personLastName = reader.GetString(2);
string personEmail = reader.GetString(3);
DateTime personBirthday = reader.GetDateTime(4);
int streetNumber = reader.GetInt32(5);
string streetName = reader.GetString(6);
string city = reader.GetString(7);
string country = reader.GetString(8);
Adress adress = new Adress(streetNumber, streetName, city, country);
AbstractPerson person = PersonFactory.Create();
// set Person properties independently
studentsOfASameCursus.Add(person);
}
reader.Close();
return(studentsOfASameCursus);
}
public static AbstractPerson Create(string name, List <AbstractPerson> students = null, List <AbstractPerson> instructors = null, Cursus cursus = null)
{
if (students != null && instructors == null)
{
AbstractPerson newInstructor = new Instructor(name, students);
return(newInstructor);
}
else if (instructors != null)
{
AbstractPerson newLeadInstructor = new LeadInstructor(name, instructors);
return(newLeadInstructor);
}
else
{
AbstractPerson newStudents = new Students(name, cursus);
return(newStudents);
}
}
public Students(string name, Cursus cursus)
{
Name = name;
Cursus = cursus;
}
