public async Task <IActionResult> RemoveQuestion(int id) { //Remove constraint from question bank 1st List <Questionsbank> lqb = _context.Questionsbank.ToList(); Questionsbank qbRemove = new Questionsbank(); foreach (Questionsbank qb in lqb) { if (qb.QuestionId == id) { qbRemove = qb; } } if (qbRemove != null) { _context.Questionsbank.Remove(qbRemove); //_context.SaveChanges(); await _context.SaveChangesAsync(); } //remove question from question table 2nd //Questions currentQuestion = _context.Questions.Find(id); Questions currentQuestion = await _context.Questions.FindAsync(id); if (currentQuestion != null) { _context.Questions.Remove(currentQuestion); //_context.SaveChanges(); await _context.SaveChangesAsync(); } return(RedirectToAction("AddQuestionToQB")); }
public async Task <GetPlanetModel> Handle(CreatePlanetCommand request, CancellationToken cancellationToken) { var planet = new Domain.Entities.Planet(request.Id, request.Name, request.Introduction, request.Description, request.Density, request.Tilt, request.ImageUrl, request.RotationPeriod, request.Period, request.Radius, request.Moons, request.Au, request.Eccentricity, request.Velocity, request.Mass, request.Inclination, request.Type, request.Ordinal); SetDomainState(planet); await _context.SaveChangesAsync(cancellationToken); return(new GetPlanetModel { Id = planet.Id, Name = planet.Name, ImageUrl = planet.ImageUrl, Introduction = planet.Introduction, Description = planet.Description, Density = planet.Density, Tilt = planet.Tilt, RotationPeriod = planet.RotationPeriod, Period = planet.Period, Radius = planet.Radius, Moons = planet.Moons, Au = planet.Au, Eccentricity = planet.Eccentricity, Velocity = planet.Velocity, Mass = planet.Mass, Inclination = planet.Inclination, Type = planet.Type, Ordinal = planet.Ordinal }); }
public async Task <Unit> Handle(DeletePlanetCommand request, CancellationToken cancellationToken) { var planet = await _context.Planets.FindAsync(request.Id); if (planet == null) { throw new DeleteFailureException(nameof(Planet), request.Id, "Unable to find planet to delete."); } planet.DeletePlanet(); SetDomainState(planet); await _context.SaveChangesAsync(cancellationToken); return(Unit.Value); }
public async Task <GetPlanetModel> Handle(UpdatePlanetCommand request, CancellationToken cancellationToken) { var planet = await _context.Planets .SingleAsync(c => c.Id == request.Id, cancellationToken); if (planet == null) { throw new NotFoundException(nameof(Planet), request.Id); } planet.UpdatePlanet(request.Name, request.Introduction, request.Description, request.Density, request.Tilt, request.ImageUrl, request.RotationPeriod, request.Period, request.Radius, request.Moons, request.Au, request.Eccentricity, request.Velocity, request.Mass, request.Inclination, request.Type, request.Ordinal); SetDomainState(planet); await _context.SaveChangesAsync(cancellationToken); return(new GetPlanetModel { Id = planet.Id, Name = planet.Name, ImageUrl = planet.ImageUrl, Introduction = planet.Introduction, Description = planet.Description, Density = planet.Density, Tilt = planet.Tilt, RotationPeriod = planet.RotationPeriod, Period = planet.Period, Radius = planet.Radius, Moons = planet.Moons, Au = planet.Au, Eccentricity = planet.Eccentricity, Velocity = planet.Velocity, Mass = planet.Mass, Inclination = planet.Inclination, Type = planet.Type, Ordinal = planet.Ordinal }); }
internal async Task <int> SaveChangesAsync() { try { return(await dataContext.SaveChangesAsync()); } catch (DbUpdateConcurrencyException ex) { throw; } catch (DbUpdateException ex) { throw; } catch (CommitFailedException ex) { throw; } catch (Exception ex) { throw; } }