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(); }
public List <Colis> list() { var tp = bd.Colis; List <Colis> lc = new List <Colis>(); var bd1 = new ProjetContext(); foreach (var item in tp) { //var v = bd.Ville.Where(p => p.Villeid == item.villeDepartColisid).FirstOrDefault(); var v = bd1.Ville.Find(item.villeDepartColisid); item.villeDepartColis = v; v = bd1.Ville.Find(item.villeArriveColisid); item.villeArriveColis = v; lc.Add(item); } return(lc); }
public Colis findid(int id) { var bd1 = new ProjetContext(); Colis c = bd.Colis.Find(id); if (c != null) { var v = bd1.Ville.Find(c.villeDepartColisid); c.villeDepartColis = v; v = bd1.Ville.Find(c.villeArriveColisid); c.villeArriveColis = v; return(c); } else { c = new Colis(); c.Colisid = -1; return(c); } }
public Compose() { context = new ProjetContext(); }
public Scenario() { context = new ProjetContext(); }
public Actions() { context = new ProjetContext(); }
public People() { context = new ProjetContext(); }