public CandidateExamWrapperModel GetAllSubmittedTests()
{
string connectionString = "server=localhost;uid=root;password=Reset1234;database=OnlineTestManagement;";
string querryString = "select * from OnlineTestManagement.CandidateExam where IsTestEnded = true";
CandidateExamWrapperModel model = new CandidateExamWrapperModel();
model.CandidateExamList = new List <CandidateExamModel>();
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
MySqlCommand command = new MySqlCommand(querryString, connection);
connection.Open();
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
CandidateExamModel obj = new CandidateExamModel();
obj.Id = (int)reader[0];
obj.StartedTime = (DateTime)reader[1];
obj.SubmittedTime = (DateTime)reader[2];
obj.IsTestEnded = (bool)reader[3];
obj.TestId = (int)reader[4];
obj.CandidateId = (int)reader[5];
model.CandidateExamList.Add(obj);
}
connection.Close();
}
return(model);
}
public int AddExam(CandidateExamModel obj)
{
int candidateExamId = 0;
string connectionString = "server=localhost;uid=root;password=Reset1234;database=OnlineTestManagement;";
string queryString =
"INSERT INTO OnlineTestManagement.CandidateExam(StartedTime, SubmittedTime, IsTestEnded, TestId, CandidateId) " +
"VALUES (@date, @date1, " + obj.IsTestEnded + ", " + obj.TestId + ", " + obj.CandidateId + ");select last_insert_id() ";
using (MySqlConnection connection =
new MySqlConnection(connectionString))
{
MySqlCommand command =
new MySqlCommand(queryString, connection);
command.Parameters.AddWithValue("@date", obj.StartedTime);
command.Parameters.AddWithValue("@date1", obj.SubmittedTime);
connection.Open();
//command.ExecuteNonQuery();
// command.ExecuteNonQuery();
candidateExamId = Convert.ToInt32(command.ExecuteScalar());
// Call Close when done reading.
connection.Close();
}
return(candidateExamId);
}
public CandidateExamModel GetCandidateExamDetails(int id)
{
CandidateExamModel model = new CandidateExamModel();
model = _candidateExamRepository.GetExamDetails(id);
CandidateDetailsViewModel candidate = _candidateRepository.GetCandidateDetails(model.CandidateId);
model.CandidateName = candidate.Name;
TestDetailsViewModel test = _testRepository.GetTestDetails(model.TestId);
model.TestName = test.Name;
model.list = new List <CandidateExamQuestionLogModel>();
model.list = _candidateExamQuestionLogRepository.FindByCandidateExamId(id);
int CorrectAnswers = 0;
int TotalQuestions = test.QuestionList.Count();
foreach (var obj in model.list)
{
if (obj.IsAnswerCorrect == true)
{
CorrectAnswers = CorrectAnswers + 1;
}
}
model.Score = CorrectAnswers + "/" + TotalQuestions;
model.TotalNumberOfQuestions = TotalQuestions;
model.AttemptedQuestions = model.list.Count();
model.CorrectAnswers = CorrectAnswers;
model.WrongAnswers = model.list.Count() - CorrectAnswers;
foreach (var que in test.QuestionList)
{
bool IsPresent = false;
foreach (var item in model.list)
{
if (que.Id == item.QuestionId)
{
IsPresent = true;
}
}
if (IsPresent == false)
{
CandidateExamQuestionLogModel rec = new CandidateExamQuestionLogModel();
rec.Question = que.Question;
rec.SelectedAnswer = "NA";
rec.IsAnswerCorrect = false;
model.list.Add(rec);
}
}
return(model);
}
public TestDetailsViewModel StartTest(string UniqueId)
{
TestDetailsViewModel model = new TestDetailsViewModel();
int CandidateId = _candidateUniqueIdRepository.FindCandidateId(UniqueId);
CandidateViewModel candidate = _candidateRepository.GetCandidateForEdit(CandidateId);
model = _testRepository.GetTestDetails(candidate.TestId);
CandidateExamModel obj = new CandidateExamModel()
{
StartedTime = DateTime.Now,
IsTestEnded = false,
TestId = candidate.TestId,
CandidateId = CandidateId
};
int candidateExamId = _candidateExamRepository.AddExam(obj);
model.CandidateExamId = candidateExamId;
return(model);
}
public CandidateExamModel GetExamDetails(int id)
{
string connectionString = "server=localhost;uid=root;password=Reset1234;database=OnlineTestManagement;";
string querryString = "select * from OnlineTestManagement.CandidateExam where Id = " + id + "";
CandidateExamModel model = new CandidateExamModel();
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
MySqlCommand command = new MySqlCommand(querryString, connection);
connection.Open();
MySqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
model.Id = (int)reader[0];
model.StartedTime = (DateTime)reader[1];
model.SubmittedTime = (DateTime)reader[2];
model.IsTestEnded = (bool)reader[3];
model.TestId = (int)reader[4];
model.CandidateId = (int)reader[5];
}
connection.Close();
}
return(model);
}
public IActionResult Details(int id)
{
CandidateExamModel model = _resultService.GetCandidateExamDetails(id);
return(View(model));
}
