public IActionResult SectionE([FromForm] SectionE secE, string returnUrl = null)
        {
            ViewData["ReturnUrl"] = returnUrl;
            var test = User.Claims.ToList()
                       .Where(u => u.Type.Equals("http://schemas.xmlsoap.org/ws/2005/05/identity/claims/nameidentifier"))
                       .FirstOrDefault().Value;
            var Ans = secE.Shaper5 + secE.Coordinator5 + secE.Planter5 + secE.Monitor5 + secE.Resource5 + secE.Implementer5 + secE.Teamwork5 + secE.Finisher5;

            if (Ans != 10)
            {
                return(RedirectToAction("Error", "Question"));
            }
            SectionE section = new SectionE
            {
                Shaper5       = secE.Shaper5,
                Coordinator5  = secE.Coordinator5,
                Planter5      = secE.Planter5,
                Monitor5      = secE.Monitor5,
                Resource5     = secE.Resource5,
                Implementer5  = secE.Implementer5,
                Teamwork5     = secE.Teamwork5,
                Finisher5     = secE.Finisher5,
                AspNetUsersId = test
            };

            _context.Set <SectionE>().AddAsync(section);
            _context.SaveChanges();
            return(RedirectToAction("SectionF", "Question"));
        }
        public IActionResult Result(SectionB secB, SectionA secA, SectionC secC, SectionD secD, SectionE secE, SectionF secF, SectionG secG)
        {
            var test = User.Claims.ToList()
                       .Where(u => u.Type.Equals("http://schemas.xmlsoap.org/ws/2005/05/identity/claims/nameidentifier"))
                       .FirstOrDefault().Value;

            var query  = _context.Set <SectionA>().Where(x => x.AspNetUsersId == test).ToList();
            var query1 = _context.Set <SectionB>().Where(x => x.AspNetUsersId == test).ToList();
            var query2 = _context.Set <SectionC>().Where(x => x.AspNetUsersId == test).ToList();
            var query3 = _context.Set <SectionD>().Where(x => x.AspNetUsersId == test).ToList();
            var query4 = _context.Set <SectionE>().Where(x => x.AspNetUsersId == test).ToList();
            var query5 = _context.Set <SectionF>().Where(x => x.AspNetUsersId == test).ToList();
            var query6 = _context.Set <SectionG>().Where(x => x.AspNetUsersId == test).ToList();

            foreach (var item in query)
            {
                var secA1 = item.Shaper1;
                var SecA2 = item.Coordinator1;
                var SecA3 = item.Planter1;
                var secA4 = item.Resource1;
                var secA5 = item.Monitor1;
                var secA6 = item.Implementer1;
                var secA7 = item.Teamwork1;
                var secA8 = item.Finisher1;
                foreach (var item1 in query1)
                {
                    var secB1 = secA1 + item1.Shaper2;
                    var secB2 = SecA2 + item1.Coordinator2;
                    var secB3 = SecA3 + item1.Planter2;
                    var secB4 = secA4 + item1.Resource2;
                    var secB5 = secA5 + item1.Monitor2;
                    var secB6 = secA6 + item1.Implementer2;
                    var secB7 = secA7 + item1.Teamwork2;
                    var secB8 = secA8 + item1.Finisher2;

                    foreach (var item2 in query2)
                    {
                        var secC1 = secB1 + item2.Shaper3;
                        var secC2 = secB2 + item2.Coordinator3;
                        var secC3 = secB3 + item2.Planter3;
                        var secC4 = secB4 + item2.Resource3;
                        var secC5 = secB5 + item2.Monitor3;
                        var secC6 = secB6 + item2.Implementer3;
                        var secC7 = secB7 + item2.Teamwork3;
                        var secC8 = secB8 + item2.Finisher3;

                        foreach (var item3 in query3)
                        {
                            var secD1 = secC1 + item3.Shaper4;
                            var secD2 = secC2 + item3.Coordinator4;
                            var secD3 = secC3 + item3.Planter4;
                            var secD4 = secC4 + item3.Resource4;
                            var secD5 = secC5 + item3.Monitor4;
                            var secD6 = secC6 + item3.Implementer4;
                            var secD7 = secC7 + item3.Teamwork4;
                            var secD8 = secC8 + item3.Finisher4;
                            foreach (var item4 in query4)
                            {
                                var secE1 = secD1 + item4.Shaper5;
                                var secE2 = secD2 + item4.Coordinator5;
                                var secE3 = secD3 + item4.Planter5;
                                var secE4 = secD4 + item4.Resource5;
                                var secE5 = secD5 + item4.Monitor5;
                                var secE6 = secD6 + item4.Implementer5;
                                var secE7 = secD7 + item4.Teamwork5;
                                var secE8 = secD8 + item4.Finisher5;

                                foreach (var item5 in query5)
                                {
                                    var secF1 = secE1 + item5.Shaper6;
                                    var secF2 = secE2 + item5.Coordinator6;
                                    var secF3 = secE3 + item5.Planter6;
                                    var secF4 = secE4 + item5.Resource6;
                                    var secF5 = secE5 + item5.Monitor6;
                                    var secF6 = secE6 + item5.Implementer6;
                                    var secF7 = secE7 + item5.Teamwork6;
                                    var secF8 = secE8 + item5.Finisher6;

                                    foreach (var item6 in query6)
                                    {
                                        var   secG1         = secF1 + item6.Shaper7;
                                        var   secG2         = secF2 + item6.Coordinator7;
                                        var   secG3         = secF3 + item6.Planter7;
                                        var   secG4         = secF4 + item6.Resource7;
                                        var   secG5         = secF5 + item6.Monitor7;
                                        var   secG6         = secF6 + item6.Implementer7;
                                        var   secG7         = secF7 + item6.Teamwork7;
                                        var   secG8         = secF8 + item6.Finisher7;
                                        int[] array         = { secG1, secG2, secG3, secG4, secG5, secG6, secG7, secG8 };
                                        var   max           = array.Max();
                                        var   secondHighest = (from number in array orderby number descending select number).Distinct().Skip(1).First();
                                        if (max == 0)
                                        {
                                            ViewBag.result1 = "Empty";
                                        }
                                        else if (max == secG1)
                                        {
                                            ViewBag.result1 = "Shaper";
                                        }
                                        else if (max == secG2)
                                        {
                                            ViewBag.result1 = "Coordinator";
                                        }
                                        else if (max == secG3)
                                        {
                                            ViewBag.result1 = "Planter";
                                        }
                                        else if (max == secG4)
                                        {
                                            ViewBag.result1 = "Resource";
                                        }
                                        else if (max == secG5)
                                        {
                                            ViewBag.result1 = "Monitor";
                                        }
                                        else if (max == secG6)
                                        {
                                            ViewBag.result1 = "Implementer";
                                        }
                                        else if (max == secG7)
                                        {
                                            ViewBag.result1 = "TeamWork";
                                        }
                                        else if (max == secG8)
                                        {
                                            ViewBag.result1 = "Finisher";
                                        }
                                        if (secondHighest == 0)
                                        {
                                            ViewBag.result2 = "Empty";
                                        }
                                        else if (secondHighest == secG1)
                                        {
                                            ViewBag.result2 = "Shaper";
                                        }
                                        else if (secondHighest == secG2)
                                        {
                                            ViewBag.result2 = "Coordinator";
                                        }
                                        else if (secondHighest == secG3)
                                        {
                                            ViewBag.result2 = "Planter";
                                        }
                                        else if (secondHighest == secG4)
                                        {
                                            ViewBag.result2 = "Resource";
                                        }
                                        else if (secondHighest == secG5)
                                        {
                                            ViewBag.result2 = "Monitor";
                                        }
                                        else if (secondHighest == secG6)
                                        {
                                            ViewBag.result2 = "Implementer";
                                        }
                                        else if (secondHighest == secG7)
                                        {
                                            ViewBag.result2 = "TeamWork";
                                        }
                                        else if (secondHighest == secG8)
                                        {
                                            ViewBag.result2 = "Finisher";
                                        }
                                        return(View());
                                    }
                                }
                            }
                        }
                    }
                }
            }


            return(View());
        }