Get page content dynamically from Sql server database MVC 5

Question

I want to get the info into an li element from SQL Server database in MVC 5 with ADO.NET entity data model.

This is my generated model.edmx

public partial class Entities : DbContext
    {
        public Entities()
            : base("name=Entities")
        {
        }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            throw new UnintentionalCodeFirstException();
        }

        public virtual DbSet<C__MigrationHistory> C__MigrationHistory { get; set; }

        public virtual DbSet<PackageType> PackageTypes { get; set; }
    }

I have a table named PackageTypes that has 3 columns Id, Name, and PackagesInDeal.

<li class="pricing-title">
                            @Html.DisplayFor(model => @Model.Name) @*Free*@
                        </li>

In this li element I need to get the Name values from the table.

I'm not very familiar on how can I add two functionalities to a controller

public ActionResult Create( int? id ) {
            ViewBag.UserId = new SelectList( db.AspNetUsers, "Id", "Email" );
            ViewBag.PackageTypeId = new SelectList( db.PackageTypes, "Id", "Name" );
            ViewBag.SelectedPackage = id;
            return View();
        }

This is the code contained by the controller, that displays 1,2, 3 or 4 deals depending on the id parameter.

The view has the following code:

 @if ( ( ViewBag.SelectedPackage ?? 0 ) <= 1 ) {
                <div class="col-lg-3 wow zoomIn" style="padding: 0;">
                    <ul class="pricing-plan list-unstyled selected" style="margin: 20px;">

@Html.DisplayFor(model => @Model.Name) @Free@

                        <li class="pricing-desc">
                            Basic package
                            <br />
                        </li>
                        <li class="pricing-price">
                            <span>00</span> / month
                        </li>
                        <li> <i class="fa fa-trophy"></i> aa </li>
                        <li> <i class="fa fa-globe"></i> bb </li>
                        <li> <i class="fa fa-suitcase"></i> cc</li>
                        <li class="selected"> <i class="fa fa-bell"></i>dd </li>
                        <li> <i class="fa fa-database"></i> ee </li>
                        <li> <i class="fa fa-envelope"></i> ff </li>
                        <li>
                            <div style="text-align: right; height: 110px;">
                            </div>
                        </li>
                        <li style="padding-top: 30px;">
                            <a class="btn btn-primary btn-xs" href="@Url.Action( "Create", "Deals", new { deal=Request.QueryString["deal"] } )" rel="1">Buy</a>
                        </li>
                    </ul>
                </div>
            }
@if ( ( ViewBag.SelectedPackage ?? 0 ) <= 2 ) {
                <div class="col-lg-3 wow zoomIn" style="padding: 0;">
                    <ul class="pricing-plan list-unstyled selected" style="margin: 20px;">
                        <li class="pricing-title">
                            Free + Domain
                        </li>
                        <li class="pricing-desc">
                            Basic package
                        </li>
                        <li class="pricing-price">
                            <span>10 </span> / month
                        </li>
                        <li> <i class="fa fa-trophy"></i> aa</li>
                        <li> <i class="fa fa-globe"></i> bb </li>
                        <li> <i class="fa fa-suitcase"></i> cc</li>
                        <li class="selected"> <i class="fa fa-bell"></i> dd</li>
                        <li> <i class="fa fa-database"></i> ee </li>
                        <li> <i class="fa fa-envelope"></i> ff </li>
                        <li>
                            @Html.Partial( "FreeDomain" )
                        </li>

                        <li style="padding-top: 30px;">
                            <a class="btn btn-primary btn-xs" href="@Url.Action( "Create", "Deals", new { deal=Request.QueryString["deal"] } )" rel="1">buy</a>
                        </li>
                    </ul>
                </div>
            }

So how can I retrieve the "Free" , "Free + Domain" and rest of the information in the li from the sql server database tables??

You should create a new ViewModel for displaying the data, rather than than using ViewBag — Amal Dev
– Amal Dev, Commented May 17, 2015 at 11:59
And can I retrieve data from 2 or more tables using the same controller in the same view? — Andrei Maieras
– Andrei Maieras, Commented May 17, 2015 at 12:43
In the action method you can fetch data from different tables/models and then assign that to the newly created view model dotnet-tricks.com/Tutorial/mvc/… — Amal Dev
– Amal Dev, Commented May 17, 2015 at 13:02
So basically I need to change my controller, get rid of ViewBag from it, and also change the logic in the view ? Can't there be any workaround to just add what I want and not delete(modify) existing code? — Andrei Maieras
– Andrei Maieras, Commented May 18, 2015 at 8:12
You can always use MVC scaffloding to generate controller / views for a given data model entity. asp.net/visual-studio/overview/2013/aspnet-scaffolding-overview — Carl Prothman
– Carl Prothman, Commented May 18, 2015 at 20:28

Carl Prothman · Accepted Answer · 2015-05-18 20:29:04Z

2

You can always use MVC scaffolding to generate controller / views for a given data model entity. http://www.asp.net/visual-studio/overview/2013/aspnet-scaffolding-overview

answered May 18, 2015 at 20:29

Carl Prothman

1,55113 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Andrei Maieras · Accepted Answer · 2020-01-10 13:19:46Z

So after long research on the web I finally obtained what I've wanted. So the controller looks like this

public ActionResult Create(int? id)
            {
            List<PackageType> packageTypes = db.PackageTypes.ToList();
            ViewBag.PackageTypesName = packageTypes;
            ViewBag.SelectedPackage = id;
            return View();
            }

And the view

@if ((ViewBag.SelectedPackage ?? 0) <= 1)
                {
                <div class="col-lg-3 wow zoomIn" style="padding: 0;">
                    <ul class="pricing-plan list-unstyled selected" style="margin: 20px;">
                        <li class="pricing-title">
                            **@ViewBag.PackageTypesName[0].Name**
                        </li>
                        <li class="pricing-desc">
                            Basic package
                            <br />
                        </li>
                        <li class="pricing-price">
                            <span>00</span> / month
                        </li>
                        <li> <i class="fa fa-trophy"></i> aa </li>
                        <li> <i class="fa fa-globe"></i> bb </li>


<li> <i class="fa fa-suitcase"></i> cc</li>
                    <li class="selected"> <i class="fa fa-bell"></i>dd </li>
                    <li> <i class="fa fa-database"></i> ee </li>
                    <li> <i class="fa fa-envelope"></i> ff </li>
                    <li>
                        <div style="text-align: right; height: 110px;">
                        </div>
                    </li>
                    <li style="padding-top: 30px;">
                        <a class="btn btn-primary btn-xs" href="@Url.Action("Create", "Deals", new { deal = Request.QueryString["deal"] })" rel="1">Buy</a>
                    </li>
                </ul>
            </div>
            }

Collectives™ on Stack Overflow

Get page content dynamically from Sql server database MVC 5

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related