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();
}
