private void LoadQuestion() { try { clsUserInfo userInfo = Session["UserInfo"] as clsUserInfo; if (userInfo == null) { Response.Redirect("/login.aspx"); } string[] sentence_separator = new string[3]; sentence_separator[0] = "I like Rat."; sentence_separator[1] = "I will eat Rat."; sentence_separator[2] = "I am Cat."; correct_answer.Value = "I am Cat.I like Rat.I will eat Rat."; int n = sentence_separator.Length; Label[] Label = new Label[n]; for (int i = 0; i < sentence_separator.Length; i++) { Label[i] = new Label(); Label[i].Text = sentence_separator[i]; HtmlGenericControl li = new HtmlGenericControl("li"); li.Attributes.Add("class", "ui-state-default"); li.Attributes.Add("id", "LI" + i); sortable.Controls.Add(li); li.Controls.Add(Label[i]); } } catch { } }
protected void ASPxCallbackPanelcont_Callback(object sender, CallbackEventArgsBase e) { ASPxCallbackPanel cbPanel = (ASPxCallbackPanel)sender; int upId = Convert.ToInt32(e.Parameter.ToString()); clsUserInfo obj = clsUserInfo.getData(upId); ASPxMemo ASPxMemoCont = (ASPxMemo)cbPanel.FindControl("ASPxMemoCont"); ASPxMemoCont.Text = obj.Address; }
private void LoadQuestion() { try { clsUserInfo userInfo = Session["UserInfo"] as clsUserInfo; if (userInfo == null) { Response.Redirect("/login.aspx"); } string sql = string.Format("SELECT [UID], [GE], [Sentence], [Correct_Answer], [option1],[option2],[option3],[option4],[Sound_FileName] FROM [dbo].[practice] WHERE UID NOT IN (SELECT practiceId from practiceresult where child_id={0})", userInfo.ChildId); DataTable dt1 = new DataTable(); bool isFound = con.GetData(sql, ref dt1); if (isFound) { UID.Value = dt1.Rows[0][0].ToString(); Corret_Answer.Value = dt1.Rows[0][3].ToString(); // lblquestion.Text = dt1.Rows[0][2].ToString(); radiovalue[0] = dt1.Rows[0][4].ToString(); radiovalue[1] = dt1.Rows[0][5].ToString(); radiovalue[2] = dt1.Rows[0][6].ToString(); radiovalue[3] = dt1.Rows[0][7].ToString(); m_FileName = dt1.Rows[0][8].ToString(); } else { divcontrol.Visible = false; Label1.Text = "Good Work! You have completed the Test."; } } catch (Exception e) { } }
protected void Button1_Click(object sender, EventArgs e) { int isansewrcorrect = 0; clsUserInfo userInfo = Session["UserInfo"] as clsUserInfo; string selectedanswer = selected_answer.Value; int childid = userInfo.ChildId; if (Corret_Answer.Value == selectedanswer) { isansewrcorrect = 1; } con.getCon(); String s = "insert into practiceresult(Child_ID,Selected_Answer,IsAnswerCorrect,practiceId) values (@Child_ID,@Selected_Answer,@IsAnswerCorrect,@practiceId)"; con.cmd = new SqlCommand(s, con.con); con.cmd.Parameters.Add("@Child_ID", SqlDbType.VarChar).Value = childid; con.cmd.Parameters.Add("@Selected_Answer", SqlDbType.VarChar).Value = selectedanswer; con.cmd.Parameters.Add("@IsAnswerCorrect", SqlDbType.VarChar).Value = isansewrcorrect; con.cmd.Parameters.Add("@practiceId", SqlDbType.VarChar).Value = UID.Value; con.cmd.ExecuteNonQuery(); System.Threading.Thread.Sleep(1000); con.cmd.Dispose(); con.disCon(); Response.Redirect("~/practice.aspx"); }
protected void Button1_Click(object sender, EventArgs e) { con.getCon(); String s = "select * from child where UserName=@user AND Password=@pass"; con.cmd = new SqlCommand(s, con.con); con.cmd.Parameters.Add("@user", SqlDbType.VarChar).Value = UserName.Text; con.cmd.Parameters.Add("@pass", SqlDbType.VarChar).Value = Password.Text; con.dr = con.cmd.ExecuteReader(); if (con.dr.HasRows) { con.dr.Read(); string sql = string.Format("INSERT INTO Student_Session (Child_ID, StartTime, EndTime) VALUES ({0}, GetDate(), NULL)", con.dr["UID"].ToString()); int uid = con.GetIDFromInsert(sql); clsUserInfo userInfo = new clsUserInfo(); userInfo.SessionId = uid; userInfo.ChildId = Convert.ToInt32(con.dr["UID"].ToString()); userInfo.Grade = Convert.ToInt32(con.dr["Grade"].ToString()); userInfo.UserName = UserName.Text; Session["UserInfo"] = userInfo; Session["username"] = UserName.Text; UserName.Text = ""; Response.Redirect("default.aspx"); } else { UserName.Text = ""; lblMsg.Text = "Invalid Username or Password"; } con.disCon(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { // Session["AppID"] = Convert.ToInt64(Request.QueryString["AppID"]); ; if (Session["SocietyName"] != null) { var txtSocName = FindControl("txtSocietyName") as TextBox; txtSocName.Text = Session["SocietyName"].ToString(); } if (Session["UserID"] != null) { // Session["AppID"] = Convert.ToInt64(DataAccess.ExecSqlScalar("select ApplicationID from Applications where UserId=" + Session["UserID"])); int AppStep = Convert.ToInt16(Session["AppStep"]);// Convert.ToInt16(DataAccess.ExecSqlScalar("select AppStep from Applications where UserId=" + Session["UserID"])); control(AppStep); if (AppStep == 0) { gvUser.ClientSideEvents.Init = "function(s,e)" + "{" + " grid.AddNewRow();" + " }"; } else { gvUser.FilterExpression = ""; gvUser.StartEdit(gvUser.VisibleStartIndex); } pc.ActiveTabIndex = AppStep; if (AppStep >= 2) { int?conMemID = DataAccess.RunSqlMaxNL("select MemberID from CommitteeMembers where MemberRoleID=4 and ApplicationID=" + Convert.ToInt64(Session["AppID"])); int?presMemID = DataAccess.RunSqlMaxNL("select MemberID from CommitteeMembers where MemberRoleID=5 and ApplicationID=" + Convert.ToInt64(Session["AppID"])); int nom = Convert.ToInt16(DataAccess.RunSqlMaxNL("select isnull(CommitteeMembers,6) from Applications where ApplicationID=" + Convert.ToInt64(Session["AppID"]))); RadioButton6.Checked = (6 == nom); RadioButton9.Checked = (9 == nom); RadioButton12.Checked = (12 == nom); if (conMemID != null) { clsUserInfo obj = clsUserInfo.getData(Convert.ToInt16(conMemID)); ASPxMemoCont.Text = obj.Address; cbocontactID.Value = conMemID; } if (presMemID != null) { clsUserInfo obj2 = clsUserInfo.getData(Convert.ToInt16(presMemID)); ASPxMemoPres.Text = obj2.Address; txtPhone.Text = obj2.PhoneNo; cbopres.Value = presMemID; } } } else { Response.Redirect("frmLogin.aspx"); } } }
protected void Button1_Click(object sender, EventArgs e) { con.getCon(); String s = "select * from child where UserName=@user AND Password=@pass"; con.cmd = new SqlCommand(s, con.con); con.cmd.Parameters.Add("@user", SqlDbType.VarChar).Value = UserName.Text; con.cmd.Parameters.Add("@pass", SqlDbType.VarChar).Value = Password.Text; con.dr = con.cmd.ExecuteReader(); if (con.dr.HasRows) { con.dr.Read(); string sql =string.Format("INSERT INTO Student_Session (Child_ID, StartTime, EndTime) VALUES ({0}, GetDate(), NULL)", con.dr["UID"].ToString()); int uid = con.GetIDFromInsert(sql); clsUserInfo userInfo = new clsUserInfo(); userInfo.SessionId = uid; userInfo.ChildId = Convert.ToInt32(con.dr["UID"].ToString()); userInfo.Grade = Convert.ToInt32(con.dr["Grade"].ToString()); userInfo.UserName = UserName.Text; Session["UserInfo"] = userInfo; Session["username"] = UserName.Text; UserName.Text = ""; Response.Redirect("default.aspx"); } else { UserName.Text = ""; lblMsg.Text = "Invalid Username or Password"; } con.disCon(); }
/// <summary> /// 部分修改保存 /// </summary> /// <param name="model">对象clsUserInfo的一个实例参数</param> /// <returns></returns> public int UpdatePart(clsUserInfo model, out string errMsg) { errMsg = string.Empty; int rtn = 0; try { string updateSql = "update tUserInfo set " + "LoginID='" + model.LoginID + "'," + "[Name]='" + model.Name + "'," + "[PassWord]='" + model.PassWord + "'," + "UnitCode='" + model.UnitCode + "'," //+ "WebLoginID='" + model.WebLoginID + "'," //+ "WebPassWord='******'," + "IsAdmin=" + model.IsAdmin + "," + "IsLock=" + model.IsLock + "," + "Remark='" + model.Remark + "'" + " where UserCode='" + model.UserCode + "' "; DataBase.ExecuteCommand(updateSql, out errMsg); rtn = 1; } catch (Exception e) { errMsg = e.Message; } return(rtn); }
/// <summary> /// 插入一条明细记录 /// </summary> /// <param name="userModel"></param> /// <returns></returns> public int Insert(clsUserInfo userModel, out string errMsg) { errMsg = string.Empty; int rtn = 0; try { //WebLoginID,WebPassWord, //+ userModel.WebLoginID + "','" //+ userModel.WebPassWord + "'," string insertSql = "INSERT INTO tUserInfo(UserCode,[LoginID],[Name],[PassWord],UnitCode,IsAdmin,IsLock,[Remark])" + " VALUES('" + userModel.UserCode + "','" + userModel.LoginID + "','" + userModel.Name + "','" + userModel.PassWord + "','" + userModel.UnitCode + "'," + userModel.IsAdmin + "," + userModel.IsLock + ",'" + userModel.Remark + "')"; DataBase.ExecuteCommand(insertSql, out errMsg); rtn = 1; } catch (Exception e) { errMsg = e.Message; } return(rtn); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { btnPrevTest.Visible = true; if (Session["username"] == null) { Response.Redirect("/login.aspx"); } clsUserInfo userInfo = Session["UserInfo"] as clsUserInfo; if (userInfo != null) { string sql = string.Format("SELECT UID, [SessionState] FROM [Student_log] WHERE [Child_ID]={0} ORDER BY UID DESC", userInfo.ChildId); DataTable dt = new DataTable(); bool IsFound = conn.GetData(sql, ref dt); if (IsFound) { int state = Convert.ToInt32(dt.Rows[0][1].ToString()); if (state == 0) { btnPrevTest.Visible = true; userInfo.LogId = Convert.ToInt32(dt.Rows[0][0].ToString()); } } else { btnPrevTest.Visible = false; } } } }
private void LoadQuestion() { try { clsUserInfo userInfo = Session["UserInfo"] as clsUserInfo; if (userInfo == null) { Response.Redirect("/login.aspx"); } int ge = 0; int lastAnswerCorrect = 0; int questionType = 0; string sql = string.Format("SELECT [UID], [currentQuestionType], [currentQuestionNo], [currentGE], [last_answer_correct] FROM [dbo].[Student_log] WHERE UID={0}", userInfo.LogId); DataTable dt1 = new DataTable(); bool isFound = con.GetData(sql, ref dt1); if (isFound) { lastAnswerCorrect = Convert.ToInt32(dt1.Rows[0][4].ToString().Trim()); ge = Convert.ToInt32(dt1.Rows[0][3].ToString().Trim()); questionType = Convert.ToInt32(dt1.Rows[0][1].ToString().Trim()); } QuestionType.Value = questionType.ToString(); if (lastAnswerCorrect == 1) { sql = string.Format("select UID, GE, option1, option2, option3, option4, option5, option6, option7, Correct_Answer, audioFileName FROM mcq_decodable_words_audio where GE>={0} and uid NOT IN (Select QuestionId From Student_ViewLog Where Child_Id={1} AND QuestionType={2}) ORDER BY GE", ge, userInfo.ChildId, questionType); } else { sql = string.Format("select UID, GE, option1, option2, option3, option4, option5, option6, option7, Correct_Answer, audioFileName FROM mcq_decodable_words_audio where GE<={0} and uid NOT IN (Select QuestionId From Student_ViewLog Where Child_Id={1} AND QuestionType={2}) ORDER BY GE DESC", ge, userInfo.ChildId, questionType); } DataTable dt = new DataTable(); bool IsFound = con.GetData(sql, ref dt); if (IsFound) { start_time.Value = DateTime.Now.ToString(); UID.Value = dt.Rows[0][0].ToString(); radiovalue[0] = dt.Rows[0][2].ToString(); radiovalue[1] = dt.Rows[0][3].ToString(); radiovalue[2] = dt.Rows[0][4].ToString(); radiovalue[3] = dt.Rows[0][5].ToString(); radiovalue[4] = dt.Rows[0][6].ToString(); radiovalue[5] = dt.Rows[0][7].ToString(); radiovalue[6] = dt.Rows[0][8].ToString(); m_FileName = dt.Rows[0][10].ToString(); // lblCorrectAnswer.Text = dt.Rows[0][9].ToString(); } } catch (Exception e) { } }
protected void ASPxCallbackcon_Callback(object sender, CallbackEventArgsBase e) { ASPxCallbackPanel cbPanel = (ASPxCallbackPanel)sender; int upId = Convert.ToInt32(e.Parameter.ToString()); clsUserInfo obj2 = clsUserInfo.getData(upId); ASPxTextBox txtPhone = (ASPxTextBox)cbPanel.FindControl("txtPhone"); ASPxMemo ASPxMemoPres = (ASPxMemo)cbPanel.FindControl("ASPxMemoPres"); txtPhone.Text = obj2.PhoneNo; ASPxMemoPres.Text = obj2.Address; }
private void LoadQuestion() { try { clsUserInfo userInfo = Session["UserInfo"] as clsUserInfo; if (userInfo == null) { Response.Redirect("/login.aspx"); } int ge = 0; int lastAnswerCorrect = 0; int questionType = 0; string sql = string.Format("SELECT [UID], [currentQuestionType], [currentQuestionNo], [currentGE], [last_answer_correct] FROM [dbo].[Student_log] WHERE UID={0}", userInfo.LogId); DataTable dt1 = new DataTable(); bool isFound = con.GetData(sql, ref dt1); if (isFound) { lastAnswerCorrect = Convert.ToInt32(dt1.Rows[0][4].ToString().Trim()); ge = Convert.ToInt32(dt1.Rows[0][3].ToString().Trim()); questionType = Convert.ToInt32(dt1.Rows[0][1].ToString().Trim()); } QuestionType.Value = questionType.ToString(); if (lastAnswerCorrect == 1) { sql = string.Format("select UID, GE, Sentences, Correct_Answer,Sound_FileName FROM word_scramble where GE>={0} and uid NOT IN (Select QuestionId From Student_ViewLog Where Child_Id={1} AND QuestionType={2}) ORDER BY GE", ge, userInfo.ChildId, questionType); } else { sql = string.Format("select UID, GE, Sentences, Correct_Answer,Sound_FileName FROM word_scramble where GE<={0} and uid NOT IN (Select QuestionId From Student_ViewLog Where Child_Id={1} AND QuestionType={2}) ORDER BY GE DESC", ge, userInfo.ChildId, questionType); } DataTable dt = new DataTable(); string word = ""; bool IsFound = con.GetData(sql, ref dt); if (IsFound) { word = dt.Rows[0][2].ToString(); start_time.Value = DateTime.Now.ToString(); UID.Value = dt.Rows[0][0].ToString(); m_FileName = dt.Rows[0][4].ToString(); string answer = dt.Rows[0][3].ToString(); answerlength.Value = answer.Length.ToString(); anslength = answer.Length * 50 + "px"; LoadEmptyBox(answer); } LoadWord(word); } catch (Exception e) { } }
private int GetGEFromType(int quetionType) { int ge = 0; clsUserInfo userInfo = Session["UserInfo"] as clsUserInfo; string fieldName = ""; if (userInfo != null) { switch (quetionType) { case 1: fieldName = "Letter_GE"; break; case 2: fieldName = "Sound_GE"; break; case 3: fieldName = "mcq_decodable_words_audio_GE"; break; case 4: fieldName = "mcq_nondecodable_words_audio_GE"; break; case 5: fieldName = "word_scramble_GE"; break; case 6: fieldName = "sentence_GE"; break; case 7: fieldName = "m_sentences_GE"; break; default: break; } string sql = string.Format("SELECT {0} FROM Difficulty_level_Grade WHERE Grade={1}", fieldName, userInfo.Grade); DataTable dt = new DataTable(); bool IsFound = conn.GetData(sql, ref dt); if (IsFound) { ge = Convert.ToInt32(dt.Rows[0][0].ToString()); } } return(ge); }
/// <summary> /// 获取用户实例 /// </summary> /// <param name="whereSql"></param> /// <returns></returns> public clsUserInfo GetInfo(string whereSql) { string errMsg = string.Empty; DataTable dt = null; clsUserInfo userInfo = null; try { System.Text.StringBuilder sb = new System.Text.StringBuilder(); sb.Append("SELECT UserCode,LoginID,Name,PassWord,UnitCode,WebLoginID,WebPassWord,IsLock,IsAdmin,Remark FROM tUserInfo"); //string selectSql = "select UserCode,LoginID,Name,PassWord,UnitCode,WebLoginID,WebPassWord,IsLock,IsAdmin,Remark" // + " from tUserInfo"; if (!whereSql.Equals("")) { sb.Append(" WHERE "); sb.Append(whereSql); // selectSql += " where " + whereSql; } string[] cmd = new string[1] { sb.ToString() }; //sCmd[0] = selectSql; string[] names = new string[1] { "UserInfo" }; // sNames[0] = "UserInfo"; dt = DataBase.GetDataSet(cmd, names, out errMsg).Tables["UserInfo"]; if (dt.Rows.Count > 0) { userInfo = new clsUserInfo(); userInfo.UserCode = dt.Rows[0]["UserCode"].ToString(); userInfo.LoginID = dt.Rows[0]["LoginID"].ToString(); userInfo.Name = dt.Rows[0]["Name"].ToString(); userInfo.PassWord = dt.Rows[0]["PassWord"].ToString(); userInfo.UnitCode = dt.Rows[0]["UnitCode"].ToString(); userInfo.WebLoginID = dt.Rows[0]["WebLoginID"].ToString(); userInfo.WebPassWord = dt.Rows[0]["WebPassWord"].ToString(); userInfo.Remark = dt.Rows[0]["Remark"].ToString(); userInfo.IsLock = Convert.ToBoolean(dt.Rows[0]["IsLock"]); userInfo.IsAdmin = Convert.ToBoolean(dt.Rows[0]["IsAdmin"]); } } catch (Exception e) { errMsg = e.Message; } return(userInfo); }
private void LoadQuestion() { try { clsUserInfo userInfo = Session["UserInfo"] as clsUserInfo; if (userInfo == null) { Response.Redirect("/login.aspx"); } char[] letterArray = new char[3]; letterArray[0] = 'o'; letterArray[1] = 'd'; letterArray[2] = 'g'; string answer = "dog"; LoadEmptyBox(answer); correct_answer.Value = answer; answerlength.Value = answer.Length.ToString(); anslength = answer.Length * 50 + "px"; int n = letterArray.Length; Label[] Label = new Label[n]; for (int i = 0; i < letterArray.Length; i++) { Label[i] = new Label(); Label[i].Text = "" + letterArray[i]; HtmlGenericControl li = new HtmlGenericControl("li"); li.Attributes.Add("class", "ui-state-default"); li.Attributes.Add("id", "LI" + i); drop.Controls.Add(li); li.Controls.Add(Label[i]); } } catch (Exception e) { } }
private void LoadQuestion() { try { clsUserInfo userInfo = Session["UserInfo"] as clsUserInfo; if (userInfo == null) { Response.Redirect("/login.aspx"); } radiovalue[0] = "A"; radiovalue[1] = "B"; radiovalue[2] = "C"; radiovalue[3] = "D"; radiovalue[4] = "E"; // lblCorrectAnswer.Text = "B"; correct_answer.Value = "C"; } catch { } }
protected void Button1_Click(object sender, EventArgs e) { try { clsUserInfo userInfo = Session["UserInfo"] as clsUserInfo; DateTime starttime = Convert.ToDateTime(start_time.Value); DateTime endTime = DateTime.Now; TimeSpan span = endTime.Subtract(starttime); int timeTaken = span.Seconds + (span.Minutes * 60); string selectedanswer = selected_answer.Value; int uid = Convert.ToInt32(UID.Value); int questionType = Convert.ToInt32(QuestionType.Value); Utils.UpdateViewLog(userInfo.ChildId, questionType, uid); string pageName = string.Format("/UpdateQuestion.aspx?QuestionType={0}&QuestionId={1}&selectedAnswer={2}&timeTaken={3}", questionType, uid, selectedanswer, timeTaken); Response.Redirect(pageName); } catch { } }
private void LoadQuestion() { try { clsUserInfo userInfo = Session["UserInfo"] as clsUserInfo; if (userInfo == null) { Response.Redirect("/login.aspx"); } string[] letterArray = new string[3]; letterArray[0] = "am"; letterArray[1] = "happy"; letterArray[2] = "I"; correct_answer.Value = "I am happy"; int n = letterArray.Length; Label[] Label = new Label[n]; for (int i = 0; i < letterArray.Length; i++) { if (letterArray[i] != "") { Label[i] = new Label(); Label[i].Text = "" + letterArray[i]; HtmlGenericControl li = new HtmlGenericControl("li"); li.Attributes.Add("class", "ui-state-default"); li.Attributes.Add("id", "LI" + i); sortable.Controls.Add(li); li.Controls.Add(Label[i]); } // Here you can modify the value of the label which is at labels[i] } } catch (Exception e) { } }
private void LoadQuestion() { try { clsUserInfo userInfo = Session["UserInfo"] as clsUserInfo; if (userInfo == null) { Response.Redirect("/login.aspx"); } radiovalue[0] = "Pird"; radiovalue[1] = "Durb"; radiovalue[2] = "Bird"; radiovalue[3] = "Lerd"; radiovalue[4] = "Brid"; radiovalue[5] = "Bidd"; radiovalue[6] = "Fly"; //lblCorrectAnswer.Text = "T"; correct_answer.Value = "Bird"; } catch { } }
protected void btnNewTest_Click(object sender, EventArgs e) { clsUserInfo userInfo = Session["UserInfo"] as clsUserInfo; if (userInfo != null) { string sql1 = "select top 1 session_id from student_log order by Session_ID desc "; DataTable dt1 = new DataTable(); string sql = "SELECT Sound_GE FROM [Difficulty_level_Grade] Where Grade='" + userInfo.Grade + "'"; DataTable dt = new DataTable(); bool IsFound1 = conn.GetData(sql1, ref dt1); if (IsFound1) { try { int sessionId = Convert.ToInt32(dt1.Rows[0][0].ToString()); if (userInfo.SessionId > sessionId) { sql1 = " delete from student_viewlog"; conn.ExecuteQuery(sql1); } } catch { } } int ge = 0; bool IsFound = conn.GetData(sql, ref dt); if (IsFound) { ge = Convert.ToInt32(dt.Rows[0][0].ToString()); sql = string.Format("INSERT INTO Student_log (Session_ID, Child_ID, TestStartTime, SessionState, currentQuestionType, currentQuestionNo, currentGE, last_answer_correct) VALUES({0},{1},GETDATE(),0, {2}, {3}, {4}, 1)", userInfo.SessionId, userInfo.ChildId, 1, 1, ge); int logId = conn.GetIDFromInsert(sql); userInfo.LogId = logId; Response.Redirect("~/letter_id_training1.aspx"); } } }
protected void Page_Load(object sender, EventArgs e) { if (Session["username"] == null) { Response.Redirect("/login.aspx"); } try { int quetionType = Convert.ToInt32(Request.QueryString["QuestionType"]); int questionId = Convert.ToInt32(Request.QueryString["QuestionId"]); string selectedAnswer = Request.QueryString["SelectedAnswer"].ToString(); int timeTaken = Convert.ToInt32(Request.QueryString["timeTaken"].ToString()); clsUserInfo userInfo = Session["UserInfo"] as clsUserInfo; string tableName = ""; string pageName = ""; if (userInfo != null) { switch (quetionType) { case 1: tableName = "Letter_ID"; break; case 2: tableName = "Sound_ID"; break; case 3: tableName = "mcq_decodable_words_audio"; break; case 4: tableName = "mcq_nondecodable_words_audio"; break; case 5: tableName = "word_scramble"; break; case 6: tableName = "sentence"; break; case 7: tableName = "m_sentences"; break; //case 1: // tableName = "Sound_ID"; // break; //case 2: // tableName = "Letter_ID"; // break; //case 3: // tableName = "m_sentences"; // break; //case 4: // tableName = "sentence"; // break; //case 5: // tableName = "word_scramble"; // break; //case 6: // tableName = "mcq_decodable_words_audio"; // break; //case 7: // tableName = "mcq_nondecodable_words_audio"; // break; default: break; } string sql = string.Format("SELECT UID, GE, Correct_Answer FROM {0} WHERE UID={1}", tableName, questionId); DataTable dt = new DataTable(); int ge = 0; int IsCorrect = 0; bool IsFound = conn.GetData(sql, ref dt); if (IsFound) { int positivejump = 0; int negativejump = 0; DataTable dt1 = new DataTable(); string sql1 = string.Format("SELECT Positivejump, NegativeJump FROM GradeJump WHERE Grade={0} and QuestionType={1}", userInfo.Grade, quetionType); bool IsFound1 = conn.GetData(sql1, ref dt1); if (IsFound1) { positivejump = Convert.ToInt32(dt1.Rows[0][0].ToString()); negativejump = Convert.ToInt32(dt1.Rows[0][1].ToString()); } ge = Convert.ToInt32(dt.Rows[0][1].ToString()); string correctanswer = dt.Rows[0][2].ToString(); if (quetionType == 6 || quetionType == 7) { string x = string.Join(" ", Regex.Split(correctanswer, @"(?:\r\n|\n|\r)")); string correctanswer1 = x.Replace(" ", ""); string selectedAnswer1 = selectedAnswer.Replace(" ", ""); if (correctanswer1 == selectedAnswer1) { IsCorrect = 1; ge = ge + positivejump; } else { IsCorrect = 0; ge = ge - negativejump; } } else { if (correctanswer == selectedAnswer) { IsCorrect = 1; ge = ge + positivejump; } else { IsCorrect = 0; ge = ge - negativejump; } } } sql = "select currentQuestionType, currentQuestionNo, currentGE from Student_log where UID=" + userInfo.LogId; dt = new DataTable(); int currentQuestionType = 0; int currentQuestionNo = 0; IsFound = conn.GetData(sql, ref dt); if (IsFound) { currentQuestionNo = Convert.ToInt32(dt.Rows[0][1].ToString()); currentQuestionType = Convert.ToInt32(dt.Rows[0][0].ToString()); } sql = string.Format("UPDATE Student_log SET {0}_question_{1}_uid={2}, {0}_question_{1}_selected_answer='{3}', {0}_question_{1}_answer_correct={4}, {0}_question_{1}_total_time={5} WHERE UID={6}", tableName, currentQuestionNo, questionId, selectedAnswer, IsCorrect, timeTaken, userInfo.LogId); conn.ExecuteQuery(sql); currentQuestionNo++; if (currentQuestionNo > 7) { currentQuestionNo = 1; currentQuestionType++; ge = GetGEFromType(currentQuestionType); } sql = string.Format("UPDATE Student_log SET currentQuestionType={0}, currentQuestionNo={1}, currentGE={2},last_answer_correct={4} WHERE UID={3}", currentQuestionType, currentQuestionNo, ge, userInfo.LogId, IsCorrect); conn.ExecuteQuery(sql); //----Check next question------- int lastAnswerCorrect = 0; int questionType = 0; string sql2 = string.Format("SELECT [UID], [currentQuestionType], [currentQuestionNo], [currentGE], [last_answer_correct] FROM [dbo].[Student_log] WHERE UID={0}", userInfo.LogId); DataTable dt2 = new DataTable(); bool isFound = conn.GetData(sql2, ref dt2); if (isFound) { lastAnswerCorrect = Convert.ToInt32(dt2.Rows[0][4].ToString().Trim()); ge = Convert.ToInt32(dt2.Rows[0][3].ToString().Trim()); questionType = Convert.ToInt32(dt2.Rows[0][1].ToString().Trim()); } if (lastAnswerCorrect == 1) { sql = string.Format("select GE, UID from {3} where GE>={0} and uid NOT IN (Select QuestionId From Student_ViewLog Where Child_Id={1} AND QuestionType={2}) ORDER BY GE", ge, userInfo.ChildId, questionType, tableName); } else { sql = string.Format("select GE, UID from {3} where GE<={0} and uid NOT IN (Select QuestionId From Student_ViewLog Where Child_Id={1} AND QuestionType={2}) ORDER BY GE DESC", ge, userInfo.ChildId, questionType, tableName); } DataTable dt3 = new DataTable(); bool IsFound2 = conn.GetData(sql, ref dt3); if (!IsFound2) { currentQuestionNo = 1; currentQuestionType++; ge = GetGEFromType(currentQuestionType); sql = string.Format("UPDATE Student_log SET currentQuestionType={0}, currentQuestionNo={1}, currentGE={2},last_answer_correct={4} WHERE UID={3}", currentQuestionType, currentQuestionNo, ge, userInfo.LogId, IsCorrect); conn.ExecuteQuery(sql); pageName = GetPageName(currentQuestionType); } else { if (currentQuestionNo != 1) { switch (currentQuestionType) { case 1: pageName = "letter_id.aspx"; break; case 2: pageName = "sound_id.aspx"; break; case 3: pageName = "test_mcq_audio.aspx"; break; case 4: pageName = "test_mcq_non-decodable.aspx"; break; case 5: pageName = "final_ls.aspx"; break; case 6: pageName = "Sentence.aspx"; break; case 7: pageName = "m_sentences.aspx"; break; default: break; } } else { pageName = GetPageName(currentQuestionType); } } if (pageName == "") { lblend.Text = "Good Work! You have completed the Letters2Meaning game. "; } else { Response.Redirect(pageName); } } } catch (Exception) { } }
private void LoadQuestion() { try { clsUserInfo userInfo = Session["UserInfo"] as clsUserInfo; if (userInfo == null) { Response.Redirect("/login.aspx"); } int ge = 0; int lastAnswerCorrect = 0; int questionType = 0; string sql = string.Format("SELECT [UID], [currentQuestionType], [currentQuestionNo], [currentGE], [last_answer_correct] FROM [dbo].[Student_log] WHERE UID={0}", userInfo.LogId); DataTable dt1 = new DataTable(); bool isFound = con.GetData(sql, ref dt1); if (isFound) { lastAnswerCorrect = Convert.ToInt32(dt1.Rows[0][4].ToString().Trim()); ge = Convert.ToInt32(dt1.Rows[0][3].ToString().Trim()); questionType = Convert.ToInt32(dt1.Rows[0][1].ToString().Trim()); } QuestionType.Value = questionType.ToString(); if (lastAnswerCorrect == 1) { sql = string.Format("select GE,Correct_Answer,Sound_FileName, UID from Letter_ID where GE>={0} and uid NOT IN (Select QuestionId From Student_ViewLog Where Child_Id={1} AND QuestionType={2}) ORDER BY GE", ge, userInfo.ChildId, questionType); } else { sql = string.Format("select GE,Correct_Answer,Sound_FileName, UID from Letter_ID where GE<={0} and uid NOT IN (Select QuestionId From Student_ViewLog Where Child_Id={1} AND QuestionType={2}) ORDER BY GE DESC", ge, userInfo.ChildId, questionType); } DataTable dt = new DataTable(); bool IsFound = con.GetData(sql, ref dt); if (IsFound) { sound_id.Value = dt.Rows[0][0].ToString(); start_time.Value = DateTime.Now.ToString(); str = dt.Rows[0][1].ToString().ToCharArray(); // myReader["Correct_Answer"].ToString().ToCharArray(); m_FileName = dt.Rows[0][2].ToString(); //lblCorrectAnswer.Text = str[0].ToString(); UID.Value = dt.Rows[0][3].ToString(); } } catch (Exception e) { } try { char[] a = RandomString(str[0]).ToCharArray(); m_Question = new List <string>(); foreach (var item in a) { m_Question.Add(item.ToString()); } } catch { } }