public ActionResult InsertBasic(string Stops, string TripTypeName, string PassengerName, string PassengerLastName, string PassengerEmail)
{
_airlinesRepository = new AirlinesRepository();
_airportsRepository = new AirportsRepository();
_tagsRepository = new TagsRepository();
_passengerRepository = new PassengerRepository();
_itineraryPingersRepository = new ItineraryPingersRepository();
new UserTagsRepository();
_usersRepository = new UsersRepository();
_monitoredFlightsRepository = new MonitoredFlightsRepository();
_itinerarysRepository = new ItinerarysRepository();
_flightsRepository = new FlightsRepository();
new GatewayAirlineRepository();
#region Create Itinerary
var model = new BasicItineraryModel
{
//ConnxysTagId = ConnxysTagId,
DepartureTime = _listF.First().DepartureDateTime,
ArrivalTime = _listF.Last().ArrivalDateTime,
DepartureName = _airportsRepository.Get(_listF.First().DepartureLocation).AirportDesignationLetters,
ArrivalName = _airportsRepository.Get(_listF.Last().ArrivalLocation).AirportDesignationLetters,
Stops = Convert.ToInt32(Stops),
TripTypeName = TripTypeName,
DepartDateTimeUTC = _listIti.First().DepartDateTimeUTC,
ArrivalDateTimeUTC = _listIti.Last().ArrivalDateTimeUTC
};
object jsonData;
//Get Passenger Information
var passenger = _passengerRepository.Get(PassengerEmail);
passenger.PassengerName = PassengerName;
passenger.PassengerLastName = PassengerLastName;
_passengerRepository.Update(passenger);
var itinerary = new Itinerary
{
//UserID = userInfo.userID,
UserID = 0,
Stops = model.Stops,
DepartDateTime = model.DepartureTime,
ArrivalDateTime = model.ArrivalTime,
AirlineReservationID = model.AirlineReservationId,
RetStops = model.RetStops,
TripType = (short?)int.Parse(model.TripTypeName),
From = model.DepartureName,
To = model.ArrivalName,
CreationDate = DateTime.UtcNow,
Type = "Real Flight",
PassengerID = passenger != null ? passenger.PassengerID : 0,
DepartDateTimeUTC = model.DepartDateTimeUTC,
ArrivalDateTimeUTC = model.ArrivalDateTimeUTC
};
try
{
//insert the new itinerary
_itinerarysRepository.Add(itinerary);
var itineraryId = itinerary.ItineraryID;
if (itineraryId > 0)
{
var connxysWcfRestService = new ConnxysWCFRestService();
var flightsList = new StringBuilder();
var currentFlight = 0L;
var flightInd = 0;
//insert all the flights
foreach (var flightItem in _listF)
{
flightItem.ItineraryID = itineraryId;
_flightsRepository.Add(flightItem);
if (flightInd == (_listF.Count - 1))
{
flightsList.Append(flightItem.FlightID);
}
else
{
flightsList.Append(flightItem.FlightID).Append("-");
}
if (flightInd == 0)
{
currentFlight = flightItem.FlightID;
}
var monitoredFlights = new MonitoredFlights();
{
monitoredFlights.FlightId = flightItem.FlightID;
monitoredFlights.FlightNumber = flightItem.FlightNumber;
monitoredFlights.StartDate = Convert.ToDateTime(flightItem.DepartureDateTime);
monitoredFlights.EndDate = Convert.ToDateTime(flightItem.ArrivalDateTime);
monitoredFlights.DepartureLocation = flightItem.DepartureLocation;
monitoredFlights.ArrivalLocation = flightItem.ArrivalLocation;
monitoredFlights.Status = 0;
var airline = _airlinesRepository.Get(flightItem.AirlineID);
monitoredFlights.AirlineDesignator = airline.AirlineDesignator;
monitoredFlights.AirlineName = airline.AirlineName;
}
//Insert monitoredflight in the database
_monitoredFlightsRepository.Add(monitoredFlights);
// Increase Flight index
flightInd++;
}
//insert all the bags
foreach (var bagItem in _listB)
{
var baggageInfo = new BaggageInfo {
BagIATANumber = bagItem.BagIATANumber,
ItineraryId = itineraryId,
PingerId = bagItem.ConnxysTagID,
PassengerEmail = passenger.PassengerEmail,
PassengerLastName = passenger.PassengerLastName,
PassengerName = passenger.PassengerName
};
connxysWcfRestService.UpdateBaggageInfo(baggageInfo);
var itineraryPinger = new ItineraryPingers {
ItineraryID = itinerary.ItineraryID,
ConnxysTagID = bagItem.ConnxysTagID
};
_itineraryPingersRepository.Add(itineraryPinger);
}
_listB = new List <BagTagDesignation>();
var creationDate = DateTime.Now.ToUniversalTime();
_storeProcedureRepository = new StoreProcedureRepository();
_storeProcedureRepository.CreateOutgoingMessage(itinerary.ItineraryID, null, null, null, null, Convert.ToInt64(model.TagId), "Manually", creationDate, false);
//Create notification message to sent a message to the passenger abput the itinerary creation
var notification = new NotificationMessage
{
Title = "Itinerary Information",
Message = string.Format
("Hello {0}! We’re excited to have you fly with us on flight #: {1} to {2}. We’ll notify you when your bag is checked in, when it’s been loaded aboard your flight, and where you can reclaim it in {3}. Enjoy your flight with us!", passenger.PassengerName, _listF[0].FlightNumber.ToString(), model.ArrivalName, model.ArrivalName),
TokenId = passenger.TokenId
};
foreach (var fl in _listF)
{
var airlineDesignator = _airlinesRepository.Get(fl.AirlineID);
var callUpdateFlight = new ConnxysWCFRestService();
if (fl.DepartureDateTime == null)
{
continue;
}
if (fl.ArrivalDateTime != null)
{
callUpdateFlight.UpdateSimpleFlight(
fl.FlightID.ToString(CultureInfo.InvariantCulture),
airlineDesignator.AirlineDesignator,
fl.FlightNumber.ToString(CultureInfo.InvariantCulture),
fl.DepartureDateTime.Value.ToString(CultureInfo.InvariantCulture),
fl.ArrivalDateTime.Value.ToString(CultureInfo.InvariantCulture));
}
}
_listF = new List <Flights>();
jsonData = new {
status = "Ok",
itineraryId = itinerary.ItineraryID
};
//Send push notification about itinerary creation to the passenger
connxysWcfRestService.SendPushNotification(notification);
}
else
{
//throw error the itinerary can not be created
_listF = new List <Flights>();
PopulateList();
jsonData = new
{
status = "Failed",
message = "Error: The itinerary was not added."
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
//throw error the itinerary can not be created
_listF = new List <Flights>();
jsonData = new
{
status = "Failed",
message = "Error: The itinerary was not added."
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
#endregion
}
public ActionResult FlightValidation(string AirlineName, string FlightNumber, string DepartureName, string ArrivalName, string DepartureTime, string ArrivalTime, string Stops, string TripTypeName, string PassengerName, string PassengerLastName, string PassengerEmail)
{
var flightService = new ConnxysWCFRestService();
var fsm = new FlightStatusMessages();
string jsonData;
GoogleTimeZone timezone = new GoogleTimeZone();
fsm.isValid = false;
fsm.messages = new Message();
_airlinesRepository = new AirlinesRepository();
_tagsRepository = new TagsRepository();
_airportsRepository = new AirportsRepository();
if (!AirlineName.Equals("") && !FlightNumber.Equals("") && !DepartureName.Equals("") && !ArrivalName.Equals("") &&
!DepartureTime.Equals("") && !ArrivalTime.Equals("") && !Stops.Equals("") && !TripTypeName.Equals(""))
{
#region Complete Info
var model = new BasicItineraryModel
{
AirlineName = AirlineName,
FlightNumber = Convert.ToInt32(FlightNumber),
DepartureName = DepartureName,
ArrivalName = ArrivalName,
DepartureTime = Convert.ToDateTime(DepartureTime),
ArrivalTime = Convert.ToDateTime(ArrivalTime),
Stops = Convert.ToInt32(Stops),
TripTypeName = TripTypeName,
PassengerName = PassengerName,
PassengerLastName = PassengerLastName,
PassengerEmail = PassengerEmail
};
//Get Airport Information: Departure and Arrival airports
Airports DepartureAirport = new Airports();
DepartureAirport = _airportsRepository.GetAirportbyName(DepartureName);
Airports ArrivalAirport = new Airports();
ArrivalAirport = _airportsRepository.GetAirportbyName(ArrivalName);
//Get UTC of Departure Airport
Double UTCDepartureAir = timezone.GetLocalDateTime(DepartureAirport.Latitude, DepartureAirport.Longitude, DateTime.UtcNow);
//Get UTC of Arrival Airport
Double UTCArrivalAir = timezone.GetLocalDateTime(ArrivalAirport.Latitude, ArrivalAirport.Longitude, DateTime.UtcNow);
//Get the difference between UTC and local time to Departure and Arrival airport
model.DepartDateTimeUTC = model.DepartureTime.Value.AddHours(UTCDepartureAir);
model.ArrivalDateTimeUTC = model.ArrivalTime.Value.AddHours(UTCArrivalAir);
var tempAirline = _airlinesRepository.GetAirlinebyName(model.AirlineName);
var result = flightService.GetInfoFlightStatus(model.FlightNumber, tempAirline.AirlineDesignator, Convert.ToDateTime(model.DepartDateTimeUTC));
var listResult = result.flightStatuses.ToList();
var totalFlightStatus = listResult.Count;
//Time validation validate the hour and minutes selected by the user
if (model.DepartureTime.Value >= model.ArrivalTime.Value)
{
fsm.messages.mainMessage = "Arrival Time must be greater than Departure Time";
jsonData = new JavaScriptSerializer().Serialize(fsm);
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
var utcNow = DateTime.UtcNow;
if (model.DepartureTime.Value < utcNow || model.ArrivalTime.Value < utcNow)
{
fsm.messages.mainMessage = "Departure Time and Arrival Time must be greater or equal than Current UTC time";
jsonData = new JavaScriptSerializer().Serialize(fsm);
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
if (totalFlightStatus > 0)
{
/* If is a real flight */
foreach (var item in listResult)
{
fsm.messages = new Message();
var matchesElements = true;
var flightStatus = item;
var serviceDepartureDate = flightStatus.departureDate.dateUtc.ToUniversalTime(); //DateTimeOffset.Parse(flightStatus.departureDate.dateUtc).UtcDateTime;
var serviceArrivalDate = flightStatus.arrivalDate.dateUtc.ToUniversalTime(); //DateTimeOffset.Parse().UtcDateTime;
#region Departure and Arrival Airports match with real flight
if (model.DepartureName == flightStatus.departureAirportFsCode && model.ArrivalName == flightStatus.arrivalAirportFsCode)
{
if (serviceDepartureDate.CompareTo(model.DepartDateTimeUTC) != 0)
{
fsm.messages.depDateMessage = "The Departure Date doesn't match with real flight.";
matchesElements = false;
}
if (serviceArrivalDate.CompareTo(model.ArrivalDateTimeUTC) != 0)
{
fsm.messages.arrDateMessage = "The Arrival Date doesn't match with real flight.";
matchesElements = false;
}
if (matchesElements)
{
fsm.isValid = true;
}
break;
}
#endregion
#region Departure Airport match with real flight
if (model.DepartureName == flightStatus.departureAirportFsCode)
{
if (model.ArrivalName != flightStatus.arrivalAirportFsCode)
{
fsm.messages.arrivalMessage = "The Arrival doesn't match with real flight.";
}
if (serviceDepartureDate.CompareTo(model.DepartDateTimeUTC) != 0)
{
fsm.messages.departureMessage = "The Departure Date doesn't match with real flight.";
}
if (serviceArrivalDate.CompareTo(model.ArrivalDateTimeUTC) != 0)
{
fsm.messages.arrDateMessage = "The Arrival Date doesn't match with real flight.";
}
break;
}
#endregion
#region Arrival Airport match with real flight
if (model.ArrivalName == flightStatus.arrivalAirportFsCode)
{
if (model.DepartureName != flightStatus.departureAirportFsCode)
{
fsm.messages.departureMessage = "The Departure doesn't match with real flight.";
}
if (serviceDepartureDate.CompareTo(model.DepartDateTimeUTC) != 0)
{
fsm.messages.depDateMessage = "The Departure Date doesn't match with real flight.";
}
if (serviceArrivalDate.CompareTo(model.ArrivalDateTimeUTC) != 0)
{
fsm.messages.arrDateMessage = "The Arrival Date doesn't match with real flight.";
}
break;
}
#endregion
#region Departure and Arrival Airports don't match with real flight
if (model.DepartureName == flightStatus.departureAirportFsCode || model.ArrivalName == flightStatus.arrivalAirportFsCode)
{
continue;
}
fsm.messages.departureMessage = "The Departure doesn't match with real flight.";
fsm.messages.arrivalMessage = "The Arrival doesn't match with real flight.";
if (serviceDepartureDate.CompareTo(model.DepartDateTimeUTC) != 0)
{
fsm.messages.depDateMessage = "The Departure Date doesn't match with real flight.";
}
if (serviceArrivalDate.CompareTo(model.ArrivalDateTimeUTC) != 0)
{
fsm.messages.arrDateMessage = "The Arrival Date doesn't match with real flight.";
}
#endregion
}
}
else
{
/* If is not a real flight */
fsm.isValid = true;
}
if (fsm.isValid)
{
// Insert the flight into flight's list
InsertFlightIntoList(model);
}
else
{
fsm.messages.mainMessage = "Error: Flight number " + model.FlightNumber + " doesn't match the Flight Stats information. Please edit the information below.";
}
#endregion
}
else
{
fsm.messages.mainMessage = "Information required: Please complete all the flight information fields.";
}
jsonData = new JavaScriptSerializer().Serialize(fsm);
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
