How can I pass two stored procedure results to one MVC view?

Question

In my Controller, I've added code to execute and retrieve for two stored procedures:

public ActionResult Index()
    {
        ViewBag.Message = "Modify this template to jump-start your ASP.NET MVC application.";

        var megaMean = _db.GetMegaMillionsMean();
        var powerMean = _db.GetPowerballMean();
        //object mega = null;
        List<mega> viewMega = megaMean.Select(p => new mega {ball1 = p.Ball_1_Average, ball2 = p.Ball_2_Average, ball3 = p.Ball_3_Average, ball4 = p.Ball_4_Average, ball5 = p.Ball_5_Average, megaball = p.MegaBall_Average}).ToList();
        List<power> viewPower = powerMean.Select(p => new power { ball1 = p.Ball_1_Average, ball2 = p.Ball_2_Average, ball3 = p.Ball_3_Average, ball4 = p.Ball_4_Average, ball5 = p.Ball_5_Average, powerball = p.Powerball_Average }).ToList();


        return View(viewMega);
    }

Currently I'm only able to pass one set of those results to my view:

@{
    foreach (var item in Model )
    {

        <tr>
            <td>
                @item.ball1
            </td>
            <td>
                @item.ball2
            </td>
            <td>
                @item.ball3
            </td>
            <td>
                @item.ball4
            </td>
            <td>
                @item.ball5
            </td>
            <td>
                @item.megaball
            </td>
        </tr>

Is there away that I can pass both of those stored procedure results to one view? Or at least any way that I can achieve this another way? Thanks!

you need a view model for this http://stackoverflow.com/questions/11064316/what-is-viewmodel-in-mvc — Matt Bodily, Nov 26 '13 at 14:30

score 3 · Accepted Answer · answered Nov 26 '13 at 14:36

Create a ViewModel...

public class PowerMega
{
   public List<mega> Megas {get;set;}
   public List<power> Powers {get;set;}
}

You can then create your ViewModel..

var megaMean = _db.GetMegaMillionsMean();
var powerMean = _db.GetPowerballMean();
var vm = new PowerMega();
vm.Megas = megaMean.Select(p => new mega {ball1 = p.Ball_1_Average, ball2 = p.Ball_2_Average, ball3 = p.Ball_3_Average, ball4 = p.Ball_4_Average, ball5 = p.Ball_5_Average, megaball = p.MegaBall_Average}).ToList();
vm.Powers = powerMean.Select(p => new power { ball1 = p.Ball_1_Average, ball2 = p.Ball_2_Average, ball3 = p.Ball_3_Average, ball4 = p.Ball_4_Average, ball5 = p.Ball_5_Average, powerball = p.Powerball_Average }).ToList();


return View(vm);

Your View would then need to be types like this...

@model namespace.PowerMega

Thanks! I forgot about ViewModels! – aqwright31 Nov 27 '13 at 11:28 — aqwright31, Nov 27 '13 at 11:28

score 0 · Answer 2 · answered Nov 26 '13 at 15:37

You could either pass via ViewBag and access the ViewBag items in View

var megaMean = _db.GetMegaMillionsMean();
var powerMean = _db.GetPowerballMean();
//object mega = null;
List<mega> viewMega = megaMean.Select(p => new mega {ball1 = p.Ball_1_Average, ball2 = p.Ball_2_Average, ball3 = p.Ball_3_Average, ball4 = p.Ball_4_Average, ball5 = p.Ball_5_Average, megaball = p.MegaBall_Average}).ToList();
List<power> viewPower = powerMean.Select(p => new power { ball1 = p.Ball_1_Average, ball2 = p.Ball_2_Average, ball3 = p.Ball_3_Average, ball4 = p.Ball_4_Average, ball5 = p.Ball_5_Average, powerball = p.Powerball_Average }).ToList();

ViewBag.MegaList = viewMega;
ViewBag.PowerList = viewPower;

Or create a viewModel and pass it to view as mentioned in the previous answer

How can I pass two stored procedure results to one MVC view?

2 Answers2