/** * This will create a new record or update an existing record given the MS SQL Data Row * @param string[] $objRow the mssql_fetch_assoc row result from MS SQL Server * @return ParentPagerChildHistory */ public static function CreateOrUpdateForMsSqlRow($objRow) { $intServerIdentifier = $objRow['lngChildHistoryID']; $intIndividualIdentifier = $objRow['lngIndividualID']; $intStationIdentifier = $objRow['lngStationID']; $intPeriodIdentifier = $objRow['lngPeriodID']; $intDropoffIndividualIdentifier = $objRow['lngDropOffByID']; $intPickupIndividualIdentifier = $objRow['lngPickupByID']; $dttDateIn = new QDateTime($objRow['dtmCheckInDateTime']); $dttDateOut = new QDateTime($objRow['dtmCheckOutDateTime']); $objParentPagerChildHistory = ParentPagerChildHistory::LoadByServerIdentifier($intServerIdentifier); if (!$objParentPagerChildHistory) { $objParentPagerChildHistory = new ParentPagerChildHistory(); $objParentPagerChildHistory->ServerIdentifier = $intServerIdentifier; } $objParentPagerChildHistory->ParentPagerIndividual = ParentPagerIndividual::LoadByServerIdentifier($intIndividualIdentifier); $objParentPagerChildHistory->ParentPagerStation = ParentPagerStation::LoadByServerIdentifier($intStationIdentifier); $objParentPagerChildHistory->ParentPagerPeriod = ParentPagerPeriod::LoadByServerIdentifier($intPeriodIdentifier); $objParentPagerChildHistory->DropoffByParentPagerIndividual = ParentPagerIndividual::LoadByServerIdentifier($intDropoffIndividualIdentifier); $objParentPagerChildHistory->PickupByParentPagerIndividual = ParentPagerIndividual::LoadByServerIdentifier($intPickupIndividualIdentifier); $objParentPagerChildHistory->DateIn = $dttDateIn; $objParentPagerChildHistory->DateOut = $dttDateOut; $objParentPagerChildHistory->Save(); return $objParentPagerChildHistory; }