protected void Button1_Click(object sender, EventArgs e) { if (DropDownList17.Text == "") { var ExamStruc = new Tbl_ExamStructure { Chapter_ID = int.Parse(DropDownList12.SelectedValue.ToString()), Num_Ques_Mcq_A = 0, Num_Ques_Mcq_B = int.Parse(DropDownList18.Text), Num_Ques_Mcq_C = int.Parse(DropDownList19.Text), Num_Ques_TF_A = int.Parse(DropDownList20.Text), Num_Ques_TF_B = int.Parse(DropDownList21.Text), Num_Ques_TF_C = int.Parse(DropDownList22.Text), }; db.Tbl_ExamStructure.Add(ExamStruc); db.SaveChanges(); Response.Redirect("ProfExamStructure.aspx"); } else if (DropDownList20.Text == "") { var ExamStruc1 = new Tbl_ExamStructure { Chapter_ID = int.Parse(DropDownList12.SelectedValue.ToString()), Num_Ques_Mcq_A = int.Parse(DropDownList17.Text), Num_Ques_Mcq_B = int.Parse(DropDownList18.Text), Num_Ques_Mcq_C = int.Parse(DropDownList19.Text), Num_Ques_TF_A = 0, Num_Ques_TF_B = int.Parse(DropDownList21.Text), Num_Ques_TF_C = int.Parse(DropDownList22.Text), }; db.Tbl_ExamStructure.Add(ExamStruc1); db.SaveChanges(); Response.Redirect("ProfExamStructure.aspx"); } else { var ExamStruc = new Tbl_ExamStructure { Chapter_ID = int.Parse(DropDownList12.SelectedValue.ToString()), Num_Ques_Mcq_A = int.Parse(DropDownList17.Text), Num_Ques_Mcq_B = int.Parse(DropDownList18.Text), Num_Ques_Mcq_C = int.Parse(DropDownList19.Text), Num_Ques_TF_A = int.Parse(DropDownList20.Text), Num_Ques_TF_B = int.Parse(DropDownList21.Text), Num_Ques_TF_C = int.Parse(DropDownList22.Text), }; db.Tbl_ExamStructure.Add(ExamStruc); db.SaveChanges(); var x = Request.QueryString["id"].ToString(); int y = int.Parse(x); Response.Redirect("ProfExamStructure.aspx?id=" + y); } }
protected void Button4_Click(object sender, EventArgs e) { if (DropDownList6.Text == "") { var ExamStruc = new Tbl_ExamStructure { Chapter_ID = int.Parse(DropDownList1.SelectedValue.ToString()), Num_Ques_Mcq_A = 0, Num_Ques_Mcq_B = int.Parse(DropDownList7.Text), Num_Ques_Mcq_C = int.Parse(DropDownList8.Text), Num_Ques_TF_A = int.Parse(DropDownList9.Text), Num_Ques_TF_B = int.Parse(DropDownList10.Text), Num_Ques_TF_C = int.Parse(DropDownList11.Text), }; db.Tbl_ExamStructure.Add(ExamStruc); db.SaveChanges(); Response.Redirect("ProfExamStructure.aspx"); } else if (DropDownList9.Text == "") { var ExamStruc1 = new Tbl_ExamStructure { Chapter_ID = int.Parse(DropDownList1.SelectedValue.ToString()), Num_Ques_Mcq_A = int.Parse(DropDownList6.Text), Num_Ques_Mcq_B = int.Parse(DropDownList7.Text), Num_Ques_Mcq_C = int.Parse(DropDownList8.Text), Num_Ques_TF_A = 0, Num_Ques_TF_B = int.Parse(DropDownList10.Text), Num_Ques_TF_C = int.Parse(DropDownList11.Text), }; db.Tbl_ExamStructure.Add(ExamStruc1); db.SaveChanges(); Response.Redirect("ProfExamStructure.aspx"); } else { var ExamStruc = new Tbl_ExamStructure { Chapter_ID = int.Parse(DropDownList1.SelectedValue.ToString()), Num_Ques_Mcq_A = int.Parse(DropDownList6.Text), Num_Ques_Mcq_B = int.Parse(DropDownList7.Text), Num_Ques_Mcq_C = int.Parse(DropDownList8.Text), Num_Ques_TF_A = int.Parse(DropDownList9.Text), Num_Ques_TF_B = int.Parse(DropDownList10.Text), Num_Ques_TF_C = int.Parse(DropDownList11.Text), }; db.Tbl_ExamStructure.Add(ExamStruc); db.SaveChanges(); Response.Redirect("ProfExamStructure.aspx"); } }
protected void Timer1_Tick(object sender, EventArgs e) { //var x = Request.QueryString["st"].ToString(); //int y = int.Parse(x); //Response.Redirect("StudentChoseExam.aspx?id=" + y); var chap = Request.QueryString["id"].ToString(); int ch = int.Parse(chap); Tbl_ExamStructure rr = db.Tbl_ExamStructure.First(u => u.Chapter_ID == ch); int MCQA = rr.Num_Ques_Mcq_A; int MCQB = rr.Num_Ques_Mcq_B; int MCQC = rr.Num_Ques_Mcq_C; int TFA = rr.Num_Ques_TF_A; int TFB = rr.Num_Ques_TF_B; int TFC = rr.Num_Ques_TF_C; int ques = MCQA + MCQB + MCQC + TFA + TFB + TFC; var x = Request.QueryString["st"].ToString(); int y = int.Parse(x); Tbl_chapter rr1 = db.Tbl_chapter.First(u => u.Chapter_ID == ch); int sub = rr1.Subject_ID; var re = new Tbl_Result { Student_ID = y, Chapter_ID = ch, Result = int.Parse(Label8.Text), Subject_ID = sub, }; db.Tbl_Result.Add(re); db.SaveChanges(); Label1.Text = "your result " + Label8.Text + " from " + ques.ToString(); Label9.Text = "الدرجة" + Label8.Text + " من" + ques.ToString(); RadioButtonList1.Visible = false; RadioButtonList2.Visible = false; Button1.Visible = false; Button2.Visible = true; }
protected void Button1_Click(object sender, EventArgs e) { int mark = int.Parse(RadioButtonList1.SelectedValue.ToString()); int final_mark = int.Parse(Label8.Text); final_mark += mark; Label8.Text = final_mark.ToString(); var chap = Request.QueryString["id"].ToString(); int ch = int.Parse(chap); Tbl_ExamStructure rr = db.Tbl_ExamStructure.First(u => u.Chapter_ID == ch); int MCQA = rr.Num_Ques_Mcq_A; int MCQB = rr.Num_Ques_Mcq_B; int MCQC = rr.Num_Ques_Mcq_C; int TFA = rr.Num_Ques_TF_A; int TFB = rr.Num_Ques_TF_B; int TFC = rr.Num_Ques_TF_C; int ques = MCQA + MCQB + MCQC + TFA + TFB + TFC; int y1 = int.Parse(Label2.Text); int y2 = int.Parse(Label3.Text); int y3 = int.Parse(Label4.Text); int y4 = int.Parse(Label5.Text); int y5 = int.Parse(Label6.Text); int y6 = int.Parse(Label7.Text); int num = y1 + y2 + y3 + y4 + y5 + y6; if (y1 < MCQA) { var rrA = db.Tbl_Question.Where(u => u.Chapter_ID == ch && u.Question_Level == "A" && u.Type == "MCQ").OrderBy(u => u.Question_ID).Skip(y1); foreach (var item in rrA) { Label1.Text = item.Question_En.ToString(); y1 += 1; Label2.Text = y1.ToString(); int qA = item.Question_ID; var stateidA = from Tbl_Answer in db.Tbl_Answer where Tbl_Answer.Question_ID == qA select new { Tbl_Answer.Answer_En, Tbl_Answer.Correct_Answer }; var statenameA = stateidA.ToList(); if (statenameA.Count > 0) { RadioButtonList1.DataSource = statenameA.ToList(); RadioButtonList1.DataTextField = "Answer_En"; RadioButtonList1.DataValueField = "Correct_Answer"; RadioButtonList1.DataBind(); } break; } } else if (y2 < MCQB) { var rrA = db.Tbl_Question.Where(u => u.Chapter_ID == ch && u.Question_Level == "B" && u.Type == "MCQ").OrderBy(u => u.Question_ID).Skip(y2); foreach (var item in rrA) { Label1.Text = item.Question_En.ToString(); y2 += 1; Label3.Text = y2.ToString(); int qA = item.Question_ID; var stateidA = from Tbl_Answer in db.Tbl_Answer where Tbl_Answer.Question_ID == qA select new { Tbl_Answer.Answer_En, Tbl_Answer.Correct_Answer }; var statenameA = stateidA.ToList(); if (statenameA.Count > 0) { RadioButtonList1.DataSource = statenameA.ToList(); RadioButtonList1.DataTextField = "Answer_En"; RadioButtonList1.DataValueField = "Correct_Answer"; RadioButtonList1.DataBind(); } break; } } else if (y3 < MCQC) { var rrA = db.Tbl_Question.Where(u => u.Chapter_ID == ch && u.Question_Level == "C" && u.Type == "MCQ").OrderBy(u => u.Question_ID).Skip(y3); foreach (var item in rrA) { Label1.Text = item.Question_En.ToString(); y3 += 1; Label4.Text = y3.ToString(); int qA = item.Question_ID; var stateidA = from Tbl_Answer in db.Tbl_Answer where Tbl_Answer.Question_ID == qA select new { Tbl_Answer.Answer_En, Tbl_Answer.Correct_Answer }; var statenameA = stateidA.ToList(); if (statenameA.Count > 0) { RadioButtonList1.DataSource = statenameA.ToList(); RadioButtonList1.DataTextField = "Answer_En"; RadioButtonList1.DataValueField = "Correct_Answer"; RadioButtonList1.DataBind(); } break; } } else if (y4 < TFA) { var rrA = db.Tbl_Question.Where(u => u.Chapter_ID == ch && u.Question_Level == "A" && u.Type == "T/F").OrderBy(u => u.Question_ID).Skip(y4); foreach (var item in rrA) { Label1.Text = item.Question_En.ToString(); y4 += 1; Label5.Text = y4.ToString(); int qA = item.Question_ID; var stateidA = from Tbl_Answer in db.Tbl_Answer where Tbl_Answer.Question_ID == qA select new { Tbl_Answer.Answer_En, Tbl_Answer.Correct_Answer }; var statenameA = stateidA.ToList(); if (statenameA.Count > 0) { RadioButtonList1.DataSource = statenameA.ToList(); RadioButtonList1.DataTextField = "Answer_En"; RadioButtonList1.DataValueField = "Correct_Answer"; RadioButtonList1.DataBind(); } break; } } else if (y5 < TFB) { var rrA = db.Tbl_Question.Where(u => u.Chapter_ID == ch && u.Question_Level == "B" && u.Type == "T/F").OrderBy(u => u.Question_ID).Skip(y5); foreach (var item in rrA) { Label1.Text = item.Question_En.ToString(); y5 += 1; Label6.Text = y5.ToString(); int qA = item.Question_ID; var stateidA = from Tbl_Answer in db.Tbl_Answer where Tbl_Answer.Question_ID == qA select new { Tbl_Answer.Answer_En, Tbl_Answer.Correct_Answer }; var statenameA = stateidA.ToList(); if (statenameA.Count > 0) { RadioButtonList1.DataSource = statenameA.ToList(); RadioButtonList1.DataTextField = "Answer_En"; RadioButtonList1.DataValueField = "Correct_Answer"; RadioButtonList1.DataBind(); } break; } } else if (y6 < TFC) { var rrA = db.Tbl_Question.Where(u => u.Chapter_ID == ch && u.Question_Level == "C" && u.Type == "T/F").OrderBy(u => u.Question_ID).Skip(y6); foreach (var item in rrA) { Label1.Text = item.Question_En.ToString(); y6 += 1; Label7.Text = y6.ToString(); int qA = item.Question_ID; var stateidA = from Tbl_Answer in db.Tbl_Answer where Tbl_Answer.Question_ID == qA select new { Tbl_Answer.Answer_En, Tbl_Answer.Correct_Answer }; var statenameA = stateidA.ToList(); if (statenameA.Count > 0) { RadioButtonList1.DataSource = statenameA.ToList(); RadioButtonList1.DataTextField = "Answer_En"; RadioButtonList1.DataValueField = "Correct_Answer"; RadioButtonList1.DataBind(); } break; } } else if (num == ques) { var x = Request.QueryString["st"].ToString(); int y = int.Parse(x); Tbl_chapter rr1 = db.Tbl_chapter.First(u => u.Chapter_ID == ch); int sub = rr1.Subject_ID; var re = new Tbl_Result { Student_ID = y, Chapter_ID = ch, Result = int.Parse(Label8.Text), Subject_ID = sub, }; db.Tbl_Result.Add(re); db.SaveChanges(); Label1.Text = "your result " + Label8.Text + " from " + ques.ToString(); RadioButtonList1.Visible = false; Button1.Visible = false; Button2.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var chap = Request.QueryString["id"].ToString(); int ch = int.Parse(chap); Tbl_ExamStructure rr = db.Tbl_ExamStructure.First(u => u.Chapter_ID == ch); int MCQA = rr.Num_Ques_Mcq_A; int MCQB = rr.Num_Ques_Mcq_B; int MCQC = rr.Num_Ques_Mcq_C; Tbl_Question rrA = db.Tbl_Question.First(u => u.Chapter_ID == ch && u.Question_Level == "A"); Tbl_Question rrB = db.Tbl_Question.First(u => u.Chapter_ID == ch && u.Question_Level == "B"); Tbl_Question rrC = db.Tbl_Question.First(u => u.Chapter_ID == ch && u.Question_Level == "C"); int qA = rrA.Question_ID; int qB = rrB.Question_ID; int qC = rrC.Question_ID; if (MCQA != 0) { Label1.Text = rrA.Question_En.ToString(); var stateidA = from Tbl_Answer in db.Tbl_Answer where Tbl_Answer.Question_ID == qA select new { Tbl_Answer.Answer_En, Tbl_Answer.Correct_Answer }; var statenameA = stateidA.ToList(); if (statenameA.Count > 0) { RadioButtonList1.DataSource = statenameA.ToList(); RadioButtonList1.DataTextField = "Answer_En"; RadioButtonList1.DataValueField = "Correct_Answer"; RadioButtonList1.DataBind(); } } else if (MCQA == 0 && MCQB != 0) { Label1.Text = rrB.Question_En.ToString(); Label3.Text = 1.ToString(); var stateidB = from Tbl_Answer in db.Tbl_Answer where Tbl_Answer.Question_ID == qB select new { Tbl_Answer.Answer_En, Tbl_Answer.Correct_Answer }; var statenameB = stateidB.ToList(); if (statenameB.Count > 0) { RadioButtonList1.DataSource = statenameB.ToList(); RadioButtonList1.DataTextField = "Answer_En"; RadioButtonList1.DataValueField = "Correct_Answer"; RadioButtonList1.DataBind(); } } else { Label1.Text = rrC.Question_En.ToString(); Label4.Text = 1.ToString(); var stateidC = from Tbl_Answer in db.Tbl_Answer where Tbl_Answer.Question_ID == qC select new { Tbl_Answer.Answer_En, Tbl_Answer.Correct_Answer }; var statenameC = stateidC.ToList(); if (statenameC.Count > 0) { RadioButtonList1.DataSource = statenameC.ToList(); RadioButtonList1.DataTextField = "Answer_En"; RadioButtonList1.DataValueField = "Correct_Answer"; RadioButtonList1.DataBind(); } } } }