public void UpdatePassengers(string passengerList)
{
PassengerTextReader pt = new PassengerTextReader();
List <PassengerData> lstPassengerData = pt.CreatePassengers(passengerList);
if (lstPassengerData != null)
{
using (var dbContext = new MyDealEntities1())
{
//Passengers not there in the db
var missingPassengers = lstPassengerData.Where(x => !dbContext.Passengers.Any(z => z.Name == x.Name)).ToList();
foreach (PassengerData pData in missingPassengers)
{
//add passenger record
Passenger passenger = new Passenger();
passenger.Name = pData.Name;
dbContext.Passengers.Add(passenger);
dbContext.SaveChanges();
//add passenger details
PassengerDetail pDetails = new PassengerDetail();
pDetails.PassengerId = passenger.Id;
pDetails.RecordLocator = pData.BookingId;
dbContext.PassengerDetails.Add(pDetails);
dbContext.SaveChanges();
}
}
}
}
