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
})));
}
