/// <summary> /// 渲染初访登记表——学生的培训、课程、考试信息 /// </summary> /// <param name="id">学生ID</param> /// <returns></returns> public ViewResult FirstRegFormTP(string id) { Guid studentID = new Guid(id); StudentInfoEntity studentInfo = repository.StudentInfo.SingleOrDefault(s => s.StudentID == studentID); StudentTPInfoEntity studentTPInfo = null; if (repository.StudentTPInfo.SingleOrDefault(s => s.StudentID == studentID) != null) { studentTPInfo = repository.StudentTPInfo.SingleOrDefault(s => s.StudentID == studentID); } else studentTPInfo = new StudentTPInfoEntity { StudentID = studentID }; ExamResultEntity tfIELTSResult = null; if(repository.ExamResult.FirstOrDefault(e=>e.StudentID == studentID && (e.ExamType == ExamType.TOFEL || e.ExamType == ExamType.IELTS)) != null) tfIELTSResult = repository.ExamResult.FirstOrDefault(e=>e.StudentID == studentID && (e.ExamType == ExamType.TOFEL || e.ExamType == ExamType.IELTS)); else tfIELTSResult = new ExamResultEntity{ExamType = Domain.Enum.ExamType.TOFEL,StudentID = studentID,ExamID = Guid.NewGuid()}; ExamResultEntity sATSSATResult = null; ExamResultSATSSATEntity sATSSATResultDetail = null; if (repository.ExamResult.FirstOrDefault(e => e.StudentID == studentID && (e.ExamType == ExamType.SAT || e.ExamType == ExamType.SSAT)) != null) { sATSSATResult = repository.ExamResult.FirstOrDefault(e => e.StudentID == studentID && (e.ExamType == ExamType.SAT || e.ExamType == ExamType.SSAT)); if (repository.ExamResultSATSSAT.SingleOrDefault(e => e.ExamID == sATSSATResult.ExamID) != null) { sATSSATResultDetail = repository.ExamResultSATSSAT.SingleOrDefault(e => e.ExamID == sATSSATResult.ExamID); } else { sATSSATResultDetail = new ExamResultSATSSATEntity { ExamID = Guid.NewGuid() }; } } else { Guid detailId = Guid.NewGuid(); sATSSATResult = new ExamResultEntity { ExamType = Domain.Enum.ExamType.SAT,StudentID = studentID,ResultID=Guid.NewGuid(),ExamID=detailId}; sATSSATResultDetail = new ExamResultSATSSATEntity { ExamID = detailId }; } ExamResultEntity sAT2Result = null; if (repository.ExamResult.FirstOrDefault(e => e.StudentID == studentID && e.ExamType == ExamType.SAT2) != null) { sAT2Result = repository.ExamResult.FirstOrDefault(e => e.StudentID == studentID && e.ExamType == ExamType.SAT2); } else sAT2Result = new ExamResultEntity { ExamType = Domain.Enum.ExamType.SAT2, StudentID = studentID }; FirstInterviewTPModel tpModel = new FirstInterviewTPModel { StudentInfo=studentInfo, StudentTPInfo = studentTPInfo, TFIELTSResult = tfIELTSResult, TFIELTSResultDetail = new ExamResultTFIELTSEntity(), SATSSATResult = sATSSATResult, SATSSATResultDetail = sATSSATResultDetail, SAT2Result = sAT2Result }; return View(tpModel); }
public void SaveExamResult(ExamResultEntity examResult) { if (examResult.ResultID == Guid.Empty) examResult.ResultID = Guid.NewGuid(); ExamResultEntity originResult = context.ExamResult.SingleOrDefault(e => e.ResultID == examResult.ResultID); if (originResult == null) { context.ExamResult.Add(examResult); } else { context.Entry(originResult).CurrentValues.SetValues(examResult); } context.SaveChanges(); }
void SaveSSATResult(ExamResultEntity ssatResult, ExamResultSATSSATEntity ssatResultDetail) { repository.SaveExamResult(ssatResult); if (ssatResultDetail.ExamID != ssatResult.ExamID) { ssatResultDetail.ExamID = ssatResult.ExamID = Guid.NewGuid(); } repository.SaveExamResultSATSSAT(ssatResultDetail); }
void SaveGreGmatResult(ExamResultEntity greGmatResult, ExamResultGREGMATEntity greGmatResultDetail) { if (greGmatResult.ExamType == ExamType.GRE || greGmatResult.ExamType == ExamType.GMAT) { repository.SaveExamResult(greGmatResult); if (greGmatResultDetail.ExamID != greGmatResult.ExamID) { greGmatResultDetail.ExamID = greGmatResult.ExamID = Guid.NewGuid(); } repository.SaveExamResultGREGMAT(greGmatResultDetail); return; } else return; }
ExamResultTFIELTSModel GetTFIELTSExamResult(Guid studentID) { //从数据库中根据StudentID、ExamDate、ExamType 选择考试条目 ExamResultEntity examResult = repository.ExamResult .FirstOrDefault(e => e.StudentID == studentID && e.IsBeforeSign == true && (e.ExamType == ExamType.TOFEL || e.ExamType == ExamType.IELTS)); if (examResult == null) { examResult = new ExamResultEntity { ResultID = Guid.NewGuid(), StudentID = studentID, ExamID = Guid.NewGuid(), IsBeforeSign = true, ExamType = ExamType.TOFEL }; } ExamResultTFIELTSEntity examResultDetail = repository.ExamResultTFIELTS.SingleOrDefault(e => e.ExamID == examResult.ExamID); if (examResultDetail == null) { examResultDetail = new ExamResultTFIELTSEntity { ExamID = examResult.ExamID, Total = examResult.Total }; } return new ExamResultTFIELTSModel { ExamResult = examResult, ExamResultDetail = examResultDetail }; }
ExamResultEntity GetSAT2ExamResult(Guid studentID) { //从数据库中根据StudentID、ExamDate、ExamType 选择考试条目 ExamResultEntity examResult = repository.ExamResult .FirstOrDefault(e => e.StudentID == studentID && e.IsBeforeSign == true && e.ExamType == ExamType.SAT2); if (examResult == null) { examResult = new ExamResultEntity { ResultID = Guid.NewGuid(), StudentID = studentID, ExamID = Guid.NewGuid(), IsBeforeSign = true, ExamType = ExamType.SAT2 }; } return examResult; }
public void SaveExamResult(ExamResultEntity examResult) { ExamResultEntity originResult = context.ExamResult.SingleOrDefault(e => e.ResultID == examResult.ResultID); if (originResult == null) { if (examResult.Total > 0) { context.ExamResult.Add(examResult); } else { return; } } else { if (examResult.Total > 0) { context.Entry(originResult).CurrentValues.SetValues(examResult); } else { context.ExamResult.Remove(originResult); } } context.SaveChanges(); }