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