static void Main(string[] args)
{
using (var dbContext = new ApplicationDbContext()) {
var _ctx = new CountryContext(new ApplicationDbContext());
var countries = _ctx.Countries.Include(cntr => cntr.Cities).ToList();
foreach (var country in countries)
{
Console.WriteLine($"COUNTRY : ID : {country.CountryId} - NAME : {country.CountryName}");
foreach (var city in country.Cities)
{
Console.WriteLine($" ---- CITY : ID : {city.CityId} - NAME : {city.CityName}");
}
}
var _accCtx = new AccountContext(dbContext);
var _clientCtx = new ClientContext(dbContext);
var accounts = _accCtx.Accounts.Include(acc => acc.Client).ToList();
var clients = _clientCtx.Clients.Include(cl => cl.Accounts).ToList();
Console.WriteLine(">>>>>>>>>>>>>>>>ACCOUNTS<<<<<<<<<<<<<<<<<<<<<");
accounts.ForEach(acc =>
{
Console.WriteLine($" ACCOUNT : ID {acc.AccountID}, LOGIN {acc.AccountLogin}, PASSWORD {acc.AccountPassword}, ROLE {acc.Role} " +
$" CREATED : {acc.Created.ToShortDateString()}, UPDATED {acc.Updated.ToShortDateString()}");
Console.WriteLine($" ---- CLIENT : ID {acc.ClientID}, NAME {acc.Client.ClientFirstname}, SURNAME {acc.Client.ClientLastname}, ADDRESS {acc.Client.ClientAddress}" +
$" CREATED : {acc.Client.Created.ToShortDateString()}, UPDATED {acc.Client.Updated.ToShortDateString()}");
});
Console.WriteLine(">>>>>>>>>>>>>>>>CLIENTS<<<<<<<<<<<<<<<<<<<<<<<");
clients.ForEach(cl =>
{
Console.WriteLine($" CLIENT : ID {cl.ClientId}, NAME {cl.ClientFirstname}, SURNAME {cl.ClientLastname}, ADDRESS {cl.ClientAddress}" +
$" CREATED : {cl.Created.ToShortDateString()}, UPDATED {cl.Updated.ToShortDateString()}");
cl.Accounts.ToList().ForEach(acc =>
{
Console.WriteLine($" ---- ACCOUNT : ID {acc.AccountID}, LOGIN {acc.AccountLogin}, PASSWORD {acc.AccountPassword}, ROLE {acc.Role} " +
$" CREATED : {acc.Created.ToShortDateString()}, UPDATED {acc.Updated.ToShortDateString()}");
});
});
var _airportCtx = new AirportContext(dbContext);
var airports = _airportCtx.Airports.Include(ap => ap.City).ToList();
airports.ForEach(ap =>
{
Console.WriteLine($"AIRPORT : ID {ap.AirportId}, CODE {ap.AirportCode}, NAME {ap.AirportName}" +
$" CREATED : {ap.Created.ToShortDateString()}, UPDATED {ap.Updated.ToShortDateString()}");
Console.WriteLine($" ---- CITY : ID : {ap.City.CityId} - NAME : {ap.City.CityName}");
});
var _airplaneCtx = new AirplaneContext(dbContext);
var airplanes = _airplaneCtx.Airplanes.Include(apl => apl.Type).ToList();
airplanes.ForEach(apl =>
{
Console.WriteLine($"AIRPLANE : ID {apl.AirplaneId}, NUMBER {apl.AirplaneNumber} , EXISTS : {apl.IsDeleted}" +
$" CREATED : {apl.Created.ToShortDateString()}, UPDATED {apl.Updated.ToShortDateString()}");
Console.WriteLine($" ---- TYPE : ID : {apl.Type.AirplaneTypeId} - NAME : {apl.Type.AirplaneTypeName}" +
$"SITS COUNT : {apl.Type.AirplaneTypeSitsCount}, PRICE : {apl.Type.SitPriceInDollars}, BUSINESS : {apl.Type.HasBusinessClass}");
});
var _airplaneTypeCtx = new AirplaneTypeContext(dbContext);
Console.WriteLine(">>>>>>>>>>>>>>>>>>>>>>>>>TYPES <<<<<<<<<<<<<<<<<<<<<<<<<<<<< ");
var _airplaneTypes = _airplaneTypeCtx.AirplaneTypes.Include(aplt => aplt.AirplanesOfCurrentType).ToList();
_airplaneTypes.ForEach(aplt =>
{
Console.WriteLine($" TYPE : ID : {aplt.AirplaneTypeId} - NAME : {aplt.AirplaneTypeName}" +
$"SITS COUNT : {aplt.AirplaneTypeSitsCount}, PRICE : {aplt.SitPriceInDollars}, BUSINESS : {aplt.HasBusinessClass}");
aplt.AirplanesOfCurrentType.ToList().ForEach(apl =>
{
Console.WriteLine($" ---- AIRPLANE : ID {apl.AirplaneId}, NUMBER {apl.AirplaneNumber} , EXISTS : {apl.IsDeleted}" +
$" CREATED : {apl.Created.ToShortDateString()}, UPDATED {apl.Updated.ToShortDateString()}");
});
});
var _flightCtx = new FlightContext(dbContext);
var flights = _flightCtx.Flights.Include(fl => fl.Airplane).Include(fl => fl.Airports).ToList();
Console.WriteLine(" >>>>>>>>>>>>>>>>>>>>>>>>FLIGHTS<<<<<<<<<<<<<<<<<<<<");
Console.WriteLine("");
Console.WriteLine("");
foreach (var flight in flights)
{
Console.WriteLine($"FLIGHT : ID {flight.FlightId} - ARRIVE TIME {flight.ArriveTime.ToShortTimeString()} - DEPARTURE TIME {flight.DepartureTime.ToShortTimeString()} ");
Console.WriteLine("");
Console.WriteLine($" ---- AIRPLANE : ID {flight.Airplane.AirplaneId}, NUMBER {flight.Airplane.AirplaneNumber} , EXISTS : {flight.Airplane.IsDeleted}");
var arrive = flight.Airports.Where(ap => ap.IsArrive).ToArray()[0];
var departure = flight.Airports.Where(ap => !ap.IsArrive).ToArray()[0];
Console.WriteLine($"----- AIRPORTS----------");
Console.WriteLine("");
Console.WriteLine($"ARRIVE AIRPORT : ID {arrive.AirportID}, CODE {arrive.Airport.AirportCode}, NAME {arrive.Airport.AirportName}");
Console.WriteLine($" ---- CITY : ID : {arrive.Airport.City.CityID} - NAME : {arrive.Airport.City.CityName}");
Console.WriteLine("");
Console.WriteLine($"DEPARTURE AIRPORT : ID {departure.AirportID}, CODE {departure.Airport.AirportCode}, NAME {departure.Airport.AirportName}");
Console.WriteLine($" ---- CITY : ID : {departure.Airport.City.CityID} - NAME : {departure.Airport.City.CityName}");
}
var _ticketCtx = new TicketContext(dbContext);
var tickets = _ticketCtx.Tickets.Include(t => t.Client).Include(t => t.Flight).ToList();
tickets.ForEach(t =>
{
Console.WriteLine($" ID : {t.TicketID} - CLIENT NAME : {t.Client.ClientFirstname + t.Client.ClientLastname} " +
$"- DEPARTURE CITY : {t.Flight.Airports.Where(ap => !ap.IsArrive).ToArray()[0].Airport.City.CityName}" +
$"- ARRIVE CITY {t.Flight.Airports.Where(ap => ap.IsArrive).ToArray()[0].Airport.City.CityName}");
});
}
}
// GET: /<controller>/
public JsonResult Index([FromServices] AirplaneContext context)
{
var a = context.Airplanes.ToArray();
return(Json(a));
}
public BaseRepository(AirplaneContext context)
{
_context = context;
DbSet = _context.Set <TEntity>();
}
public UnitOfWork(AirplaneContext context)
{
_context = context;
}
protected Repository(AirplaneContext context)
{
Db = context;
DbSet = Db.Set <TEntity>();
}
public AirplaneRepository(AirplaneContext context)
{
this.context = context;
}
public AirplaneController(AirplaneContext context, IServiceAirplane serviceAirplane)
{
_context = context;
_serviceAirplane = serviceAirplane;
}
public AirplaneRepository(AirplaneContext context) : base(context)
{
}
public Repository(AirplaneContext context)
{
_context = context;
}
public Repository(AirplaneContext context)
{
Db = context;
DbSet = Db.Set <TEntity>();
}
public RepositorioAirplane(AirplaneContext airplaneContext)
{
_airplaneContext = airplaneContext;
}
