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