// GET: mem_train_record
        public IActionResult Index(string memberId)
        {
            List <ViewModels.mem_train_record.mem_train_recordViewModel> mem_train_recordViewModels = new List <ViewModels.mem_train_record.mem_train_recordViewModel>();
            var member            = _context.member.Single(m => m.id == new Guid(memberId));
            var mem_train_records = _context.mem_train_record.Where(m => m.member_code == member.member_code).OrderBy(m => m.course_code).ToList();

            foreach (var mtr in mem_train_records)
            {
                var mem_train_recordViewModel = new ViewModels.mem_train_record.mem_train_recordViewModel();

                /**
                 * mem_train_recordViewModel.course_code = mtr.course_code;
                 * mem_train_recordViewModel.member_code = mtr.member_code;
                 * mem_train_recordViewModel.course_grade = mtr.course_grade;
                 * mem_train_recordViewModel.course_desc = _context.project_course.Single(p => p.course_code == mtr.course_code).course_desc;
                 **/
                mem_train_recordViewModel.mem_train_record = mtr;
                mem_train_recordViewModel.project_course   = _context.project_course.Single(p => p.course_code == mtr.course_code);
                mem_train_recordViewModel.cgrade_desc      = _context.course_grade.Single(c => c.cgrade_code == mtr.course_grade).cgrade_desc;
                mem_train_recordViewModels.Add(mem_train_recordViewModel);
            }
            ViewBag.memberId     = memberId;
            ViewBag.course_grade = new SelectList(_context.course_grade, "cgrade_code", "cgrade_desc");
            return(View(mem_train_recordViewModels));
        }
Esempio n. 2
0
 // GET: mem_train_record
 public IActionResult Index(string memberId)
 {
     List<ViewModels.mem_train_record.mem_train_recordViewModel> mem_train_recordViewModels = new List<ViewModels.mem_train_record.mem_train_recordViewModel>();
     var member = _context.member.Single(m => m.id == new Guid(memberId));
     var mem_train_records = _context.mem_train_record.Where(m => m.member_code == member.member_code).OrderBy(m => m.course_code).ToList();
     foreach (var mtr in mem_train_records)
     {
         var mem_train_recordViewModel = new ViewModels.mem_train_record.mem_train_recordViewModel();
         /**
         mem_train_recordViewModel.course_code = mtr.course_code;
         mem_train_recordViewModel.member_code = mtr.member_code;
         mem_train_recordViewModel.course_grade = mtr.course_grade;
         mem_train_recordViewModel.course_desc = _context.project_course.Single(p => p.course_code == mtr.course_code).course_desc;
         **/
         mem_train_recordViewModel.mem_train_record = mtr;
         mem_train_recordViewModel.project_course = _context.project_course.Single(p => p.course_code == mtr.course_code);
         mem_train_recordViewModel.cgrade_desc = _context.course_grade.Single(c => c.cgrade_code == mtr.course_grade).cgrade_desc;
         mem_train_recordViewModels.Add(mem_train_recordViewModel);
     }
     ViewBag.memberId = memberId;
     ViewBag.course_grade = new SelectList(_context.course_grade, "cgrade_code", "cgrade_desc");
     return View(mem_train_recordViewModels);
 }