public string BluePrint(BluePrintParams model) { string message = ""; ReturnMessage QuestionValidate = new ReturnMessage(); List <BluePrintArchieve> archieves = new List <BluePrintArchieve>(); string query = $"EXECUTE SP_BluePrint {model.NoQuestions},{model.Mild},{model.Normal},{model.Hard}"; archieves = _db.Database.SqlQuery <BluePrintArchieve>(query).ToList(); #region Original Items foreach (var item in archieves) { string getOriginalItem = $"EXECUTE SP_OriginalItem '{item.Id}','{model.ExamId}',{item.Degree}"; QuestionValidate = _db.Database.SqlQuery <ReturnMessage>(getOriginalItem).FirstOrDefault(); if (QuestionValidate.Key == 1) { // Add Answers string applyAnswersArchieve = $"EXECUTE SP_ApplyAnswers '{item.Id}','{QuestionValidate.ReturnId}','{model.ExamId}'"; message = _db.Database.SqlQuery <string>(applyAnswersArchieve).FirstOrDefault(); } } #endregion return(message); }
public IHttpActionResult BluePrint([FromBody] BluePrintParams model) { var result = new ExamService().BluePrint(model); return(Ok(result)); }