internal GuestClaim GuestClaim(DataRow row)
 {
     return new GuestClaim
     {
         claim = row.ReadInt("claim$id"),
         period = new DatePeriod
         {
             begin = new System.DateTime?(row.ReadDateTime("claim$datebeg")),
             end = new System.DateTime?(row.ReadDateTime("claim$dateend"))
         },
         tourname = row.ReadNullableTrimmedString("tour$name")
     };
 }
 internal SurveyNote SurveyNote(DataRow row)
 {
     return new SurveyNote
     {
         Invitation = row.ReadInt("invitation"),
         CompleteDate = row.ReadDateTime("completedate"),
         Language = row.ReadNullableTrimmedString("lang"),
         ParticipantPrefix = row.ReadNullableTrimmedString("prefix"),
         ParticipantName = row.ReadNullableTrimmedString("name"),
         Notes = new System.Collections.Generic.List<SurveyNoteItem>()
     };
 }
 internal InvitationInfo InvitationInfo(DataRow row)
 {
     return new InvitationInfo
     {
         Id = row.ReadInt("invitation"),
         ObjectType = row.ReadNullableTrimmedString("objecttype"),
         ObjectId = row.ReadInt("objectid"),
         ObjectName = row.ReadNullableTrimmedString("objectname"),
         Language = row.ReadNullableTrimmedString("lang"),
         Data = row.ReadNullableTrimmedString("data"),
         CreateDate = row.ReadDateTime("createdate"),
         AccessCode = row.ReadNullableTrimmedString("accesscode"),
         AccessCodeExpired = row.ReadNullableDateTime("accesscodeexpdate"),
         CompleteDate = row.ReadNullableDateTime("completedate"),
         Verified = row.ReadBoolean("verified"),
         ShareCode = row.ReadNullableTrimmedString("sharecode"),
         IsSurveyed = row.ReadBoolean("is_surveyed"),
         IsExpired = row.ReadBoolean("is_expired"),
         CanSurvey = row.ReadBoolean("can_survey"),
         IsShared = row.ReadBoolean("is_shared"),
         CanShare = row.ReadBoolean("can_share")
     };
 }
 internal GuestOrder GuestOrder(DataRow row)
 {
     GuestOrder result = new GuestOrder();
     result.period = new DatePeriod
     {
         begin = new System.DateTime?(row.ReadDateTime("order$datebeg")),
         end = new System.DateTime?(row.ReadDateTime("order$dateend"))
     };
     if (!row.IsNull("hotel$id"))
     {
         result.hotelid = row.ReadNullableInt("hotel$id");
         result.title = row.ReadNullableTrimmedString("hotel$name");
         result.description = row.ReadNullableTrimmedString("hotel$room");
     }
     else
     {
         if (!row.IsNull("service$id"))
         {
             result.serviceid = row.ReadNullableInt("service$id");
             result.title = row.ReadNullableTrimmedString("service$name");
         }
     }
     return result;
 }