public ActionResult RealExamResult() { ResultEntities realexam = new ResultEntities(); QuestionBL question = new QuestionBL(); realexam = question.GetRightAnswerByUserID(int.Parse(Session["UserId"].ToString())); return(View(realexam)); }
public ResultEntities GetRightAnswerByUserID(int UserId) { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["SchoolDBConnectionString"].ConnectionString); con.Open(); SqlCommand cmd = new SqlCommand("stpGetRightAnswerByUserID", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserId", UserId); SqlDataAdapter da = new SqlDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); con.Close(); ResultEntities topicEntities = new ResultEntities(); //topicEntities.UserId = Convert.ToInt32(ds.Tables[0].Rows[0]["UserId"].ToString()); topicEntities.TotalMarks = Convert.ToDecimal(ds.Tables[0].Rows[0]["TotalMarks"]); topicEntities.MarksObtained = Convert.ToDecimal(ds.Tables[1].Rows[0]["MarksObtained"]); return(topicEntities); }