public static ScoreBoardModels GetStudentScoreBoard(string PaperID, string StudentID)
{
ScoreBoardModels models = new ScoreBoardModels();
SqlParameter[] pr = new SqlParameter[] {
new SqlParameter("@StudentID", StudentID),
new SqlParameter("@PaperID", PaperID),
new SqlParameter("@Mode", "GetScoreBoard")
};
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.ConnectionStr(), CommandType.StoredProcedure, "sp_GetStudentPapareList", pr);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
models.PaperName = ds.Tables[0].Rows[0]["Paper_Name"].ToString();
models.Obtain_Marks = ds.Tables[0].Rows[0]["Obtain_Marks"].ToString();
models.TotalQuestion = Convert.ToInt32(ds.Tables[0].Rows[0]["Total_Questions"].ToString());
models.correctQuestions = Convert.ToInt32(ds.Tables[0].Rows[0]["Right_Questions"].ToString());
models.wrongQuestions = Convert.ToInt32(ds.Tables[0].Rows[0]["Wrong_Questions"].ToString());
models.leftQuestions = Convert.ToInt32(ds.Tables[0].Rows[0]["Left_Questions"].ToString());
models.TimeTaken = 50; //Convert.ToInt32(ds.Tables[0].Rows[0]["Duration"].ToString());
models.Duration = 15; // Convert.ToInt32(ds.Tables[0].Rows[0][""].ToString());
models.leftTime = 20; //Convert.ToInt32(ds.Tables[0].Rows[0][""].ToString());
}
return(models);
}
public ActionResult TestReport(string id, string SID)
{
ScoreBoardModels models = new ScoreBoardModels();
if (!string.IsNullOrEmpty(id) && !string.IsNullOrEmpty(SID))
{
models = CommanFunction.GetStudentScoreBoard(CommanFunction.UrlDecode(id), CommanFunction.UrlDecode(SID));
}
return(View(models));
}
