protected void btnLogin_Click(object sender, EventArgs e) { //open connection //set reference to database //String query = "select * UserAccounts where Username= '******' and Password='******'"; // OleDbConnection conn = Connections.connect(); //OleDbCommand processQuery = new OleDbCommand(query, conn);//execute the query var service = new OnlineTestService();//create object int userID; var pulledData = service.validUser(txtUsername.Text, txtPassword.Text, out userID); if (pulledData.Keys.First() == false) { lblInvalidCredentials.Visible = true; } if (pulledData.Keys.First() & pulledData.Values.First() == false) { Tests tests = new Tests(); Response.Redirect($"~/Tests.aspx?userID={userID}");//INTERPOLATION } else if ((pulledData.Keys.First() && pulledData.Values.First() == true)) { AddQuestions addQuestions = new AddQuestions(); Response.Redirect($"~/AddQuestions.aspx?userID={userID}"); } } //buton click
protected void btnAddQuestion_Click(object sender, EventArgs e) { lblError.Visible = false; String topic = txtTopic.Text; String question = txtQuestion.Text; //1=easy 2==medium 3=hard int difficulty = Convert.ToInt32(ddlDifficulty.SelectedValue.ToString()); String questionTypeA = ddlQuestionType.SelectedValue; int questionType = 0; if (Convert.ToInt32(questionTypeA) == 1) { if (txtTopic.Text.Equals("") || txtQuestion.Text.Equals("") || txtSingleAns.Text.Equals("")) { lblError.Visible = true; lblQuestionAddedConfirmation.Visible = false; } } //if (Convert.ToInt32(questionTypeA) == 2) {//2 value = multiple choice selected // questionType = 1; //} if (Convert.ToInt32(questionTypeA) == 2) { if (txtTopic.Text.Equals("") || txtQuestion.Text.Equals("") || txtA.Text.Equals("") || txtB.Text.Equals("") || txtC.Text.Equals("") || txtD.Text.Equals("")) { lblError.Visible = true; lblQuestionAddedConfirmation.Visible = false; } } if (lblError.Visible == false) { //1=6-10yrs 2=11-13yrs 3=14-16yrs int level = Convert.ToInt32(ddlQuizLevel.SelectedValue.ToString()); String correctSingleAns = txtSingleAns.Text; //collect 4 answers for mutiple choice type questions String ansA = txtA.Text; String ansB = txtB.Text; String ansC = txtC.Text; String ansD = txtD.Text; //identify the correct answers **there can be more than one correct answer for the mutiple choice //correct answer is the one that admin chooses to tick bool isA_right = chkA.Checked; bool isB_right = chkB.Checked; bool isC_right = chkC.Checked; bool isD_right = chkD.Checked; var service = new OnlineTestService(); //create object //insert the new question created service.insertQuestions(topic, question, difficulty, level, questionType, correctSingleAns, ansA, ansB, ansC, ansD, isA_right, isB_right, isC_right, isD_right); //insert the corresponding answers lblQuestionAddedConfirmation.Visible = true; lblError.Visible = false; } }
protected void Page_Load(object sender, EventArgs e) { OnlineTestService service = new OnlineTestService(); List <String> goldMedallistsList = service.getGoldMeds(); List <String> silverMedallistsList = service.getSilverMeds(); foreach (String name in goldMedallistsList) { txtGold.Text += name + Environment.NewLine; } foreach (String name in silverMedallistsList) { txtSilver.Text += name + Environment.NewLine; } }