public void UpdateAir_AirlineVendorLocators(Galileo.PnrService.DisplayRetrievePNR result, Int64 AgentId, string RecordLocator)
{
PNRInfoProvider pnrInfoProvider = new PNRInfoProvider();
bool IsChanged = false;
var Pnrs = entity.PNRs.Where(x => x.AgentId == AgentId && x.GDSRefrenceNumber == RecordLocator);
foreach (PNRs pnr in Pnrs)
{
foreach (var vndRec in result.VendorRecordLocatorList)
{
var Air_AirlineVendorLocators = entity.Air_AirlineVendorLocators.Where(x => x.PNRId == pnr.PNRId &&
x.AirlineCode == vndRec.Vendor &&
x.VendorLocatorNo == vndRec.RecordLocator);
if (Air_AirlineVendorLocators.FirstOrDefault() == null)
{
var obj = new Air_AirlineVendorLocators
{
PNRId = pnr.PNRId,
AirlineCode = vndRec.Vendor,
VendorLocatorNo = vndRec.RecordLocator,
VendorRemark = null,
ReceivedOnDate = vndRec.DtStamp,
ReceivedTime = TimeSpan.Parse(ATLTravelPortal.Helpers.TimeFormat.GetFormattedTime(vndRec.TmStamp))
};
entity.AddToAir_AirlineVendorLocators(obj);
IsChanged = true;
}
}
}
if (IsChanged)
{
entity.SaveChanges();
}
}
public void SaveAir_AirlineVendorLocators(Int64 PNRId, string AirlineCode, string VendorLocator, string VendorRemarks, DateTime ReceivedOnDate, string ReceivedTime)
{
var obj = new Air_AirlineVendorLocators
{
PNRId = PNRId,
AirlineCode = AirlineCode,
VendorLocatorNo = VendorLocator,
VendorRemark = VendorRemarks,
ReceivedOnDate = ReceivedOnDate,
ReceivedTime = TimeSpan.Parse(ATLTravelPortal.Helpers.TimeFormat.GetFormattedTime(ReceivedTime))
};
entity.AddToAir_AirlineVendorLocators(obj);
entity.SaveChanges();
}
