public List <Flight> GetFlightList() { var flightsEntityList = new List <Flight>(); try { //TraceManager.StartMethodTrace(parameters: "flightEntity: " + JsonConvert.SerializeObject(flightEntity)); // Build the filters var flights = this.DatabaseContext.Flight .Include(flight => flight.DepartureAirport) .Include(flight => flight.DestinationAirport); if (flights.Any()) { flightsEntityList = DataAutoMapper.Map <List <Flight> >(flights.ToList()); } return(flightsEntityList); } finally { //TraceManager.FinishMethodTrace(output: "flightsEntityList: " + JsonConvert.SerializeObject(flightsEntityList)); } }
/// <summary> /// Get the airport list /// </summary> /// <param name="airportEntity">Airport data</param> /// <returns>Return the airports List with the data </returns> public List <Airport> GetAirports(Airport airportEntity) { var airportsEntityList = new List <Airport>(); try { //TraceManager.StartMethodTrace(parameters: "airportEntity: " + JsonConvert.SerializeObject(airportEntity)); // Build the filters var getPredicateBuilderForGetAirports = AirportsPredicateBuilder.GetPredicateBuilderForGetAirports(airportEntity); var airports = this.DatabaseContext.Airport .Where(getPredicateBuilderForGetAirports); if (airports.Any()) { airportsEntityList = DataAutoMapper.Map <List <Airport> >(airports.ToList()); } return(airportsEntityList); } finally { //TraceManager.FinishMethodTrace(output: "airportsEntityList: " + JsonConvert.SerializeObject(airportsEntityList)); } }
/// <summary> /// Create an airport /// </summary> /// <param name="airportEntity">entity with the info</param> public void CreateAirport(Airport airportEntity) { try { //TraceManager.StartMethodTrace(parameters: "airportEntity: " + JsonConvert.SerializeObject(airportEntity)); var airport = DataAutoMapper.Map <Models.Schemas.dbo.Airport>(airportEntity); //TraceManager.ObjectDataTrace("airport", JsonConvert.SerializeObject(airport)); DatabaseContext.Airport.AddOrUpdate(airport); DatabaseContext.SaveChanges(); } finally { //TraceManager.FinishMethodTrace(); } }
/// <summary> /// Update or insert in a flight /// </summary> /// <param name="flightEntity">entity with the info</param> public void CreateFlight(Flight flightEntity) { try { //TraceManager.StartMethodTrace(parameters: "flightEntity: " + JsonConvert.SerializeObject(flightEntity)); var flight = DataAutoMapper.Map <Models.Schemas.dbo.Flight>(flightEntity); //TraceManager.ObjectDataTrace("flight", JsonConvert.SerializeObject(flight)); flight.DepartureAirport = DatabaseContext.Airport.FirstOrDefault(airport => airport.Name.Equals(flight.DepartureAirport.Name)); flight.DestinationAirport = DatabaseContext.Airport.FirstOrDefault(airport => airport.Name.Equals(flight.DestinationAirport.Name)); DatabaseContext.Flight.AddOrUpdate(flight); DatabaseContext.SaveChanges(); } finally { //TraceManager.FinishMethodTrace(); } }