public async Task <IActionResult> Edit(int id, [Bind("ID,user_id,create_time,age,gunhurdle_time,gunhurdle_score,threeoffroad_time,threeoffroad_score,twohurdle_time,twohurdle_score,threehurdle_time,threehurdle_score")] ComtrainAbilities comtrainAbilities)
{
if (id != comtrainAbilities.ID)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(comtrainAbilities);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!ComtrainAbilitiesExists(comtrainAbilities.ID))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(comtrainAbilities));
}
public async Task <IActionResult> Create([Bind("ID,user_id,create_time,age,gunhurdle_time,gunhurdle_score,threeoffroad_time,threeoffroad_score,twohurdle_time,twohurdle_score,threehurdle_time,threehurdle_score,score")] ComtrainAbilities comtrainAbilities, string type)
{
comtrainAbilities.create_time = DateTime.Now;
var s = await _context.Gunhurdle_Score.SingleOrDefaultAsync(m => m.age == comtrainAbilities.age && m.num == comtrainAbilities.gunhurdle_time);
comtrainAbilities.gunhurdle_score = s.score * 20 + 40;
var s2 = await _context.Threeoffroad_Score.SingleOrDefaultAsync(m => m.age == comtrainAbilities.age && m.num == comtrainAbilities.threeoffroad_time);
comtrainAbilities.threeoffroad_score = s2.score * 20 + 40;
var s3 = await _context.Threehurdle_Score.SingleOrDefaultAsync(m => m.age == comtrainAbilities.age && m.num == comtrainAbilities.threehurdle_time);
comtrainAbilities.threehurdle_score = s3.score * 20 + 40;
var s4 = await _context.Twohurdle_Score.SingleOrDefaultAsync(m => m.age == comtrainAbilities.age && m.num == comtrainAbilities.twohurdle_time);
comtrainAbilities.twohurdle_score = s4.score * 20 + 40;
comtrainAbilities.score = (comtrainAbilities.gunhurdle_score + comtrainAbilities.threehurdle_score
+ comtrainAbilities.threehurdle_score + comtrainAbilities.twohurdle_score) / 4;
if (type == "yes")
{
_context.Add(comtrainAbilities);
await _context.SaveChangesAsync();
}
Result res = new Result();
res.gunhurdlescore = comtrainAbilities.gunhurdle_score.ToString();
res.threehurdlescore = comtrainAbilities.threehurdle_score.ToString();
res.twohurdlescore = comtrainAbilities.twohurdle_score.ToString();
res.threeoffroadscore = comtrainAbilities.threeoffroad_score.ToString();
JsonResult result = Json(res);
return(result);
}