public ActionResult TaoCauTraLoi(int ID)
{
CAU_HOI q = db.CAU_HOI.Find(ID);
ViewBag.Macauhoi = q.MaCauHoi;
ViewBag.Socautraloi = q.SoCauTraLoi;
return(View());
}
public ActionResult Create(CAU_HOI model)
{
if (ModelState.IsValid)
{
db.CAU_HOI.Add(model);
db.SaveChanges();
return(RedirectToAction("TaoCauTraLoi", new { ID = model.MaCauHoi }));
}
return(View());
}
public ActionResult Edit(int id, CAU_HOI f, HttpPostedFileBase IMAGE_URL)
{
var question = model.CAU_HOI.FirstOrDefault(x => x.ID == id);
question.CAU_HOI1 = f.CAU_HOI1;
question.MO_TA = f.MO_TA;
question.ID_DANH_MUC = f.ID_DANH_MUC;
question.NGAY_TAO = DateTime.Now;
question.ID_TAI_KHOAN = f.ID_TAI_KHOAN;
model.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(CAU_HOI f, HttpPostedFileBase IMAGE_URL)
{
var question = new CAU_HOI();
question.CAU_HOI1 = f.CAU_HOI1;
question.MO_TA = f.MO_TA;
question.ID_DANH_MUC = f.ID_DANH_MUC;
question.NGAY_TAO = DateTime.Now;
question.ID_TAI_KHOAN = f.ID_TAI_KHOAN;
model.CAU_HOI.Add(question);
model.SaveChanges();
return(RedirectToAction("Index"));
}
private void AddCauHoi()
{
var id = data.CAU_HOIs.Where(u => u.MaCauHoi == int.Parse(txt_idq.Text)).SingleOrDefault <CAU_HOI>();
if (id != null)
{
tb_thongbao.Text = "Mã Câu hỏi đã tồn tại.";
return;
}
else
{
CAU_HOI h = new CAU_HOI();
h.MaCauHoi = int.Parse(txt_idq.Text);
h.MaLopHoc = cb_lop.SelectedValue.ToString();
h.CauHoi = txt_Cauhoi.Text;
h.DapAnA = txt_da1.Text;
h.DapAnB = txt_da2.Text;
h.DapAnC = txt_da3.Text;
h.DapAnD = txt_da4.Text;
if (daA.IsChecked == true)
{
traloi = "A";
}
else if (daB.IsChecked == true)
{
traloi = "B";
}
else if (daC.IsChecked == true)
{
traloi = "C";
}
else if (daB.IsChecked == true)
{
traloi = "D";
}
h.TraLoi = traloi;
data.CAU_HOIs.InsertOnSubmit(h);
data.SubmitChanges();
CT_DETHI ct = new CT_DETHI();
ct.MaDeThi = int.Parse(cb_dethi.Text);
ct.MaCauHoi = int.Parse(txt_idq.Text);
data.CT_DETHIs.InsertOnSubmit(ct);
data.SubmitChanges();
tb_thongbao.Text = "Thêm câu hỏi thành công!";
}
}
private void UpdateCauHoi()
{
CAU_HOI h = (data.CAU_HOIs.Where(t => t.MaCauHoi == int.Parse(txt_idq.Text)).SingleOrDefault <CAU_HOI>());
try
{
h.MaLopHoc = cb_lop.SelectedValue.ToString();
h.CauHoi = txt_Cauhoi.Text;
h.DapAnA = txt_da1.Text;
h.DapAnB = txt_da2.Text;
h.DapAnC = txt_da3.Text;
h.DapAnD = txt_da4.Text;
if (daA.IsChecked == true)
{
traloi = "A";
}
else if (daB.IsChecked == true)
{
traloi = "B";
}
else if (daC.IsChecked == true)
{
traloi = "C";
}
else if (daB.IsChecked == true)
{
traloi = "D";
}
h.TraLoi = traloi;
data.SubmitChanges();
tb_thongbao.Text = "Chỉnh sửa thành công!";
}
catch (Exception ex)
{
System.Windows.MessageBox.Show(ex.Message, "Lỗi");
}
finally
{
GetData_Cauhoi();
}
}
public ActionResult Delete(int id)
{
CAU_HOI q = db.CAU_HOI.Find(id);
if (q == null)
{
return(View("eror404"));
}
var de = debai.DE_BAI.Where(x => x.MaCauHoi == q.MaCauHoi);
if (de != null)
{
ModelState.AddModelError("", "Câu hỏi đã có trong đề bài! Không xóa được");
return(RedirectToAction("Index"));
}
db.CAU_TRA_LOI.RemoveRange(db.CAU_TRA_LOI.Where(x => x.MaCauHoi == q.MaCauHoi));
db.CAU_HOI.Remove(q);
db.SaveChanges();
ModelState.AddModelError("", "Xóa thành công");
return(RedirectToAction("Index"));
}
public ActionResult Details(int id)
{
CAU_HOI q = db.CAU_HOI.Find(id);
List <CAU_TRA_LOI> a = db.CAU_TRA_LOI.Where(x => x.MaCauHoi == q.MaCauHoi).ToList();
Question question = new Question();
question.MaCauHoi = q.MaCauHoi;
question.NoiDungCauHoi = q.NoiDungCauHoi;
List <Answer> answers = new List <Answer>();
foreach (CAU_TRA_LOI an in a)
{
Answer ans = new Answer();
ans.MaCauTraLoi = an.IDCauTraLoi;
ans.NoiDungCauTraLoi = an.NoiDungCauTraLoi;
ans.ThuocCauHoi = question;
answers.Add(ans);
}
question.ListCauTraLoi = answers;
return(View(question));
}
private void cauhoi_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
int rowindex = kithi.SelectedIndex;
if (rowindex == -1)
{
}
else
{
CAU_HOI a = (CAU_HOI)cauhoi.SelectedItem;
txt_idq.Text = a.MaCauHoi.ToString();
txt_Cauhoi.Text = a.CauHoi;
txt_da1.Text = a.DapAnA;
txt_da2.Text = a.DapAnB;
txt_da3.Text = a.DapAnC;
txt_da4.Text = a.DapAnD;
if (a.TraLoi == "A")
{
daA.IsChecked = true;
}
else if (a.TraLoi == "B")
{
daB.IsChecked = true;
}
else if (a.TraLoi == "C")
{
daC.IsChecked = true;
}
else if (a.TraLoi == "D")
{
daD.IsChecked = true;
}
cb_lop.SelectedValue = a.MaLopHoc;
}
}
catch (Exception ex)
{
}
}
private void RemoveCauHoi()
{
try
{
if (System.Windows.Forms.MessageBox.Show("Xác nhận xoá? ", "Thông Báo", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
{
CAU_HOI c = data.CAU_HOIs.Single(item => item.MaCauHoi == int.Parse(txt_idq.Text));
data.CAU_HOIs.DeleteOnSubmit(c);
CT_DETHI ct = data.CT_DETHIs.Single(i => i.MaCauHoi == int.Parse(txt_idq.Text));
data.CT_DETHIs.DeleteOnSubmit(ct);
data.SubmitChanges();
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
finally
{
GetData_Cauhoi();
}
}
public ActionResult Edit(int id)
{
CAU_HOI q = db.CAU_HOI.Find(id);
return(View(q));
}
