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();
}
