public async Task <IActionResult> Edit(int id, [Bind("ID,user_id,create_time,horbara_num,horbara_score,horbarb_num,horbarb_score,doubara_num,doubara_score,doubarb_num,doubarb_score,pushup_num,pushup_score,situp_num,situp_score,score")] EnergyAbility energyAbility)
        {
            if (id != energyAbility.ID)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(energyAbility);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!EnergyAbilityExists(energyAbility.ID))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(energyAbility));
        }
        public async Task <IActionResult> Create([Bind("ID,user_id,horbara_num,horbarb_num,doubara_num,doubarb_num,pushup_num,situp_num,age")] EnergyAbility energyAbility, string type)
        {
            energyAbility.create_time = DateTime.Now;
            var s = await _context.Horbara_Score.SingleOrDefaultAsync(m => m.age == energyAbility.age && m.num == energyAbility.horbara_num);

            energyAbility.horbara_score = s.score;
            var s2 = await _context.Ontheroll_Score.SingleOrDefaultAsync(m => m.age == energyAbility.age && m.num == energyAbility.horbarb_num);

            if (s2.score == 1)
            {
                s2.score = 60;
            }
            else if (s2.score == 2)
            {
                s2.score = 80;
            }
            else
            {
                s2.score = 100;
            }
            energyAbility.horbarb_score = s2.score;
            if (energyAbility.doubara_num <= 8)
            {
                energyAbility.doubara_score = 60;
            }
            else if (energyAbility.doubara_num > 8 && energyAbility.doubara_num <= 12)
            {
                energyAbility.doubara_score = 80;
            }
            else
            {
                energyAbility.doubara_score = 100;
            }
            var s3 = await _context.Swingflex_Score.SingleOrDefaultAsync(m => m.age == energyAbility.age && m.num == energyAbility.doubarb_num);

            if (s3.score == 1)
            {
                s3.score = 60;
            }
            else if (s3.score == 2)
            {
                s3.score = 80;
            }
            else
            {
                s3.score = 100;
            }
            energyAbility.doubarb_score = s3.score;
            var s4 = await _context.Pushup_Score.SingleOrDefaultAsync(m => m.age == energyAbility.age && m.num == energyAbility.pushup_num);

            energyAbility.pushup_score = s4.score;
            var s5 = await _context.Situp_Score.SingleOrDefaultAsync(m => m.age == energyAbility.age && m.num == energyAbility.situp_num);

            energyAbility.situp_score = s5.score;

            energyAbility.score = (int)(energyAbility.horbara_score + energyAbility.horbarb_score + energyAbility.doubara_score + energyAbility.doubarb_score + energyAbility.doubarb_score + energyAbility.pushup_score + energyAbility.situp_score) / 7;

            if (type == "yes")
            {
                _context.Add(energyAbility);
                await _context.SaveChangesAsync();
            }

            Result result = new Result();

            result.horbara = energyAbility.horbara_score;
            result.horbarb = energyAbility.horbarb_score;
            result.doubara = energyAbility.doubara_score;
            result.doubarb = energyAbility.doubarb_score;
            result.pushup  = energyAbility.pushup_score;
            result.situp   = energyAbility.situp_score;
            JsonResult res = Json(result);

            return(res);
        }
 public EnergyList()
 {
     lastlist = new EnergyAbility();
     list     = new List <EnergyAbility>();
     timelist = new List <string>();
 }