public JsonResult GetQuestionSetForApplicant(int?ApplicantID)
{
ApplicantExamAttempt d;
using (var usersContext = new UsersContext())
{
d = usersContext.GetApplicantExamAttempts(ApplicantID);
}
DreamJobsBAL DJBAL = new DreamJobsBAL();
ApplicantExamVM _ApplicantExamVM = DJBAL.GetQuestionSetForApplicant(new ApplicantExamVM {
ApplicantAttempt = new ApplicantExamAttempt {
AttemptID = d == null ? 0 : d.AttemptID, Applicant = new Applicant {
ApplicantID = ApplicantID
}
}
});
string strPartialView = RenderPartialToStringExtensions.RenderPartialToString(this.ControllerContext, "_PartialQuestions", _ApplicantExamVM);
if (_ApplicantExamVM.ApplicantAttempt == null)
{
return(Json(new JsonReurnData {
ReturnStatus = 0, ReturnMessage = "No question set available for you at this moment!", ReturnData = strPartialView
}, JsonRequestBehavior.AllowGet));
}
return(Json(new JsonReurnData {
ReturnStatus = 1, ReturnMessage = "", ReturnData = strPartialView
}, JsonRequestBehavior.AllowGet));
}
public DataSet GetQuestionSetForApplicant(ApplicantExamVM ApplicantExamVM)
{
List <SqlParameter> _param = new List <SqlParameter>();
try
{
_param.Add(new SqlParameter("@ApplicantID", ApplicantExamVM.ApplicantAttempt.Applicant.ApplicantID));
_param.Add(new SqlParameter("@AttemptID", (object)ApplicantExamVM.ApplicantAttempt.AttemptID ?? DBNull.Value));
return(_SqlDbBridge.ExecuteDataSet("usp_GetQuestionSetForApplicant", _param));
}
catch (Exception ex)
{
return(new DataSet());
}
}
public ActionResult QuestionPaper()
{
Applicant user;
using (var usersContext = new UsersContext())
{
user = usersContext.GetApplicant(User.Identity.Name);
}
DJ_Entity.ApplicantExamVM vm = new ApplicantExamVM {
ApplicantAttempt = new ApplicantExamAttempt {
Applicant = new Applicant {
ApplicantID = user.ApplicantID
}
}
};
return(View(vm));
}
public ApplicantExamVM GetQuestionSetForApplicant(ApplicantExamVM ApplicantExamVM)
{
DataSet ds = _DreamJobsDAL.GetQuestionSetForApplicant(ApplicantExamVM);
if (ds.Tables.Count > 0)
{
ApplicantExamVM _ApplicantExamVM = new DJ_Entity.ApplicantExamVM();
_ApplicantExamVM.ApplicantAttempt = new ApplicantExamAttempt
{
AttemptID = (long)ds.Tables[0].Rows[0]["AttemptID"]
,
Applicant = new Applicant {
ApplicantID = (long)ds.Tables[0].Rows[0]["ApplicantID"]
}
,
ExamStartDateTime = ds.Tables[0].Rows[0]["ExamStartDateTime"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(ds.Tables[0].Rows[0]["ExamStartDateTime"]),
ExamEndDateTime = ds.Tables[0].Rows[0]["ExamEndDateTime"] == DBNull.Value ? DateTime.Now : Convert.ToDateTime(ds.Tables[0].Rows[0]["ExamEndDateTime"]),
MarksObtained = ds.Tables[0].Rows[0]["MarksObtained"] == DBNull.Value ? 0 : Convert.ToDouble(ds.Tables[0].Rows[0]["MarksObtained"])
};
_ApplicantExamVM.ApplicantAnswers = ds.Tables[0].AsEnumerable().Select(d => new ApplicantAnswer
{
Question = new QuestionSet
{
QNO = Convert.ToInt32(d["QNO"])
,
QuestionID = Convert.ToInt64(d["QuestionID"])
,
Question = Convert.ToString(d["Question"])
,
A = d["A"] == DBNull.Value ? "" : Convert.ToString(d["A"])
,
B = d["B"] == DBNull.Value ? "" : Convert.ToString(d["B"])
,
C = d["C"] == DBNull.Value ? "" : Convert.ToString(d["C"])
,
D = d["D"] == DBNull.Value ? "" : Convert.ToString(d["D"])
,
E = d["E"] == DBNull.Value ? "" : Convert.ToString(d["E"])
//,
//MarksForCorrect = Convert.ToDouble(d["MarksForCorrect"]),
//MarksForInCorrect = Convert.ToDouble(d["MarksForInCorrect"]),
//AttachmentUrl = d["AttachmentUrl"] == DBNull.Value ? "" : Convert.ToString(d["AttachmentUrl"])
}
,
AnswerByApplicant = d["AnswerByApplicant"] == DBNull.Value ? "" : Convert.ToString(d["AnswerByApplicant"])
}).ToList();
return(_ApplicantExamVM);
}
else
{
return(new ApplicantExamVM {
ApplicantAnswers = new List <ApplicantAnswer> {
new ApplicantAnswer {
Question = new QuestionSet {
QuestionID = 0, Question = "No Question available for you this time"
}
}
}
});
}
return(new ApplicantExamVM());
}
