static void RunCursusOption(CursusOption option)
{
if (option.Students)
{
AbstractPerson students = new AbstractPerson();
students.DatabaseConnection = Database.Instance;
students.DatabaseConnection.DisplayStudentsByCursus(option.CursusName);
}
else if (option.Quests)
{
}
}
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 void Main(string[] args)
{
/*Parser.Default.ParseArguments<EventsOption, CursusOption>(args)
* .WithParsed<EventsOption>(RunEventsOption)
* .WithParsed<CursusOption>(RunCursusOption);*/
/*Event newEvent = new Event("Important meeting");
* newEvent.StartTime = DateTime.Now;
* newEvent.EndTime = DateTime.Now + TimeSpan.FromHours(1);
* newEvent.Postpone(TimeSpan.FromHours(1));
* Console.WriteLine("Another meeting is postponed");*/
//Création d'événement pour une personne
Event rentree = new Event("rentrée");
rentree.StartTime = new DateTime(2019, 12, 09);
rentree.EndTime = new DateTime(2019, 12, 10);
Event hackathon = new Event("hackathon");
hackathon.StartTime = new DateTime(2020, 02, 13);
hackathon.EndTime = new DateTime(2020, 02, 15);
List <Event> events = new List <Event>();
events.Add(rentree);
events.Add(hackathon);
AbstractPerson person = new AbstractPerson();
person.Agenda = events;
DateTime date1 = new DateTime(2018, 01, 10);
DateTime date2 = new DateTime(2020, 03, 10);
Console.WriteLine(person.GetEvents(date1, date2, events));
/*Cursus csharp = new Cursus();
*
* AbstractPerson student1 = PersonFactory.Create("Tom", null, null, csharp);
* AbstractPerson student2 = PersonFactory.Create("Lys", null, null, csharp);
* AbstractPerson student3 = PersonFactory.Create("Nathaniel", null, null, csharp);
*
*
* List<AbstractPerson> studentsList = new List<AbstractPerson>();
*
* studentsList.Add(student1);
* studentsList.Add(student2);
* studentsList.Add(student3);
*
* List<AbstractPerson> instructorsList = new List<AbstractPerson>();
*
* AbstractPerson instructor = PersonFactory.Create("Instructor1", studentsList);
* Console.WriteLine(instructor.GetAllStudentsOfAInstructor());
* //Console.WriteLine(instructor.ToString());
*
*
* AbstractPerson instructor2 = PersonFactory.Create("Instructor2", studentsList);
*
* instructorsList.Add(instructor);
* instructorsList.Add(instructor2);
*
* AbstractPerson lead = PersonFactory.Create("Chef", studentsList, instructorsList);
*
* //Console.WriteLine(lead.ToString()); */
// Display Students By Cursus and Instructor Id
/*string nameCursus = "c#";
* ;
* AbstractPerson students = new AbstractPerson();
* students.DatabaseConnection = Database.Instance;
*
* students.DatabaseConnection.DisplayStudentsByCursus(nameCursus);
*
* int instructorId = 3;
*
* students.DatabaseConnection.DisplayStudentsByInstructor(instructorId);*/
}