public ActionResult List()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.ExamChange.List();
var tbStudent = from p in db.Table <Student.Entity.tbStudent>()
select p;
var student = (from p in tbStudent
where (p.StudentCode == vm.SearchText || p.StudentName == vm.SearchText)
select new
{
p.Id,
p.StudentCode,
p.StudentName
}).FirstOrDefault();
if (student != null)
{
vm.StudentId = student.Id;
var tb = from p in db.Table <Exam.Entity.tbExamMark>()
where p.tbExamCourse.IsDeleted == false && p.tbExamCourse.tbCourse.IsDeleted == false &&
p.tbStudent.Id == student.Id &&
p.tbExamCourse.tbExam.IsDeleted == false
select p;
vm.ExamMarkList = (from p in tb
select new Dto.ExamChange.List
{
Id = p.Id,
CourseId = p.tbExamCourse.tbCourse.Id,
StudentId = p.tbStudent.Id,
StudentCode = p.tbStudent.StudentCode,
StudentName = p.tbStudent.StudentName,
ExamName = p.tbExamCourse.tbExam.ExamName,
CourseName = p.tbExamCourse.tbCourse.CourseName,
AppraiseMark = p.AppraiseMark,
SegmentMark = p.SegmentMark,
TotalMark = p.TotalMark,
ExamLevelName = p.tbExamLevel.ExamLevelName,
}).ToList();
}
return(View(vm));
}
}
public ActionResult List(Models.ExamChange.List vm)
{
return(Code.MvcHelper.Post(null, Url.Action("List", new { searchText = vm.SearchText })));
}