Example #1
0
        public EnquiryResult GetEnquiryResult(int UserId, int QuizId)
        {
            EnquiryResult objEnquiryResult = new EnquiryResult();

            try
            {
                db.parameters.Clear();
                db.AddParameter("@QuizId", SqlDbType.Int, QuizId);
                db.AddParameter("@UserId", SqlDbType.Int, UserId);

                DataSet ds = db.FillData("sp_AssessmentResultGet");
                if (ds.Tables.Count > 0)
                {
                    objEnquiryResult.UserId        = Convert.ToInt32(ds.Tables[0].Rows[0][0]);
                    objEnquiryResult.FullName      = Convert.ToString(ds.Tables[0].Rows[0][1]);
                    objEnquiryResult.Score         = Convert.ToInt32(ds.Tables[0].Rows[0][2]);
                    objEnquiryResult.NoOfQuestions = Convert.ToInt32(ds.Tables[0].Rows[0][3]);
                }
                return(objEnquiryResult);
            }
            catch (Exception ex)
            {
                newException.AddException(ex);
                throw ex;
            }
        }
        public ActionResult Result()
        {
            EnquiryResult enquiryResult = new EnquiryResult();

            try
            {
                int UserId = Convert.ToInt32(Session["Enquiry"]);
                int QuizId = Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["SurveyId"]);
                enquiryResult = quizRepository.GetEnquiryResult(UserId, QuizId);
                if (enquiryResult.Score > 0)
                {
                    enquiryResult.Score = (enquiryResult.Score * 100) / enquiryResult.NoOfQuestions;
                }
                //enquiryResult.AssessmentLink = System.Configuration.ConfigurationManager.AppSettings["AssessmentLink"];
            }
            catch (Exception ex)
            {
                newException.AddException(ex);
                TempData["Issue"] = "Issue Occured";
            }
            return(View(enquiryResult));
        }