//private static EventStatus Map(DB.EventStatus eventStatus)
//{
// return new EventStatus() { Id = eventStatus.ID, Description = eventStatus.Description };
//}
public static FlightSearch Map(DB.FlightSearch dbFlightSearch)
{
if (dbFlightSearch == null)
{
return(null);
}
var flightSearch = new FlightSearch
{
Id = dbFlightSearch.ID,
DepartureStation = dbFlightSearch.DepartureStation.Trim(),
ArrivalStation = dbFlightSearch.ArrivalStation.Trim(),
BeginDate = dbFlightSearch.StartDate,
EndDate = dbFlightSearch.EndDate,
DaysOfWeek = (short)dbFlightSearch.DaysOfWeek,
MaxPrice = (short?)dbFlightSearch.MaxPrice,
Flights = new List <Flight>()
};
dbFlightSearch.Flights.ToList().ForEach(f => flightSearch.Flights.Add(Map(f)));
// link selected flight from collection
if (dbFlightSearch.SelectedFlightID.HasValue)
{
flightSearch.SelectedFlight =
flightSearch.Flights.Single(f => f.Id.Equals(dbFlightSearch.SelectedFlightID));
}
return(flightSearch);
}
public CoreQuery Create(FlightSearch search)
{
return(new CoreQuery()
{
OriginDestinations = CreateDestinations(search)
});
}
public List <FlightSearchResult> GetFlightSearch(FlightSearch fs)
{
SqlParameter[] Parameters = { new SqlParameter("@LoginSNo", fs.LoginSNo),
new SqlParameter("@FlightDate", fs.FlightDate),
new SqlParameter("@OriginAirportSNo", fs.OriginAirportSNo),
new SqlParameter("@DestinationAirportSNo", fs.DestinationAirportSNo),
new SqlParameter("@VolWeight", fs.VolumeWeight),
new SqlParameter("@GrWeight", fs.GrossWeight),
new SqlParameter("@ProductSNo", fs.ProductSNo),
new SqlParameter("@CommoditySNo", fs.CommoditySNo),
new SqlParameter("@IsCAO", fs.IsCAO),
new SqlParameter("@IsULD", fs.IsULD),
new SqlParameter("@ErrorMessage", DbType.String)
{
Direction = ParameterDirection.Output, Size = 250
} };
DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "spReservation_FlightSearch", Parameters);
var flightList = ds.Tables[0].AsEnumerable().Select(e => new FlightSearchResult
{
DailyFlightSNo = Convert.ToInt32(e["SNo"]),
FlightNo = e["FlightNo"].ToString(),
From = e["OriginAirportCode"].ToString(),
ETD = Convert.ToDateTime(e["ETD"]).ToString("dd-MMM-yyyy hh:mm"),
To = e["DestinationAirportCode"].ToString(),
ETA = Convert.ToDateTime(e["ETA"]).ToString("dd-MMM-yyyy hh:mm"),
AircraftType = e["AircraftType"].ToString(),
AvailableGross = Convert.ToDecimal(e["AvailableGross"]),
AvailableVolume = Convert.ToDecimal(e["AvailableVolume"]),
DestAirportSNo = Convert.ToInt32(e["DestinationAirPortSNo"]),
OriginAirportSNo = Convert.ToInt32(e["OriginAirPortSNo"])
}).ToList();
return(flightList);
}
public ActionResult SubmitSearch(FlightIndexVM flightsData)
{
// convert origin and destination cities to codes
DataLayer dl = new DataLayer();
flightsData.originCode = (from u in dl.locations
where u.city.ToLower() == flightsData.originCity.ToLower()
select u.code).ToList <string>().FirstOrDefault();
flightsData.desCode = (from u in dl.locations
where u.city.ToLower() == flightsData.desCity.ToLower()
select u.code).ToList <string>().FirstOrDefault();
// create the api object
FlightSearch flightSearch = new FlightSearch();
flightSearch.FillData(flightsData.originCode, flightsData.desCode, flightsData.sdate, flightsData.edate, flightsData.originCountry, flightsData.originCity, flightsData.desCountry, flightsData.desCity);
// if no results were found (400: bad request)
if (flightSearch.GetResponse() != "")
{
FlightSearchResultsVM newObj = new FlightSearchResultsVM()
{
destinationCity = flightSearch.GetDestinationCity(),
destinationCountry = flightSearch.GetDestinationCountry(),
originCity = flightSearch.GetOriginCity(),
originCountry = flightSearch.GetOriginCountry(),
departureDate = flightsData.sdate,
returnDate = flightsData.edate,
};
return(View("SearchResults", newObj));
}
// for the google map
string[] loc = flightSearch.GetLocation().Split(',');
double latitude = Double.Parse(loc[0]);
double longitude = Double.Parse(loc[1]);
// create object to pass to the view
FlightSearchResultsVM flightSearchResultsVM = new FlightSearchResultsVM()
{
departureDate = flightSearch.GetDepartureDate(),
destinationCity = flightSearch.GetDestinationCity(),
destinationCodeCity = flightSearch.GetDestinationCodeCity(),
destinationCountry = flightSearch.GetDestinationCountry(),
inbound = flightSearch.GetInbound(),
originCity = flightSearch.GetOriginCity(),
originCodeCity = flightSearch.GetOriginCodeCity(),
originCountry = flightSearch.GetOriginCountry(),
outbound = flightSearch.GetOutbound(),
price = flightSearch.GetPrice(),
returnDate = flightSearch.GetReturnDate(),
seatsRemaining = flightSearch.GetSeatsRemaining(),
airline = flightSearch.GetAirline(),
latitude = latitude,
longitude = longitude,
};
return(View("SearchResults", flightSearchResultsVM));
}
public string BeginSearch(string fromAirport, string toAirport, DateTime dateTime, int adults, int child,
int infants, out string error)
{
error = string.Empty;
var mode = ConfigSettings.SupplierMode;
var supplierInfos = SupplierDataProviderFactory.GetSupplierDataProvider().GetSuppliers(mode);
var suppliers = GetSuppliers(supplierInfos);
var searchParams = new FlightSearchParams
{
FromAirport = fromAirport,
Adults = adults,
Children = child,
Date = dateTime,
Infants = infants,
ToAirport = toAirport
};
var flightSearch = new FlightSearch(searchParams, suppliers, _cacheProvider);
flightSearch.BeginSearch();
return flightSearch.SearchKey;
}
public void EnterFlightDetails(FlightSearch flightSearch)
{
//CheckIn.Click();
SelectCheckIn(flightSearch.OneWay);
EnterOriginAirportTextField();
//EnterOriginAirportTextField(flightSearch.OriginAirport);
}
public IActionResult AvailableFlights(FlightSearch flightSearch)
{
if (_context.Flights.Any(fl => fl.FlightsID == 0))
{
return(RedirectToAction("Error", "Home"));
}
try
{
/*
* ----< The if condition checks whether there ia a flight available for selected inputs
* Also the Controller returns only the required fields to the View, This is where we are returning the price
* of the selected class so that the correct price can be displayed in View>----
*/
int totalTicketCount = flightSearch.AdultSearch + flightSearch.ChildrenSearch + flightSearch.InfantSearch;
IQueryable <ReturningValue> flightOrder = Enumerable.Empty <ReturningValue>().AsQueryable();
if (flightSearch.ClassSearch.Equals("economy"))
{
var search = _context.Flights.Where(s => s.Source.Equals(flightSearch.FromSearch) &&
s.Destination.Equals(flightSearch.ToSearch) &&
s.DepartureDate.Equals(flightSearch.DateSearch) &&
s.EconomyNos >= (flightSearch.AdultSearch + flightSearch.ChildrenSearch + flightSearch.InfantSearch));
flightOrder = search.OrderBy(s => s.DepartsOn)
.Select(s => new ReturningValue
{
Id = s.FlightsID,
Name = s.FlightName,
Departure = s.DepartsOn,
Arrival = s.ArrivesOn,
PFirst = 0, //Selected class is Economy, so make First 0
PEconomy = s.PriceEconomy * totalTicketCount,
TicketSelected = totalTicketCount
});
}
if (flightSearch.ClassSearch.Equals("first"))
{
var search = _context.Flights.Where(s => s.Source.Equals(flightSearch.FromSearch) &&
s.Destination.Equals(flightSearch.ToSearch) &&
s.DepartureDate.Equals(flightSearch.DateSearch) &&
s.FirstNos >= (flightSearch.AdultSearch + flightSearch.ChildrenSearch + flightSearch.InfantSearch));
flightOrder = search.OrderBy(s => s.DepartsOn)
.Select(s => new ReturningValue
{
Id = s.FlightsID,
Name = s.FlightName,
Departure = s.DepartsOn,
Arrival = s.ArrivesOn,
PFirst = s.PriceFirst * totalTicketCount,
PEconomy = 0, //Selected class is Economy, so make Economy 0
TicketSelected = totalTicketCount
});
}
return(View(flightOrder));
}
catch (Exception)
{
//This is where we return no flights available for the given search
return(RedirectToAction("Error", "Home"));
}
}
public AirShoppingRS FlightSearch(FlightSearch search)
{
var xml = CreateXml(search);
var result = _soapService.SendRequest(xml);
var airShopping = _xmlService.AirShoppingParser(result);
return(airShopping);
}
public Preference Create(FlightSearch search)
{
return(new Preference()
{
FarePreferences = CreateFarePreference("759"),
CabinPreferences = CreateCabinPreference(search.FlightClass)
});
}
public ActionResult Search(FlightSearch searchParam)
{
if (ModelState.IsValid)
{
SearchManager srchMgr = new SearchManager();
searchParam.SearchResults = srchMgr.SearchFlights(Convert.ToInt16(searchParam.SourceCity), Convert.ToInt16(searchParam.DestinationCity));
}
return(View(searchParam));
}
public static List <SearchResultDto> ExportToSearchResultDtos(this FlightSearch flightSearch)
{
var results = flightSearch.Results.Select(result => new SearchResultDto
{
Itineraries = result.Itineraries.Select(itinerary => (ItineraryDto)itinerary),
TotalPrice = result.Fare.TotalPrice
});
return(results.ToList());
}
private void CopyParticipantAvailability(string participantId, FlightSearch flightSearch)
{
foreach (var flight in flightSearch.Flights)
{
flight.ParticipantAvailability =
flight.Availabilities.Single(a => a.ParticipantId.Equals(participantId));
// reduce JSON response
//flight.Availabilities.ForEach(a => a.ParticipantId = "");
}
}
//Passing 1st trip and run a reverse search with return date
public ActionResult FlightListReturn(string fid, int rid, int?page)
{
try
{
var ridParse = int.TryParse(rid.ToString(), out int ridParsed);
if (string.IsNullOrEmpty(fid))
{
fid = (string)Session["fid1"];
}
if (!ridParse)
{
rid = (int)Session["rid1"];
}
Session["fid1"] = fid;
Session["rid1"] = rid;
Session["fid2"] = null;
FlightResult firstTrip = FlightSearchDAO.GetFlightResult(fid, rid);
FlightSearch flightSearch = (FlightSearch)Session["searchParams"];
ViewBag.RoundTrip = flightSearch.IsRoundTrip;
var seatsLeft = firstTrip.FlightVM.AvailSeatsB + firstTrip.FlightVM.AvailSeatsF + firstTrip.FlightVM.AvailSeatsE;
//interrupt check for available seats
if (seatsLeft == 0)
{
TempData["NoSeatsMessage"] = "Sorry, there are no more seats left for flight " + firstTrip.FlightVM.FNo;
return(RedirectToAction("FlightList", flightSearch));
}
//flip search query
FlightSearch flightSearchReturn = ReverseFlightSearch(flightSearch);
ViewBag.firstTrip = firstTrip;
ViewBag.Pages = GetPages(flightSearchReturn);
if (page == null)
{
ViewBag.PageIndex = 1;
return(View("FlightList", GetFlightsForPage(1)));
}
ViewBag.PageIndex = page;
//for debugging, making sure the original params are intact
//Session["searchParams"] = flightSearch;
return(View("FlightList", GetFlightsForPage(int.Parse(page.ToString()))));
}
catch (Exception)
{
//returns to home if search reversal procedure fails at any point
TempData["errorM"] = "There was an error executing your requests. Please try again";
return(RedirectToAction("Index"));
}
}
public MainWindowViewModel()
{
Currency = new List <string>()
{
"HRK", "EUR", "USD"
};
Countries = AirportManager.GetCountries();
FlightSearch = new FlightSearch();
FlightResult = new FlightResult();
AirportAutocomplete = new AirportAutocomplete();
AirportManager.ReadFlights();
}
// GET: api/FlightSeach
public IHttpActionResult Get([FromUri] FlightSearch flightSearch)
{
try
{
var result = this.service.GetFlightResult(flightSearch);
return(Ok(result));
}
catch (Exception)
{
return(BadRequest("bad"));
}
}
private static bool IsValid(FlightSearch flightSearch)
{
if (flightSearch != null &&
flightSearch.From != null &&
flightSearch.To != null &&
flightSearch.DepartureDate.GetHashCode() != 0 &&
flightSearch.From != flightSearch.To)
{
return(true);
}
return(false);
}
public IEnumerable <FlightResult> GetFlightResult(FlightSearch flightSearch)
{
var data = GetData();
if (flightSearch.From == null || flightSearch.To == null)
{
return(data);
}
var filteredResult = data.Where(x => x.From.Equals(flightSearch.From, StringComparison.InvariantCultureIgnoreCase) &&
x.To.Equals(flightSearch.To, StringComparison.InvariantCultureIgnoreCase));
return(filteredResult);
}
public IEnumerable <FlightViewModel> Post(FlightSearch flightSearch)
{
try
{
var flights = flightRepository.GetFlights(flightSearch.FromAirport, flightSearch.ToAirport);
return(flights);
}
catch (ArgumentException aex)
{
// TODO: Log Exception
return(new List <FlightViewModel>());
}
}
private void Dont_get_flight_because_dont_find_airport()
{
var flightInfo = new FlightSearch()
{
DepartureAirport = "undefined airport",
ArrivalAirport = this._flight.ArrivalAirport.Name,
};
RedirectToRouteResult routeResult = this._controller.GetFlights(flightInfo) as RedirectToRouteResult;
var value = routeResult.RouteValues["Notification"];
Assert.AreEqual("Sorry, departure is not found.", value);
}
public JsonResult SerachFlight(FlightSearchParameter objserch)
{
try
{
string datefrm = null;
string dateTo = null;
if (objserch.Tripmode == "1")
{
DateTime datefrm11 = Convert.ToDateTime(objserch.FromDate);
datefrm = datefrm11.ToString("yyyy-MM-dd");
dateTo = null;
}
else if (objserch.Tripmode == "2")
{
DateTime datefrm11 = Convert.ToDateTime(objserch.FromDate);
datefrm = datefrm11.ToString("yyyy-MM-dd");
DateTime date_to = Convert.ToDateTime(objserch.ToDate);
dateTo = date_to.ToString("yyyy-MM-dd");
}
var GetTokenValue = GetToken();
FlightSearch objflightsearch = new FlightSearch();
objflightsearch.TokenId = GetTokenValue;
objflightsearch.AdultCount = objserch.Adult;
objflightsearch.ChildCount = objserch.Child;
objflightsearch.InfantCount = objserch.Infant;
objflightsearch.DirectFlight = "false";
objflightsearch.OneStopFlight = "false";
objflightsearch.JourneyType = objserch.Tripmode;
objflightsearch.PreferredAirlines = null;
objflightsearch.Origin = objserch.FromCityCode;
objflightsearch.Destination = objserch.TOAirportCode;
objflightsearch.FlightCabinClass = objserch.TravelType;
objflightsearch.PreferredDepartureTime = datefrm;
objflightsearch.PreferredArrivalTime = dateTo;
objflightsearch.Sources = "6E";
dynamic searchflight = Tek_TravelAPI.SerachFlight(objflightsearch);
var data = JsonConvert.SerializeObject(searchflight);
//var searchflight = Tek_TravelAPI.SerachFlight(GetTokenValue,"1","0","0","true", "false", "1", PreferredAirlines, "CCU","BOM","1", Date_from, datetovalue, "6E");
string TraceId = searchflight.Response.TraceId;
return(Json(data, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
throw ex;
}
}
public List <Traveler> Create(FlightSearch search)
{
var travelers = new List <Traveler>();
for (int i = 0; i < search.NumberOfAdults; i++)
{
travelers.Add(CreateAdult());
}
for (int i = 0; i < search.NumberOfChildren; i++)
{
travelers.Add(CreateChild());
}
return(travelers);
}
public ActionResult GetFlights([Bind(Include = "DepartureAirport,ArrivalAirport,beginningDate,endingDate")] FlightSearch search)
{
if (!HasAirport(search.DepartureAirport))
{
return(GetNotFound("departure"));
}
if (!HasAirport(search.ArrivalAirport))
{
return(GetNotFound("arrival"));
}
Airport departureAirport = null;
Airport arrivalAirport = null;
using (var session = this._airportUnit.GetSession())
{
departureAirport = session.GetRepository().Find((a) => a.Name == search.DepartureAirport).First();
arrivalAirport = session.GetRepository().Find((a) => a.Name == search.ArrivalAirport).First();
}
using (var session = this._flightUnit.GetSession())
{
var flightRepo = session.GetRepository();
if (search.BeginningDate != DateTime.MinValue && search.EndingDate != DateTime.MinValue)
{
ViewBag.flights = flightRepo.Find(flight =>
flight.DepartureAirport.Id == departureAirport.Id &&
flight.ArrivalAirport.Id == arrivalAirport.Id &&
search.BeginningDate <= flight.StartDate &&
flight.StartDate <= search.EndingDate);
}
else
{
foreach (var flight in flightRepo.GetAll())
{
Debug.WriteLine(flight.Description);
}
ViewBag.flights = flightRepo.Find(flight => flight.DepartureAirport.Id == departureAirport.Id &&
flight.ArrivalAirport.Id == arrivalAirport.Id);
}
}
ViewBag.previousResearch = search;
return(View("FlightDetails"));
}
FlightSearch ReverseFlightSearch(FlightSearch flightSearch)
{
//create new search parameters in memory that references the original parameters (else changing the depatures will change session's values)
FlightSearch flightSearchReversed = FlightSearchDAO.Copy(flightSearch);
//flip departure and arrival and run search query
var roundTripEnd = flightSearchReversed.Departure;
var roundTripStart = flightSearchReversed.Destination;
flightSearchReversed.Departure = roundTripStart;
flightSearchReversed.Destination = roundTripEnd;
flightSearchReversed.DepartureTime = flightSearch.ReturnDepartureTime;
return(flightSearchReversed);
}
private bool validateFlightSearch(FlightSearch flightSearch)
{
// string error = "";
if (flightSearch.DepartureDate <= DateTime.Now)
{
// error += "Please select a valid departure date";
return(false);
}
if (flightSearch.ReturnDate <= flightSearch.DepartureDate)
{
// error += "Please select a valid return date";
return(false);
}
// add other validation if necessary
return(true);
}
public ActionResult FlightListWithStops()
{
Session["fid1"] = null;
FlightSearch flightSearch = (FlightSearch)Session["searchParams"];
ViewBag.RoundTrip = flightSearch.IsRoundTrip;
IEnumerable <FlightResult> firstTrips = FlightSearchDAO.GetFlightResultsWithStops(flightSearch).OrderBy(item => item.FlightVM.BasePrice);
Session["firstTrips"] = firstTrips;
if (firstTrips.Count() == 0)
{
TempData["errorM"] = "Could not find any connecting trips to " + flightSearch.Destination + ", Sorry.";
return(RedirectToAction("Index"));
}
return(View(firstTrips));
}
private void Get_flight_without_date()
{
var flightInfo = new FlightSearch()
{
DepartureAirport = this._flight.DepartureAirport.Name,
ArrivalAirport = this._flight.ArrivalAirport.Name,
};
ViewResult result = this._controller.GetFlights(flightInfo) as ViewResult;
var flights = result.ViewBag.flights as IList;
// Assert
Assert.IsNotNull(result);
Assert.IsNotEmpty(flights);
Assert.AreEqual("FlightDetails", result.ViewName);
}
int GetPages(FlightSearch flightSearch)
{
flightResults = GetFlightList(flightSearch);
int pages;
int flights = flightResults.Count();
int pagesM = flights % numFlightsPerPage;
if (pagesM > 0)
{
pages = (flights / numFlightsPerPage) + 1;
}
else
{
pages = flights / numFlightsPerPage;
}
return(pages);
}
public void GetFlightsReturnsIEnumerableFlightViewModelObject()
{
// Arrange
var flightRepository = new FlightRepository(flightServiceMock.Object, mapper);
var flightController = new FlightController(flightRepository);
var flightSearch = new FlightSearch()
{
FromAirport = "SEA",
ToAirport = "LAX"
};
// Act
var flights = flightController.Post(flightSearch);
// Assert
Assert.IsInstanceOfType(flights, typeof(IEnumerable <FlightViewModel>));
}
public void GetFlightsReturnsMulitpleFlightRecords()
{
// Arrange
var flightRepository = new FlightRepository(flightServiceMock.Object, mapper);
var flightController = new FlightController(flightRepository);
var flightSearch = new FlightSearch()
{
FromAirport = "SEA",
ToAirport = "LAX"
};
// Act
var flights = flightController.Post(flightSearch);
// Assert
Assert.AreEqual(2, flights.Count());
}
private List <OriginDestination> CreateDestinations(FlightSearch search)
{
var destinations = new List <OriginDestination>();
switch (search.TripType)
{
case TripType.OneWay:
destinations.Add(CreateDestination(search.From, search.To, search.Departure));
break;
case TripType.Return:
destinations.Add(CreateDestination(search.From, search.To, search.Departure));
destinations.Add(CreateDestination(search.To, search.From, search.Return));
break;
}
return(destinations);
}
public void TestMethod1()
{
var searchReq = new FlightSearch()
{
From = "EWR", To = "MIA", DepartDate = null
};
var tbValues1 = new List <FlightResult>()
{
new FlightResult {
Airline = "Continental", From = "EWR", To = "MIA", DepartDate = "2019-01-25", Price = 239
},
};
_mockFlightSearchService.Setup(x => x.GetFlightResult(searchReq)).Returns(tbValues1);
var result = _flightSearchController.Get(searchReq);
Assert.IsNotNull(result);
}
public ActionResult ProcessFlightSearch(FlightSearch flightSearch)
{
if (ModelState.IsValid)
{
// for now we are going to pretend it is a package search
// this call will prep the search
FlightServiceClient flightServiceClient = new FlightServiceClient();
var flightSearchResult = flightServiceClient.StartSearch(flightSearch);
// save this into session
SessionService sessionService = new SessionService();
sessionService.SetItem(SessionEnum.FlightSearch, flightSearchResult.FlightSearchId.ToString(), flightSearchResult);
// this will change depending on the search type
return Redirect("search/package-flight-wait/?id=" + flightSearchResult.FlightSearchId);
}
else
{
return View("flightSearch");
}
}
