Store the data from the form into the database according to the radio button choice

Question

Store the data from the form into the database according to the radio button choice

I feel like a fish out of water here...freshly dipping my toes into the ASP.net world, but finding it quite fascinating so far.

Let me begin at the starting line:

Background: I am currently working on an ASP.net MVC5 application that involves user login information. Users will be able to create accounts, receive messages, and more. The key feature is a form on the site where users can submit information using a Conditional Logic HTML Form with radio buttons, text areas, and other elements. My ultimate objective is to allow users to fill out and submit the form, save it to the MySQL database, send an email to both the admin and the user with the selected details, and display their responses in their "Account Dashboard" section.

Problem: I'm facing a challenge in extracting user-submitted information based on their radio button selection in the HTML Form, which can fall under three different scenarios:

Web Project
2D Design Project
3D Design Project

For instance, if a user selects "Web" instead of "Graphic" in the "Project Type" field, they should only be submitting values related to "Web". However, I'm uncertain about the best approach to tackle this issue...

Here's a snippet of the code I've started working on for when a user chooses a Web project for submission to the database:

if (IsPost) && (RadioButton.projectType.Equals(Web))
{
    projectType = Request.Form["Web"];
    TypeOfWebsite = Request.Form["TypeOfWebsite"];
    DeviceExperience = Request.Form["DeviceExperience"];
}

Below are the form values:

<form method="post">
        <br />

        <!--Form fields go here-->

    </form>

I have referred to various MSDN tutorials to gain a better understanding:

However, these resources haven't provided clear guidance on how to implement the three conditional statements necessary for my form:

"If user selects Project Type = "Web" and submits the form, save the data to the database"
"If user selects Project Type = "Graphic" and Dimension = "2D" upon form submission, store the relevant values"
"If user selects Project Type = "Graphic" and Dimension = "3D" when submitting the form, save the corresponding values to the database"

Recap:

How do I write the conditional statement to achieve this?
Should I reconsider the HTML form structure I'm currently using in favor of ASP Web Pages?

I have also implemented some JavaScript to dynamically display available form values based on user selections. It's functioning as expected! I now need assistance in linking this information to the database for user profile usage. Any insights or solutions would be greatly appreciated!

c#javascript mysql asp.net-mvc forms

Answer 1

Answer №1

This is quite a complex form, but I'll simplify it for you by reducing the number of fields to demonstrate the MVC approach.

It seems like you're not fully utilizing MVC (Model-View-Controller) in your code. Models play a crucial role in MVC architecture, so it's recommended to include them in your project. Let's consider the following models...

public class ProjectTypeModel
{
    public string Name { get; set; }
}

public class TestModel
{
    public IList<ProjectTypeModel> Types { get; set; }
}

Your view should reference these models at the top of the file, like this...

@model  MvcTest.Models.TestModel

Now, let's simplify the form design with the following structure...

@using(Html.BeginForm("ProcessTypes","Home")){
    <div class="row">
        <label class="formquestion col-md-3">Project Type: </label>
        <span class="col-md-8">

            @foreach (var p in Model.Types)
            {
                <input id="@("radio_" + p.Name)" type="radio" name="SelectedProjectType" value="@p.Name" />
                <label for="@("radio_" + p.Name)">@p.Name</label>
            }

        </span>

    </div>

    <input type="submit" name="SubmitForm" class="btn btn-info btn-large" value="Submit Form" />
    }

Just ensure that radio buttons share the same name attribute and have unique ids for label association. The form submits data to the "ProcessTypes" action in the Home controller...

Your Home controller's action might look like this...

public ActionResult ProcessTypes(string SelectedProjectType)
        {

            // processing logic...
       }

In this simplified example, the SelectedProjectType variable will hold the selected radio button value ("Web" or "Design"). This overview should give you a basic understanding of MVC and Razor syntax. There's more to explore, so keep learning!

Answer 2

This is quite a complex form, but I'll simplify it for you by reducing the number of fields to demonstrate the MVC approach.

It seems like you're not fully utilizing MVC (Model-View-Controller) in your code. Models play a crucial role in MVC architecture, so it's recommended to include them in your project. Let's consider the following models...

public class ProjectTypeModel
{
    public string Name { get; set; }
}

public class TestModel
{
    public IList<ProjectTypeModel> Types { get; set; }
}

Your view should reference these models at the top of the file, like this...

@model  MvcTest.Models.TestModel

Now, let's simplify the form design with the following structure...

@using(Html.BeginForm("ProcessTypes","Home")){
    <div class="row">
        <label class="formquestion col-md-3">Project Type: </label>
        <span class="col-md-8">

            @foreach (var p in Model.Types)
            {
                <input id="@("radio_" + p.Name)" type="radio" name="SelectedProjectType" value="@p.Name" />
                <label for="@("radio_" + p.Name)">@p.Name</label>
            }

        </span>

    </div>

    <input type="submit" name="SubmitForm" class="btn btn-info btn-large" value="Submit Form" />
    }

Just ensure that radio buttons share the same name attribute and have unique ids for label association. The form submits data to the "ProcessTypes" action in the Home controller...

Your Home controller's action might look like this...

public ActionResult ProcessTypes(string SelectedProjectType)
        {

            // processing logic...
       }

In this simplified example, the SelectedProjectType variable will hold the selected radio button value ("Web" or "Design"). This overview should give you a basic understanding of MVC and Razor syntax. There's more to explore, so keep learning!

Store the data from the form into the database according to the radio button choice

Answer №1

Similar questions

Would you mind providing some clarification on these two JavaScript examples?

Error: The module cannot be found due to a resolution issue when trying to import the Vue.js component './app/index.vue' using ES6 syntax

Adding the Load More feature to your WordPress template for displaying custom posts

How are single and double quotation marks utilized in SQL databases?

Tips for creating a stylish ReactJs Header component that stays fixed at the top of the page

How can I create a new PHP table using data from an existing table?

Ways to access Angular controllers from various folders

Challenges encountered when trying to save a json document

jQuery is not active on responsive designs

Using TypeScript and webpack 2 to integrate typeahead.js into your project

Trouble with linkage in jQuery for AJAX requests in an external .js document

The exception ResourceClosed is being thrown by my servlet

Enzyme fails to locate text within a div even though it is present

How can I retrieve a formController in AngularJS?

Can't seem to res.send using Express framework

CSS transition fails to revert

Tips for setting react-native image source dynamically in a flat list

Exploring the variations between getRequestHandler and render functions in Custom Next.js applicationsIn a

At what precise scenarios do synchronous continuations pose a risk?

Having trouble with my ajax request not functioning correctly