예제 #1
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.RegistrationsTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.RegistrationsRecord");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new RegistrationsSqlTable();
            ((RegistrationsSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            RegistrationIdColumn.CodeName        = "RegistrationId";
            EventIdColumn.CodeName                = "EventId";
            ContactIdColumn.CodeName              = "ContactId";
            ValidationUidColumn.CodeName          = "ValidationUid";
            RegistrationTypeIdColumn.CodeName     = "RegistrationTypeId";
            AdditionalDinnerTicketColumn.CodeName = "AdditionalDinnerTicket";
            SpecialRequirementsColumn.CodeName    = "SpecialRequirements";
            AdditionalDinnerNameColumn.CodeName   = "AdditionalDinnerName";
            DatePaidColumn.CodeName               = "DatePaid";
            InitialCreationDateColumn.CodeName    = "InitialCreationDate";
            RecordDeletedColumn.CodeName          = "RecordDeleted";
            RecordDeletedColumn.DefaultValue      = EvaluateFormula("\"false\"");
            PaymentRefColumn.CodeName             = "PaymentRef";
        }
예제 #2
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.UsersTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.UsersRecord");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new UsersSqlTable();
            ((UsersSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            UserId0Column.CodeName           = "UserId0";
            UserName0Column.CodeName         = "UserName0";
            PasswordColumn.CodeName          = "Password";
            eMailColumn.CodeName             = "eMail";
            ActiveColumn.CodeName            = "Active";
            LastLoginDateColumn.CodeName     = "LastLoginDate";
            RoleIdColumn.CodeName            = "RoleId";
            CreatedByColumn.CodeName         = "CreatedBy";
            UpdatedByColumn.CodeName         = "UpdatedBy";
            CreatedOnColumn.CodeName         = "CreatedOn";
            UpdatedOnColumn.CodeName         = "UpdatedOn";
            ActiveEventIdColumn.CodeName     = "ActiveEventId";
            ActiveEventIdColumn.DefaultValue = EvaluateFormula("\"1\"");
        }
예제 #3
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.TrapsTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.TrapsRecord");
            this.ApplicationName = "RatTrap";
            this.DataAdapter     = new TrapsSqlTable();
            ((TrapsSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            TrapIdColumn.CodeName           = "TrapId";
            TrapTypeIdColumn.CodeName       = "TrapTypeId";
            GroupIdColumn.CodeName          = "GroupId";
            GroupIdColumn.Name              = EvaluateFormula("\"Allocated to Group\"");
            ActiveColumn.CodeName           = "Active";
            ActiveColumn.Name               = EvaluateFormula("\"Active?\"");
            LocationIdColumn.CodeName       = "LocationId";
            ProjectIdColumn.CodeName        = "ProjectId";
            TrapIdentifierIdColumn.CodeName = "TrapIdentifierId";
            DeletedColumn.CodeName          = "Deleted";
            DeletedColumn.DefaultValue      = EvaluateFormula("\"0\"");
            UpdatedByColumn.CodeName        = "UpdatedBy";
            UpdatedOnColumn.CodeName        = "UpdatedOn";
            CreatedByColumn.CodeName        = "CreatedBy";
            CreatedOnColumn.CodeName        = "CreatedOn";
        }
예제 #4
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.View_StatsView");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.View_StatsRecord");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new View_StatsSqlView();
            ((View_StatsSqlView)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            FieldTripIdColumn.CodeName           = "FieldTripId";
            SUM1Column.CodeName = "SUM1";
            FieldTripOptionIdColumn.CodeName = "FieldTripOptionId";
            SUM2Column.CodeName = "SUM2";
            FieldTripOptionId2Column.CodeName = "FieldTripOptionId2";
            SUM3Column.CodeName = "SUM3";
            FieldTripOptionId3Column.CodeName = "FieldTripOptionId3";
            PlacesAvailableColumn.CodeName    = "PlacesAvailable";
            PlacesAvailable2Column.CodeName   = "PlacesAvailable2";
            PlacesAvailable3Column.CodeName   = "PlacesAvailable3";
            ftKeyColumn.CodeName   = "ftKey";
            ftO1KeyColumn.CodeName = "ftO1Key";
            ftO2KeyColumn.CodeName = "ftO2Key";
            ftO3KeyColumn.CodeName = "ftO3Key";
        }
예제 #5
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.LocationsTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.LocationsRecord");
            this.ApplicationName = "RatTrap";
            this.DataAdapter     = new LocationsSqlTable();
            ((LocationsSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            LocationIdColumn.CodeName            = "LocationId";
            LatColumn.CodeName         = "Lat";
            Long0Column.CodeName       = "Long0";
            DescriptionColumn.CodeName = "Description";
            GroupIdColumn.CodeName     = "GroupId";
            LatitudeColumn.CodeName    = "Latitude";
            LongitudeColumn.CodeName   = "Longitude";
            AddressColumn.CodeName     = "Address";
            UpdatedByColumn.CodeName   = "UpdatedBy";
            UpdatedOnColumn.CodeName   = "UpdatedOn";
            CreatedByColumn.CodeName   = "CreatedBy";
            CreatedOnColumn.CodeName   = "CreatedOn";
        }
예제 #6
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.UsersTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.UsersRecord");
            this.ApplicationName = "RatTrap";
            this.DataAdapter     = new UsersSqlTable();
            ((UsersSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            UserId0Column.CodeName   = "UserId0";
            UserName0Column.CodeName = "UserName0";
            FirstNameColumn.CodeName = "FirstName";
            LastNameColumn.CodeName  = "LastName";
            PasswordColumn.CodeName  = "Password";
            UpdatedByColumn.CodeName = "UpdatedBy";
            UpdatedOnColumn.CodeName = "UpdatedOn";
            CreatedByColumn.CodeName = "CreatedBy";
            CreatedOnColumn.CodeName = "CreatedOn";
            eMailColumn.CodeName     = "eMail";
        }
예제 #7
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.TrapRecordsTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.TrapRecordsRecord");
            this.ApplicationName = "RatTrap";
            this.DataAdapter     = new TrapRecordsSqlTable();
            ((TrapRecordsSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            TrapRecordIdColumn.CodeName          = "TrapRecordId";
            TrapIdColumn.CodeName      = "TrapId";
            BaitTypeColumn.CodeName    = "BaitType";
            DateOfCheckColumn.CodeName = "DateOfCheck";
            DateOfCheckColumn.Name     = EvaluateFormula("\"Date Checked\"");
            SpeciesColumn.CodeName     = "Species";
            SexColumn.CodeName         = "Sex";
            CommentColumn.CodeName     = "Comment";
            LocationIdColumn.CodeName  = "LocationId";
            ProjectIdColumn.CodeName   = "ProjectId";
            GroupIdColumn.CodeName     = "GroupId";
            TrapTypeIdColumn.CodeName  = "TrapTypeId";
            UserId0Column.CodeName     = "UserId0";
            UpdatedByColumn.CodeName   = "UpdatedBy";
            UpdatedOnColumn.CodeName   = "UpdatedOn";
            CreatedByColumn.CodeName   = "CreatedBy";
            CreatedOnColumn.CodeName   = "CreatedOn";
        }
예제 #8
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.ContactsTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.ContactsRecord");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new ContactsSqlTable();
            ((ContactsSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            ContactIdColumn.CodeName             = "ContactId";
            Address1Column.CodeName            = "Address1";
            Address1Column.Name                = EvaluateFormula("\"Address\"");
            Address2Column.CodeName            = "Address2";
            Address3Column.CodeName            = "Address3";
            HometownIdColumn.CodeName          = "HometownId";
            MobileNumberColumn.CodeName        = "MobileNumber";
            PSNZMembershipCheckColumn.CodeName = "PSNZMembershipCheck";
            PSNZMemberColumn.CodeName          = "PSNZMember";
            EmailColumn.CodeName               = "Email";
            PSNZAppliedForColumn.CodeName      = "PSNZAppliedFor";
            FirstNameColumn.CodeName           = "FirstName";
            LastNameColumn.CodeName            = "LastName";
            RecordDeletedColumn.CodeName       = "RecordDeleted";
            RecordDeletedColumn.DefaultValue   = EvaluateFormula("\"false\"");
            NZIPPMemberColumn.CodeName         = "NZIPPMember";
        }
예제 #9
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.FieldTripChoicesTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.FieldTripChoicesRecord");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new FieldTripChoicesSqlTable();
            ((FieldTripChoicesSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            FieldTripChoiceIdColumn.CodeName     = "FieldTripChoiceId";
            FieldTripOptionIdColumn.CodeName     = "FieldTripOptionId";
            FieldTripOptionIdColumn.Name         = EvaluateFormula("\"First Choice\"");
            RegistrationIdColumn.CodeName        = "RegistrationId";
            FieldTripOptionId2Column.CodeName    = "FieldTripOptionId2";
            FieldTripOptionId2Column.Name        = EvaluateFormula("\"Second Choice\"");
            FieldTripOptionId3Column.CodeName    = "FieldTripOptionId3";
            FieldTripOptionId3Column.Name        = EvaluateFormula("\"Third Choice\"");
            FieldTripIdColumn.CodeName           = "FieldTripId";
            RecordDeletedColumn.CodeName         = "RecordDeleted";
            RecordDeletedColumn.DefaultValue     = EvaluateFormula("\"false\"");
            FieldTripAllocatedColumn.CodeName    = "FieldTripAllocated";
        }
예제 #10
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.View_FieldTripSelectionsView");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.View_FieldTripSelectionsRecord");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new View_FieldTripSelectionsSqlView();
            ((View_FieldTripSelectionsSqlView)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            ContactIdColumn.CodeName             = "ContactId";
            ValidationUidColumn.CodeName         = "ValidationUid";
            DatePaidColumn.CodeName            = "DatePaid";
            InitialCreationDateColumn.CodeName = "InitialCreationDate";
            FieldTripIdColumn.CodeName         = "FieldTripId";
            FirstChoiceIdColumn.CodeName       = "FirstChoiceId";
            SecondChoiceIdColumn.CodeName      = "SecondChoiceId";
            ThirdChoiceIdColumn.CodeName       = "ThirdChoiceId";
            AllocatedIdColumn.CodeName         = "AllocatedId";
            AllocatedIdColumn.Name             = EvaluateFormula("\"Allocated Field Trip\"");
            RecIdColumn.CodeName      = "RecId";
            PaymentRefColumn.CodeName = "PaymentRef";
        }
예제 #11
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.RegistrationTypesTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.RegistrationTypesRecord");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new RegistrationTypesSqlTable();
            ((RegistrationTypesSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            RegistrationTypeIdColumn.CodeName    = "RegistrationTypeId";
            EventIdColumn.CodeName                = "EventId";
            EventIdColumn.DefaultValue            = EvaluateFormula("Session(\"ActiveEventId\")");
            RegistrationTypeColumn.CodeName       = "RegistrationType";
            CostMemberColumn.CodeName             = "CostMember";
            CostNonMemberColumn.CodeName          = "CostNonMember";
            CostNonMemberColumn.Name              = EvaluateFormula("\"Cost Non Member\"");
            Default0Column.CodeName               = "Default0";
            ActiveOptionColumn.CodeName           = "ActiveOption";
            ActiveOptionColumn.DefaultValue       = EvaluateFormula("\"true\"");
            MaximumNumberColumn.CodeName          = "MaximumNumber";
            InactiveOnMaxColumn.CodeName          = "InactiveOnMax";
            ActivateOnInactiveTypeColumn.CodeName = "ActivateOnInactiveType";
            InactiveTypeColumn.CodeName           = "InactiveType";
        }
예제 #12
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.HomeTownsTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.HomeTownsRecord");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new HomeTownsSqlTable();
            ((HomeTownsSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            HomeTownIdColumn.CodeName            = "HomeTownId";
            TownNameColumn.CodeName = "TownName";
        }
예제 #13
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.SexTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.SexRecord");
            this.ApplicationName = "RatTrap";
            this.DataAdapter     = new SexSqlTable();
            ((SexSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            SexIdColumn.CodeName   = "SexId";
            SexColumn.CodeName     = "Sex";
            SexColumn.DefaultValue = EvaluateFormula("\"Unknown\"");
        }
예제 #14
0
    protected virtual void Initialize()
    {
        XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);
        this.TableDefinition = new TableDefinition();
        this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.PhotoClubsTable");
        def.InitializeTableDefinition(this.TableDefinition);
        this.ConnectionName = def.GetConnectionName();
        this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.PhotoClubsRecord");
        this.ApplicationName = "OLR";
        this.DataAdapter = new PhotoClubsSqlTable();
        ((PhotoClubsSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;
		
        this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
        PhotoClubIdColumn.CodeName = "PhotoClubId";
        DescriptionColumn.CodeName = "Description";

        
    }
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.UsersGroupsLinkTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.UsersGroupsLinkRecord");
            this.ApplicationName = "RatTrap";
            this.DataAdapter     = new UsersGroupsLinkSqlTable();
            ((UsersGroupsLinkSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            UserGroupsIdColumn.CodeName          = "UserGroupsId";
            UserId0Column.CodeName = "UserId0";
            GroupIdColumn.CodeName = "GroupId";
        }
예제 #16
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.ConfigurationTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.ConfigurationRecord");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new ConfigurationSqlTable();
            ((ConfigurationSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            ConfigurationIdColumn.CodeName       = "ConfigurationId";
            EventIdColumn.CodeName            = "EventId";
            EventIdColumn.DefaultValue        = EvaluateFormula("1");
            SendEmailCopiesColumn.CodeName    = "SendEmailCopies";
            EmailCopiesAddressColumn.CodeName = "EmailCopiesAddress";
        }
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.PhotoClubContactLinksTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.PhotoClubContactLinksRecord");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new PhotoClubContactLinksSqlTable();
            ((PhotoClubContactLinksSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            ContactIdColumn.CodeName             = "ContactId";
            PhotoClubIdColumn.CodeName           = "PhotoClubId";
            PhotoClubContactIdColumn.CodeName    = "PhotoClubContactId";
            RecordDeletedColumn.CodeName         = "RecordDeleted";
            RecordDeletedColumn.DefaultValue     = EvaluateFormula("\"false\"");
        }
예제 #18
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.FieldTripOptionsTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.FieldTripOptionsRecord");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new FieldTripOptionsSqlTable();
            ((FieldTripOptionsSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            FieldTripOptionIdColumn.CodeName     = "FieldTripOptionId";
            FieldTripIdColumn.CodeName           = "FieldTripId";
            PlacesAvailableColumn.CodeName       = "PlacesAvailable";
            DescriptionColumn.CodeName           = "Description";
            CostColumn.CodeName = "Cost";
        }
예제 #19
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.OtherCostsTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.OtherCostsRecord");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new OtherCostsSqlTable();
            ((OtherCostsSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            OtherCostIdColumn.CodeName           = "OtherCostId";
            CostDescriptionColumn.CodeName       = "CostDescription";
            CostColumn.CodeName        = "Cost";
            EventIdColumn.CodeName     = "EventId";
            EventIdColumn.DefaultValue = EvaluateFormula("Session(\"ActiveEventId\")");
        }
예제 #20
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.Roles1Table");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.Roles1Record");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new Roles1SqlTable();
            ((Roles1SqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            RoleIDColumn.CodeName    = "RoleID";
            RoleNameColumn.CodeName  = "RoleName";
            CreatedByColumn.CodeName = "CreatedBy";
            UpdatedByColumn.CodeName = "UpdatedBy";
            CreatedOnColumn.CodeName = "CreatedOn";
            UpdatedOnColumn.CodeName = "UpdatedOn";
        }
예제 #21
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.GroupsTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.GroupsRecord");
            this.ApplicationName = "RatTrap";
            this.DataAdapter     = new GroupsSqlTable();
            ((GroupsSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            GroupIdColumn.CodeName   = "GroupId";
            GroupNameColumn.CodeName = "GroupName";
            UpdatedByColumn.CodeName = "UpdatedBy";
            UpdatedOnColumn.CodeName = "UpdatedOn";
            CreatedByColumn.CodeName = "CreatedBy";
            CreatedOnColumn.CodeName = "CreatedOn";
        }
예제 #22
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.WorkshopsTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.WorkshopsRecord");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new WorkshopsSqlTable();
            ((WorkshopsSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            WorkshopIdColumn.CodeName            = "WorkshopId";
            RegistrationIdColumn.CodeName        = "RegistrationId";
            AvailableWorkshopIdColumn.CodeName   = "AvailableWorkshopId";
            AttendingColumn.CodeName             = "Attending";
            AttendingColumn.Name         = EvaluateFormula("\"Attending?\"");
            RecordDeletedColumn.CodeName = "RecordDeleted";
        }
예제 #23
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.EventsTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.EventsRecord");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new EventsSqlTable();
            ((EventsSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            EventIdColumn.CodeName       = "EventId";
            EventNameColumn.CodeName     = "EventName";
            GIDColumn.CodeName           = "GID";
            ActiveColumn.CodeName        = "Active";
            ContactEmailColumn.CodeName  = "ContactEmail";
            AccountNumberColumn.CodeName = "AccountNumber";
        }
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.View_Trap_SummaryView");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("RatTrap.Business", "RatTrap.Business.View_Trap_SummaryRecord");
            this.ApplicationName = "RatTrap";
            this.DataAdapter     = new View_Trap_SummarySqlView();
            ((View_Trap_SummarySqlView)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            SexColumn.CodeName          = "Sex";
            SpeciesColumn.CodeName      = "Species";
            BaitTypeColumn.CodeName     = "BaitType";
            CreatedByColumn.CodeName    = "CreatedBy";
            GroupIdColumn.CodeName      = "GroupId";
            UserId0Column.CodeName      = "UserId0";
            TrapRecordIdColumn.CodeName = "TrapRecordId";
        }
예제 #25
0
        protected virtual void Initialize()
        {
            XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);

            this.TableDefinition = new TableDefinition();
            this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.FieldTripsTable");
            def.InitializeTableDefinition(this.TableDefinition);
            this.ConnectionName  = def.GetConnectionName();
            this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("OLR.Business", "OLR.Business.FieldTripsRecord");
            this.ApplicationName = "OLR";
            this.DataAdapter     = new FieldTripsSqlTable();
            ((FieldTripsSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;

            this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
            FieldTripIdColumn.CodeName           = "FieldTripId";
            DescriptionColumn.CodeName           = "Description";
            Date0Column.CodeName           = "Date0";
            TimeColumn.CodeName            = "Time";
            EventIdColumn.CodeName         = "EventId";
            EventIdColumn.DefaultValue     = EvaluateFormula("Session(\"ActiveEventId\")");
            DisplaySequenceColumn.CodeName = "DisplaySequence";
        }
예제 #26
0
 protected virtual void Initialize()
 {
     XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);
     this.TableDefinition = new TableDefinition();
     this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.VwSiteView");
     def.InitializeTableDefinition(this.TableDefinition);
     this.ConnectionName = def.GetConnectionName();
     this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.VwSiteRecord");
     this.ApplicationName = "FPCEstimate";
     this.DataAdapter = new VwSiteSqlView();
     ((VwSiteSqlView)this.DataAdapter).ConnectionName = this.ConnectionName;
     ((VwSiteSqlView)this.DataAdapter).ApplicationName = this.ApplicationName;
     this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
     SiteIDColumn.CodeName = "SiteID";
     SiteNoColumn.CodeName = "SiteNo";
     SiteNoColumn.Name = EvaluateFormula("\"Site #\"");
     SiteNameColumn.CodeName = "SiteName";
     SiteAddrColumn.CodeName = "SiteAddr";
     SiteCityColumn.CodeName = "SiteCity";
     SiteStateColumn.CodeName = "SiteState";
     SiteZipColumn.CodeName = "SiteZip";
 }
예제 #27
0
 protected virtual void Initialize()
 {
     XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);
     this.TableDefinition = new TableDefinition();
     this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.UsersTable");
     def.InitializeTableDefinition(this.TableDefinition);
     this.ConnectionName = def.GetConnectionName();
     this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.UsersRecord");
     this.ApplicationName = "FPCEstimate";
     this.DataAdapter = new UsersSqlTable();
     ((UsersSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;
     ((UsersSqlTable)this.DataAdapter).ApplicationName = this.ApplicationName;
     this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
     UserId0Column.CodeName = "UserId0";
     UserName0Column.CodeName = "UserName0";
     UserPassword0Column.CodeName = "UserPassword0";
 }
예제 #28
0
 protected virtual void Initialize()
 {
     XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);
     this.TableDefinition = new TableDefinition();
     this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.EstimateTable");
     def.InitializeTableDefinition(this.TableDefinition);
     this.ConnectionName = def.GetConnectionName();
     this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.EstimateRecord");
     this.ApplicationName = "FPCEstimate";
     this.DataAdapter = new EstimateSqlTable();
     ((EstimateSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;
     ((EstimateSqlTable)this.DataAdapter).ApplicationName = this.ApplicationName;
     this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
     EstimateIDColumn.CodeName = "EstimateID";
     EstimateNameColumn.CodeName = "EstimateName";
     SiteIDColumn.CodeName = "SiteID";
     StatusColumn.CodeName = "Status";
     StatusColumn.DefaultValue = EvaluateFormula("1");
     CreatedDateColumn.CodeName = "CreatedDate";
     CreatedByColumn.CodeName = "CreatedBy";
     CreatedByIDColumn.CodeName = "CreatedByID";
     LastEditDateColumn.CodeName = "LastEditDate";
     LastEditByColumn.CodeName = "LastEditBy";
     LastEditByIDColumn.CodeName = "LastEditByID";
 }
예제 #29
0
 protected virtual void Initialize()
 {
     XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);
     this.TableDefinition = new TableDefinition();
     this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.VwCategoryView");
     def.InitializeTableDefinition(this.TableDefinition);
     this.ConnectionName = def.GetConnectionName();
     this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.VwCategoryRecord");
     this.ApplicationName = "FPCEstimate";
     this.DataAdapter = new VwCategorySqlView();
     ((VwCategorySqlView)this.DataAdapter).ConnectionName = this.ConnectionName;
     ((VwCategorySqlView)this.DataAdapter).ApplicationName = this.ApplicationName;
     this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
     CatIDColumn.CodeName = "CatID";
     ParentCatIDColumn.CodeName = "ParentCatID";
     lvlColumn.CodeName = "lvl";
     CatNameColumn.CodeName = "CatName";
     StatusColumn.CodeName = "Status";
 }
 protected virtual void Initialize()
 {
     XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);
     this.TableDefinition = new TableDefinition();
     this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.VwPropSBondBudgetView");
     def.InitializeTableDefinition(this.TableDefinition);
     this.ConnectionName = def.GetConnectionName();
     this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.VwPropSBondBudgetRecord");
     this.ApplicationName = "FPCEstimate";
     this.DataAdapter = new VwPropSBondBudgetSqlView();
     ((VwPropSBondBudgetSqlView)this.DataAdapter).ConnectionName = this.ConnectionName;
     ((VwPropSBondBudgetSqlView)this.DataAdapter).ApplicationName = this.ApplicationName;
     this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
     ID0Column.CodeName = "ID0";
     DeptIDColumn.CodeName = "DeptID";
     categoryColumn.CodeName = "category";
     TotalColumn.CodeName = "Total";
 }
예제 #31
0
 protected virtual void Initialize()
 {
     XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);
     this.TableDefinition = new TableDefinition();
     this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.VwAreaView");
     def.InitializeTableDefinition(this.TableDefinition);
     this.ConnectionName = def.GetConnectionName();
     this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.VwAreaRecord");
     this.ApplicationName = "FPCEstimate";
     this.DataAdapter = new VwAreaSqlView();
     ((VwAreaSqlView)this.DataAdapter).ConnectionName = this.ConnectionName;
     ((VwAreaSqlView)this.DataAdapter).ApplicationName = this.ApplicationName;
     this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
     AreaIDColumn.CodeName = "AreaID";
     BldgIDColumn.CodeName = "BldgID";
     RoomNoColumn.CodeName = "RoomNo";
     UnitIDColumn.CodeName = "UnitID";
     AreaDescColumn.CodeName = "AreaDesc";
     AreaSqFtColumn.CodeName = "AreaSqFt";
     AreaFloorNoColumn.CodeName = "AreaFloorNo";
 }
예제 #32
0
 protected virtual void Initialize()
 {
     XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);
     this.TableDefinition = new TableDefinition();
     this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.RolesTable");
     def.InitializeTableDefinition(this.TableDefinition);
     this.ConnectionName = def.GetConnectionName();
     this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.RolesRecord");
     this.ApplicationName = "FPCEstimate";
     this.DataAdapter = new RolesSqlTable();
     ((RolesSqlTable)this.DataAdapter).ConnectionName = this.ConnectionName;
     ((RolesSqlTable)this.DataAdapter).ApplicationName = this.ApplicationName;
     this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
     RoleIDColumn.CodeName = "RoleID";
     RoleNameColumn.CodeName = "RoleName";
     RoleDescColumn.CodeName = "RoleDesc";
 }
예제 #33
0
 protected virtual void Initialize()
 {
     XmlTableDefinition def = new XmlTableDefinition(TableDefinitionString);
     this.TableDefinition = new TableDefinition();
     this.TableDefinition.TableClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.VwBldgView");
     def.InitializeTableDefinition(this.TableDefinition);
     this.ConnectionName = def.GetConnectionName();
     this.RecordClassName = System.Reflection.Assembly.CreateQualifiedName("FPCEstimate.Business", "FPCEstimate.Business.VwBldgRecord");
     this.ApplicationName = "FPCEstimate";
     this.DataAdapter = new VwBldgSqlView();
     ((VwBldgSqlView)this.DataAdapter).ConnectionName = this.ConnectionName;
     ((VwBldgSqlView)this.DataAdapter).ApplicationName = this.ApplicationName;
     this.TableDefinition.AdapterMetaData = this.DataAdapter.AdapterMetaData;
     BldgIDColumn.CodeName = "BldgID";
     SiteIDColumn.CodeName = "SiteID";
     BldgNameColumn.CodeName = "BldgName";
     SiteNoColumn.CodeName = "SiteNo";
     BldgCodeColumn.CodeName = "BldgCode";
     BldgNoColumn.CodeName = "BldgNo";
     BldgSqFtColumn.CodeName = "BldgSqFt";
 }