public async Task <IActionResult> EditGrade(string member_code, string course_code, int grade) { project_course_register r = _context.project_course_register.SingleOrDefault(rr => (rr.member_code == member_code) && (rr.course_code == course_code)); r.course_grade = grade; _context.project_course_register.Update(r); await _context.SaveChangesAsync(); return(Json(new { result = "success" })); }
public async Task <IActionResult> Register(string cid, string courseId) { project_course c = _context.project_course.SingleOrDefault(cc => cc.id == new Guid(courseId)); member m = _context.member.SingleOrDefault(mm => mm.cid_card == cid); int countReg = _context.project_course_register.Where(cr => cr.course_code == c.course_code).Count(); int targetReg = 0; if (c.target_member_join != null) { targetReg = (int)c.target_member_join; } else { targetReg = 999999999; } try { if (countReg < targetReg) { project_course_register pcr = new project_course_register(); pcr.course_code = c.course_code; pcr.member_code = m.member_code; pcr.x_status = "Y"; _context.Add(pcr); await _context.SaveChangesAsync(); } else { return(Json(new { result = "full", cid = cid })); } } catch (Exception) { return(Json(new { result = "fail", cid = cid })); } return(Json(new { result = "success", cid = cid })); }