public IActionResult Create(string memberId, string course_code, string course_desc, string course_grade)
{
var member = _context.member.Single(m => m.id == new Guid(memberId));
var mem_train_record = new mem_train_record();
mem_train_record.member_code = member.member_code;
mem_train_record.course_code = course_code;
mem_train_record.course_grade = course_grade;
mem_train_record.x_status = "Y";
//Temp create project, this need to review business logic
var project_course = new project_course();
project_course.course_code = mem_train_record.course_code;
project_course.course_desc = course_desc;
project_course.x_status = "Y";
_context.mem_train_record.Add(mem_train_record);
_context.project_course.Add(project_course);
_context.SaveChanges();
return(Json(new { result = "success" }));
//return RedirectToAction("Index","mem_train_record",new {memberId = memberId});
}
public async Task <IActionResult> Unregister(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);
var cr = await _context.project_course_register.SingleOrDefaultAsync(crr => crr.course_code == c.course_code && crr.member_code == m.member_code);
if (cr != null)
{
if (cr.course_grade != 0)
{
return(Json(new { result = "pass", cid = cid }));
}
else
{
_context.Remove(cr);
await _context.SaveChangesAsync();
return(Json(new { result = "success", cid = cid }));
}
}
else
{
return(Json(new { result = "fail", cid = cid }));
}
}
public async Task <IActionResult> CourseCreate([Bind("course_code,active_member_join,budget,cgroup_code,charge_head,course_approve_date,course_begin,course_date,course_desc,course_end,ctype_code,id,passed_member,project_code,project_manager,ref_doc,support_head,target_member_join,x_log,x_note,x_status")] project_course project_course)
{
if (ModelState.IsValid)
{
_context.Add(project_course);
await _context.SaveChangesAsync();
return(RedirectToAction("CourseIndex"));
}
return(View(project_course));
}
// GET: mem_train_record/Details/5
public IActionResult Details(string id)
{
if (id != null)
{
mem_train_record mtr = _context.mem_train_record.Single(m => m.id == new Guid(id));
if (mtr != null)
{
project_course pc = _context.project_course.Single(p => p.course_code == mtr.course_code);
return(Json(new { id = mtr.id, course_code = mtr.course_code, course_desc = pc.course_desc, course_grade = mtr.course_grade }));
}
else
{
return(HttpNotFound());
}
}
else
{
return(HttpNotFound());
}
}
public async Task <IActionResult> CourseEdit(string id, [Bind("passed_score,course_code,active_member_join,budget,cgroup_code,charge_head,course_approve_date,course_begin,course_date,course_desc,course_end,ctype_code,id,passed_member,project_code,project_manager,ref_doc,support_head,target_member_join,x_log,x_note,x_status")] project_course project_course)
{
if (new Guid(id) != project_course.id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(project_course);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
throw;
}
return(RedirectToAction("CourseIndex"));
}
return(View(project_course));
}
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 }));
}
