public ActionResult List()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.StudyClassTeacher.List();
vm.WeekList = Basis.Controllers.WeekController.SelectList();
var tb = from p in db.Table <Study.Entity.tbStudyClassTeacher>()
orderby p.tbClass.No
where p.tbStudy.Id == vm.StudyId &&
p.tbClass.IsDeleted == false &&
p.tbTeacher.IsDeleted == false &&
p.tbStudy.IsDeleted == false &&
p.tbWeek.IsDeleted == false
select p;
if (string.IsNullOrEmpty(vm.SearchText) == false)
{
tb = tb.Where(d => d.tbTeacher.TeacherCode.Contains(vm.SearchText) || d.tbTeacher.TeacherName.Contains(vm.SearchText));
}
vm.StudyClassTeacherList = (from p in tb
orderby p.tbTeacher.TeacherName
select new Dto.StudyClassTeacher.List
{
Id = p.Id,
ClassId = p.tbClass.Id,
ClassName = p.tbClass.ClassName,
IsMaster = p.IsMaster,
TeacherId = p.tbTeacher.Id,
TeacherCode = p.tbTeacher.TeacherCode,
TeacherName = p.tbTeacher.TeacherName,
WeekId = p.tbWeek.Id
}).ToList();
return(View(vm));
}
}
public ActionResult List(Models.StudyClassTeacher.List vm)
{
return(Code.MvcHelper.Post(null, Url.Action("List", new { searchText = vm.SearchText, studyId = vm.StudyId })));
}
