public void ShowTutorList()
{
var context = new TutoratDbContext();
var query =
from tutor in context.Tutors
select new
{
TutorID = tutor.Id,
LastName = tutor.LastName,
FirstName = tutor.FirstName,
EmailAdress = tutor.EmailAdress
};
foreach (var tuteurs in query)
{
Console.WriteLine("TutorID : {0} Name : {1} {2} Email Adress : {3}",
tuteurs.TutorID, tuteurs.FirstName, tuteurs.LastName, tuteurs.EmailAdress);
}
Console.ReadLine();
}
public void ShowTutorList()
{
var context = new TutoratDbContext();
var query =
from tutor in context.Tutors
from tutoringsession in context.TutoringSessions
where tutor.Id == tutoringsession.TutorId &&
tutoringsession.DateTimeSession != new DateTime(2015, 06, 02)
select new
{
TutorID = tutor.Id,
LastName = tutor.LastName,
FirstName = tutor.FirstName,
EmailAdress = tutor.EmailAdress
};
foreach (var tuteurs in query)
{
Console.WriteLine("TutorID : {0} Name : {1} {2} Email Adress : {3}",
tuteurs.TutorID, tuteurs.FirstName, tuteurs.LastName, tuteurs.EmailAdress);
}
Console.ReadLine();
}
static void Main(string[] args)
{
Console.WriteLine("Pour voir les entrées des 3 tables appuyez sur 0,");
Console.WriteLine("Pour voir la requête 1 appuyez sur 1,");
Console.WriteLine("Pour voir la requête 2 appuyez sur 2,");
Console.WriteLine("Pour voir la requête 3 appuyez sur 3,");
Console.WriteLine("Pour voir la requête 4 appuyez sur 4,");
Console.WriteLine("Pour peupler les tables appuyez sur 5 :");
string resultat = Console.ReadLine();
if (resultat == "0")
{
var context = new TutoratDbContext();
var query =
from tutor in context.Tutors
from helped in context.HelpedStudents
from sessions in context.TutoringSessions
select new
{
TutorID = tutor.Id,
TutorLastName = tutor.LastName,
TutorFirstName = tutor.FirstName,
TutorEmailAdress = tutor.EmailAdress,
HelpedID = helped.Id,
HelpedLastName = helped.LastName,
HelpedFirstName = helped.FirstName,
HelpedEmailAdress = helped.EmailAdress,
SessionsId = sessions.Id,
SessionsTutorId = sessions.TutorId,
SessionsHelpedId = sessions.HelpedId,
SessionsTime = sessions.DateTimeSession,
SessionsLenght = sessions.LenghtSession
};
foreach (var tuteurs in query)
{
Console.WriteLine("TutorID : {0} Name : {1} {2} Email Adress : {3}",
tuteurs.TutorID, tuteurs.TutorFirstName, tuteurs.TutorLastName, tuteurs.TutorEmailAdress);
}
foreach (var helped in query)
{
Console.WriteLine("HelpedID : {0} Name : {1} {2} Email Adress : {3}",
helped.HelpedID, helped.HelpedFirstName, helped.HelpedLastName, helped.HelpedEmailAdress);
}
foreach (var session in query)
{
Console.WriteLine("SessionID : {0} TutorId : {1} HelpedId : {2} Time : {3} Lenght Session : {4}",
session.SessionsId, session.SessionsTutorId, session.SessionsHelpedId, session.SessionsTime, session.SessionsLenght);
}
Console.ReadLine();
}
else if (resultat == "1")
{
TutorController controller = new TutorController();
controller.AfficherListeTuteurs();
}
else if (resultat == "4")
{
TutorController controller = new TutorController();
controller.AfficherListTuteurs2Juin();
}
else if (resultat == "5")
{
var contextTutor = new EfEntityRepository <Tutor>();
var tutorGB = new Tutor();
tutorGB.LastName = "Bilodeau";
tutorGB.FirstName = "Gary";
tutorGB.EmailAdress = "*****@*****.**";
contextTutor.Add(tutorGB);
var tutorSG = new Tutor();
tutorSG.LastName = "Gagnon";
tutorSG.FirstName = "Samuel";
tutorSG.EmailAdress = "*****@*****.**";
contextTutor.Add(tutorSG);
var tutorSimG = new Tutor();
tutorSimG.LastName = "Gingras";
tutorSimG.FirstName = "Simon";
tutorSimG.EmailAdress = "*****@*****.**";
contextTutor.Add(tutorSimG);
var tutorER = new Tutor();
tutorER.LastName = "Roy";
tutorER.FirstName = "Éric";
tutorER.EmailAdress = "*****@*****.**";
contextTutor.Add(tutorER);
var tutorCV = new Tutor();
tutorCV.LastName = "Veilleux";
tutorCV.FirstName = "Caroline";
tutorCV.EmailAdress = "*****@*****.**";
contextTutor.Add(tutorCV);
var tutorKT = new Tutor();
tutorKT.LastName = "Tremblay";
tutorKT.FirstName = "Karine";
tutorKT.EmailAdress = "*****@*****.**";
contextTutor.Add(tutorKT);
var tutorLV = new Tutor();
tutorLV.LastName = "Vézina";
tutorLV.FirstName = "Louis";
tutorLV.EmailAdress = "*****@*****.**";
contextTutor.Add(tutorLV);
var contextHelpedStudent = new EfEntityRepository <HelpedStudent>();
var helpedMA = new HelpedStudent();
helpedMA.LastName = "Arsenault";
helpedMA.FirstName = "Marc";
helpedMA.EmailAdress = "*****@*****.**";
contextHelpedStudent.Add(helpedMA);
var helpedEB = new HelpedStudent();
helpedEB.LastName = "Boilard";
helpedEB.FirstName = "Éric";
helpedEB.EmailAdress = "*****@*****.**";
contextHelpedStudent.Add(helpedEB);
var helpedJCC = new HelpedStudent();
helpedJCC.LastName = "Couture";
helpedJCC.FirstName = "Jean-Christophe";
helpedJCC.EmailAdress = "*****@*****.**";
contextHelpedStudent.Add(helpedJCC);
var helpedJD = new HelpedStudent();
helpedJD.LastName = "Desrosiers";
helpedJD.FirstName = "Julianne";
helpedJD.EmailAdress = "*****@*****.**";
contextHelpedStudent.Add(helpedJD);
var helpedLGA = new HelpedStudent();
helpedLGA.LastName = "Grégoire-Allen";
helpedLGA.FirstName = "Léo";
helpedLGA.EmailAdress = "*****@*****.**";
contextHelpedStudent.Add(helpedLGA);
var helpedFH = new HelpedStudent();
helpedFH.LastName = "Hamel";
helpedFH.FirstName = "François";
helpedFH.EmailAdress = "*****@*****.**";
contextHelpedStudent.Add(helpedFH);
var helpedJL = new HelpedStudent();
helpedJL.LastName = "Lepage";
helpedJL.FirstName = "Jérémy";
helpedJL.EmailAdress = "*****@*****.**";
contextHelpedStudent.Add(helpedJL);
var helpedNP = new HelpedStudent();
helpedNP.LastName = "Poitras";
helpedNP.FirstName = "Nicolas";
helpedNP.EmailAdress = "*****@*****.**";
contextHelpedStudent.Add(helpedNP);
var helpedSRG = new HelpedStudent();
helpedSRG.LastName = "Roy-Gagnon";
helpedSRG.FirstName = "Samuel";
helpedSRG.EmailAdress = "*****@*****.**";
contextHelpedStudent.Add(helpedSRG);
var helpedBS = new HelpedStudent();
helpedBS.LastName = "Simard";
helpedBS.FirstName = "Benjamin";
helpedBS.EmailAdress = "*****@*****.**";
contextHelpedStudent.Add(helpedBS);
var helpedSV = new HelpedStudent();
helpedSV.LastName = "Vachon";
helpedSV.FirstName = "Samuel";
helpedSV.EmailAdress = "*****@*****.**";
contextHelpedStudent.Add(helpedSV);
var contextSessions = new EfEntityRepository <TutoringSession>();
var session = new TutoringSession();
session.DateTimeSession = new DateTime(2015, 03, 16, 13, 00, 00);
session.LenghtSession = 2;
session.Helped = helpedLGA;
session.HelpedId = helpedLGA.Id;
session.Tutor = tutorCV;
session.TutorId = tutorCV.Id;
contextSessions.Add(session);
var session1 = new TutoringSession();
session1.DateTimeSession = new DateTime(2015, 03, 24, 10, 00, 00);
session1.LenghtSession = 1;
session1.Helped = helpedLGA;
session1.HelpedId = helpedLGA.Id;
session1.Tutor = tutorGB;
session1.TutorId = tutorGB.Id;
contextSessions.Add(session1);
var session2 = new TutoringSession();
session2.DateTimeSession = new DateTime(2015, 03, 25, 13, 00, 00);
session2.LenghtSession = 1;
session2.Helped = helpedEB;
session2.HelpedId = helpedEB.Id;
session2.Tutor = tutorER;
session2.TutorId = tutorER.Id;
contextSessions.Add(session2);
var session3 = new TutoringSession();
session3.DateTimeSession = new DateTime(2015, 04, 01, 12, 00, 00);
session3.LenghtSession = 2;
session3.Helped = helpedMA;
session3.HelpedId = helpedMA.Id;
session3.Tutor = tutorCV;
session3.TutorId = tutorCV.Id;
contextSessions.Add(session3);
var session4 = new TutoringSession();
session4.DateTimeSession = new DateTime(2015, 04, 01, 13, 00, 00);
session4.LenghtSession = 1;
session4.Helped = helpedEB;
session4.HelpedId = helpedEB.Id;
session4.Tutor = tutorSG;
session4.TutorId = tutorSG.Id;
contextSessions.Add(session4);
var session5 = new TutoringSession();
session5.DateTimeSession = new DateTime(2015, 04, 06, 16, 00, 00);
session5.LenghtSession = 1;
session5.Helped = helpedMA;
session5.HelpedId = helpedMA.Id;
session5.Tutor = tutorER;
session5.TutorId = tutorER.Id;
contextSessions.Add(session5);
var session6 = new TutoringSession();
session6.DateTimeSession = new DateTime(2015, 04, 08, 10, 00, 00);
session6.LenghtSession = 1;
session6.Helped = helpedFH;
session6.HelpedId = helpedFH.Id;
session6.Tutor = tutorER;
session6.TutorId = tutorER.Id;
contextSessions.Add(session6);
var session7 = new TutoringSession();
session7.DateTimeSession = new DateTime(2015, 04, 10, 10, 00, 00);
session7.LenghtSession = 2;
session7.Helped = helpedMA;
session7.HelpedId = helpedMA.Id;
session7.Tutor = tutorER;
session7.TutorId = tutorER.Id;
contextSessions.Add(session7);
var session8 = new TutoringSession();
session8.DateTimeSession = new DateTime(2015, 04, 29, 12, 00, 00);
session8.LenghtSession = 1;
session8.Helped = helpedSRG;
session8.HelpedId = helpedSRG.Id;
session8.Tutor = tutorCV;
session8.TutorId = tutorCV.Id;
contextSessions.Add(session8);
var session9 = new TutoringSession();
session9.DateTimeSession = new DateTime(2015, 05, 25, 13, 00, 00);
session9.LenghtSession = 1;
session9.Helped = helpedBS;
session9.HelpedId = helpedBS.Id;
session9.Tutor = tutorLV;
session9.TutorId = tutorLV.Id;
contextSessions.Add(session9);
var session10 = new TutoringSession();
session10.DateTimeSession = new DateTime(2015, 05, 27, 12, 00, 00);
session10.LenghtSession = 2;
session10.Helped = helpedBS;
session10.HelpedId = helpedBS.Id;
session10.Tutor = tutorCV;
session10.TutorId = tutorCV.Id;
contextSessions.Add(session10);
var session11 = new TutoringSession();
session11.DateTimeSession = new DateTime(2015, 05, 27, 13, 00, 00);
session11.LenghtSession = 1;
session11.Helped = helpedEB;
session11.HelpedId = helpedEB.Id;
session11.Tutor = tutorSimG;
session11.TutorId = tutorSimG.Id;
contextSessions.Add(session11);
var session12 = new TutoringSession();
session12.DateTimeSession = new DateTime(2015, 06, 01, 9, 00, 00);
session12.LenghtSession = 1;
session12.Helped = helpedJL;
session12.HelpedId = helpedJL.Id;
session12.Tutor = tutorLV;
session12.TutorId = tutorLV.Id;
contextSessions.Add(session12);
var session13 = new TutoringSession();
session13.DateTimeSession = new DateTime(2015, 06, 02, 9, 00, 00);
session13.LenghtSession = 1;
session13.Helped = helpedSV;
session13.HelpedId = helpedSV.Id;
session13.Tutor = tutorLV;
session13.TutorId = tutorLV.Id;
contextSessions.Add(session13);
var session14 = new TutoringSession();
session14.DateTimeSession = new DateTime(2015, 06, 02, 11, 00, 00);
session14.LenghtSession = 1;
session14.Helped = helpedEB;
session14.HelpedId = helpedEB.Id;
session14.Tutor = tutorLV;
session14.TutorId = tutorLV.Id;
contextSessions.Add(session14);
var session15 = new TutoringSession();
session15.DateTimeSession = new DateTime(2015, 06, 02, 13, 00, 00);
session15.LenghtSession = 1;
session15.Helped = helpedLGA;
session15.HelpedId = helpedLGA.Id;
session15.Tutor = tutorGB;
session15.TutorId = tutorGB.Id;
contextSessions.Add(session15);
var session16 = new TutoringSession();
session16.DateTimeSession = new DateTime(2015, 06, 02, 15, 00, 00);
session16.LenghtSession = 1;
session16.Helped = helpedSRG;
session16.HelpedId = helpedSRG.Id;
session16.Tutor = tutorER;
session16.TutorId = tutorER.Id;
contextSessions.Add(session16);
var session17 = new TutoringSession();
session17.DateTimeSession = new DateTime(2015, 06, 03, 13, 00, 00);
session17.LenghtSession = 2;
session17.Helped = helpedJL;
session17.HelpedId = helpedJL.Id;
session17.Tutor = tutorSimG;
session17.TutorId = tutorSimG.Id;
contextSessions.Add(session17);
Console.WriteLine("Tables correctement peuplées");
}
Console.ReadLine();
}