public void TestRelatedEntities() { using (var scope = new TransactionScope()) { using (var context = new SchoolContext()) { var leerling = context.Leerlingen.Add(new Leerling { Naam = "Test" }); var studie = new Studie { Naam = "PretPakket" }; leerling.Studie = studie; context.SaveChanges(); } using (var context = new SchoolContext()) { context.Database.Log += Console.WriteLine; var leerling = context .Leerlingen .Include(l => l.Studie) .First(p => p.Naam == "Test"); Assert.IsNotNull(leerling.Studie); } //scope.Complete(); } }
public async Task <IActionResult> PutStudie(int id, Studie studie) { if (id != studie.StudieId) { return(BadRequest()); } _context.Entry(studie).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!StudieExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <ActionResult <Studie> > PostStudie(Studie studie) { _context.Studie.Add(studie); await _context.SaveChangesAsync(); return(CreatedAtAction("GetStudie", new { id = studie.StudieId }, studie)); }
public IActionResult PromoteStudent([FromBody] Studie studie) { if (studie.Studies == null || studie.Semester == null) { return(BadRequest()); } ObjectResult ob = new ObjectResult(new SqlServerDbService().PromoteStudents(studie.Semester, studie.Studies)); ob.StatusCode = 201; return(ob); }