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();
}
