public ActionResult SearchCourse(int examId) { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.ExamCourse.SearchCourse(); vm.SubjectList = Course.Controllers.SubjectController.SelectList(); var tb = from p in db.Table <Exam.Entity.tbExamCourse>() where p.tbExam.Id == examId && p.tbCourse.IsDeleted == false && p.tbCourse.tbSubject.IsDeleted == false && (p.tbCourse.tbSubject.Id == vm.SubjectId || vm.SubjectId == 0) select p; if (string.IsNullOrEmpty(vm.SearchText) == false) { tb = tb.Where(d => d.tbCourse.CourseName.Contains(vm.SearchText)); } vm.SubjectCourseList = (from p in tb orderby p.tbCourse.CourseName select new Areas.Course.Dto.Course.List { Id = p.Id, CourseName = p.tbCourse.CourseName, SubjectName = p.tbCourse.tbSubject.SubjectName }).Distinct().ToList(); return(View(vm)); } }
public ActionResult SearchCourse(Models.ExamCourse.SearchCourse vm) { return(Code.MvcHelper.Post(null, Url.Action("SearchCourse", new { examId = vm.ExamId, SubjectId = vm.SubjectId, searchText = vm.SearchText }))); }