public IList <FlightModel> GetAllFlights(FlightType flightType)
{
using var dbContext = new LocalDatabaseContext();
var flights = dbContext.Flights.Where(x => x.Type == flightType);
return(this.mapper.ProjectTo <FlightModel>(flights).ToList());
}
// TODO 2.1: Upravte metodu tak, aby vrátila pouze lety specifického typu
public IList <FlightModel> GetAllFlights()
{
using var dbContext = new LocalDatabaseContext();
var flights = dbContext.Flights;
return(this.mapper.ProjectTo <FlightModel>(flights).ToList());
}
public IList <AirplaneModel> GetClubAirplanes()
{
using var dbContext = new LocalDatabaseContext();
var airplanes = dbContext.ClubAirplanes
.Include(airplane => airplane.AirplaneType);
return(this.mapper.ProjectTo <AirplaneModel>(airplanes).ToList());
}
// TODO 2.3: Vytvořte metodu, která načte letadla, která jsou ve vzduchu, seřadí je od nejstarších,
// a v případě shody dá vlečné pred kluzák, který táhne
public void LandFlight(FlightLandingModel landingModel)
{
using var dbContext = new LocalDatabaseContext();
var flight = dbContext.Flights.Find(landingModel.FlightId);
flight.LandingTime = landingModel.LandingTime;
dbContext.SaveChanges();
}
public void TakeoffFlight(long?gliderFlightId, long?towplaneFlightId)
{
using var dbContext = new LocalDatabaseContext();
var flightStart = new FlightStart
{
Glider = dbContext.Flights.Find(gliderFlightId),
Towplane = dbContext.Flights.Find(towplaneFlightId),
};
dbContext.FlightStarts.Add(flightStart);
dbContext.SaveChanges();
}
public long AddGuestAirplane(AirplaneModel airplaneModel)
{
using var dbContext = new LocalDatabaseContext();
Airplane airplane = new Airplane
{
GuestAirplaneImmatriculation = airplaneModel.Immatriculation,
GuestAirplaneType = airplaneModel.Type,
};
dbContext.Airplanes.Add(airplane);
dbContext.SaveChanges();
return(airplane.Id);
}
public IList <FlightModel> GetAirplanesInAir()
{
using var dbContext = new LocalDatabaseContext();
var flights = dbContext.Flights
.Include(x => x.Airplane)
.Include(x => x.Copilot)
.Include(x => x.Pilot)
.Where(x => x.LandingTime == null)
.OrderBy(x => x.TakeoffTime)
.ThenByDescending(x => x.Type);
return(this.mapper.ProjectTo <FlightModel>(flights).ToList());
}
// ReSharper disable once UnusedMember.Global - used by Framework
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, IMapper mapper, ILoggerFactory loggerFactory)
{
loggerFactory.AddLog4Net();
// Security headers make me happy
app.UseHsts(options => options.MaxAge(365).IncludeSubdomains());
app.UseXContentTypeOptions();
app.UseReferrerPolicy(opts => opts.NoReferrer());
app.UseXXssProtection(options => options.EnabledWithBlockMode());
app.UseXfo(options => options.Deny());
app.UseCsp(opts => opts
.BlockAllMixedContent()
.StyleSources(s => s.Self())
.StyleSources(s => s.UnsafeInline())
.FontSources(s => s.Self())
.FormActions(s => s.Self())
.FrameAncestors(s => s.Self())
.ImageSources(s => s.Self())
.ScriptSources(s => s.Self()));
// End Security Headers
app.UseDefaultFiles();
app.UseStaticFiles();
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
TestDatabaseGenerator.RenewDatabase();
}
else
{
using var dbContext = new Repositories.LocalDatabaseContext();
dbContext.Database.EnsureCreated();
}
app.UseHttpsRedirection();
app.UseRouting();
app.UseAuthorization();
app.UseEndpoints(endpoints => {
endpoints.MapControllers();
});
mapper.ConfigurationProvider.AssertConfigurationIsValid();
}
public long AddGuestPerson(PersonModel pilot)
{
using var dbContext = new LocalDatabaseContext();
var address = new Address {
City = pilot.Address.City, Country = pilot.Address.Country, PostalCode = pilot.Address.PostalCode, Street = pilot.Address.Street
};
var person = new Person {
Address = address, FirstName = pilot.FirstName, LastName = pilot.LastName, PersonType = PersonType.Guest
};
dbContext.Persons.Add(person);
dbContext.SaveChanges();
return(person.Id);
}
public bool TryGetAirplane(AirplaneModel airplaneModel, out long airplaneId)
{
using var dbContext = new LocalDatabaseContext();
var firstAirplane = dbContext.Airplanes.FirstOrDefault(airplane => airplane.Id == airplaneModel.Id);
if (firstAirplane != null)
{
airplaneId = firstAirplane.Id;
return(true);
}
else
{
airplaneId = 0;
return(false);
}
}
public IList <ReportModel> GetReport()
{
using var dbContext = new LocalDatabaseContext();
var flightStarts = dbContext.FlightStarts
.Include(flight => flight.Glider)
.Include(flight => flight.Glider.Airplane)
.Include(flight => flight.Glider.Pilot)
.Include(flight => flight.Glider.Copilot)
.Include(flight => flight.Towplane)
.Include(flight => flight.Towplane.Airplane)
.Include(flight => flight.Towplane.Pilot)
.Include(flight => flight.Towplane.Copilot)
.OrderByDescending(start => start.Towplane.TakeoffTime);
return(this.mapper.ProjectTo <ReportModel>(flightStarts).ToList());
}
public bool TryGetPerson(PersonModel personModel, out long personId)
{
using var dbContext = new LocalDatabaseContext();
Person firstPerson = dbContext.Persons.FirstOrDefault(person => person.MemberId == personModel.MemberId);
if (firstPerson != null)
{
personId = firstPerson.Id;
return(true);
}
else
{
personId = 0;
return(false);
}
}
public long CreateClubMember(PersonModel pilot)
{
using var dbContext = new LocalDatabaseContext();
var person = new Person
{
FirstName = pilot.FirstName,
LastName = pilot.LastName,
PersonType = PersonType.ClubMember,
MemberId = pilot.MemberId,
};
dbContext.Persons.Add(person);
dbContext.SaveChanges();
return(person.Id);
}
public long CreateFlight(CreateFlightModel model)
{
using var dbContext = new LocalDatabaseContext();
var copilot = model.CopilotId != null
? dbContext.Persons.Find(model.CopilotId)
: null;
var flight = new Flight
{
Airplane = dbContext.Airplanes.Find(model.AirplaneId),
Copilot = copilot,
Pilot = dbContext.Persons.Find(model.PilotId),
TakeoffTime = model.TakeOffTime,
Task = model.Task
};
dbContext.Flights.Add(flight);
dbContext.SaveChanges();
return(flight.Id);
}
