/**
* 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 ParentPagerAttendantHistory
*/
public static function CreateOrUpdateForMsSqlRow($objRow)
{
$intServerIdentifier = $objRow['lngAttendantHistoryID'];
$intIndividualIdentifier = $objRow['lngIndividualID'];
$intStationIdentifier = $objRow['lngStationID'];
$intPeriodIdentifier = $objRow['lngPeriodID'];
$intProgramIdentifier = $objRow['lngProgramID'];
$dttDateIn = new QDateTime($objRow['dtmStartDateTime']);
$dttDateOut = new QDateTime($objRow['dtmEndDateTime']);
$objParentPagerAttendantHistory = ParentPagerAttendantHistory::LoadByServerIdentifier($intServerIdentifier);
if (!$objParentPagerAttendantHistory) {
$objParentPagerAttendantHistory = new ParentPagerAttendantHistory();
$objParentPagerAttendantHistory->ServerIdentifier = $intServerIdentifier;
}
$objParentPagerAttendantHistory->ParentPagerIndividual = ParentPagerIndividual::LoadByServerIdentifier($intIndividualIdentifier);
$objParentPagerAttendantHistory->ParentPagerStation = ParentPagerStation::LoadByServerIdentifier($intStationIdentifier);
$objParentPagerAttendantHistory->ParentPagerPeriod = ParentPagerPeriod::LoadByServerIdentifier($intPeriodIdentifier);
$objParentPagerAttendantHistory->ParentPagerProgram = ParentPagerProgram::LoadByServerIdentifier($intProgramIdentifier);
$objParentPagerAttendantHistory->DateIn = $dttDateIn;
$objParentPagerAttendantHistory->DateOut = $dttDateOut;
$objParentPagerAttendantHistory->Save();
return $objParentPagerAttendantHistory;
}
