public List <AnswerEntities> FileReading() { var entities = new List <AnswerEntities>(); Path.Combine(Path.GetDirectoryName(Assembly.GetExecutingAssembly().Location), @"Answers5.csv"); using (var reader = new StreamReader(@"Answers5.csv")) { if (!reader.EndOfStream) { reader.ReadLine(); } while (!reader.EndOfStream) { var line = reader.ReadLine(); var values = line.Split(';'); var newEntity = new AnswerEntities() { PartitionKey = values[0], RowKey = values[1], Name = values[2], Email = values[3], Answer1 = values[4], Answer2 = values[5], Answer3 = values[6], Answer4 = values[7], IsProcessed = false }; entities.Add(newEntity); } } return(entities); }
public ProcessTestCompleteView CompleteTest() { CompleteDateTime = DateTime.UtcNow; ValidAnswers = AnswerEntities.Count(a => a.AnswerEntity.Mark > 0); NumberAnswers = AnswerEntities.Count(); return(AsCompleteView()); }
public bool CreateAnswer(AnswerEntities entity) { Answer newItem = new Answer() { IdAnswer = entity.IdAnswer, IdQuestion = entity.IdQuestion, IdChoices = entity.IdChoices, IdAnsPaper = entity.IdAnsPaper }; _unit.AnswerGenericType.Insert(newItem); return(true); }
public bool UpdateAnswer(Guid id, AnswerEntities entity) { bool success = false; var updateItem = _unit.AnswerGenericType.GetByID(id); if (updateItem != null) { updateItem.IdQuestion = entity.IdQuestion; updateItem.IdAnsPaper = entity.IdAnsPaper; updateItem.IdChoices = entity.IdChoices; _unit.AnswerGenericType.Update(updateItem); _unit.Save(); success = true; } return(success); }
public QuestionEntity TakeQuestion() { var answed = AnswerEntities.Select(a => a.AnswerEntity.QuestionId).ToList(); if (TestEntity.FactoryMethod == TestFactoryMethod.Fixed) { return(TestEntity.ValidQuestionEntities.OrderBy(q => q.Position).FirstOrDefault(q => answed.Contains(q.QuestionId) == false)?.QuestionEntity); } else if (TestEntity.FactoryMethod == TestFactoryMethod.Randomize) { return(TestEntity.ValidQuestionEntities.FirstOrDefault(q => answed.Contains(q.QuestionId) == false)?.QuestionEntity); } else { throw new NotImplementedException(); } return(null); }
// insert public JsonResult <APIResultEntities <bool> > Post(AnswerEntities entity) { APIResultEntities <bool> rs = new APIResultEntities <bool>(); try { _iAnswerServices.CreateAnswer(entity); rs.Data = true; rs.ErrCode = ErrorCodeEntites.Success; rs.ErrDescription = string.Format(Constants.MSG_INSERT_SUCCESS, Constants.Answer); } catch (Exception ex) { rs.Data = false; rs.ErrCode = ErrorCodeEntites.Fail; rs.ErrDescription = ex.ToString(); throw new Exception(ex.ToString()); } return(Json(rs)); }
private ExamPaper CreateDataSet(DataSet dsQuestion) { ExamPaper examPaper = new ExamPaper(); List <QuestionEntities> questionEntitiesList = new List <QuestionEntities>(); List <int> IdList = new List <int>(); List <AnsweredQuestions> answeredQuestionsList = new List <AnsweredQuestions>(); for (int i = 0; i < dsQuestion.Tables[0].Rows.Count; i++) { QuestionEntities questionEntities = new QuestionEntities(); questionEntities.Id = Convert.ToInt32(dsQuestion.Tables[0].Rows[i]["Id"].ToString()); questionEntities.QuestionText = Convert.ToString(dsQuestion.Tables[0].Rows[i]["QuestionText"]); questionEntities.Marks = Convert.ToDecimal(dsQuestion.Tables[0].Rows[i]["Marks"]); // IdList.Add(questionEntities.Id); DataTable dtAns = dsQuestion.Tables[1].AsEnumerable() .Where(r => r.Field <int>("QuestionId") == int.Parse(dsQuestion.Tables[0].Rows[i]["Id"].ToString())).CopyToDataTable(); List <AnswerEntities> answerEntities = new List <AnswerEntities>(); for (int j = 0; j < dtAns.Rows.Count; j++) { AnswerEntities answerEntities1 = new AnswerEntities(); answerEntities1.ID = Convert.ToInt32(dtAns.Rows[j]["Id"].ToString()); answerEntities1.AnswerText = Convert.ToString(dtAns.Rows[j]["ChoiceText"]); answerEntities1.QuestionID = Convert.ToInt32(dtAns.Rows[j]["QuestionId"].ToString()); answerEntities1.IsRightAnswer = Convert.ToString(dtAns.Rows[j]["IsAnswer"].ToString()); answerEntities1.IsUserAnswer = Convert.ToInt32(dtAns.Rows[j]["IsUserAnswer"].ToString()); answerEntities1.ChoiceID = Convert.ToInt32(dtAns.Rows[j]["ChoiceId"].ToString()); if (dtAns.Rows[j]["IsUserAnswer"].ToString() == "1") { examPaper.UserAnswer = answerEntities1.ChoiceID.ToString(); } //examPaper.RadioValue = dtAns.Rows[j]["IsUserAnswer"].ToString(); answerEntities.Add(answerEntities1); } questionEntities.AnswerEntities = answerEntities; questionEntitiesList.Add(questionEntities); } examPaper.QuestionEntities = questionEntitiesList; for (int i = 0; i < dsQuestion.Tables[3].Rows.Count; i++) { IdList.Add(int.Parse(dsQuestion.Tables[3].Rows[i]["Id"].ToString())); } examPaper.QuestionList = IdList; examPaper.QuestionCount = IdList.Count; List <int> qCnt = new List <int>(); for (int k = 0; k < dsQuestion.Tables[2].Rows.Count; k++) { qCnt.Add(int.Parse(dsQuestion.Tables[2].Rows[k][0].ToString())); } examPaper.AnsweredQuestionList = qCnt; for (int l = 0; l < dsQuestion.Tables[4].Rows.Count; l++) { AnsweredQuestions aq = new AnsweredQuestions(); aq.RowNo = Convert.ToInt32(dsQuestion.Tables[4].Rows[l]["RowNo"].ToString()); aq.QuestionId = Convert.ToInt32(dsQuestion.Tables[4].Rows[l]["QuestionId"].ToString()); aq.HasAnswered = Convert.ToInt32(dsQuestion.Tables[4].Rows[l]["HasAnswered"].ToString()); answeredQuestionsList.Add(aq); } examPaper.AnsweredQuestions = answeredQuestionsList; return(examPaper); }