public static string submit(List <tbl_userans> tbl_ua) { foreach (var ua in tbl_ua) { ua.createddt = Convert.ToDateTime(ua.createddt).ToString("yyyy-MM-dd HH:mm:ss"); } string message = ""; var sid = Convert.ToInt32(System.Web.HttpContext.Current.Session["uid"]); try { foreach (var ua in tbl_ua) { DataTable dt = new clsQuiz().submit(0, sid, ua.qid, ua.aid, ua.createddt).Tables[0]; message = dt.Rows[0][0].ToString(); } } catch (Exception ex) { Custom.generatelog(null, null, "submit", ex.Message + ex.StackTrace); message = ex.Message + "|2"; } return(message); }
public static List <tbl_results> getResults() { string message = ""; List <tbl_results> data_str1 = new List <tbl_results>(); var sid = Convert.ToInt32(System.Web.HttpContext.Current.Session["uid"]); try { DataTable dt = new clsQuiz().getResults(sid).Tables[0]; tbl_results tbl_row; foreach (DataRow dr in dt.Rows) { tbl_row = new tbl_results(); tbl_row.uaid = Convert.ToInt32(dr["uaid"]); tbl_row.sid = Convert.ToInt32(dr["sid"]); tbl_row.qid = Convert.ToInt32(dr["qid"]); tbl_row.titleq = Convert.ToString(dr["titleq"]); tbl_row.ques = Convert.ToString(dr["ques"]); tbl_row.aid = Convert.ToInt32(dr["aid"]); tbl_row.titlea = Convert.ToString(dr["titlea"]); tbl_row.ans = Convert.ToString(dr["ans"]); tbl_row.correct = Convert.ToBoolean(dr["correct"]); tbl_row.createddt = Convert.ToString(dr["createddt"]); data_str1.Add(tbl_row); } } catch (Exception ex) { Custom.generatelog(null, null, "get result", ex.Message + ex.StackTrace); message = ex.Message + "|2"; } return(data_str1); }
public static List <tbl_ansmaster> getAnswers(string user) { string message = ""; List <tbl_ansmaster> data_str1 = new List <tbl_ansmaster>(); try { DataTable dt = new clsQuiz().getAnswers().Tables[0]; tbl_ansmaster tbl_row; foreach (DataRow dr in dt.Rows) { tbl_row = new tbl_ansmaster(); tbl_row.aid = Convert.ToInt32(dr["aid"]); tbl_row.qid = Convert.ToInt32(dr["qid"]); tbl_row.title = Convert.ToString(dr["title"]); tbl_row.ans = Convert.ToString(dr["ans"]); //tbl_row.correct = Convert.ToBoolean(dr["correct"]); tbl_row.createdby = Convert.ToString(dr["createdby"]); tbl_row.createddt = Convert.ToString(dr["createddt"]); tbl_row.modifiedby = Convert.ToString(dr["modifiedby"]); tbl_row.modifieddt = Convert.ToString(dr["modifieddt"]); data_str1.Add(tbl_row); } message = ""; } catch (Exception ex) { Custom.generatelog(null, null, "get answers", ex.Message + ex.StackTrace); message = ex.Message + "|2"; } return(data_str1); }