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; }