public async Task <Flight> AddFlightAsync(Flight flight)
{
var entityEntry = await context.Flight.AddAsync(flight);
var result = await context.SaveChangesAsync();
if (result < 1)
{
return(null);
}
return(entityEntry.Entity);
}
public async Task <News> AddNewsAsync(News news)
{
var entityEntry = await context.News.AddAsync(news);
var result = await context.SaveChangesAsync();
if (result < 1)
{
return(null);
}
return(entityEntry.Entity);
}
public async Task <Airport> UpdateAirportAsync(Airport airport)
{
var airportToUpdate = await context.Airport.FirstOrDefaultAsync(a => a.Id == airport.Id);
context.Entry(airportToUpdate).CurrentValues.SetValues(new { airport.Iata, airport.Name, airport.MapUrl, airport.MapName, airport.RentingCompanyUrl, airport.RentingCompanyName, airport.RentingCompanyPhoneNo, airport.TaxiPhoneNo, airport.EmergencyPhoneNo, airport.Icao });
var result = await context.SaveChangesAsync();
if (result < 1)
{
return(null);
}
return(await context.Airport.FirstOrDefaultAsync(a => a.Id == airportToUpdate.Id));
}
public async Task CleanUp()
{
flyItContext.RemoveRange(flyItContext.Airport);
flyItContext.RemoveRange(flyItContext.News);
await flyItContext.SaveChangesAsync();
}
public async Task <UserChatroom> AddUserChatroomAsync(UserChatroom userChatroom)
{
if (userChatroom is null)
{
return(null);
}
var entityEntry = await context.UserChatroom.AddAsync(userChatroom);
var result = await context.SaveChangesAsync();
if (result < 1)
{
return(null);
}
return(entityEntry.Entity);
}
public async Task <UserToken> UpdateUserTokenAsync(UserToken userToken)
{
var userTokenToUpdate = await context.UserToken.SingleOrDefaultAsync(ut => ut.Id == userToken.Id && ut.RefreshToken == userToken.RefreshToken);
if (userTokenToUpdate is null)
{
return(null);
}
context.Entry(userTokenToUpdate).CurrentValues.SetValues(userToken);
var result = await context.SaveChangesAsync();
if (result < 1)
{
return(null);
}
return(await context.UserToken.SingleOrDefaultAsync(ut => ut.Id == userToken.Id && ut.RefreshToken == userToken.RefreshToken));
}
public async Task <ChatroomMessage> AddChatroomMessageAsync(ChatroomMessage chatroomMessage)
{
if (chatroomMessage is null)
{
return(null);
}
var enitityEntry = await flyItContext.ChatroomMessage.AddAsync(chatroomMessage);
var result = await flyItContext.SaveChangesAsync();
if (result < 1)
{
return(null);
}
return(enitityEntry.Entity);
}
