protected static void SectionC(ProjetContext appContext)
{
Tutor tutorUP = new Tutor();
tutorUP = appContext.Tutor.Where(s => s.FirstName == "Gary" && s.LastName == "Bilodeau").FirstOrDefault <Tutor>();
if (tutorUP != null)
{
tutorUP.EmailAddress = "*****@*****.**";
}
HelpedStudent hsUP;
hsUP = appContext.HelpedStudent.Where(hs => hs.FirstName == "Marc" && hs.LastName == "Arsenault").FirstOrDefault <HelpedStudent>();
TutoringSession TutoringSessionHsUp = appContext.TutoringSession.Where(s => s.Id == hsUP.Id).FirstOrDefault();
appContext.TutoringSession.Remove(TutoringSessionHsUp);
appContext.HelpedStudent.Remove(hsUP);
appContext.SaveChanges();
HelpedStudent hsUP2;
hsUP2 = appContext.HelpedStudent.Where(hs => hs.FirstName == "Marc" && hs.LastName == "Arsenault").FirstOrDefault <HelpedStudent>();
TutoringSession TutoringSessionUP = new TutoringSession();
TutoringSessionUP = appContext.TutoringSession.Where(ts => ts.Helped.Id == hsUP2.Id).FirstOrDefault <TutoringSession>();
if (tutorUP != null)
{
TutoringSessionUP.DateSession = new DateTime(2015, 04, 09, 11, 0, 0);
TutoringSessionUP.TimeSession = TimeSpan.FromHours(2);
}
appContext.SaveChanges();
HelpedStudent HsJoin = new HelpedStudent();
HsJoin = appContext.HelpedStudent.Where(hs => hs.FirstName == "Samuel" && hs.LastName == "Vachon").FirstOrDefault <HelpedStudent>();
Tutor TutorJoin = new Tutor();
TutorJoin = appContext.Tutor.Where(hs => hs.FirstName == "Louis" && hs.LastName == "Vézina").FirstOrDefault <Tutor>();
TutoringSession newTutoringSession = new TutoringSession();
newTutoringSession.DateSession = new DateTime(2015, 06, 04, 10, 0, 0);
newTutoringSession.TimeSession = TimeSpan.FromHours(10);
newTutoringSession.LengthSession = TimeSpan.FromHours(2);
newTutoringSession.HelpedId = HsJoin;
newTutoringSession.TutorId = TutorJoin;
appContext.TutoringSession.Add(newTutoringSession);
appContext.SaveChanges();
}
protected override void Seed(SinapseContext appContext)
{
base.Seed(appContext);
Tutor tut1 = new Tutor()
{
ID = 100, LastName = "Bilodeau", FirstName = "Gary", EmailAddress = "*****@*****.**"
};
Tutor tut2 = new Tutor()
{
ID = 101, LastName = "Gagnon", FirstName = "Samuel", EmailAddress = "*****@*****.**"
};
Tutor tut3 = new Tutor()
{
ID = 102, LastName = "Gingras", FirstName = "Simon", EmailAddress = "*****@*****.**"
};
Tutor tut4 = new Tutor()
{
ID = 103, LastName = "Roy", FirstName = "Éric", EmailAddress = "*****@*****.**"
};
Tutor tut5 = new Tutor()
{
ID = 104, LastName = "Veilleux", FirstName = "Caroline", EmailAddress = "*****@*****.**"
};
Tutor tut6 = new Tutor()
{
ID = 105, LastName = "Tremblay", FirstName = "Karine", EmailAddress = "*****@*****.**"
};
Tutor tut7 = new Tutor()
{
ID = 106, LastName = "Vézina", FirstName = "Louis", EmailAddress = "*****@*****.**"
};
appContext.Tutors.Add(tut1);
appContext.Tutors.Add(tut2);
appContext.Tutors.Add(tut3);
appContext.Tutors.Add(tut4);
appContext.Tutors.Add(tut5);
appContext.Tutors.Add(tut6);
appContext.Tutors.Add(tut7);
HelpedStudent stu1 = new HelpedStudent()
{
ID = 100, LastName = "Arsenault", FirstName = "Marc", EmailAddress = "*****@*****.**"
};
HelpedStudent stu2 = new HelpedStudent()
{
ID = 101, LastName = "Boilard", FirstName = "Eric", EmailAddress = "*****@*****.**"
};
HelpedStudent stu3 = new HelpedStudent()
{
ID = 102, LastName = "Couture", FirstName = "Jean-Cristophe", EmailAddress = "*****@*****.**"
};
HelpedStudent stu4 = new HelpedStudent()
{
ID = 103, LastName = "Desrosiers", FirstName = "Julianne", EmailAddress = "*****@*****.**"
};
HelpedStudent stu5 = new HelpedStudent()
{
ID = 104, LastName = "Grégoire-Allen", FirstName = "Léo", EmailAddress = "*****@*****.**"
};
HelpedStudent stu6 = new HelpedStudent()
{
ID = 105, LastName = "Hamel", FirstName = "François", EmailAddress = "*****@*****.**"
};
HelpedStudent stu7 = new HelpedStudent()
{
ID = 106, LastName = "Lepage", FirstName = "Jérémy", EmailAddress = "*****@*****.**"
};
HelpedStudent stu8 = new HelpedStudent()
{
ID = 107, LastName = "Poitras", FirstName = "Nicolas", EmailAddress = "*****@*****.**"
};
HelpedStudent stu9 = new HelpedStudent()
{
ID = 108, LastName = "Roy-Gagnon", FirstName = "Samuel", EmailAddress = "*****@*****.**"
};
HelpedStudent stu10 = new HelpedStudent()
{
ID = 109, LastName = "Simard", FirstName = "Benjamin", EmailAddress = "*****@*****.**"
};
HelpedStudent stu11 = new HelpedStudent()
{
ID = 110, LastName = "Vachon", FirstName = "Samuel", EmailAddress = "*****@*****.**"
};
appContext.HelpedStudents.Add(stu1);
appContext.HelpedStudents.Add(stu2);
appContext.HelpedStudents.Add(stu3);
appContext.HelpedStudents.Add(stu4);
appContext.HelpedStudents.Add(stu5);
appContext.HelpedStudents.Add(stu6);
appContext.HelpedStudents.Add(stu7);
appContext.HelpedStudents.Add(stu8);
appContext.HelpedStudents.Add(stu9);
appContext.HelpedStudents.Add(stu10);
appContext.HelpedStudents.Add(stu11);
TutoringSession tgs1 = new TutoringSession()
{
ID = 100, DateSession = new DateTime(2015, 03, 16), TimeSession = 13, LengthSession = 2, HelpedID = stu5, TutorID = tut5
};
TutoringSession tgs2 = new TutoringSession()
{
ID = 101, DateSession = new DateTime(2015, 03, 24), TimeSession = 10, LengthSession = 1, HelpedID = stu5, TutorID = tut1
};
TutoringSession tgs3 = new TutoringSession()
{
ID = 102, DateSession = new DateTime(2015, 03, 25), TimeSession = 13, LengthSession = 1, HelpedID = stu2, TutorID = tut4
};
TutoringSession tgs4 = new TutoringSession()
{
ID = 103, DateSession = new DateTime(2015, 04, 01), TimeSession = 12, LengthSession = 2, HelpedID = stu1, TutorID = tut5
};
TutoringSession tgs5 = new TutoringSession()
{
ID = 104, DateSession = new DateTime(2015, 04, 01), TimeSession = 13, LengthSession = 1, HelpedID = stu2, TutorID = tut3
};
TutoringSession tgs6 = new TutoringSession()
{
ID = 105, DateSession = new DateTime(2015, 04, 06), TimeSession = 16, LengthSession = 1, HelpedID = stu1, TutorID = tut4
};
TutoringSession tgs7 = new TutoringSession()
{
ID = 106, DateSession = new DateTime(2015, 04, 08), TimeSession = 10, LengthSession = 1, HelpedID = stu6, TutorID = tut4
};
TutoringSession tgs8 = new TutoringSession()
{
ID = 107, DateSession = new DateTime(2015, 04, 10), TimeSession = 10, LengthSession = 2, HelpedID = stu1, TutorID = tut4
};
TutoringSession tgs9 = new TutoringSession()
{
ID = 108, DateSession = new DateTime(2015, 04, 29), TimeSession = 12, LengthSession = 1, HelpedID = stu9, TutorID = tut5
};
TutoringSession tgs10 = new TutoringSession()
{
ID = 109, DateSession = new DateTime(2015, 05, 25), TimeSession = 13, LengthSession = 1, HelpedID = stu10, TutorID = tut7
};
TutoringSession tgs11 = new TutoringSession()
{
ID = 110, DateSession = new DateTime(2015, 05, 27), TimeSession = 12, LengthSession = 2, HelpedID = stu10, TutorID = tut5
};
TutoringSession tgs12 = new TutoringSession()
{
ID = 111, DateSession = new DateTime(2015, 05, 27), TimeSession = 13, LengthSession = 1, HelpedID = stu2, TutorID = tut3
};
TutoringSession tgs13 = new TutoringSession()
{
ID = 112, DateSession = new DateTime(2015, 06, 01), TimeSession = 9, LengthSession = 1, HelpedID = stu7, TutorID = tut7
};
TutoringSession tgs14 = new TutoringSession()
{
ID = 113, DateSession = new DateTime(2015, 06, 02), TimeSession = 9, LengthSession = 1, HelpedID = stu11, TutorID = tut7
};
TutoringSession tgs15 = new TutoringSession()
{
ID = 114, DateSession = new DateTime(2015, 06, 02), TimeSession = 11, LengthSession = 1, HelpedID = stu2, TutorID = tut7
};
TutoringSession tgs16 = new TutoringSession()
{
ID = 115, DateSession = new DateTime(2015, 06, 02), TimeSession = 13, LengthSession = 1, HelpedID = stu5, TutorID = tut1
};
TutoringSession tgs17 = new TutoringSession()
{
ID = 116, DateSession = new DateTime(2015, 06, 02), TimeSession = 15, LengthSession = 1, HelpedID = stu9, TutorID = tut4
};
TutoringSession tgs18 = new TutoringSession()
{
ID = 117, DateSession = new DateTime(2015, 06, 03), TimeSession = 13, LengthSession = 2, HelpedID = stu7, TutorID = tut3
};
appContext.TutoringSessions.Add(tgs1);
appContext.TutoringSessions.Add(tgs2);
appContext.TutoringSessions.Add(tgs3);
appContext.TutoringSessions.Add(tgs4);
appContext.TutoringSessions.Add(tgs5);
appContext.TutoringSessions.Add(tgs6);
appContext.TutoringSessions.Add(tgs7);
appContext.TutoringSessions.Add(tgs8);
appContext.TutoringSessions.Add(tgs9);
appContext.TutoringSessions.Add(tgs10);
appContext.TutoringSessions.Add(tgs11);
appContext.TutoringSessions.Add(tgs12);
appContext.TutoringSessions.Add(tgs13);
appContext.TutoringSessions.Add(tgs14);
appContext.TutoringSessions.Add(tgs15);
appContext.TutoringSessions.Add(tgs16);
appContext.TutoringSessions.Add(tgs17);
appContext.TutoringSessions.Add(tgs18);
}
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();
}
