Back to Home

Back to Samples

Samples SQL

Table of Contents

• Overview
• Stored Procedures
• Tables
• Dynamic Samples

Overview

tables and stored procedures associated with Inspection Types

Stored Procedures

• [smart].[p11_Get_DynamicIntakeForm]
• [smart].[p11_Get_DynamicIntakeFields]
• [smart].[p11_Get_DynamicIntakeOptions]
• [smart].[p11_Save_DynamicIntakeForm]
• [smart].[p11_Save_DynamicIntakeFields]
• [smart].[p11_Save_DynamicIntakeOptions]

Tables

• [smart].[P11_Dynamic_IntakeForm]
• [smart].[p11_Dynamic_IntakeField]
• [smart].[p11_Dynamic_IntakeOption]
• [smart].[p11_CodeList]

Dynamic Samples

A Sample's fields in detailsview are dynamically shown depending on the Fields and Options saved in the Setup Intake Form page

• DynamicIntakeField
  • Fields shown in the detailsview
  • Option1 checks for New Intake Forms
  • Option2 Field holds Validate ID
  • Option7 is the InspectionTypeNo
    • See p11_Get_DynamicFields stored procedure
    • See sub_Initialize_DynamicFields() in p11_uc_IntakeFormNew.ascx.cs page for example
• DynamicIntakeOption
  • Options pertaining to the InspectionType's Field (DynamicField)
  • Option1 is the Order of Sequence of the Field's datatypes: Checkboxes, Radiobuttons, etc)
  • Option2 - If value = 'True', then the field's option is preselected by default
  • Option7 is the InspectionTypeNo
    • See p11_Get_Dynamic stored procedure
    • See sub_Initialize_DynamicOptions() in p11_uc_IntakeFormNew.ascx.cs page for example