/// <summary>
/// Search in the baggage TTY messages table the bag tag
/// </summary>
/// <param name="bagTag"></param>
/// <returns>OSUSR_UUK_BSM[]</returns>
private OSUSR_UUK_FLT_INFO SearchFlightInfo(String airlineFlightNumber, Nullable <System.DateTime> flightDate, String flightOrigin, String flightDestination)
{
String airline = null;
Int32 flightNumber;
BaggageEntities db = new BaggageEntities();
airlineFlightNumber = CommonFunctions.FormatFlightNumber(airlineFlightNumber);
airline = airlineFlightNumber.Substring(0, 2);
flightNumber = Convert.ToInt32(airlineFlightNumber.Substring(2, 4));
if (flightDate == null)
{
throw new EngineProcessingException("Flight date invalid");
}
var bagQuery = from s in db.OSUSR_UUK_FLT_INFO
select s;
var result = bagQuery.Where(s => s.OPERATOR == airline &&
s.FLT_NR == flightNumber &&
s.FROM_IATA == flightOrigin &&
s.TO_IATA == flightDestination &&
DbFunctions.TruncateTime(s.STD) == flightDate).FirstOrDefault <OSUSR_UUK_FLT_INFO>();
return(result);
}
/// <summary>
/// Last baggage integraty table
/// </summary>
/// <param name="bagInteg"></param>
/// <returns>OSUSR_UUK_BAGINTEG</returns>
private OSUSR_UUK_BAGINTEG LastBaggageIntegraty(OSUSR_UUK_BAGINTEG bagInteg)
{
BaggageEntities db = new BaggageEntities();
var bagQuery = from s in db.OSUSR_UUK_BAGINTEG
where s.NUMBER == bagInteg.NUMBER
select s;
var results = bagQuery.OrderByDescending(s => s.TIMESTAMP)
.ToList <OSUSR_UUK_BAGINTEG>();
OSUSR_UUK_BAGINTEG lastBagInteg = results.FirstOrDefault();
if (results != null && results.Count > 1)
{
foreach (OSUSR_UUK_BAGINTEG aux in results)
{
if (aux != lastBagInteg)
{
lastBagInteg = MergeBagIntegrity(lastBagInteg, aux);
db.OSUSR_UUK_BAGINTEG.Remove(aux);
}
}
try
{
db.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
return(lastBagInteg);
}
/// <summary>
/// Constructor for the Baggage TTY parser with TTY parsing logic
/// </summary>
public TTYMessageFormatter(TTYCollection ttyCollection, BaggageEntities db, String hub)
{
this.ttyCollection = ttyCollection;
this.parserBag = new BaggageMessageParsing(ttyCollection);
this.parserPTM = new PTMMessageParsing(ttyCollection, hub);
this.db = db;
}
/// <summary>
/// Search H2H information to be updated
/// </summary>
/// <param name="airlineFlightNumber"></param>
/// <param name="flightDate"></param>
/// <param name="origin"></param>
/// <returns></returns>
private OSUSR_UUK_H2H SearchH2HInformation(String iAirlineFlightNumber, Nullable <System.DateTime> iFlightDate, String iOrigin,
String fAirlineFlightNumber, Nullable <System.DateTime> fFlightDate, String fOrigin)
{
if (fAirlineFlightNumber == null && iAirlineFlightNumber == null)
{
throw new EngineProcessingException("Flight number invalid search");
}
if (fAirlineFlightNumber != null && fAirlineFlightNumber.Length != 6 ||
iAirlineFlightNumber != null && iAirlineFlightNumber.Length != 6)
{
throw new EngineProcessingException("Flight number invalid");
}
if (fFlightDate == null && iFlightDate == null)
{
throw new EngineProcessingException("Flight date invalid search");
}
BaggageEntities db = new BaggageEntities();
var h2hQuery = from s in db.OSUSR_UUK_H2H
select s;
var result = h2hQuery.Where(s => s.IFLTNR == iAirlineFlightNumber &&
DbFunctions.TruncateTime(s.IDATE) == DbFunctions.TruncateTime(iFlightDate) &&
s.IORIGIN == iOrigin &&
s.OFLTNR == fAirlineFlightNumber &&
DbFunctions.TruncateTime(s.ODATE) == DbFunctions.TruncateTime(fFlightDate))
.OrderByDescending(x => x.ID)
.FirstOrDefault <OSUSR_UUK_H2H>();
return(result);
}
/// <summary>
/// Search in the baggage integraty table the bag tag
/// </summary>
/// <param name="bagTag"></param>
/// <returns>OSUSR_UUK_BAGINTEG</returns>
private OSUSR_UUK_H2H SearchH2HyByFlightPair(String iAirlineFlightNumber, Nullable <System.DateTime> iFlightDate, String iOrigin,
String fAirlineFlightNumber, Nullable <System.DateTime> fFlightDate, String fOrigin)
{
if (fAirlineFlightNumber == null && iAirlineFlightNumber == null)
{
throw new EngineProcessingException("Flight number invalid search");
}
if (fAirlineFlightNumber != null && fAirlineFlightNumber.Length != 6 ||
iAirlineFlightNumber != null && iAirlineFlightNumber.Length != 6)
{
throw new EngineProcessingException("Flight number invalid");
}
if (fFlightDate == null && iFlightDate == null)
{
throw new EngineProcessingException("Flight date invalid search");
}
BaggageEntities db = new BaggageEntities();
var h2hQuery = from s in db.OSUSR_UUK_H2H
select s;
var results = h2hQuery.Where(s => s.IFLTNR == iAirlineFlightNumber &&
DbFunctions.TruncateTime(s.IDATE) == DbFunctions.TruncateTime(iFlightDate) &&
s.IORIGIN == iOrigin &&
s.OFLTNR == fAirlineFlightNumber &&
DbFunctions.TruncateTime(s.ODATE) == DbFunctions.TruncateTime(fFlightDate))
.OrderByDescending(x => x.ID)
.ToList <OSUSR_UUK_H2H>();
OSUSR_UUK_H2H result = results.FirstOrDefault();
if (results != null && results.Count > 1)
{
foreach (OSUSR_UUK_H2H h2h in results)
{
if (result != h2h)
{
db.OSUSR_UUK_H2H.Remove(h2h);
}
}
try
{
db.SaveChanges();
}
catch (Exception e)
{
throw e;
}
}
return(result);
}
/// <summary>
/// Search taxi times for flight
/// </summary>
/// <returns></returns>
private List <OSUSR_UUK_TAXITIMES> SearchTaxiTimes()
{
BaggageEntities db = new BaggageEntities();
var taxiTimes = from s in db.OSUSR_UUK_TAXITIMES
select s;
var results = taxiTimes.ToList <OSUSR_UUK_TAXITIMES>();
return(results);
}
/// <summary>
/// Search reference times per stand and gate
/// </summary>
/// <returns></returns>
private List <OSUSR_UUK_PTMREFS2G> SearchRefStandGateTimes()
{
BaggageEntities db = new BaggageEntities();
var refSTandGateTimes = from s in db.OSUSR_UUK_PTMREFS2G
select s;
var results = refSTandGateTimes.ToList <OSUSR_UUK_PTMREFS2G>();
return(results);
}
/// <summary>
/// Search security times
/// </summary>
/// <returns></returns>
private List <OSUSR_UUK_PTM_REF_SEC_TIME> SearchSecTimes()
{
BaggageEntities db = new BaggageEntities();
var secTimes = from s in db.OSUSR_UUK_PTM_REF_SEC_TIME
select s;
var results = secTimes.ToList <OSUSR_UUK_PTM_REF_SEC_TIME>();
return(results);
}
/// <summary>
/// Obtain flight baggage times
/// </summary>
/// <returns></returns>
private List <OSUSR_UUK_BAGTIMESREFERENCE> SearchBagTimesReference()
{
BaggageEntities db = new BaggageEntities();
var bagsTimesReference = from s in db.OSUSR_UUK_BAGTIMESREFERENCE
select s;
var results = bagsTimesReference.ToList <OSUSR_UUK_BAGTIMESREFERENCE>();
return(results);
}
/// <summary>
/// Obtain equipement type
/// </summary>
/// <returns></returns>
private List <OSUSR_UUK_EQUIPTYPE> SearchEquipementsTypes()
{
BaggageEntities db = new BaggageEntities();
var equipTypes = from s in db.OSUSR_UUK_EQUIPTYPE
select s;
var results = equipTypes.ToList <OSUSR_UUK_EQUIPTYPE>();
return(results);
}
/// <summary>
/// Search flight information by primary key
/// </summary>
/// <param name="bagTag"></param>
/// <returns>OSUSR_UUK_BSM[]</returns>
private OSUSR_UUK_FLT_INFO SearchFlightInfoByPK(int flightId)
{
BaggageEntities db = new BaggageEntities();
var bagQuery = from s in db.OSUSR_UUK_FLT_INFO
select s;
var result = bagQuery.Where(s => s.ID == flightId).FirstOrDefault <OSUSR_UUK_FLT_INFO>();
return(result);
}
/// <summary>
/// Obtain aircraft registration
/// </summary>
/// <returns></returns>
private List <OSUSR_UUK_REGISTRATIONS> SearchRegistration()
{
BaggageEntities db = new BaggageEntities();
var registration = from s in db.OSUSR_UUK_REGISTRATIONS
select s;
var results = registration.ToList <OSUSR_UUK_REGISTRATIONS>();
return(results);
}
/// <summary>
/// Search H2H information to be updated
/// </summary>
/// <param name="airlineFlightNumber"></param>
/// <param name="flightDate"></param>
/// <param name="origin"></param>
/// <returns></returns>
private List <OSUSR_UUK_PTM_H2H> SearchPTMH2HInformation(String iAirlineFlightNumber, Nullable <System.DateTime> iFlightDate, String iOrigin)
{
BaggageEntities db = new BaggageEntities();
var h2hQuery = from s in db.OSUSR_UUK_PTM_H2H
select s;
var result = h2hQuery.Where(s => s.IFLTNR == iAirlineFlightNumber &&
DbFunctions.TruncateTime(s.IDATE) == DbFunctions.TruncateTime(iFlightDate) &&
s.IORIGIN == iOrigin).ToList <OSUSR_UUK_PTM_H2H>();
return(result);
}
/// <summary>
/// Search in the baggage integraty table the bag tag with timestamp higher that specified
/// </summary>
/// <param name="bagTag"></param>
/// <returns>List<OSUSR_UUK_BAGMSGS></returns>
private List <OSUSR_UUK_BAGMSGS> SearchBaggageMsgsByBagTagandTimestamp(OSUSR_UUK_BAGMSGS bagTag)
{
BaggageEntities db = new BaggageEntities();
var bagQuery = from s in db.OSUSR_UUK_BAGMSGS
select s;
var results = bagQuery.Where(s => s.NBAGTAG == bagTag.NBAGTAG &&
s.TIMESTAMP > bagTag.TIMESTAMP)
.OrderBy(s => s.TIMESTAMP)
.ToList <OSUSR_UUK_BAGMSGS>();
return(results);
}
/// <summary>
/// Search in the baggage integraty table the bag tag
/// </summary>
/// <param name="bagTag"></param>
/// <returns>OSUSR_UUK_BAGINTEG</returns>
public OSUSR_UUK_BAGINTEG SearchBaggageIntegratyByBagIdentifier(String bagTag)
{
BaggageEntities db = new BaggageEntities();
var bagQuery = from s in db.OSUSR_UUK_BAGINTEG
where s.NUMBER == bagTag
select s;
var results = bagQuery.OrderByDescending(s => s.TIMESTAMP)
.ToList <OSUSR_UUK_BAGINTEG>();
OSUSR_UUK_BAGINTEG result = results.FirstOrDefault();
return(result);
}
/// <summary>
/// Search for last PTM date for the flight
/// </summary>
/// <param name="ptm"></param>
/// <returns>System.Nullable<DateTime></returns>
public System.Nullable <DateTime> SearchLastPTMForFlight(String iFLTNR, System.Nullable <DateTime> iDATE, String iORIGIN,
String oFLTNR, System.Nullable <DateTime> oDATE, String oDEST)
{
BaggageEntities db = new BaggageEntities();
var maxPTMDate = (from s in db.OSUSR_UUK_PAXMSGS
where s.IFLTNR == iFLTNR &&
s.IDATE == iDATE &&
s.IORIGIN == iORIGIN &&
s.OFLTNR == oFLTNR &&
s.ODATE == oDATE &&
s.ODEST == oDEST
select s.TIMESTAMP).Max();
return(maxPTMDate);
}
/// <summary>
/// Search in the baggage integraty table the bag tag with timestamp higher that specified
/// </summary>
/// <param name="bagTag"></param>
/// <returns>List<OSUSR_UUK_BAGMSGS></returns>
private List <OSUSR_UUK_BAGMSGS> SearchBaggageMsgsByFlightandSeatNumber(OSUSR_UUK_BAGMSGS bagTag)
{
BaggageEntities db = new BaggageEntities();
var bagQuery = from s in db.OSUSR_UUK_BAGMSGS
select s;
var results = bagQuery.Where(s => s.FFLTNR == bagTag.FFLTNR &&
s.FDATE == bagTag.FDATE &&
s.FDEST == bagTag.FDEST &&
s.IFLTNR == bagTag.IFLTNR &&
s.IDATE == bagTag.IDATE &&
s.IORIGIN == bagTag.IORIGIN &&
s.SSEAT == bagTag.SSEAT &&
s.NBAGTAG != bagTag.NBAGTAG &&
s.TIMESTAMP == bagQuery.Where(k => k.NBAGTAG == s.NBAGTAG &&
k.SMI == BagTMRulesActions.SMI_BSM)
.Max(x => x.TIMESTAMP))
.OrderBy(s => s.TIMESTAMP)
.ToList <OSUSR_UUK_BAGMSGS>();
return(results);
}
private void refreshList()
{
refreshLimit = DateTime.Now.AddMinutes(5);
BaggageEntities dbSV = new BaggageEntities();
var sorterVolumeQuery = (from bi in dbSV.OSUSR_UUK_H2H
where bi.IETA != null && bi.IETA >= DateTime.Now
// here I choose each field I want to group by
group bi by new { bi.IETA, bi.IATA } into g
select new
{
DATEINIT = (g.Key.IATA != null && ((DateTime)g.Key.IATA).Year > 1900) ?
(DateTime)g.Key.IATA : (DateTime)g.Key.IETA,
Count = g.Sum(x => x.INRBAGS)
}
).ToList();
var sorterVolumePerTime = sorterVolumeQuery
.Select(s => new
{
DATEINIT = s.DATEINIT.AddMinutes(-1 * s.DATEINIT.Minute % 5),
Count = s.Count
});
sorterVolumeCalculate = sorterVolumePerTime
.GroupBy(s => new { s.DATEINIT })
.Select(r => new SorterVolume
{
DATEINIT = r.Key.DATEINIT,
DATEEND = r.Key.DATEINIT.AddMinutes(5),
COUNT = r.Sum(x => (double)x.Count)
}).ToList <SorterVolume>();
BagTMLog.LogDebug("BagTM Engine Update H2H Bag Calculate", sorterVolumeCalculate);
}
/// <summary>
/// Process engine rules
/// </summary>
/// <param name="messageObject"></param>
/// <param name="n"></param>
public void ProcessFLTINFOEngine(Object messageObject, int n)
{
BagTMLog.LogDebug("BagTM Engine FLT INFO", this);
// Only process message if is a baggage message
if (messageObject.GetType() != typeof(OSUSR_UUK_FLT_INFO))
{
throw new EngineProcessingException("Not a FLTINFO message.");
}
OSUSR_UUK_FLT_INFO info = (OSUSR_UUK_FLT_INFO)messageObject;
OSUSR_UUK_FLT_INFO flightInfoF = null;
OSUSR_UUK_FLT_INFO flightInfoI = null;
bool isHub = false;
BaggageEntities db = new BaggageEntities();
var h2hQuery = from s in db.OSUSR_UUK_H2H
select s;
var h2hList = h2hQuery.Where(s => s.IFLTINFOID == info.ID ||
s.OFLTINFOID == info.ID)
.OrderByDescending(x => x.ID)
.ToList <OSUSR_UUK_H2H>();
foreach (OSUSR_UUK_H2H h2h in h2hList)
{
flightInfoF = this.SearchFlightInfoByPK((h2h.OFLTINFOID != null) ? (int)h2h.OFLTINFOID : 0);
flightInfoI = this.SearchFlightInfoByPK((h2h.IFLTINFOID != null) ? (int)h2h.IFLTINFOID : 0);
flightInfoI = (flightInfoI != null) ? flightInfoI : new OSUSR_UUK_FLT_INFO();
isHub = (flightInfoI != null && flightInfoI.FLT_NR != null) ? true : false;
BagTMLog.LogDebug("BagTM Engine Search FlightInfoI", flightInfoI);
BagTMLog.LogDebug("BagTM Engine Search FlightInfoF", flightInfoF);
BagTMLog.LogDebug("BagTM Engine Rules H2H", this);
if (flightInfoF == null || flightInfoF.FLT_NR == null || flightInfoI == null)
{
BagTMLog.LogDebug("No update to H2H since no flight information, please check flight in FLT_INFO table.", this);
}
else
{
this.h2hProcessing.EngineUpdateH2H(flightInfoI, flightInfoF, isHub);
}
}
var ptmH2HQuery = from s in db.OSUSR_UUK_PTM_H2H
select s;
var ptmH2HList = ptmH2HQuery.Where(s => s.IFLTINFOID == info.ID ||
s.OFLTINFOID == info.ID)
.OrderByDescending(x => x.ID)
.ToList <OSUSR_UUK_PTM_H2H>();
foreach (OSUSR_UUK_PTM_H2H ptmH2H in ptmH2HList)
{
flightInfoF = this.SearchFlightInfoByPK((ptmH2H.OFLTINFOID != null) ? (int)ptmH2H.OFLTINFOID : 0);
flightInfoI = this.SearchFlightInfoByPK((ptmH2H.IFLTINFOID != null) ? (int)ptmH2H.IFLTINFOID : 0);
flightInfoI = (flightInfoI != null) ? flightInfoI : new OSUSR_UUK_FLT_INFO();
isHub = (flightInfoI != null && flightInfoI.FLT_NR != null) ? true : false;
BagTMLog.LogDebug("BagTM Engine Search FlightInfoI", flightInfoI);
BagTMLog.LogDebug("BagTM Engine Search FlightInfoF", flightInfoF);
BagTMLog.LogDebug("BagTM Engine Rules H2H", this);
if (flightInfoF == null || flightInfoF.FLT_NR == null || flightInfoI == null)
{
BagTMLog.LogDebug("No update to H2H since no flight information, please check flight in FLT_INFO table.", this);
}
else
{
this.ptmH2HProcessing.EngineUpdatePTMH2H(flightInfoI, (DateTime)this.ptmH2HProcessing.SearchLastPTMForFlight(ptmH2H));
}
}
BagTMLog.LogDebug("BagTM Engine FLT INFO End", this);
}
/// <summary>
/// Update H2H table based on flight information
/// </summary>
public void EngineUpdateH2H(OSUSR_UUK_FLT_INFO flightInfoI, OSUSR_UUK_FLT_INFO flightInfoF, bool isHub)
{
BagTMLog.LogDebug("BagTM Engine Update H2H Start", this);
try
{
BagTMLog.LogDebug("BagTM Engine Update H2H FlightInfoI", flightInfoI);
BagTMLog.LogDebug("BagTM Engine Update H2H FlightInfoF", flightInfoF);
BagTMLog.LogDebug("BagTM Engine Update H2H Hub", this.hub);
BagTMLog.LogDebug("BagTM Engine Update Search H2H", this);
String iFLTNR = null;
System.Nullable <DateTime> iDATE = null;
String iORIGIN = null;
String iDEST = null;
String fFLTNR = null;
System.Nullable <DateTime> fDATE = null;
String fORIGIN = null;
String fDEST = null;
iFLTNR = (flightInfoI != null) ?
CommonFunctions.FormatFlightNumber(flightInfoI.OPERATOR + flightInfoI.FLT_NR) : null;
iDATE = (flightInfoI != null) ? flightInfoI.STD : null;
iORIGIN = (flightInfoI != null) ? flightInfoI.FROM_IATA : null;
iDEST = (flightInfoI != null) ? flightInfoI.TO_IATA : null;
fFLTNR = (flightInfoF != null) ?
CommonFunctions.FormatFlightNumber(flightInfoF.OPERATOR + flightInfoF.FLT_NR) : null;
fDATE = (flightInfoF != null) ? flightInfoF.STD : null;
fORIGIN = (flightInfoF != null) ? flightInfoF.FROM_IATA : null;
fDEST = (flightInfoF != null) ? flightInfoF.TO_IATA : null;
OSUSR_UUK_H2H h2h = this.SearchH2HyByFlightPair(
iFLTNR, iDATE, iORIGIN, fFLTNR, fDATE, fORIGIN);
BagTMLog.LogDebug("BagTM Engine Update H2H List", h2h);
BaggageEntities dbinup = new BaggageEntities();
var bagQuery = from s in dbinup.OSUSR_UUK_BAGINTEG
select s;
var bagList = bagQuery.Where(s => s.IFLTNR == iFLTNR &&
DbFunctions.TruncateTime(s.IDATE) == DbFunctions.TruncateTime(iDATE) &&
s.IORIGIN == iORIGIN &&
(s.IAUT != BagTMRulesActions.PAX_AUT_STATUS_CODE ||
s.IAUT != BagTMRulesActions.BAG_GROUP_AUT_CODE))
.ToList();
BagTMLog.LogDebug("BagTM Engine Update Calculate BagIntegrity Bag Count", bagList);
var bagCalculate = (from bi in bagList
// here I choose each field I want to group by
group bi by new { bi.IFLTNR, bi.IDATE, bi.IORIGIN, bi.FFLTNR, bi.FDATE, bi.FDEST } into g
select new
{
IFLTNR = g.Key.IFLTNR,
IDATE = g.Key.IDATE,
IORIGIN = g.Key.IORIGIN,
OFLTNR = g.Key.FFLTNR,
ODATE = g.Key.FDATE,
ODEST = g.Key.FDEST,
Count = g.Count()
}
).ToList();
BagTMLog.LogDebug("BagTM Engine Update H2H Bag Calculate", bagCalculate);
if (h2h != null)
{
BagTMLog.LogDebug("BagTM Engine Update H2H Flight Process", h2h);
h2h.IDATE = (flightInfoI != null) ? flightInfoI.STD : null;
h2h.IETA = (flightInfoI != null) ? flightInfoI.ETA : null;
h2h.IATA = (flightInfoI != null) ? flightInfoI.ATA : null;
h2h.ISTAND = (flightInfoI != null) ? flightInfoI.TO_STAND : null;
h2h.HULLOPEN = (flightInfoI != null) ? flightInfoI.DOOROPEN : null;
h2h.IFLTINFOID = (flightInfoI != null && flightInfoI.ID != 0) ? (System.Nullable <int>)flightInfoI.ID : null;
h2h.ODATE = (flightInfoF != null) ? flightInfoF.STD : null;
h2h.ETD = (flightInfoF != null) ? flightInfoF.ETD : null;
h2h.ATD = (flightInfoF != null) ? flightInfoF.ATD : null;
h2h.STANDD = (flightInfoF != null) ? flightInfoF.FROM_STAND : null;
h2h.HULLCLOSE = (flightInfoF != null) ? flightInfoF.DOORCLOSED : null;
h2h.OFLTINFOID = (flightInfoF != null && flightInfoF.ID != 0) ? (System.Nullable <int>)flightInfoF.ID : null;
var calcBaggageFlightIF = bagCalculate.Where(s => s.IFLTNR == h2h.IFLTNR &&
s.IDATE == ((h2h.IDATE != null) ? ((DateTime)h2h.IDATE).Date : h2h.IDATE) &&
s.IORIGIN == h2h.IORIGIN &&
s.OFLTNR == h2h.OFLTNR &&
s.ODATE == ((h2h.ODATE != null) ? ((DateTime)h2h.ODATE).Date : h2h.ODATE))
.FirstOrDefault();
var calcBaggageFlightI = bagCalculate.Where(s => s.IFLTNR == h2h.IFLTNR &&
s.IDATE == ((h2h.IDATE != null) ? ((DateTime)h2h.IDATE).Date : h2h.IDATE) &&
s.IFLTNR != null)
.GroupBy(s => new { s.IFLTNR, s.IDATE })
.Select(r => new
{
FLIGHT = r.Key.IFLTNR,
DATE = r.Key.IDATE,
SUMBAGGAGES = r.Sum(x => x.Count)
}).FirstOrDefault();
BagTMLog.LogDebug("BagTM Engine Update H2H Exist", calcBaggageFlightIF);
if (calcBaggageFlightIF != null && calcBaggageFlightIF.Count > 0)
{
// To update inbound NRBAGS count for Hub messages
if (h2h.IFLTNR != null)
{
h2h.INRBAGS = calcBaggageFlightIF.Count;
h2h.OLNRBAGS = 0;
}
else
{
h2h.INRBAGS = 0;
h2h.OLNRBAGS = calcBaggageFlightIF.Count;
}
if (h2h.OFLTNR == null)
{
h2h.OLNRBAGS = 0;
}
BagTMLog.LogInfo("BagTM Engine H2H Update: " + h2h.ID, this);
}
else
{
// To update inbound NRBAGS count for Hub messages
if (isHub)
{
h2h.INRBAGS = 0;
}
else
{
h2h.OLNRBAGS = 0;
}
}
System.Nullable <int> inboundFlightEquip = null;
if (flightInfoI != null && flightInfoI.AC_REGISTRATION != null)
{
OSUSR_UUK_REGISTRATIONS reg = registrationList.Where(x => x.ACREGISTRATION == flightInfoI.AC_REGISTRATION)
.FirstOrDefault <OSUSR_UUK_REGISTRATIONS>();
inboundFlightEquip = (reg != null) ? reg.EQUIPTYPEID : (System.Nullable <int>)Convert.ToInt32(this.defaultEquipment);
}
System.Nullable <int> outboundFlightEquip = null;
if (flightInfoF != null && flightInfoF.AC_REGISTRATION != null)
{
OSUSR_UUK_REGISTRATIONS reg = registrationList.Where(x => x.ACREGISTRATION == flightInfoF.AC_REGISTRATION)
.FirstOrDefault <OSUSR_UUK_REGISTRATIONS>();
outboundFlightEquip = (reg != null) ? reg.EQUIPTYPEID : (System.Nullable <int>)Convert.ToInt32(this.defaultEquipment);
}
Decimal[] timesInbound = this.CalculateTimes(
(inboundFlightEquip != null) ? inboundFlightEquip : (System.Nullable <int>)Convert.ToInt32(this.defaultEquipment),
(flightInfoI != null) ? flightInfoI.TO_STAND : this.defaultStandFrom,
(flightInfoI != null) ? this.baggageTerminalCode : this.defaultGateTo);
Decimal[] timesOutbound = this.CalculateTimes(
(outboundFlightEquip != null) ? outboundFlightEquip : (System.Nullable <int>)Convert.ToInt32(this.defaultEquipment),
(flightInfoF != null) ? this.baggageTerminalCode : this.defaultStandFrom,
(flightInfoF != null) ? flightInfoF.FROM_GATE : this.defaultGateTo);
Double calcETU = 0;
Double calcETL = 0;
// Calculate times and insert if flight exists
if (h2h.IFLTNR != null)
{
h2h.IUNLOAD = (calcBaggageFlightI != null) ? timesInbound[0] * (Decimal)calcBaggageFlightI.SUMBAGGAGES
: 0;
h2h.IINJECT = (calcBaggageFlightI != null) ? timesInbound[1] * (Decimal)calcBaggageFlightI.SUMBAGGAGES
: 0;
h2h.ITAXI = (calcBaggageFlightI != null) ? timesInbound[3] : 0;
// Calculate ETU
calcETU = Convert.ToDouble(h2h.IUNLOAD + h2h.IINJECT + h2h.ITAXI);
calcETU = Math.Max(this.minLoadUnloadTime * 60 + Convert.ToDouble(h2h.IINJECT) + Convert.ToDouble(h2h.ITAXI), calcETU);
calcETU = Math.Min(this.maxLoadUnloadTime * 60 + Convert.ToDouble(h2h.IINJECT) + Convert.ToDouble(h2h.ITAXI), calcETU);
h2h.ETU = (h2h.HULLOPEN != null && h2h.HULLOPEN.Value.Year != 1900) ? h2h.HULLOPEN :
(h2h.IATA != null && h2h.IATA.Value.Year != 1900) ? h2h.IATA :
(h2h.IETA != null && h2h.IETA.Value.Year != 1900) ? h2h.IETA : null;
if (h2h.ETU != null)
{
h2h.ETU = ((DateTime)h2h.ETU).AddSeconds(Math.Min(calcETU, (double)this.maxBaggageTurnaround * 60));
}
}
if (h2h.OFLTNR != null)
{
h2h.OLOAD = (calcBaggageFlightIF != null) ? timesOutbound[2] * (Decimal)calcBaggageFlightIF.Count
: 0;
h2h.OINJECT = (calcBaggageFlightIF != null) ? timesOutbound[1] * (Decimal)calcBaggageFlightIF.Count
: 0;
h2h.OTAXI = (calcBaggageFlightIF != null) ? timesOutbound[3] : 0;
// Calculate ETL
calcETL = Convert.ToDouble(h2h.OLOAD + h2h.OINJECT + h2h.OTAXI);
calcETL = Math.Max(this.minLoadUnloadTime * 60 + Convert.ToDouble(h2h.OINJECT) + Convert.ToDouble(h2h.OTAXI), calcETL);
calcETL = Math.Min(this.maxLoadUnloadTime * 60 + Convert.ToDouble(h2h.OINJECT) + Convert.ToDouble(h2h.OTAXI), calcETL);
h2h.ETL = (h2h.HULLOPEN != null && h2h.HULLOPEN.Value.Year != 1900) ? h2h.HULLOPEN :
(h2h.IATA != null && h2h.IATA.Value.Year != 1900) ? h2h.IATA :
(h2h.IETA != null && h2h.IETA.Value.Year != 1900) ? h2h.IETA : null;
if (h2h.ETL != null)
{
// Calc final ETL time
calcETL = calcETL + this.processSorterProcessingTimes((DateTime)h2h.ETL) * 60;
h2h.ETL = ((DateTime)h2h.ETL).AddSeconds(Math.Min(calcETU + calcETL, 2 * (double)this.maxBaggageTurnaround * 60));
h2h.ETLU = ((DateTime)h2h.ETL).AddSeconds(calcETU + calcETL);
}
}
try
{
// Calculate Hub time
h2h.HUB = (h2h.ETL != null && h2h.ETD != null &&
((DateTime)h2h.ETL).Year > 1900 && ((DateTime)h2h.ETD).Year > 1900) ?
(System.Nullable <int>)((TimeSpan)(h2h.ETD - h2h.ETL)).TotalMinutes : null;
BagTMLog.LogDebug("BagTM Engine Update to ", h2h);
dbinup.OSUSR_UUK_H2H.Attach(h2h);
dbinup.Entry(h2h).State = EntityState.Modified;
BagTMLog.LogInfo("BagTM Engine H2H Update: " + h2h.ID, this);
}
catch (DbEntityValidationException ex)
{
dbinup.OSUSR_UUK_H2H.Remove(h2h);
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new EngineProcessingException(exceptionMessage);
}
catch (Exception e)
{
dbinup.OSUSR_UUK_H2H.Remove(h2h);
throw e;
}
}
else
{
OSUSR_UUK_H2H newH2H = new OSUSR_UUK_H2H();
newH2H.IFLTNR = iFLTNR;
newH2H.IORIGIN = iORIGIN;
newH2H.IDATE = iDATE;
newH2H.IETA = (flightInfoI != null) ? flightInfoI.ETA : null;
newH2H.IATA = (flightInfoI != null) ? flightInfoI.ATA : null;
newH2H.ISTAND = (flightInfoI != null) ? flightInfoI.TO_STAND : null;
newH2H.HULLOPEN = (flightInfoI != null) ? flightInfoI.DOOROPEN : null;
newH2H.IFLTINFOID = (flightInfoI != null && flightInfoI.ID != 0) ? (System.Nullable <int>)flightInfoI.ID : null;
newH2H.ONTOFLIGHT = fFLTNR;
newH2H.OFLTNR = fFLTNR;
newH2H.ODATE = fDATE;
newH2H.ETD = (flightInfoF != null) ? flightInfoF.ETD : null;
newH2H.ATD = (flightInfoF != null) ? flightInfoF.ATD : null;
newH2H.STANDD = (flightInfoF != null) ? flightInfoF.FROM_STAND : null;
newH2H.HULLCLOSE = (flightInfoF != null) ? flightInfoF.DOORCLOSED : null;
newH2H.OFLTINFOID = (flightInfoF != null && flightInfoF.ID != 0) ? (System.Nullable <int>)flightInfoF.ID : null;
// To update inbound NRBAGS count for Hub messages
if (newH2H.IFLTNR != null)
{
newH2H.INRBAGS = 1;
newH2H.OLNRBAGS = 0;
}
else
{
newH2H.INRBAGS = 0;
newH2H.OLNRBAGS = 1;
}
if (newH2H.OFLTNR == null)
{
newH2H.OLNRBAGS = 0;
}
System.Nullable <int> inboundFlightEquip = null;
if (flightInfoI != null && flightInfoI.AC_REGISTRATION != null)
{
OSUSR_UUK_REGISTRATIONS reg = registrationList.Where(x => x.ACREGISTRATION == flightInfoI.AC_REGISTRATION)
.FirstOrDefault <OSUSR_UUK_REGISTRATIONS>();
inboundFlightEquip = (reg != null) ? reg.EQUIPTYPEID : (System.Nullable <int>)Convert.ToInt32(this.defaultEquipment);
}
System.Nullable <int> outboundFlightEquip = null;
if (flightInfoF != null && flightInfoF.AC_REGISTRATION != null)
{
OSUSR_UUK_REGISTRATIONS reg = registrationList.Where(x => x.ACREGISTRATION == flightInfoI.AC_REGISTRATION)
.FirstOrDefault <OSUSR_UUK_REGISTRATIONS>();
outboundFlightEquip = (reg != null) ? reg.EQUIPTYPEID : (System.Nullable <int>)Convert.ToInt32(this.defaultEquipment);
}
Decimal[] timesInbound = this.CalculateTimes(
(inboundFlightEquip != null) ? inboundFlightEquip : (System.Nullable <int>)Convert.ToInt32(this.defaultEquipment),
(flightInfoI != null) ? flightInfoI.TO_STAND : this.defaultStandFrom,
(flightInfoI != null) ? this.baggageTerminalCode : this.defaultGateTo);
Decimal[] timesOutbound = this.CalculateTimes(
(outboundFlightEquip != null) ? outboundFlightEquip : (System.Nullable <int>)Convert.ToInt32(this.defaultEquipment),
(flightInfoF != null) ? this.baggageTerminalCode : this.defaultStandFrom,
(flightInfoF != null) ? flightInfoF.FROM_GATE : this.defaultGateTo);
Double calcETU = 0;
Double calcETL = 0;
// Calculate times and insert if flight exists
if (newH2H.IFLTNR != null)
{
newH2H.IUNLOAD = timesInbound[0];
newH2H.IINJECT = timesInbound[1];
newH2H.ITAXI = timesInbound[3];
// Calculate ETU
calcETU = Convert.ToDouble(newH2H.IUNLOAD + newH2H.IINJECT + newH2H.ITAXI);
calcETU = Math.Max(this.minLoadUnloadTime * 60 + Convert.ToDouble(newH2H.IINJECT) + Convert.ToDouble(newH2H.ITAXI), calcETU);
calcETU = Math.Min(this.maxLoadUnloadTime * 60 + Convert.ToDouble(newH2H.IINJECT) + Convert.ToDouble(newH2H.ITAXI), calcETU);
newH2H.ETU = (newH2H.HULLOPEN != null && newH2H.HULLOPEN.Value.Year != 1900) ? newH2H.HULLOPEN :
(newH2H.IATA != null && newH2H.IATA.Value.Year != 1900) ? newH2H.IATA :
(newH2H.IETA != null && newH2H.IETA.Value.Year != 1900) ? newH2H.IETA : null;
if (newH2H.ETU != null)
{
newH2H.ETU = ((DateTime)newH2H.ETU).AddSeconds(Math.Min(calcETU, (double)this.maxBaggageTurnaround * 60));
}
}
if (newH2H.OFLTNR != null)
{
newH2H.OLOAD = timesOutbound[2];
newH2H.OINJECT = timesOutbound[1];
newH2H.OTAXI = timesOutbound[3];
// Calculate ETL
calcETL = Convert.ToDouble(newH2H.OLOAD + newH2H.OINJECT + newH2H.OTAXI);
calcETL = Math.Max(this.minLoadUnloadTime * 60 + Convert.ToDouble(newH2H.OINJECT) + Convert.ToDouble(newH2H.OTAXI), calcETL);
calcETL = Math.Min(this.maxLoadUnloadTime * 60 + Convert.ToDouble(newH2H.OINJECT) + Convert.ToDouble(newH2H.OTAXI), calcETL);
newH2H.ETL = (newH2H.HULLOPEN != null && newH2H.HULLOPEN.Value.Year != 1900) ? newH2H.HULLOPEN :
(newH2H.IATA != null && newH2H.IATA.Value.Year != 1900) ? newH2H.IATA :
(newH2H.IETA != null && newH2H.IETA.Value.Year != 1900) ? newH2H.IETA : null;
if (newH2H.ETL != null)
{
// Calc final ETL time
calcETL = calcETL + this.processSorterProcessingTimes((DateTime)newH2H.ETL) * 60;
newH2H.ETL = ((DateTime)newH2H.ETL).AddSeconds(Math.Min(calcETU + calcETL, 2 * (double)this.maxBaggageTurnaround * 60));
newH2H.ETLU = ((DateTime)newH2H.ETL).AddSeconds(calcETU + calcETL);
}
}
try
{
// Calculate Hub time
newH2H.HUB = (newH2H.ETL != null && newH2H.ETD != null &&
((DateTime)newH2H.ETL).Year > 1900 && ((DateTime)newH2H.ETD).Year > 1900) ?
(System.Nullable <int>)((TimeSpan)(newH2H.ETD - newH2H.ETL)).TotalMinutes : null;
OSUSR_UUK_H2H h2hExist = this.SearchH2HInformation(
newH2H.IFLTNR, newH2H.IDATE, newH2H.IORIGIN, newH2H.OFLTNR, newH2H.ODATE, "");
if (h2hExist != null && h2hExist.IFLTNR != null)
{
EngineUpdateH2H(flightInfoI, flightInfoF, isHub);
BagTMLog.LogDebug("BagTM Engine Update H2H Already Exist", h2hExist);
return;
}
dbinup.OSUSR_UUK_H2H.Add(newH2H);
BagTMLog.LogInfo("BagTM Engine H2H Create: " + newH2H.ID, this);
BagTMLog.LogDebug("BagTM Engine Update H2H Create", newH2H);
}
catch (DbEntityValidationException ex)
{
dbinup.OSUSR_UUK_H2H.Remove(newH2H);
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new EngineProcessingException(exceptionMessage);
}
catch (Exception e)
{
dbinup.OSUSR_UUK_H2H.Remove(newH2H);
throw e;
}
}
dbinup.SaveChanges();
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new EngineProcessingException(exceptionMessage);
}
BagTMLog.LogDebug("BagTM Engine Update H2H End", this);
}
/// <summary>
/// Update H2H table based on flight information
/// </summary>
public void EngineUpdatePTMH2H(OSUSR_UUK_FLT_INFO flightInfoI, DateTime stampPTM)
{
BagTMLog.LogDebug("BagTM Engine Update PTM H2H Start", this);
int i = 0;
BaggageEntities db = new BaggageEntities();
try
{
BagTMLog.LogDebug("BagTM Engine Update PTM H2H FlightInfoI", flightInfoI);
BagTMLog.LogDebug("BagTM Engine Update PTM H2H Hub", hub);
BagTMLog.LogDebug("BagTM Engine Update Search PTM H2H", this);
String iFLTNR = (flightInfoI != null) ?
CommonFunctions.FormatFlightNumber(flightInfoI.OPERATOR + flightInfoI.FLT_NR) : null;
System.Nullable <DateTime> iDATE = (flightInfoI != null) ? flightInfoI.STD : null;
String iORIGIN = (flightInfoI != null) ? flightInfoI.FROM_IATA : null;
String iDEST = (flightInfoI != null) ? flightInfoI.TO_IATA : null;
System.Nullable <DateTime> stamp = stampPTM;
List <OSUSR_UUK_PTM_H2H> h2hList = this.SearchPTMH2HInformation(
iFLTNR, iDATE, iORIGIN);
List <OSUSR_UUK_PTMREFS2G> refStandGateTimes = this.SearchRefStandGateTimes();
List <OSUSR_UUK_PTM_REF_SEC_TIME> secTimes = this.SearchSecTimes();
BagTMLog.LogDebug("BagTM Engine Update PTM H2H List", h2hList);
var ptmQuery = from s in db.OSUSR_UUK_PAXMSGS
where s.TIMESTAMP == stamp
select s;
var ptmList = ptmQuery.Where(s => s.IFLTNR == iFLTNR &&
s.IDATE == ((DateTime)iDATE).Date &&
s.IORIGIN == iORIGIN &&
s.TIMESTAMP == stamp)
.Select(x => new
{
x.IFLTNR,
x.IDATE,
x.IORIGIN,
x.OFLTNR,
x.ODATE,
x.ODEST,
x.RESERVATIONSTATUS
})
.Distinct()
.ToList();
BagTMLog.LogDebug("BagTM Engine Update Obtain PTM TTY list", ptmList);
OSUSR_UUK_FLT_INFO flightInfoF;
foreach (OSUSR_UUK_PTM_H2H h2h in h2hList)
{
flightInfoF = null;
BagTMLog.LogDebug("BagTM Engine Update PTM H2H Flight Process", h2h);
i++;
var ptmListH2H = ptmList.Where(s => s.IFLTNR == h2h.IFLTNR &&
s.IDATE == h2h.IDATE &&
s.IORIGIN == h2h.IORIGIN &&
s.OFLTNR == h2h.OFLTNR &&
s.ODATE == h2h.ODATE &&
s.ODEST == h2h.ODEST &&
s.RESERVATIONSTATUS == h2h.STATUS)
.ToList();
var h2hExists = ptmListH2H.FirstOrDefault();
BagTMLog.LogDebug("BagTM Engine Update Calculate PTMH2H PAX Count", ptmListH2H);
var PAXCalculate = ptmQuery.Where(s => s.IFLTNR == h2h.IFLTNR &&
s.IDATE == h2h.IDATE &&
s.IORIGIN == h2h.IORIGIN &&
s.OFLTNR == h2h.OFLTNR &&
s.ODATE == h2h.ODATE &&
s.ODEST == h2h.ODEST &&
s.RESERVATIONSTATUS == h2h.STATUS)
.GroupBy(x => new
{
x.IFLTNR,
x.IDATE,
x.IORIGIN,
x.OFLTNR,
x.ODATE,
x.ODEST,
x.RESERVATIONSTATUS
})
.Select(x => new
{
IFLTNR = x.Key.IFLTNR,
IDATE = x.Key.IDATE,
IORIGIN = x.Key.IORIGIN,
OFLTNR = x.Key.OFLTNR,
ODATE = x.Key.ODATE,
ODEST = x.Key.ODEST,
RESERVATIONSTATUS = x.Key.RESERVATIONSTATUS,
SumFIRST = x.Sum(z => z.FIRST),
SumBUSINESS = x.Sum(z => z.BUSINESS),
SumECONOMY = x.Sum(z => z.ECONOMY)
}
).FirstOrDefault();
BagTMLog.LogDebug("BagTM Engine Update H2H Exist", PAXCalculate);
if (h2h.OFLTNR != null && h2h.ODATE != null)
{
flightInfoF = this.SearchFlightInfo(h2h.OFLTNR, h2h.ODATE, hub, h2h.ODEST);
}
else
{
flightInfoF = new OSUSR_UUK_FLT_INFO();
}
BagTMLog.LogDebug("BagTM Engine Search FlightInfoF", flightInfoF);
if (PAXCalculate != null && PAXCalculate.IFLTNR != null)
{
// To update inbound NRBAGS count for Hub messages
h2h.FIRST = PAXCalculate.SumFIRST;
h2h.BUSINESS = PAXCalculate.SumBUSINESS;
h2h.ECONOMY = PAXCalculate.SumECONOMY;
h2h.ETA = (flightInfoI != null && flightInfoI.DOOROPEN != null && flightInfoI.DOOROPEN.Value.Year != 1900) ? flightInfoI.DOOROPEN :
(flightInfoI != null && flightInfoI.ATA != null && flightInfoI.ATA.Value.Year != 1900) ? flightInfoI.ATA :
(flightInfoI != null && flightInfoI.ETA != null && flightInfoI.ETA.Value.Year != 1900) ? flightInfoI.ETA : null;
h2h.GATE = (flightInfoF != null && flightInfoF.FROM_GATE != null) ? flightInfoF.FROM_GATE : null;
h2h.ETD = (flightInfoF != null && flightInfoF.DOORCLOSED != null && flightInfoF.DOORCLOSED.Value.Year != 1900) ? flightInfoF.DOORCLOSED :
(flightInfoF != null && flightInfoF.ATD != null && flightInfoF.ATD.Value.Year != 1900) ? flightInfoF.ATD :
(flightInfoF != null && flightInfoF.ETD != null && flightInfoF.ETD.Value.Year != 1900) ? flightInfoF.ETD :
(flightInfoF != null && flightInfoF.STD != null && flightInfoF.STD.Value.Year != 1900) ? flightInfoF.STD : null;
h2h.STAND = (flightInfoI != null && flightInfoI.TO_STAND != null) ? flightInfoI.TO_STAND : null;
h2h.STATUS = PAXCalculate.RESERVATIONSTATUS;
h2h.IFLTINFOID = (flightInfoI != null) ? (System.Nullable <int>)flightInfoI.ID : null;
h2h.OFLTINFOID = (flightInfoF != null) ? (System.Nullable <int>)flightInfoF.ID : null;
System.Nullable <DateTime> etg = null;
if (flightInfoI != null)
{
if (flightInfoI.DOOROPEN != null)
{
etg = flightInfoI.DOOROPEN;
}
else if (flightInfoI.ATA != null)
{
etg = flightInfoI.ATA;
}
else if (flightInfoI.ETA != null)
{
etg = flightInfoI.ETA;
}
}
// Obtain security times from table
OSUSR_UUK_PTMREFS2G refStandGateTime = refStandGateTimes.Where(
s => s.GATE == h2h.GATE &&
s.STAND == h2h.STAND).FirstOrDefault();
int standGateMinutes = (refStandGateTime != null && refStandGateTime.MINUTES != null) ? (int)refStandGateTime.MINUTES / 2 : 0;
if (refStandGateTime != null && SEC_Y.Equals(refStandGateTime.SEC))
{
OSUSR_UUK_PTM_REF_SEC_TIME secTime = secTimes.Where(
s => s.WEEK == ((DateTime)h2h.IDATE).DayOfWeek.ToString() &&
s.FROM_TIME > ((DateTime)etg).AddMinutes(standGateMinutes))
.FirstOrDefault();
h2h.SEC = (secTime != null && secTime.TIME != null) ? standGateMinutes + (int)secTime.TIME : standGateMinutes;
}
else
{
h2h.SEC = standGateMinutes;
}
if (h2h.ETD != null)
{
h2h.ETCG = h2h.ETD;
h2h.ETCG.Value.AddMinutes(-1 * etcg);
}
h2h.ETG = h2h.ETA;
h2h.ETG = (h2h.ETG != null) ? (System.Nullable <DateTime>)((DateTime)h2h.ETG).AddMinutes(
Math.Min((h2h.SEC != null) ? (int)h2h.SEC : 0, this.maxPaxTurnaround)) : null;
h2h.HUB = (h2h.ETD != null && h2h.ETG != null) ? (System.Nullable <int>)((TimeSpan)(h2h.ETD - h2h.ETG)).TotalMinutes : null;
BagTMLog.LogInfo("BagTM Engine H2H Update: " + h2h.ID, this);
}
else
{
// To update inbound NRBAGS count for Hub messages
h2h.FIRST = 0;
h2h.BUSINESS = 0;
h2h.ECONOMY = 0;
h2h.ETA = (flightInfoI != null && flightInfoI.ETA != null) ? flightInfoI.ETA : null;
h2h.GATE = (flightInfoF != null && flightInfoF.FROM_GATE != null) ? flightInfoF.FROM_GATE : null;
h2h.ETD = (flightInfoF != null && flightInfoF.ETD != null) ? flightInfoF.ETD : null;
h2h.STAND = (flightInfoI != null && flightInfoI.TO_STAND != null) ? flightInfoI.TO_STAND : null;
h2h.STATUS = null;
h2h.SEC = 0;
h2h.ETG = null;
h2h.ETCG = null;
h2h.HUB = null;
}
db.OSUSR_UUK_PTM_H2H.Attach(h2h);
db.Entry(h2h).State = EntityState.Modified;
BagTMLog.LogInfo("BagTM Engine PTM H2H Update: " + h2h.ID, this);
ptmList.Remove(h2hExists);
}
OSUSR_UUK_PTM_H2H newH2H = null;
foreach (var ptmNotIn in ptmList)
{
flightInfoF = null;
// Verify if passengers in connection with a FI flight
if (ptmNotIn.OFLTNR != null && !ptmNotIn.OFLTNR.StartsWith(this.airline))
{
continue;
}
newH2H = new OSUSR_UUK_PTM_H2H();
var PAXCalculate = ptmQuery.Where(s => s.IFLTNR == ptmNotIn.IFLTNR &&
s.IDATE == ptmNotIn.IDATE &&
s.IORIGIN == ptmNotIn.IORIGIN &&
s.OFLTNR == ptmNotIn.OFLTNR &&
s.ODATE == ptmNotIn.ODATE &&
s.ODEST == ptmNotIn.ODEST &&
s.RESERVATIONSTATUS == ptmNotIn.RESERVATIONSTATUS)
.GroupBy(x => new
{
x.IFLTNR,
x.IDATE,
x.IORIGIN,
x.OFLTNR,
x.ODATE,
x.ODEST,
x.RESERVATIONSTATUS
})
.Select(x => new
{
IFLTNR = x.Key.IFLTNR,
IDATE = x.Key.IDATE,
IORIGIN = x.Key.IORIGIN,
OFLTNR = x.Key.OFLTNR,
ODATE = x.Key.ODATE,
ODEST = x.Key.ODEST,
RESERVATIONSTATUS = x.Key.RESERVATIONSTATUS,
SumFIRST = x.Sum(z => z.FIRST),
SumBUSINESS = x.Sum(z => z.BUSINESS),
SumECONOMY = x.Sum(z => z.ECONOMY)
}
).FirstOrDefault();
BagTMLog.LogDebug("BagTM Engine Update H2H Don't Exist", PAXCalculate);
if (PAXCalculate != null && PAXCalculate.IFLTNR != null)
{
// To update inbound NRBAGS count for Hub messages
newH2H.FIRST = PAXCalculate.SumFIRST;
newH2H.BUSINESS = PAXCalculate.SumBUSINESS;
newH2H.ECONOMY = PAXCalculate.SumECONOMY;
}
else
{
newH2H.FIRST = 0;
newH2H.BUSINESS = 0;
newH2H.ECONOMY = 0;
}
if (ptmNotIn.OFLTNR != null && ptmNotIn.ODATE != null)
{
flightInfoF = this.SearchFlightInfo(ptmNotIn.OFLTNR, ptmNotIn.ODATE, hub, ptmNotIn.ODEST);
}
else
{
flightInfoF = new OSUSR_UUK_FLT_INFO();
}
BagTMLog.LogDebug("BagTM Engine Search FlightInfoF", flightInfoF);
newH2H.IFLTNR = ptmNotIn.IFLTNR;
newH2H.IDATE = ptmNotIn.IDATE;
newH2H.IORIGIN = ptmNotIn.IORIGIN;
newH2H.OFLTNR = ptmNotIn.OFLTNR;
newH2H.ODATE = ptmNotIn.ODATE;
newH2H.ODEST = ptmNotIn.ODEST;
newH2H.ETA = (flightInfoI != null && flightInfoI.DOOROPEN != null && flightInfoI.DOOROPEN.Value.Year != 1900) ? flightInfoI.DOOROPEN :
(flightInfoI != null && flightInfoI.ATA != null && flightInfoI.ATA.Value.Year != 1900) ? flightInfoI.ATA :
(flightInfoI != null && flightInfoI.ETA != null && flightInfoI.ETA.Value.Year != 1900) ? flightInfoI.ETA : null;
newH2H.GATE = (flightInfoF != null && flightInfoF.FROM_GATE != null) ? flightInfoF.FROM_GATE : null;
newH2H.ETD = (flightInfoF != null && flightInfoF.DOORCLOSED != null && flightInfoF.DOORCLOSED.Value.Year != 1900) ? flightInfoF.DOORCLOSED :
(flightInfoF != null && flightInfoF.ATD != null && flightInfoF.ATD.Value.Year != 1900) ? flightInfoF.ATD :
(flightInfoF != null && flightInfoF.ETD != null && flightInfoF.ETD.Value.Year != 1900) ? flightInfoF.ETD :
(flightInfoF != null && flightInfoF.STD != null && flightInfoF.STD.Value.Year != 1900) ? flightInfoF.STD : null;
newH2H.STAND = (flightInfoI != null && flightInfoI.TO_STAND != null) ? flightInfoI.TO_STAND : null;
newH2H.STATUS = ptmNotIn.RESERVATIONSTATUS;
newH2H.IFLTINFOID = (flightInfoI != null) ? (System.Nullable <int>)flightInfoI.ID : null;
newH2H.OFLTINFOID = (flightInfoF != null) ? (System.Nullable <int>)flightInfoF.ID : null;
System.Nullable <DateTime> etcg = null;
if (flightInfoI != null)
{
if (flightInfoI.DOOROPEN != null && flightInfoI.DOOROPEN.Value.Year != 1900)
{
etcg = flightInfoI.DOOROPEN;
}
else if (flightInfoI.ATA != null && flightInfoI.ATA.Value.Year != 1900)
{
etcg = flightInfoI.ATA;
}
else if (flightInfoI.ETA != null && flightInfoI.ETA.Value.Year != 1900)
{
etcg = flightInfoI.ETA;
}
}
// Obtain security times from table
OSUSR_UUK_PTMREFS2G refStandGateTime = refStandGateTimes.Where(
s => s.GATE == newH2H.GATE &&
s.STAND == newH2H.STAND).FirstOrDefault();
int standGateMinutes = (refStandGateTime != null && refStandGateTime.MINUTES != null) ? (int)refStandGateTime.MINUTES / 2 : 0;
if (refStandGateTime != null && SEC_Y.Equals(refStandGateTime.SEC))
{
OSUSR_UUK_PTM_REF_SEC_TIME secTime = secTimes.Where(
s => s.WEEK == ((DateTime)newH2H.IDATE).DayOfWeek.ToString() &&
s.FROM_TIME > ((DateTime)flightInfoF.ETA).AddMinutes(standGateMinutes)).FirstOrDefault();
newH2H.SEC = (secTime != null && secTime.TIME != null) ? standGateMinutes + (int)secTime.TIME : standGateMinutes;
}
else
{
newH2H.SEC = standGateMinutes;
}
newH2H.ETG = newH2H.ETA;
newH2H.ETG = (newH2H.ETG != null) ? (System.Nullable <DateTime>)((DateTime)newH2H.ETG).AddMinutes(
Math.Min((newH2H.SEC != null) ? (int)newH2H.SEC : 0, this.maxPaxTurnaround)) : null;
newH2H.HUB = (newH2H.ETD != null && newH2H.ETG != null) ? (System.Nullable <int>)((TimeSpan)(newH2H.ETD - newH2H.ETG)).TotalMinutes : null;
try
{
db.OSUSR_UUK_PTM_H2H.Add(newH2H);
BagTMLog.LogInfo("BagTM Engine PTM H2H Create: " + newH2H.ID, this);
}
catch (DbEntityValidationException ex)
{
db.OSUSR_UUK_PTM_H2H.Remove(newH2H);
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new EngineProcessingException(exceptionMessage);
}
}
try
{
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new EngineProcessingException(exceptionMessage);
}
}
catch (Exception e)
{
BagTMLog.LogError("BagTM Engine Error updating PTM H2H Table", this, e);
throw e;
}
BagTMLog.LogDebug("BagTM Engine Update PTM H2H End", this);
}
public void CreateBagIntegrity(OSUSR_UUK_BAGMSGS bag, OSUSR_UUK_BAGINTEG bagIntegrity, String hub, bool isHub)
{
BagTMLog.LogDebug("BagTM Engine Create Bag Integrity Start", this);
BagTMLog.LogDebug("BagTM Engine Create Bag Integrity ", bag);
BagTMLog.LogDebug("BagTM Engine Create Bag Integrity ", bagIntegrity);
BagTMLog.LogDebug("BagTM Engine Create Bag Integrity ", hub);
BagTMLog.LogDebug("BagTM Engine Create Bag Integrity ", isHub);
bool isLocalTTYforHub = false;
bool isLocalEndingInHub = false;
if (isHub && BagTMRulesActions.localBagParameter.Equals(bag.VBAGSOURCIND))
{
isLocalTTYforHub = true;
}
if (isHub && isLocalTTYforHub && bag.OFLTNR == null)
{
isLocalEndingInHub = true;
}
if (isHub && !isLocalTTYforHub && bag.IFLTNR != null)
{
isLocalEndingInHub = true;
}
bagIntegrity.NUMBER = bag.NBAGTAG + bag.NNRTAGS;
bagIntegrity.CLOSE = null;
bagIntegrity.TIMESTAMP = DateTime.Now;
// Create different BagIntegrity record creation for Hub and Local TTY messages
if (isHub)
{
// The message is a local message for Hub transit
if (isLocalTTYforHub)
{
bagIntegrity.IFLTNR = CommonFunctions.FormatFlightNumber(bag.FFLTNR);
bagIntegrity.IDATE = bag.FDATE;
bagIntegrity.IORIGIN = bag.VCITY;
bagIntegrity.ISEAT = bag.SSEAT;
bagIntegrity.IAUT = bag.SAUTL;
// Fill the FFP information for the flight
if (bag.YFQTV != null)
{
if (bag.YFQTV.Contains(BagTMRulesActions.FFP_GOLD))
{
bagIntegrity.IFFP = BagTMRulesActions.FFP_GOLD_VALUE;
}
else if (bag.YFQTV.Contains(BagTMRulesActions.FFP_SILVER))
{
bagIntegrity.IFFP = BagTMRulesActions.FFP_SILVER_VALUE;
}
else
{
bagIntegrity.IFFP = BagTMRulesActions.FFP_BLUE_VALUE;
}
}
// If TTY implicates a onward flight out of the Hub
if (!isLocalEndingInHub)
{
bagIntegrity.FFLTNR = CommonFunctions.FormatFlightNumber(bag.OFLTNR);
bagIntegrity.FDATE = bag.ODATE;
bagIntegrity.FDEST = bag.ODEST;
}
if (BagTMRulesActions.SMI_BPM.Equals(bag.SMI))
{
bagIntegrity.BPMIN = BagTMRulesActions.YES;
}
if (BagTMRulesActions.PAX_BOARDED_STATUS.Equals(bag.SPAXCK))
{
bagIntegrity.BSMBOARDI = BagTMRulesActions.PAX_BOARDED_STATUS;
}
if (BagTMRulesActions.BAGGAGE_RUSH.Equals(bag.EEXCEP) || this.IsRush(bagIntegrity))
{
bagIntegrity.ISRUSH = BagTMRulesActions.BAGGAGE_RUSH_VALUE;
}
if (BagTMRulesActions.BAGGAGE_PRIO.Equals(bag.EEXCEP))
{
bagIntegrity.ISRUSH = BagTMRulesActions.BAGGAGE_PRIO_VALUE;
}
if (bag.PPAXNAME.Equals(BagTMRulesActions.BAGGAGE_CREW))
{
bagIntegrity.IAUT = BagTMRulesActions.BAG_CREW_VALUE;
bagIntegrity.BPMIN = BagTMRulesActions.BAG_CREW_VALUE;
bagIntegrity.BSMBOARDI = BagTMRulesActions.BAG_CREW_VALUE;
}
}
else
{
bagIntegrity.IFLTNR = CommonFunctions.FormatFlightNumber(bag.IFLTNR);
bagIntegrity.IDATE = bag.IDATE;
bagIntegrity.IORIGIN = bag.IORIGIN;
bagIntegrity.FFLTNR = CommonFunctions.FormatFlightNumber(bag.FFLTNR);
bagIntegrity.FDATE = bag.FDATE;
bagIntegrity.FDEST = bag.FDEST;
bagIntegrity.FAUT = bag.SAUTL;
bagIntegrity.FSEAT = bag.SSEAT;
// Fill the FFP information for the flight
if (bag.YFQTV != null)
{
if (bag.YFQTV.Contains(BagTMRulesActions.FFP_GOLD))
{
bagIntegrity.OFFP = BagTMRulesActions.FFP_GOLD_VALUE;
}
else if (bag.YFQTV.Contains(BagTMRulesActions.FFP_SILVER))
{
bagIntegrity.OFFP = BagTMRulesActions.FFP_SILVER_VALUE;
}
else
{
bagIntegrity.OFFP = BagTMRulesActions.FFP_BLUE_VALUE;
}
}
if (BagTMRulesActions.SMI_BPM.Equals(bag.SMI))
{
bagIntegrity.BPMHUB = BagTMRulesActions.YES;
}
if (BagTMRulesActions.PAX_BOARDED_STATUS.Equals(bag.SPAXCK))
{
bagIntegrity.BSMBOARD = BagTMRulesActions.PAX_BOARDED_STATUS;
}
if (BagTMRulesActions.BAGGAGE_RUSH.Equals(bag.EEXCEP) || this.IsRush(bagIntegrity))
{
bagIntegrity.ISRUSH = BagTMRulesActions.BAGGAGE_RUSH_VALUE;
}
if (BagTMRulesActions.BAGGAGE_PRIO.Equals(bag.EEXCEP))
{
bagIntegrity.ISRUSH = BagTMRulesActions.BAGGAGE_PRIO_VALUE;
}
if (bag.PPAXNAME.Equals(BagTMRulesActions.BAGGAGE_CREW))
{
bagIntegrity.FAUT = BagTMRulesActions.BAG_CREW_VALUE;
bagIntegrity.BPMHUB = BagTMRulesActions.BAG_CREW_VALUE;
bagIntegrity.BSMBOARD = BagTMRulesActions.BAG_CREW_VALUE;
}
}
}
else
{
bagIntegrity.FFLTNR = CommonFunctions.FormatFlightNumber(bag.FFLTNR);
bagIntegrity.FDATE = bag.FDATE;
bagIntegrity.FDEST = bag.FDEST;
bagIntegrity.FAUT = bag.SAUTL;
bagIntegrity.FSEAT = bag.SSEAT;
// Fill the FFP information for the flight
if (bag.YFQTV != null)
{
if (bag.YFQTV.Contains(BagTMRulesActions.FFP_GOLD))
{
bagIntegrity.OFFP = BagTMRulesActions.FFP_GOLD_VALUE;
}
else if (bag.YFQTV.Contains(BagTMRulesActions.FFP_SILVER))
{
bagIntegrity.OFFP = BagTMRulesActions.FFP_SILVER_VALUE;
}
else
{
bagIntegrity.OFFP = BagTMRulesActions.FFP_BLUE_VALUE;
}
}
if (BagTMRulesActions.SMI_BPM.Equals(bag.SMI))
{
bagIntegrity.BPMHUB = BagTMRulesActions.YES;
}
if (BagTMRulesActions.PAX_BOARDED_STATUS.Equals(bag.SPAXCK))
{
bagIntegrity.BSMBOARD = BagTMRulesActions.PAX_BOARDED_STATUS;
}
if (BagTMRulesActions.BAGGAGE_RUSH.Equals(bag.EEXCEP) || this.IsRush(bagIntegrity))
{
bagIntegrity.ISRUSH = BagTMRulesActions.BAGGAGE_RUSH_VALUE;
}
if (BagTMRulesActions.BAGGAGE_PRIO.Equals(bag.EEXCEP))
{
bagIntegrity.ISRUSH = BagTMRulesActions.BAGGAGE_PRIO_VALUE;
}
if (bag.PPAXNAME.Equals(BagTMRulesActions.BAGGAGE_CREW))
{
bagIntegrity.FAUT = BagTMRulesActions.BAG_CREW_VALUE;
bagIntegrity.BPMHUB = BagTMRulesActions.BAG_CREW_VALUE;
bagIntegrity.BSMBOARD = BagTMRulesActions.BAG_CREW_VALUE;
}
}
// Change register for baggage groups
if (!bagIntegrity.NUMBER.EndsWith(BagTMRulesActions.BAGGAGE_NRTAG_001))
{
bagIntegrity.FAUT = (bagIntegrity.FAUT != null) ? BagTMRulesActions.BAG_GROUP_AUT_CODE : null;
bagIntegrity.IAUT = (bagIntegrity.IAUT != null) ? BagTMRulesActions.BAG_GROUP_AUT_CODE : null;
bagIntegrity.BPMIN = (bagIntegrity.BPMIN != null) ? BagTMRulesActions.BAG_GROUP_BPM_CODE : null;
bagIntegrity.IAUT = (bagIntegrity.BPMHUB != null) ? BagTMRulesActions.BAG_GROUP_BPM_CODE : null;
}
BaggageEntities dbin = new BaggageEntities();
try
{
BagTMLog.LogDebug("BagTM Engine Create Bag Integrity Saving", bagIntegrity);
dbin.OSUSR_UUK_BAGINTEG.Add(bagIntegrity);
dbin.SaveChanges();
BagTMLog.LogInfo("BagTM Engine Create Bag Integrity: " + bagIntegrity.NUMBER, this);
}
catch (DbEntityValidationException ex)
{
dbin.OSUSR_UUK_BAGINTEG.Remove(bagIntegrity);
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors;
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new EngineProcessingException(exceptionMessage);
}
catch (Exception e)
{
dbin.OSUSR_UUK_BAGINTEG.Remove(bagIntegrity);
throw e;
}
BagTMLog.LogDebug("BagTM Engine Create Bag Integrity End", this);
}
public void UpdateBagIntegrity(OSUSR_UUK_BAGMSGS bag, OSUSR_UUK_BAGINTEG bagIntegrity, String hub, bool isHub, Int32 TTYChange)
{
BagTMLog.LogDebug("BagTM Engine Upodate Bag Integrity Start", this);
BagTMLog.LogDebug("BagTM Engine Upodate Bag Integrity", bag);
BagTMLog.LogDebug("BagTM Engine Upodate Bag Integrity", bagIntegrity);
BagTMLog.LogDebug("BagTM Engine Upodate Bag Integrity", hub);
BagTMLog.LogDebug("BagTM Engine Upodate Bag Integrity", isHub);
BagTMLog.LogDebug("BagTM Engine Upodate Bag Integrity", TTYChange);
bool isLocalTTYforHub = false;
if (isHub && BagTMRulesActions.localBagParameter.Equals(bag.VBAGSOURCIND))
{
isLocalTTYforHub = true;
}
if (bag.NBAGTAG == null || bagIntegrity.NUMBER != bag.NBAGTAG + bag.NNRTAGS)
{
throw new EngineProcessingException(
String.Format("Message TTY {0} and BAGTAG {1} not processed due to incosistences.",
bag.SMI, bag.NBAGTAG));
}
// Have to be defined what to do
if (null != bagIntegrity.CLOSE)
{
bagIntegrity.CLOSE = null;
}
// Create different BagIntegrity record creation for Hub and Local TTY messages
if (isHub)
{
// The message is a local message for Hub transit
if (isLocalTTYforHub)
{
if (bag.FFLTNR != null && !CommonFunctions.FormatFlightNumber(bag.FFLTNR).Equals(bagIntegrity.IFLTNR))
{
bagIntegrity.IFLTNR = CommonFunctions.FormatFlightNumber(bag.FFLTNR);
}
if (bag.FDATE != null && !bag.FDATE.Equals(bagIntegrity.IDATE))
{
bagIntegrity.IDATE = bag.FDATE;
}
if (bag.VCITY != null && !bag.VCITY.Equals(bagIntegrity.IORIGIN))
{
bagIntegrity.IORIGIN = bag.VCITY;
}
if (bag.SSEAT != null && !bag.SSEAT.Equals(bagIntegrity.ISEAT))
{
bagIntegrity.ISEAT = bag.SSEAT;
}
if (bag.OFLTNR != null && !CommonFunctions.FormatFlightNumber(bag.OFLTNR).Equals(bagIntegrity.FFLTNR))
{
bagIntegrity.FFLTNR = CommonFunctions.FormatFlightNumber(bag.OFLTNR);
}
if (bag.ODATE != null && !bag.ODATE.Equals(bagIntegrity.FDATE))
{
bagIntegrity.FDATE = bag.ODATE;
}
if (bag.ODEST != null && !bag.ODEST.Equals(bagIntegrity.FDEST))
{
bagIntegrity.FDEST = bag.ODEST;
}
if (BagTMRulesActions.SMI_BPM.Equals(bag.SMI))
{
bagIntegrity.BPMIN = BagTMRulesActions.YES;
}
if (BagTMRulesActions.PAX_BOARDED_STATUS.Equals(bag.SPAXCK))
{
bagIntegrity.BSMBOARDI = BagTMRulesActions.PAX_BOARDED_STATUS;
}
switch (TTYChange)
{
case BagTMRulesActions.BAG_TTY_CHANGE_AUTH:
bagIntegrity.IAUT = bag.SAUTL;
break;
case BagTMRulesActions.BAG_TTY_CHANGE_PAX_BOARDED:
bagIntegrity.BSMBOARDI = BagTMRulesActions.PAX_BOARDED_STATUS;
break;
case BagTMRulesActions.BAG_TTY_CHANGE_LOAD_FAIL:
bagIntegrity.BPMIN = BagTMRulesActions.PAX_BOARDED_FAIL;
break;
case BagTMRulesActions.BAG_TTY_CHANGE_BAGGAGE_OFFLOAD:
if (bagIntegrity.IFLTNR != null)
{
bagIntegrity.IAUT = BagTMRulesActions.BAG_OFF;
bagIntegrity.BPMIN = BagTMRulesActions.BAG_OFF;
}
if (bagIntegrity.FFLTNR != null)
{
bagIntegrity.FAUT = BagTMRulesActions.BAG_OFF;
bagIntegrity.BPMHUB = BagTMRulesActions.BAG_OFF;
}
break;
case BagTMRulesActions.BAG_TTY_CHANGE_PAX_CANCEL:
if (bagIntegrity.IFLTNR != null)
{
bagIntegrity.IAUT = BagTMRulesActions.PAX_AUT_STATUS_CODE;
bagIntegrity.BPMIN = BagTMRulesActions.PAX_AUT_STATUS_CODE;
}
if (bagIntegrity.FFLTNR != null)
{
bagIntegrity.FAUT = BagTMRulesActions.PAX_AUT_STATUS_CODE;
bagIntegrity.BPMHUB = BagTMRulesActions.PAX_AUT_STATUS_CODE;
}
break;
}
if (bag.PPAXNAME.Equals(BagTMRulesActions.BAGGAGE_CREW))
{
bagIntegrity.FAUT = BagTMRulesActions.BAG_CREW_VALUE;
bagIntegrity.BPMIN = BagTMRulesActions.BAG_CREW_VALUE;
bagIntegrity.BSMBOARDI = BagTMRulesActions.BAG_CREW_VALUE;
}
}
else
{
if (bag.IFLTNR != null && !CommonFunctions.FormatFlightNumber(bag.IFLTNR).Equals(bagIntegrity.IFLTNR))
{
bagIntegrity.IFLTNR = CommonFunctions.FormatFlightNumber(bag.IFLTNR);
}
if (bag.IDATE != null && !bag.IDATE.Equals(bagIntegrity.IDATE))
{
bagIntegrity.IDATE = bag.IDATE;
}
if (bag.IORIGIN != null && !bag.IORIGIN.Equals(bagIntegrity.IORIGIN))
{
bagIntegrity.IORIGIN = bag.IORIGIN;
}
if (bag.SSEAT != null && !bag.SSEAT.Equals(bagIntegrity.FSEAT))
{
bagIntegrity.FSEAT = bag.SSEAT;
}
if (bag.FFLTNR != null && !CommonFunctions.FormatFlightNumber(bag.FFLTNR).Equals(bagIntegrity.FFLTNR))
{
bagIntegrity.FFLTNR = CommonFunctions.FormatFlightNumber(bag.FFLTNR);
}
if (bag.FDATE != null && !bag.FDATE.Equals(bagIntegrity.FDATE))
{
bagIntegrity.FDATE = bag.FDATE;
}
if (bag.FDEST != null && !bag.FDEST.Equals(bagIntegrity.FDEST))
{
bagIntegrity.FDEST = bag.FDEST;
}
if (BagTMRulesActions.SMI_BPM.Equals(bag.SMI))
{
bagIntegrity.BPMHUB = BagTMRulesActions.YES;
}
if (BagTMRulesActions.BAGGAGE_RUSH.Equals(bag.EEXCEP) || this.IsRush(bagIntegrity))
{
bagIntegrity.ISRUSH = BagTMRulesActions.BAGGAGE_RUSH_VALUE;
}
if (BagTMRulesActions.BAGGAGE_PRIO.Equals(bag.EEXCEP))
{
bagIntegrity.ISRUSH = BagTMRulesActions.BAGGAGE_PRIO_VALUE;
}
if (BagTMRulesActions.PAX_BOARDED_STATUS.Equals(bag.SPAXCK))
{
bagIntegrity.BSMBOARD = BagTMRulesActions.PAX_BOARDED_STATUS;
}
switch (TTYChange)
{
case BagTMRulesActions.BAG_TTY_CHANGE_AUTH:
bagIntegrity.FAUT = bag.SAUTL;
break;
case BagTMRulesActions.BAG_TTY_CHANGE_PAX_BOARDED:
bagIntegrity.BSMBOARD = BagTMRulesActions.PAX_BOARDED_STATUS;
break;
case BagTMRulesActions.BAG_TTY_CHANGE_LOAD_FAIL:
bagIntegrity.BPMHUB = BagTMRulesActions.PAX_BOARDED_FAIL;
break;
case BagTMRulesActions.BAG_TTY_CHANGE_BAGGAGE_OFFLOAD:
bagIntegrity.FAUT = BagTMRulesActions.BAG_OFF;
bagIntegrity.BPMHUB = BagTMRulesActions.BAG_OFF;
break;
case BagTMRulesActions.BAG_TTY_CHANGE_PAX_CANCEL:
bagIntegrity.FAUT = BagTMRulesActions.PAX_AUT_STATUS_CODE;
bagIntegrity.BPMHUB = BagTMRulesActions.PAX_AUT_STATUS_CODE;
break;
}
if (bag.PPAXNAME.Equals(BagTMRulesActions.BAGGAGE_CREW))
{
bagIntegrity.FAUT = BagTMRulesActions.BAG_CREW_VALUE;
bagIntegrity.BPMHUB = BagTMRulesActions.BAG_CREW_VALUE;
bagIntegrity.BSMBOARD = BagTMRulesActions.BAG_CREW_VALUE;
}
}
}
else
{
if (bag.FFLTNR != null && !CommonFunctions.FormatFlightNumber(bag.FFLTNR).Equals(bagIntegrity.FFLTNR))
{
bagIntegrity.FFLTNR = CommonFunctions.FormatFlightNumber(bag.FFLTNR);
}
if (bag.FDATE != null && !bag.FDATE.Equals(bagIntegrity.FDATE))
{
bagIntegrity.FDATE = bag.FDATE;
}
if (bag.FDEST != null && !bag.FDEST.Equals(bagIntegrity.FDEST))
{
bagIntegrity.FDEST = bag.FDEST;
}
if (bag.SSEAT != null && !bag.SSEAT.Equals(bagIntegrity.FSEAT))
{
bagIntegrity.FSEAT = bag.SSEAT;
}
if (BagTMRulesActions.SMI_BPM.Equals(bag.SMI))
{
bagIntegrity.BPMHUB = BagTMRulesActions.YES;
}
if (BagTMRulesActions.BAGGAGE_RUSH.Equals(bag.EEXCEP) || this.IsRush(bagIntegrity))
{
bagIntegrity.ISRUSH = BagTMRulesActions.BAGGAGE_RUSH_VALUE;
}
if (BagTMRulesActions.BAGGAGE_PRIO.Equals(bag.EEXCEP))
{
bagIntegrity.ISRUSH = BagTMRulesActions.BAGGAGE_PRIO_VALUE;
}
if (BagTMRulesActions.PAX_BOARDED_STATUS.Equals(bag.SPAXCK))
{
bagIntegrity.BSMBOARD = BagTMRulesActions.PAX_BOARDED_STATUS;
}
switch (TTYChange)
{
case BagTMRulesActions.BAG_TTY_CHANGE_AUTH:
bagIntegrity.FAUT = bag.SAUTL;
break;
case BagTMRulesActions.BAG_TTY_CHANGE_PAX_BOARDED:
bagIntegrity.BSMBOARD = BagTMRulesActions.PAX_BOARDED_STATUS;
break;
case BagTMRulesActions.BAG_TTY_CHANGE_LOAD_FAIL:
bagIntegrity.BPMHUB = BagTMRulesActions.PAX_BOARDED_FAIL;
break;
case BagTMRulesActions.BAG_TTY_CHANGE_BAGGAGE_OFFLOAD:
bagIntegrity.FAUT = BagTMRulesActions.BAG_OFF;
bagIntegrity.BPMHUB = BagTMRulesActions.BAG_OFF;
break;
case BagTMRulesActions.BAG_TTY_CHANGE_PAX_CANCEL:
bagIntegrity.FAUT = BagTMRulesActions.PAX_AUT_STATUS_CODE;
bagIntegrity.BPMHUB = BagTMRulesActions.PAX_AUT_STATUS_CODE;
break;
}
if (bag.PPAXNAME.Equals(BagTMRulesActions.BAGGAGE_CREW))
{
bagIntegrity.FAUT = BagTMRulesActions.BAG_CREW_VALUE;
bagIntegrity.BPMHUB = BagTMRulesActions.BAG_CREW_VALUE;
bagIntegrity.BSMBOARD = BagTMRulesActions.BAG_CREW_VALUE;
}
}
// Change register for baggage groups
if (!bagIntegrity.NUMBER.EndsWith(BagTMRulesActions.BAGGAGE_NRTAG_001))
{
bagIntegrity.FAUT = (bagIntegrity.FAUT != null) ? BagTMRulesActions.BAG_GROUP_AUT_CODE : null;
bagIntegrity.IAUT = (bagIntegrity.IAUT != null) ? BagTMRulesActions.BAG_GROUP_AUT_CODE : null;
bagIntegrity.BPMIN = (bagIntegrity.BPMIN != null) ? BagTMRulesActions.BAG_GROUP_BPM_CODE : null;
bagIntegrity.IAUT = (bagIntegrity.BPMHUB != null) ? BagTMRulesActions.BAG_GROUP_BPM_CODE : null;
}
BaggageEntities dbup = new BaggageEntities();
try
{
BagTMLog.LogDebug("BagTM Engine Upodate Bag Integrity Saving", bagIntegrity);
// Verifies if updating last baggage integrity record, if more then one remove all
OSUSR_UUK_BAGINTEG lastBaggageIntegraty = this.LastBaggageIntegraty(bagIntegrity);
if (lastBaggageIntegraty != null && lastBaggageIntegraty.TIMESTAMP != null &&
lastBaggageIntegraty.TIMESTAMP > bagIntegrity.TIMESTAMP)
{
this.UpdateBagIntegrity(bag, lastBaggageIntegraty, hub, isHub, TTYChange);
}
else
{
if (lastBaggageIntegraty != null)
{
bagIntegrity = MergeBagIntegrity(bagIntegrity, lastBaggageIntegraty);
}
bagIntegrity.TIMESTAMP = DateTime.Now;
dbup.OSUSR_UUK_BAGINTEG.Attach(bagIntegrity);
dbup.Entry(bagIntegrity).State = EntityState.Modified;
dbup.SaveChanges();
}
BagTMLog.LogInfo("BagTM Engine Update Bag Integrity: " + bagIntegrity.NUMBER, this);
}
catch (DbEntityValidationException ex)
{
dbup.OSUSR_UUK_BAGINTEG.Remove(bagIntegrity);
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors;
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
throw new EngineProcessingException(exceptionMessage);
}
catch (Exception e)
{
dbup.OSUSR_UUK_BAGINTEG.Remove(bagIntegrity);
throw e;
}
BagTMLog.LogDebug("BagTM Engine Upodate Bag Integrity End", this);
}
public Object parse(String messageString, BaggageEntities db)
{
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing PTM TTY {0}", messageString), this);
Match flight;
MatchCollection outbounds;
IPTMTTYTable messageObject = null;
String methodName;
String parameter = null;
String messageStripped;
// At this stage formatter alredy removed headers
messageStripped = this.RemoveHeaders(messageString);
flight = Regex.Match(messageString, matchFlights);
outbounds = Regex.Matches(messageString.Remove(0, flight.Length), matchOutbounds);
try
{
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing PTM TTY Message flight {0}", flight.Value), this);
PTMTTYTable paxmsgs = new PTMTTYTable();
TTYComponentConfigElement configFlight = ttyCollection.GetTTYElement("PTM").ttyElements.GetTTYElementElement("default").ttycomponents.GetTTYElementElement("Flight");
if (!flight.Success)
throw new PTMParsingException("No flight information impossible to process PTM message.");
DateTime messageTimestamp = DateTime.Now;
if (outbounds.Count > 0)
{
foreach (Match outbound in outbounds)
{
messageObject = (IPTMTTYTable)Activator.CreateInstance(Type.GetType(ttyCollection.GetTTYElement("PTM").entityName));
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing PTM TTY Message flight {0}", flight.Value), this);
parameter = flight.Value.Substring(4, flight.Length - 10);
methodName = configFlight.methodName;
// Not necessary if parameter is null since no change to object
if (parameter != null) messageObject.SetValue(methodName, parameter);
TTYComponentConfigElement configOutbound = ttyCollection.GetTTYElement("PTM").ttyElements.GetTTYElementElement("default").ttycomponents.GetTTYElementElement("Outbounds");
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing PTM TTY Message flight {0} and outbound {1}", flight.Value, outbound.Value), this);
parameter = outbound.Value;
methodName = configOutbound.methodName;
// Not necessary if parameter is null since no change to object
if (parameter != null) messageObject.SetValue(methodName, parameter);
// Create timestamp message identifier
messageObject.SetValue("Stamp", messageTimestamp.ToString());
// Se o objeto estiver instanciado então foi preenchido e deve ser guardado em base de dados
if (messageObject != null)
{
BagTMLog.LogInfo(
String.Format("BagTM Queue Message PTM Message Outbound Parsed {0}", messageObject), this);
messageObject.Save(db, hub);
}
}
}
else
{
messageObject = (IPTMTTYTable)Activator.CreateInstance(Type.GetType(ttyCollection.GetTTYElement("PTM").entityName));
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing PTM TTY Message flight {0}", flight.Value), this);
parameter = flight.Value.Substring(4, flight.Length - 10);
methodName = configFlight.methodName;
// Not necessary if parameter is null since no change to object
if (parameter != null) messageObject.SetValue(methodName, parameter);
// Se o objeto estiver instanciado então foi preenchido e deve ser guardado em base de dados
if (messageObject != null)
{
BagTMLog.LogInfo(
String.Format("BagTM Queue Message PTM Message Parsed {0}", messageObject), this);
messageObject.Save(db, hub);
}
}
return ((PTMTTYTable)messageObject).getOSUSR_UUK_PAXMSGS();
} catch (Exception e)
{
BagTMLog.LogError("BagTM Queue Message Parsing PTM TTY Parser Error", this, e);
throw e;
}
}
public Object parse(String messageString, BaggageEntities db)
{
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing TTY {0}", messageString), this);
String[] elements;
String[] components;
String keyTTY;
String keyElement;
IBaggageTTYTable messageObject = null;
String methodName;
String parameter = null;
String messageStripped;
// At this stage formatter alredy removed headers
messageStripped = this.RemoveHeaders(messageString);
elements = Regex.Split(messageStripped, matchElements);
try
{
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing TTY Message element[0] {0} element[0].lenght {1}",
elements[0], elements[0].Length), this);
if (elements[0] != null && elements[0].Length > 2 && ttyCollection.HasTTY(elements[0].Substring(0, 3)))
{
keyTTY = elements[0].Substring(0, 3);
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing TTY Message with Key {0} Processing by EntityName {1} and Type {2}",
keyTTY, ttyCollection.GetTTYElement(keyTTY).entityName,
Type.GetType(ttyCollection.GetTTYElement(keyTTY).entityName)), this);
messageObject = (IBaggageTTYTable)Activator.CreateInstance(Type.GetType(ttyCollection.GetTTYElement(keyTTY).entityName));
messageObject.Clean();
foreach (string element in elements)
{
components = Regex.Split(element, matchComponents);
keyElement = (!element.Equals(elements[0])) ? components[0] : "default";
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing TTY Message with Key {0} Processing KeyElement {1} for Element {2} and Components[0] {3} ",
keyTTY, keyElement, element, components[0]), this);
if (components[0] != null && ttyCollection.HasTTYElement(keyTTY, keyElement))
{
foreach (TTYComponentConfigElement config in ttyCollection.GetTTYElement(keyTTY).ttyElements.GetTTYElementElement(keyElement).ttycomponents)
{
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing TTY Message with Config Size {0}", ttyCollection.GetTTYElement(keyTTY).ttyElements.GetTTYElementElement(keyElement).ttycomponents.Count), this);
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing TTY Message key {0}, keyElement {1}, position {2} and substring {3} from components {4}",
keyTTY, keyElement, config.GetPositionInt(), config.substring, components.Length), this);
parameter = null;
methodName = config.methodName;
// To process all components based on XML configuration
if (config.GetPositionInt() < 0)
{
// If position = 0 then all components in the same attribute
// Also remove . and /
parameter = element.Substring(components[0].Length + 1);
}
else if (config.GetPositionInt() < components.Length)
{
if (config.substring != null && config.substring.Length > 0)
{
if (components[config.GetPositionInt()].Length >= config.StartSubString() + config.LenghtSubString())
{
parameter = components[config.GetPositionInt()].
Substring(config.StartSubString(), config.LenghtSubString());
}
else
{
parameter = null;
}
}
else
{
parameter = components[config.GetPositionInt()];
}
}
if (config.GetPositionInt() < components.Length)
{
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing TTY Message key {0} and keyElement {1} position {2} to method {3} with parameters {4}",
keyTTY, keyElement, config.position, methodName, parameter), this);
// Not necessary if parameter is null since no change to object
if (parameter != null)
{
messageObject.SetValue(methodName, parameter);
}
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing TTY Message key {0} and keyElement {1} position {2} stored object {3}",
keyTTY, keyElement, config.position, messageObject.ToString()), this);
}
}
}
else
{
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing TTY Message key {0} and keyElement {1} does not process in element {2}",
keyTTY, keyElement, element), this);
}
}
}
else
{
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing TTY Message key {0} does not process {1}", elements[0], messageString), this);
}
} catch (Exception e)
{
BagTMLog.LogError("BagTM Queue Message Parsing TTY Parser Error", this, e);
throw e;
}
BagTMLog.LogDebug(
String.Format("BagTM Queue Message Parsing TTY Parser Collection {0}", messageString), this);
// Se o objeto estiver instanciado então foi preenchido e deve ser guardado em base de dados
if (messageObject != null)
{
BagTMLog.LogInfo(
String.Format("BagTM Queue Message Message Parsed {0}", messageObject), this);
return(messageObject.Save(db));
}
else
{
return(null);
}
}
