//Convenience method for creating a record
public KeyValue NewRecord(
string EventIdValue,
string ContactIdValue,
string ValidationUidValue,
string RegistrationTypeIdValue,
string AdditionalDinnerTicketValue,
string SpecialRequirementsValue,
string AdditionalDinnerNameValue,
string DatePaidValue,
string InitialCreationDateValue,
string RecordDeletedValue,
string PaymentRefValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(EventIdValue, EventIdColumn);
rec.SetString(ContactIdValue, ContactIdColumn);
rec.SetString(ValidationUidValue, ValidationUidColumn);
rec.SetString(RegistrationTypeIdValue, RegistrationTypeIdColumn);
rec.SetString(AdditionalDinnerTicketValue, AdditionalDinnerTicketColumn);
rec.SetString(SpecialRequirementsValue, SpecialRequirementsColumn);
rec.SetString(AdditionalDinnerNameValue, AdditionalDinnerNameColumn);
rec.SetString(DatePaidValue, DatePaidColumn);
rec.SetString(InitialCreationDateValue, InitialCreationDateColumn);
rec.SetString(RecordDeletedValue, RecordDeletedColumn);
rec.SetString(PaymentRefValue, PaymentRefColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string FieldTripOptionIdValue,
string RegistrationIdValue,
string FieldTripOptionId2Value,
string FieldTripOptionId3Value,
string FieldTripIdValue,
string RecordDeletedValue,
string FieldTripAllocatedValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(FieldTripOptionIdValue, FieldTripOptionIdColumn);
rec.SetString(RegistrationIdValue, RegistrationIdColumn);
rec.SetString(FieldTripOptionId2Value, FieldTripOptionId2Column);
rec.SetString(FieldTripOptionId3Value, FieldTripOptionId3Column);
rec.SetString(FieldTripIdValue, FieldTripIdColumn);
rec.SetString(RecordDeletedValue, RecordDeletedColumn);
rec.SetString(FieldTripAllocatedValue, FieldTripAllocatedColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string UserName0Value,
string PasswordValue,
string eMailValue,
string ActiveValue,
string LastLoginDateValue,
string RoleIdValue,
string CreatedByValue,
string UpdatedByValue,
string CreatedOnValue,
string UpdatedOnValue,
string ActiveEventIdValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(UserName0Value, UserName0Column);
rec.SetString(PasswordValue, PasswordColumn);
rec.SetString(eMailValue, eMailColumn);
rec.SetString(ActiveValue, ActiveColumn);
rec.SetString(LastLoginDateValue, LastLoginDateColumn);
rec.SetString(RoleIdValue, RoleIdColumn);
rec.SetString(CreatedByValue, CreatedByColumn);
rec.SetString(UpdatedByValue, UpdatedByColumn);
rec.SetString(CreatedOnValue, CreatedOnColumn);
rec.SetString(UpdatedOnValue, UpdatedOnColumn);
rec.SetString(ActiveEventIdValue, ActiveEventIdColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string TrapTypeIdValue,
string GroupIdValue,
string ActiveValue,
string LocationIdValue,
string ProjectIdValue,
string TrapIdentifierIdValue,
string DeletedValue,
string UpdatedByValue,
string UpdatedOnValue,
string CreatedByValue,
string CreatedOnValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(TrapTypeIdValue, TrapTypeIdColumn);
rec.SetString(GroupIdValue, GroupIdColumn);
rec.SetString(ActiveValue, ActiveColumn);
rec.SetString(LocationIdValue, LocationIdColumn);
rec.SetString(ProjectIdValue, ProjectIdColumn);
rec.SetString(TrapIdentifierIdValue, TrapIdentifierIdColumn);
rec.SetString(DeletedValue, DeletedColumn);
rec.SetString(UpdatedByValue, UpdatedByColumn);
rec.SetString(UpdatedOnValue, UpdatedOnColumn);
rec.SetString(CreatedByValue, CreatedByColumn);
rec.SetString(CreatedOnValue, CreatedOnColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string LatValue,
string NameValue,
string Long0Value,
string UpdatedByValue,
string UpdatedOnValue,
string CreatedByValue,
string CreatedOnValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(LatValue, LatColumn);
rec.SetString(NameValue, NameColumn);
rec.SetString(Long0Value, Long0Column);
rec.SetString(UpdatedByValue, UpdatedByColumn);
rec.SetString(UpdatedOnValue, UpdatedOnColumn);
rec.SetString(CreatedByValue, CreatedByColumn);
rec.SetString(CreatedOnValue, CreatedOnColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string ContactIdValue,
string ValidationUidValue,
string DatePaidValue,
string InitialCreationDateValue,
string FieldTripIdValue,
string FirstChoiceIdValue,
string SecondChoiceIdValue,
string ThirdChoiceIdValue,
string AllocatedIdValue,
string RecIdValue,
string PaymentRefValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(ContactIdValue, ContactIdColumn);
rec.SetString(ValidationUidValue, ValidationUidColumn);
rec.SetString(DatePaidValue, DatePaidColumn);
rec.SetString(InitialCreationDateValue, InitialCreationDateColumn);
rec.SetString(FieldTripIdValue, FieldTripIdColumn);
rec.SetString(FirstChoiceIdValue, FirstChoiceIdColumn);
rec.SetString(SecondChoiceIdValue, SecondChoiceIdColumn);
rec.SetString(ThirdChoiceIdValue, ThirdChoiceIdColumn);
rec.SetString(AllocatedIdValue, AllocatedIdColumn);
rec.SetString(RecIdValue, RecIdColumn);
rec.SetString(PaymentRefValue, PaymentRefColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string SexValue,
string SpeciesValue,
string BaitTypeValue,
string CreatedByValue,
string GroupIdValue,
string UserId0Value,
string TrapRecordIdValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(SexValue, SexColumn);
rec.SetString(SpeciesValue, SpeciesColumn);
rec.SetString(BaitTypeValue, BaitTypeColumn);
rec.SetString(CreatedByValue, CreatedByColumn);
rec.SetString(GroupIdValue, GroupIdColumn);
rec.SetString(UserId0Value, UserId0Column);
rec.SetString(TrapRecordIdValue, TrapRecordIdColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string LatValue,
string Long0Value,
string DescriptionValue,
string GroupIdValue,
string LatitudeValue,
string LongitudeValue,
string AddressValue,
string UpdatedByValue,
string UpdatedOnValue,
string CreatedByValue,
string CreatedOnValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(LatValue, LatColumn);
rec.SetString(Long0Value, Long0Column);
rec.SetString(DescriptionValue, DescriptionColumn);
rec.SetString(GroupIdValue, GroupIdColumn);
rec.SetString(LatitudeValue, LatitudeColumn);
rec.SetString(LongitudeValue, LongitudeColumn);
rec.SetString(AddressValue, AddressColumn);
rec.SetString(UpdatedByValue, UpdatedByColumn);
rec.SetString(UpdatedOnValue, UpdatedOnColumn);
rec.SetString(CreatedByValue, CreatedByColumn);
rec.SetString(CreatedOnValue, CreatedOnColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string EventIdValue,
string RegistrationTypeValue,
string CostMemberValue,
string CostNonMemberValue,
string Default0Value,
string ActiveOptionValue,
string MaximumNumberValue,
string InactiveOnMaxValue,
string ActivateOnInactiveTypeValue,
string InactiveTypeValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(EventIdValue, EventIdColumn);
rec.SetString(RegistrationTypeValue, RegistrationTypeColumn);
rec.SetString(CostMemberValue, CostMemberColumn);
rec.SetString(CostNonMemberValue, CostNonMemberColumn);
rec.SetString(Default0Value, Default0Column);
rec.SetString(ActiveOptionValue, ActiveOptionColumn);
rec.SetString(MaximumNumberValue, MaximumNumberColumn);
rec.SetString(InactiveOnMaxValue, InactiveOnMaxColumn);
rec.SetString(ActivateOnInactiveTypeValue, ActivateOnInactiveTypeColumn);
rec.SetString(InactiveTypeValue, InactiveTypeColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string DescriptionValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(DescriptionValue, DescriptionColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return rec.GetID();
}
//Convenience method for creating a record
public KeyValue NewRecord(
string TownNameValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(TownNameValue, TownNameColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string UserId0Value,
string GroupIdValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(UserId0Value, UserId0Column);
rec.SetString(GroupIdValue, GroupIdColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string ContactIdValue,
string PhotoClubIdValue,
string RecordDeletedValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(ContactIdValue, ContactIdColumn);
rec.SetString(PhotoClubIdValue, PhotoClubIdColumn);
rec.SetString(RecordDeletedValue, RecordDeletedColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string EventIdValue,
string SendEmailCopiesValue,
string EmailCopiesAddressValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(EventIdValue, EventIdColumn);
rec.SetString(SendEmailCopiesValue, SendEmailCopiesColumn);
rec.SetString(EmailCopiesAddressValue, EmailCopiesAddressColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string EventIdValue,
string WorkshopDescriptionValue,
string PlacesAvailableValue,
string CostValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(EventIdValue, EventIdColumn);
rec.SetString(WorkshopDescriptionValue, WorkshopDescriptionColumn);
rec.SetString(PlacesAvailableValue, PlacesAvailableColumn);
rec.SetString(CostValue, CostColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string RegistrationIdValue,
string AvailableWorkshopIdValue,
string AttendingValue,
string RecordDeletedValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(RegistrationIdValue, RegistrationIdColumn);
rec.SetString(AvailableWorkshopIdValue, AvailableWorkshopIdColumn);
rec.SetString(AttendingValue, AttendingColumn);
rec.SetString(RecordDeletedValue, RecordDeletedColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string TrapIdValue,
string BaitTypeValue,
string DateOfCheckValue,
string SpeciesValue,
string SexValue,
string CommentValue,
string LocationIdValue,
string ProjectIdValue,
string GroupIdValue,
string TrapTypeIdValue,
string UserId0Value,
string UpdatedByValue,
string UpdatedOnValue,
string CreatedByValue,
string CreatedOnValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(TrapIdValue, TrapIdColumn);
rec.SetString(BaitTypeValue, BaitTypeColumn);
rec.SetString(DateOfCheckValue, DateOfCheckColumn);
rec.SetString(SpeciesValue, SpeciesColumn);
rec.SetString(SexValue, SexColumn);
rec.SetString(CommentValue, CommentColumn);
rec.SetString(LocationIdValue, LocationIdColumn);
rec.SetString(ProjectIdValue, ProjectIdColumn);
rec.SetString(GroupIdValue, GroupIdColumn);
rec.SetString(TrapTypeIdValue, TrapTypeIdColumn);
rec.SetString(UserId0Value, UserId0Column);
rec.SetString(UpdatedByValue, UpdatedByColumn);
rec.SetString(UpdatedOnValue, UpdatedOnColumn);
rec.SetString(CreatedByValue, CreatedByColumn);
rec.SetString(CreatedOnValue, CreatedOnColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string DescriptionValue,
string Date0Value,
string TimeValue,
string EventIdValue,
string DisplaySequenceValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(DescriptionValue, DescriptionColumn);
rec.SetString(Date0Value, Date0Column);
rec.SetString(TimeValue, TimeColumn);
rec.SetString(EventIdValue, EventIdColumn);
rec.SetString(DisplaySequenceValue, DisplaySequenceColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string EventNameValue,
string GIDValue,
string ActiveValue,
string ContactEmailValue,
string AccountNumberValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(EventNameValue, EventNameColumn);
rec.SetString(GIDValue, GIDColumn);
rec.SetString(ActiveValue, ActiveColumn);
rec.SetString(ContactEmailValue, ContactEmailColumn);
rec.SetString(AccountNumberValue, AccountNumberColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string FieldTripIdValue,
string SUM1Value,
string FieldTripOptionIdValue,
string SUM2Value,
string FieldTripOptionId2Value,
string SUM3Value,
string FieldTripOptionId3Value,
string PlacesAvailableValue,
string PlacesAvailable2Value,
string PlacesAvailable3Value,
string ftKeyValue,
string ftO1KeyValue,
string ftO2KeyValue,
string ftO3KeyValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(FieldTripIdValue, FieldTripIdColumn);
rec.SetString(SUM1Value, SUM1Column);
rec.SetString(FieldTripOptionIdValue, FieldTripOptionIdColumn);
rec.SetString(SUM2Value, SUM2Column);
rec.SetString(FieldTripOptionId2Value, FieldTripOptionId2Column);
rec.SetString(SUM3Value, SUM3Column);
rec.SetString(FieldTripOptionId3Value, FieldTripOptionId3Column);
rec.SetString(PlacesAvailableValue, PlacesAvailableColumn);
rec.SetString(PlacesAvailable2Value, PlacesAvailable2Column);
rec.SetString(PlacesAvailable3Value, PlacesAvailable3Column);
rec.SetString(ftKeyValue, ftKeyColumn);
rec.SetString(ftO1KeyValue, ftO1KeyColumn);
rec.SetString(ftO2KeyValue, ftO2KeyColumn);
rec.SetString(ftO3KeyValue, ftO3KeyColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string RoleNameValue,
string DescriptionValue,
string UpdatedByValue,
string UpdatedOnValue,
string CreatedByValue,
string CreatedOnValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(RoleNameValue, RoleNameColumn);
rec.SetString(DescriptionValue, DescriptionColumn);
rec.SetString(UpdatedByValue, UpdatedByColumn);
rec.SetString(UpdatedOnValue, UpdatedOnColumn);
rec.SetString(CreatedByValue, CreatedByColumn);
rec.SetString(CreatedOnValue, CreatedOnColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string NoteValue,
string ProjectIdValue,
string UpdatedByValue,
string UpdatedOnValue,
string CreatedByValue,
string CreatedOnValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(NoteValue, NoteColumn);
rec.SetString(ProjectIdValue, ProjectIdColumn);
rec.SetString(UpdatedByValue, UpdatedByColumn);
rec.SetString(UpdatedOnValue, UpdatedOnColumn);
rec.SetString(CreatedByValue, CreatedByColumn);
rec.SetString(CreatedOnValue, CreatedOnColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
//Convenience method for creating a record
public KeyValue NewRecord(
string Address1Value,
string Address2Value,
string Address3Value,
string HometownIdValue,
string MobileNumberValue,
string PSNZMembershipCheckValue,
string PSNZMemberValue,
string EmailValue,
string PSNZAppliedForValue,
string FirstNameValue,
string LastNameValue,
string RecordDeletedValue,
string NZIPPMemberValue
)
{
IPrimaryKeyRecord rec = (IPrimaryKeyRecord)this.CreateRecord();
rec.SetString(Address1Value, Address1Column);
rec.SetString(Address2Value, Address2Column);
rec.SetString(Address3Value, Address3Column);
rec.SetString(HometownIdValue, HometownIdColumn);
rec.SetString(MobileNumberValue, MobileNumberColumn);
rec.SetString(PSNZMembershipCheckValue, PSNZMembershipCheckColumn);
rec.SetString(PSNZMemberValue, PSNZMemberColumn);
rec.SetString(EmailValue, EmailColumn);
rec.SetString(PSNZAppliedForValue, PSNZAppliedForColumn);
rec.SetString(FirstNameValue, FirstNameColumn);
rec.SetString(LastNameValue, LastNameColumn);
rec.SetString(RecordDeletedValue, RecordDeletedColumn);
rec.SetString(NZIPPMemberValue, NZIPPMemberColumn);
rec.Create(); //update the DB so any DB-initialized fields (like autoincrement IDs) can be initialized
return(rec.GetID());
}
