public void SaveExamResultSATSSAT(ExamResultSATSSATEntity satSSATDetail) { if (satSSATDetail.ExamID == Guid.Empty) satSSATDetail.ExamID = Guid.NewGuid(); ExamResultSATSSATEntity originDetail = context.ExamResult_SAT_SSAT.SingleOrDefault(e => e.ExamID == satSSATDetail.ExamID); if (originDetail == null) { context.ExamResult_SAT_SSAT.Add(satSSATDetail); } else { context.Entry(originDetail).CurrentValues.SetValues(satSSATDetail); } context.SaveChanges(); }
/// <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); }
ExamResultSATSSATModel GetSATSSATExamResult(Guid studentID) { //从数据库中根据StudentID、ExamDate、ExamType 选择考试条目 ExamResultEntity examResult = repository.ExamResult .FirstOrDefault(e => e.StudentID == studentID && e.IsBeforeSign == true && (e.ExamType == ExamType.SAT || e.ExamType == ExamType.SSAT)); if (examResult == null) { examResult = new ExamResultEntity { ResultID = Guid.NewGuid(), StudentID = studentID, ExamID = Guid.NewGuid(), IsBeforeSign = true, ExamType = ExamType.SAT }; } ExamResultSATSSATEntity examResultDetail = repository.ExamResultSATSSAT.SingleOrDefault(e => e.ExamID == examResult.ExamID); if (examResultDetail == null) { examResultDetail = new ExamResultSATSSATEntity { ExamID = examResult.ExamID, Total = examResult.Total }; } return new ExamResultSATSSATModel { ExamResult = examResult, ExamResultDetail = examResultDetail }; }
void SaveSSATResult(ExamResultEntity ssatResult, ExamResultSATSSATEntity ssatResultDetail) { repository.SaveExamResult(ssatResult); if (ssatResultDetail.ExamID != ssatResult.ExamID) { ssatResultDetail.ExamID = ssatResult.ExamID = Guid.NewGuid(); } repository.SaveExamResultSATSSAT(ssatResultDetail); }
public void SaveExamResultSATSSAT(ExamResultSATSSATEntity satSSATDetail) { ExamResultSATSSATEntity originDetail = context.ExamResult_SAT_SSAT.SingleOrDefault(e => e.ExamID == satSSATDetail.ExamID); if (originDetail == null) { if (satSSATDetail.Total > 0) context.ExamResult_SAT_SSAT.Add(satSSATDetail); else return; } else { if (satSSATDetail.Total > 0) context.Entry(originDetail).CurrentValues.SetValues(satSSATDetail); else context.ExamResult_SAT_SSAT.Remove(originDetail); } context.SaveChanges(); }