public static void SaveBody(string weightsum, string BMI, string fatRate, string muscle,
string moisture, string boneMass, string subcutaneousFat, string BMR, string proteinRate, string physicalAge, string weightScore,
string clientId, ExamResultModel examRet)
{
using (var ctx = new ExaminationEntities())
{
var model = new Body();
model.ID = Guid.NewGuid();
model.ExamDate = DateTime.Now;
model.WeightSum = weightsum;
model.ClientID = clientId.ToGuid();
model.BMI = BMI;
model.FatRate = fatRate;
model.Muscle = muscle;
model.Moisture = moisture;
model.BoneMass = boneMass;
model.SubcutaneousFat = subcutaneousFat;
model.BMR = BMR;
model.ProteinRate = proteinRate;
model.PhysicalAge = physicalAge;
model.WeightScore = weightScore;
model.ExamRet = JsonConvert.SerializeObject(examRet);
ctx.Body.Add(model);
ctx.SaveChanges();
}
}
public bool addNewExamResult(ExamResultModel examResult)
{
try
{
_Context.ExamResultModels.Add(examResult);
return(_Context.SaveChanges() != 0);
}
catch
{
return(false);
}
}
public static void SaveBloodFat(float val, string clientId, ExamResultModel examRet)
{
using (var ctx = new ExaminationEntities())
{
var model = new BloodFat();
model.ID = Guid.NewGuid();
model.ExamDate = DateTime.Now;
model.BloodFat1 = val;
model.ClientID = clientId.ToGuid();
model.ExamRet = JsonConvert.SerializeObject(examRet);
ctx.BloodFat.Add(model);
ctx.SaveChanges();
}
}
//public static ExamResultModel ExamUricAcid(float val, int sex)
//{
// string settings = ExamHelper.GetExamSettings("uricacid");
// var allSts = JsonConvert.DeserializeObject<List<List<ExamResultModel>>>(settings);
// List<ExamResultModel> standards = sex == 0 ? allSts[0] : allSts[1];
// ExamResultModel st = ExamHelper.GetCurrentStandard(val, standards);
// return st;
//}
public static void SaveUricAcid(float val, int sex, string clientId, ExamResultModel examRet)
{
using (var ctx = new ExaminationEntities())
{
var model = new UricAcid();
model.ID = Guid.NewGuid();
model.ExamDate = DateTime.Now;
model.Sex = sex;
model.UricAcid1 = val;
model.ClientID = clientId.ToGuid();
model.ExamRet = JsonConvert.SerializeObject(examRet);
ctx.UricAcid.Add(model);
ctx.SaveChanges();
}
}
public bool deleteCurrentExamResult(ExamResultModel examResult)
{
var ExamResultToDelete = _Context.ExamResultModels.SingleOrDefault
(x => x.StrExamTimesID == examResult.StrExamTimesID);
try
{
_Context.ExamResultModels.Remove(ExamResultToDelete);
return(_Context.SaveChanges() != 0);
}
catch
{
return(false);
}
}
public bool updateCurrentExamResult(ExamResultModel examResult)
{
try
{
var ExamResultToUpdate = _Context.ExamResultModels.SingleOrDefault
(x => x.StrExamTimesID == examResult.StrExamTimesID);
if (ExamResultToUpdate != null)
{
ExamResultToUpdate.StrStudentID = examResult.StrStudentID;
ExamResultToUpdate.StrSubjectID = examResult.StrSubjectID;
ExamResultToUpdate.DGrade = examResult.DGrade;
return(_Context.SaveChanges() != 0);
}
return(false);
}
catch
{
return(false);
}
}
public async Task CheckExamResult(ExaminerExamModel model, string currentUser)
{
double finalResult = 0;
var checkedExam = _mapper.Map <ExaminerExamModel>(_dbContext
.Exams
.Include("Questions.Answers")
.FirstOrDefaultAsync(exam => exam.ExamId == model.ExamId).Result);
var examResultModel = new ExamResultModel
{
ExamId = model.ExamId,
ExamResultDate = DateTime.UtcNow,
ExamName = checkedExam.Name,
UserId = currentUser,
UserEmail = _dbContext.Users
.FirstOrDefaultAsync(x =>
x.Id == currentUser).Result.Email
};
foreach (var question in model.Questions)
{
var checkedQuestion =
checkedExam.Questions.FirstOrDefault(questionModel =>
questionModel.QuestionId == question.QuestionId);
if (checkedQuestion is null)
{
throw new Exception("Checked question not found");
}
var examResultQuestion = new ExamResultQuestionModel
{
Question = checkedQuestion.QuestionMessage
};
var correctlyAnswered = false;
var isFrozen = false;
foreach (var answer in question.Answers)
{
var checkedAnswer =
checkedQuestion.Answers
.FirstOrDefault(answerModel =>
answerModel.AnswerId == answer.AnswerId);
if (checkedAnswer is null)
{
throw new Exception("Checked answer not found");
}
var examResultAnswerModel = new ExamResultAnswerModel
{
IsCorrect = checkedAnswer.IsCorrect,
IsTouched = answer.IsCorrect,
Value = checkedAnswer.Value
};
examResultQuestion.ExamResultAnswers.Add(examResultAnswerModel);
if (answer.IsCorrect == checkedAnswer.IsCorrect)
{
correctlyAnswered = true;
}
else
{
correctlyAnswered = false;
isFrozen = true;
}
}
if (correctlyAnswered && !isFrozen)
{
finalResult++;
}
examResultModel.ExamResultQuestions.Add(examResultQuestion);
}
examResultModel.ExamResultInPercent =
(finalResult / examResultModel.ExamResultQuestions.Count)
.ToString("P", CultureInfo.InvariantCulture);
var result = _mapper.Map <ExamResult>(examResultModel);
await _dbContext.ExamResults.AddAsync(result);
await _dbContext.SaveChangesAsync();
}
//public static ExamResultModel SimpleExam(string settingName, float value)
//{
// string settings = ExamHelper.GetExamSettings(settingName);
// var standards = JsonConvert.DeserializeObject<List<ExamResultModel>>(settings);
// ExamResultModel st = ExamHelper.GetCurrentStandard(value, standards);
// return st;
//}
//public static ExamResultModel ExamBloodPressure(float highVal, float lowVal)
//{
// string settings = ExamHelper.GetExamSettings("bloodpressure");
// var standards = JsonConvert.DeserializeObject<List<List<ExamResultModel>>>(settings);
// List<ExamResultModel> highStandards = standards[0];
// List<ExamResultModel> lowStandards = standards[1];
// ExamResultModel highSt = ExamHelper.GetCurrentStandard(highVal, highStandards);
// ExamResultModel lowSt = ExamHelper.GetCurrentStandard(lowVal, lowStandards);
// if (highSt.Code > lowSt.Code)
// {
// return highSt;
// }
// else
// {
// return lowSt;
// }
//}
public static void SaveBloodPressure(float highVal, float lowVal, float heartRate, string clientId, ExamResultModel examRet)
{
using (var ctx = new ExaminationEntities())
{
var model = new BloodPressure();
model.ID = Guid.NewGuid();
model.ExamDate = DateTime.Now;
model.HighPressure = highVal;
model.LowPressure = lowVal;
model.HeartRate = heartRate;
model.ClientID = Guid.Parse(clientId);
model.ExamRet = JsonConvert.SerializeObject(examRet);
ctx.BloodPressure.Add(model);
ctx.SaveChanges();
}
}
