Build Complete Applications with T-SQL

-- Create an order entry form with validation
DECLARE @CustomerID NVARCHAR(MAX);
DECLARE @ProductID NVARCHAR(MAX);
DECLARE @Quantity NVARCHAR(MAX);
DECLARE @SubmitButton NVARCHAR(MAX);
DECLARE @Message NVARCHAR(MAX);

-- Get form values from modal
EXEC sp_api_modal_get_value @name=N'@CustomerID', @value=@CustomerID OUT;
EXEC sp_api_modal_get_value @name=N'@ProductID', @value=@ProductID OUT;
EXEC sp_api_modal_get_value @name=N'@Quantity', @value=@Quantity OUT;
EXEC sp_api_modal_get_value @name=N'@SubmitButton', @value=@SubmitButton OUT;

-- Display form title
EXEC sp_api_modal_text @text = N'New Order Entry', @class = N'h3';

-- Customer dropdown
EXEC sp_api_modal_select
    @name = N'@CustomerID',
    @value = @CustomerID OUT,
    @card_name = N'customers',
    @placeholder = N'Select Customer';
    
-- Product dropdown
EXEC sp_api_modal_select
    @name = N'@ProductID',
    @value = @ProductID OUT,
    @card_name = N'products',
    @placeholder = N'Select Product';
    
-- Quantity input
EXEC sp_api_modal_input_decimal
    @name = N'@Quantity',
    @value = @Quantity OUT,
    @placeholder = N'Enter Quantity';
    
-- Submit button
EXEC sp_api_modal_button
    @name = N'@SubmitButton',
    @value = N'Create Order',
    @valueout = @SubmitButton OUT,
    @class = N'btn-primary';

-- Handle form submission
IF @SubmitButton IS NOT NULL
BEGIN
    -- Validation
    IF @CustomerID IS NULL OR @ProductID IS NULL OR ISNULL(@Quantity, N'') = N''
    BEGIN
        SET @Message = N'Please fill in all required fields';
        EXEC sp_api_toast @text = @Message, @class = N'btn-warning';
        RETURN;
    END
    
    -- Insert order into database
    INSERT INTO orders (customer_id, product_id, quantity)
    VALUES (@CustomerID, @ProductID, @Quantity);
    
    SET @Message = N'Order created successfully';
    EXEC sp_api_toast @text = @Message, @class = N'btn-success';
    EXEC sp_api_modal_clear;
END