public ActionResult List(Models.Course.List vm)
{
return(Code.MvcHelper.Post(null, Url.Action("List", new
{
showModel = vm.ShowModel,
searchText = vm.SearchText,
courseTypeId = vm.CourseTypeId,
subjectId = vm.SubjectId,
CourseDomainTypeId = vm.CourseDomainTypeId,
CourseDomainId = vm.CourseDomainId,
CourseGroupId = vm.CourseGroupId
})));
}
public ActionResult List()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.Course.List();
vm.SubjectList = SubjectController.SelectList();
vm.CourseTypeList = CourseTypeController.SelectList();
vm.CourseDomainList = CourseDomainController.SelectList();
vm.CourseGroupList = CourseGroupController.SelectList();
var tb = from p in db.Table <Course.Entity.tbCourse>()
select p;
if (string.IsNullOrEmpty(vm.SearchText) == false)
{
tb = tb.Where(d => d.CourseName.Contains(vm.SearchText));
}
if (vm.SubjectId != 0)
{
tb = tb.Where(d => d.tbSubject.Id == vm.SubjectId);
}
if (vm.CourseTypeId != 0)
{
tb = tb.Where(d => d.tbCourseType.Id == vm.CourseTypeId);
}
if (vm.CourseDomainId != 0)
{
tb = tb.Where(d => d.tbCourseDomain.Id == vm.CourseDomainId);
}
if (vm.CourseGroupId != 0)
{
tb = tb.Where(d => d.tbCourseGroup.Id == vm.CourseGroupId);
}
vm.CourseSubjectList = (from p in tb
orderby p.tbSubject.No
select new Dto.Subject.Info
{
Id = p.tbSubject.Id,
SubjectName = p.tbSubject.SubjectName
}).Distinct().ToList();
vm.CourseList = (from p in tb
orderby
p.tbCourseDomain.No, p.tbCourseDomain.CourseDomainName,
p.tbSubject.No, p.tbSubject.SubjectName, p.CourseCode, p.CourseName
select new Dto.Course.List
{
Id = p.Id,
CourseName = p.CourseName,
CourseNameEn = p.CourseNameEn,
CourseTypeName = p.tbCourseType.CourseTypeName,
SubjectName = p.tbSubject.SubjectName,
Point = p.Point,
Hour = p.Hour,
CourseCode = p.CourseCode,
CourseDomainName = p.tbCourseDomain.CourseDomainName,
CourseGroupName = p.tbCourseGroup.CourseGroupName,
IsLevel = p.IsLevel
}).ToList();
return(View(vm));
}
}
