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 }); }
public void SaveExamResultTFIELTS(ExamResultTFIELTSEntity tfIELTSDetail) { ExamResultTFIELTSEntity originDetail = context.ExamResult_TF_IELTS.SingleOrDefault(e => e.ExamID == tfIELTSDetail.ExamID); if (originDetail == null) { if (tfIELTSDetail.Total > 0) { context.ExamResult_TF_IELTS.Add(tfIELTSDetail); } else { return; } } else { if (tfIELTSDetail.Total > 0) { context.Entry(originDetail).CurrentValues.SetValues(tfIELTSDetail); } else { context.ExamResult_TF_IELTS.Remove(originDetail); } } context.SaveChanges(); }
public JsonResult PostFirstInterviewRegTPForm(FirstInterviewRegModel ajaxData) { if (ajaxData == null || ajaxData.StudentInfo == null) { return(Json(false)); } StudentTPInfoEntity studentTPInfo = ajaxData.StudentTPInfo; StudentInfoEntity studentInfo = repository.StudentInfo.SingleOrDefault(s => s.StudentID == ajaxData.StudentInfo.StudentID); AppRelationsEntity appRelation = repository.AppRelation.SingleOrDefault(a => a.StudentID == studentInfo.StudentID); studentInfo.EducationIntention = ajaxData.StudentInfo.EducationIntention; studentInfoRepository.SaveStudentTPInfo(studentTPInfo); studentInfoRepository.SaveStudentInfo(studentInfo, appRelation); ExamResultEntity _TFIELTSResult = ajaxData.TFIELTSResult; ExamResultTFIELTSEntity _TFIELTSResultDetail = ajaxData.TFIELTSResultDetail; if ((_TFIELTSResult.ExamType == ExamType.TOFEL || _TFIELTSResult.ExamType == ExamType.IELTS)) { repository.SaveExamResult(_TFIELTSResult); if (_TFIELTSResultDetail.ExamID != _TFIELTSResult.ExamID) { _TFIELTSResultDetail.ExamID = _TFIELTSResult.ExamID = Guid.NewGuid(); } repository.SaveExamResultTFIELTS(_TFIELTSResultDetail); } EducationIntention eduIntention = studentInfo.EducationIntention; switch (eduIntention) { case EducationIntention.高中: { ajaxData.SATSSATResult.ExamType = ExamType.SSAT; SaveSSATResult(ajaxData.SATSSATResult, ajaxData.SATSSATResultDetail); break; } case EducationIntention.本科: { ajaxData.SATSSATResult.ExamType = ExamType.SAT; repository.SaveExamResult(ajaxData.SAT2Result); SaveSATResult(ajaxData.SATSSATResult, ajaxData.SATSSATResultDetail); break; } case EducationIntention.研究生: SaveGreGmatResult(ajaxData.GREGMATResult, ajaxData.GREGMATResultDetail); break; default: break; } return(Json(true)); }
public void SaveExamResultTFIELTS(ExamResultTFIELTSEntity tfIELTSDetail) { if (tfIELTSDetail.ExamID == Guid.Empty) { tfIELTSDetail.ExamID = Guid.NewGuid(); } ExamResultTFIELTSEntity originDetail = context.ExamResult_TF_IELTS.SingleOrDefault(e => e.ExamID == tfIELTSDetail.ExamID); if (originDetail == null) { context.ExamResult_TF_IELTS.Add(tfIELTSDetail); } else { context.Entry(originDetail).CurrentValues.SetValues(tfIELTSDetail); } context.SaveChanges(); }