using Podium.Models;
using Podium.Models.viewmodels;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace Podium.Controllers
{
    public class LutaController : Controller
    {
        // GET: Luta
        public ActionResult Index()
        {
            ApplicationDbContext context = new ApplicationDbContext();
            List<CompetidoresViewModel> competidores = context.Database.SqlQuery<CompetidoresViewModel>("SP_CHAVES").ToList();

            CompetidoresViewModel[] chave = new CompetidoresViewModel[8];

            chave[0] = competidores.ElementAt(0);
            chave[1] = competidores.ElementAt(4);
            chave[2] = competidores.ElementAt(1);
            chave[3] = competidores.ElementAt(6);
            chave[4] = competidores.ElementAt(2);
            chave[5] = competidores.ElementAt(5);
            chave[6] = competidores.ElementAt(3);
            chave[7] = competidores.ElementAt(7);
            chave[8] = competidores.ElementAt(8);
            chave[9] = competidores.ElementAt(12);
            chave[10] = competidores.ElementAt(9);
            chave[11] = competidores.ElementAt(14);
            chave[12] = competidores.ElementAt(10);
            chave[13] = competidores.ElementAt(13);
            chave[14] = competidores.ElementAt(11);
            chave[15] = competidores.ElementAt(15);







            ViewBag.chave = chave;

            return View();
        }
    }
}