protected void Button36_Click(object sender, EventArgs e) { var x = Request.QueryString["id"].ToString(); int y = int.Parse(x); int t = db.Tbl_Answer.Count(u => u.Question_ID == y); for (int i = 1; i <= t; i++) { Tbl_Answer rr1 = db.Tbl_Answer.First(u => u.Question_ID == y); db.Tbl_Answer.Remove(rr1); db.SaveChanges(); } Tbl_Question rr = db.Tbl_Question.First(u => u.Question_ID == y); db.Tbl_Question.Remove(rr); db.SaveChanges(); var x1 = Request.QueryString["pr"].ToString(); int y1 = int.Parse(x1); Response.Redirect("ProfEditQuestion.aspx?id=" + y1); }
protected void Button2_Click(object sender, EventArgs e) { var que = new Tbl_Question { Question_Ar = TextBox10.Text, Question_En = TextBox9.Text, Chapter_ID = int.Parse(DropDownList7.SelectedValue.ToString()), Type = DropDownList9.SelectedValue.ToString(), Question_Level = DropDownList8.SelectedValue.ToString(), Time = 60, }; db.Tbl_Question.Add(que); db.SaveChanges(); //que.Question_ID.ToString(); //Tbl_Question rr = db.Tbl_Question.First(u => u.Question_ID == y1); if (DropDownList9.SelectedValue == "MCQ") { var ans1 = new Tbl_Answer { Answer_Ar = TextBox15.Text, Answer_En = TextBox11.Text, Correct_Answer = "0", Question_ID = que.Question_ID, Count = 0, }; db.Tbl_Answer.Add(ans1); db.SaveChanges(); var ans2 = new Tbl_Answer { Answer_Ar = TextBox16.Text, Answer_En = TextBox12.Text, Correct_Answer = "0", Question_ID = que.Question_ID, Count = 0, }; db.Tbl_Answer.Add(ans2); db.SaveChanges(); var ans3 = new Tbl_Answer { Answer_Ar = TextBox17.Text, Answer_En = TextBox13.Text, Correct_Answer = "0", Question_ID = que.Question_ID, Count = 0, }; db.Tbl_Answer.Add(ans3); db.SaveChanges(); var ans4 = new Tbl_Answer { Answer_Ar = TextBox18.Text, Answer_En = TextBox14.Text, Correct_Answer = "0", Question_ID = que.Question_ID, Count = 0, }; db.Tbl_Answer.Add(ans4); db.SaveChanges(); Tbl_Answer rr = db.Tbl_Answer.First(u => u.Question_ID == que.Question_ID && u.Answer_Ar == DropDownList10.Text); rr.Correct_Answer = "1"; db.SaveChanges(); queAr.Text = ""; queEn.Text = ""; TextBox11.Text = ""; TextBox12.Text = ""; TextBox13.Text = ""; TextBox14.Text = ""; TextBox15.Text = ""; TextBox16.Text = ""; TextBox17.Text = ""; TextBox18.Text = ""; } else if (DropDownList9.SelectedValue == "T/F") { var ans1 = new Tbl_Answer { Answer_Ar = "صح", Answer_En = "True", Correct_Answer = "0", Question_ID = que.Question_ID, Count = 0, }; db.Tbl_Answer.Add(ans1); db.SaveChanges(); var ans2 = new Tbl_Answer { Answer_Ar = "خطأ", Answer_En = "False", Correct_Answer = "0", Question_ID = que.Question_ID, Count = 0, }; db.Tbl_Answer.Add(ans2); db.SaveChanges(); Tbl_Answer rr = db.Tbl_Answer.First(u => u.Question_ID == que.Question_ID && u.Answer_Ar == RadioButtonList2.Text); rr.Correct_Answer = "1"; db.SaveChanges(); TextBox10.Text = ""; TextBox9.Text = ""; DropDownList10.Items.Clear(); } DropDownList10.Items.Clear(); }