public async Task <User> Register(User user, string password) { if (user == null || password == null || password == string.Empty) { return(null); } CreatePasswordHash(password, out var passwordHash, out var passwordSalt); user.PasswordHash = passwordHash; user.PasswordSalt = passwordSalt; GenerateRegistrationToken(ref user); try { await _context.Users.AddAsync(user); await _context.SaveChangesAsync(); } catch (Exception e) { Console.WriteLine(e); return(null); } return(user); }
public async Task <IActionResult> PutFlight([FromRoute] int id, [FromBody] Flight flight) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != flight.FlightId) { return(BadRequest()); } _context.Entry(flight).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!FlightExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task <bool> Add(Flight flight) { try { await _context.Flights.AddAsync(flight); return(await _context.SaveChangesAsync() > 0); } catch (Exception e) { Console.WriteLine(e); return(false); } }
public async Task <bool> Add(Airplane airplane) { try { await _context.Airplanes.AddAsync(airplane); return(await _context.SaveChangesAsync() > 0); } catch (Exception e) { Console.WriteLine(e); return(false); } }
public async Task AddAsync(IEnumerable <AirportDetails> europeAirports) { List <string> iataList = new List <string>(); foreach (var item in europeAirports) { if (!iataList.Contains(item.Iata)) { _dbContext.AirportDetails.Add(item); iataList.Add(item.Iata); } } await _dbContext.SaveChangesAsync(); }
public async Task <List <Passenger> > AddPassengers(IEnumerable <Passenger> passengers) { try { var entities = passengers.Select(passenger => _context.Passengers.Add(passenger).Entity).ToList(); await _context.SaveChangesAsync(); return(entities); } catch (Exception e) { Console.WriteLine(e); return(null); } }
public async Task <Booking> Add(Booking booking) { try { var result = await _context.Bookings.AddAsync(booking); await _context.SaveChangesAsync(); return(result.Entity); } catch (Exception e) { Console.WriteLine(e); return(null); } }
public async Task <bool> Add(T entity) { bool flag; try { entities.Add(entity); await db.SaveChangesAsync(); flag = true; } catch (Exception ex) { flag = false; } return(flag); }
public async Task <Payment> Add(double price, int passengerCount, int bookingId) { var payment = new Payment { Amount = price * passengerCount, BookingId = bookingId, ReferenceNumber = PaymentIdGenerator.GenerateId(bookingId) }; try { var paymentResult = _context.Payments.Add(payment); await _context.SaveChangesAsync(); return(paymentResult.Entity); } catch (Exception e) { Console.WriteLine(e); return(null); } }
private async Task <bool> Update(User user) { try { _context.Update(user); return(await _context.SaveChangesAsync() > 0); } catch (Exception e) { Console.WriteLine(e); return(false); } }
public async Task <bool> Add(User employee, string password) { try { await _context.Users.AddAsync(employee); return(await _context.SaveChangesAsync() > 0); } catch (Exception e) { Console.WriteLine(e); return(false); } }
public async Task Seed <TEntity>() where TEntity : class { var dbSet = _dbContext.Set <TEntity>(); if (!await dbSet.AnyAsync()) { Console.WriteLine($"Seeding {typeof(TEntity).Name} table . . ."); await IdentityInsert <TEntity>(true); await Reseed <TEntity>(); var seedData = _dataSource.Get <TEntity>(); await dbSet.AddRangeAsync(seedData); await _dbContext.SaveChangesAsync(); await IdentityInsert <TEntity>(false); } }
public async Task <bool> SaveAsync() { try { var changes = _context.ChangeTracker.Entries().Count( p => p.State == EntityState.Modified || p.State == EntityState.Deleted || p.State == EntityState.Added); if (changes == 0) { return(true); } return(await _context.SaveChangesAsync() > 0); } catch (Exception) { return(false); } }
public async Task <bool> SaveAsync() { return(await _context.SaveChangesAsync() >= 0); }
public async Task <int> SaveChangesAsync() { return(await _dbContext.SaveChangesAsync()); }
public async Task Create(TEntity entity) { await _dbContext.Set <TEntity>().AddAsync(entity); await _dbContext.SaveChangesAsync(); }
//Setting up the in-memory db. public static async Task AddTestData(AirportDbContext airportDbContext) { airportDbContext.Runways.Add(new Runway { Id = 1, Name = "Runway1", Landings = new List <Landing>(), TakeOffs = new List <TakeOff>(), NextAvailableTime = DateTimeOffset.Now.AddMinutes(45) }); airportDbContext.Runways.Add(new Runway { Id = 2, Name = "Runway2", Landings = new List <Landing>(), TakeOffs = new List <TakeOff>(), NextAvailableTime = DateTimeOffset.Now.AddMinutes(60) }); airportDbContext.Flights.Add(new Flight { Id = 1, LandingDuration = new TimeSpan(0, 7, 0), Name = "Flight1", TakeOffDuration = new TimeSpan(0, 9, 0) }); airportDbContext.Flights.Add(new Flight { Id = 2, LandingDuration = new TimeSpan(0, 8, 0), Name = "Flight2", TakeOffDuration = new TimeSpan(0, 9, 0) }); airportDbContext.Flights.Add(new Flight { Id = 3, LandingDuration = new TimeSpan(0, 10, 0), Name = "Flight3", TakeOffDuration = new TimeSpan(0, 12, 0) }); airportDbContext.Flights.Add(new Flight { Id = 4, LandingDuration = new TimeSpan(0, 8, 0), Name = "Flight4", TakeOffDuration = new TimeSpan(0, 8, 0) }); airportDbContext.Flights.Add(new Flight { Id = 5, LandingDuration = new TimeSpan(0, 11, 0), Name = "Flight5", TakeOffDuration = new TimeSpan(0, 9, 0) }); airportDbContext.Flights.Add(new Flight { Id = 6, LandingDuration = new TimeSpan(0, 7, 0), Name = "Flight6", TakeOffDuration = new TimeSpan(0, 9, 0) }); airportDbContext.Flights.Add(new Flight { Id = 7, LandingDuration = new TimeSpan(0, 10, 0), Name = "Flight7", TakeOffDuration = new TimeSpan(0, 10, 0) }); await airportDbContext.SaveChangesAsync(); }