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