public ActionResult Create(CauHoi collection) { try { // TODO: Add insert logic here if (ModelState.IsValid) { byte[] imageData = null; if (Request.Files.Count > 0) { HttpPostedFileBase poImgFile = Request.Files["fileim"]; using (var binary = new BinaryReader(poImgFile.InputStream)) { imageData = binary.ReadBytes(poImgFile.ContentLength); } } collection.Picture = imageData; var qz = new CauHoiDAO(); int id = qz.Insert(collection); if (id > 0) { return(RedirectToAction("Index", "CauHoi")); } else { ModelState.AddModelError("", "Thêm thất bại"); } } return(RedirectToAction("Index")); } catch { return(View()); } }
private void LoadDSCH() { dgvDSCauHoi.DataBindings.Clear(); foreach (DataGridViewRow item in dgvDSCauHoi.Rows) { var cell = item.Cells["Chon"] as DataGridViewCheckBoxCell; cell.Value = cell.FalseValue; } bindingDSCH.DataSource = _cauHoiRepository.FindAll(); dgvDSCauHoi.DataSource = bindingDSCH; if (dgvDeThi.SelectedRows.Count <= 0) { return; } string maDT = dgvDeThi.SelectedRows[0].Cells["MaDT"].Value.ToString(); List <DeThi_CauHoi> dt_ch = _dt_chRepository.FindByCondition(p => p.MaDT.Equals(maDT)).ToList(); foreach (DataGridViewRow item in dgvDSCauHoi.Rows) { string cauhoi = item.Cells["DeThiCauHoi"].Value.ToString(); CauHoi idCauHoi = _cauHoiRepository.FindByCondition(p => p.CauHoiDeBai.Equals(cauhoi)).Single(); foreach (DeThi_CauHoi j in dt_ch) { if (idCauHoi.IDCauHoi.Equals(j.IDCauHoi)) { var cell = item.Cells["Chon"] as DataGridViewCheckBoxCell; cell.Value = cell.TrueValue; } } } }
public static bool ThemCauHoi(CauHoi ch) { bool flag = true; using (var qlch = new QuanLyThiTracNghiemDataContext()) { var query = qlch.CauHois.Where(c => c.MaCauHoi == ch.MaCauHoi).SingleOrDefault(); if (query != null) { flag = false; } else { qlch.CauHois.InsertOnSubmit(ch); try { qlch.SubmitChanges(); } catch (Exception) { flag = false; } } } return(flag); }
private void btnTu2ChuyenQua1_Click(object sender, EventArgs e) { if (listDanhSachCauHoiTheoKhoi.CheckedItems.Count == 0) { MessageBox.Show("Bạn phải chọn để có câu hỏi thay đổi", "Thông báo ", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } List <CauHoi> temp123 = new List <CauHoi>(); for (int i = 0; i < listDanhSachCauHoiTheoKhoi.CheckedItems.Count; i++) { CauHoi cauHoi = cauHoiBUS_HT.GetOneCauHoi(Int32.Parse(listDanhSachCauHoiTheoKhoi.CheckedItems[i].Text)); if (cauHoi == null) { continue; } int temp = cauHoiTrongDeNaoDAO.InsertDeVaCauHoi(CauHoiTrongDeNao.MaDe, cauHoi.MaCauHoi, CauHoiTrongDeNao.MaKhoi); if (temp == 4) { MessageBox.Show("Đã tồn tại những câu hỏi này trong mã đề và mã khối.", "Thông báo lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } temp123.Add(cauHoi); } foreach (var temp in temp123) { CauHoiTrongDeNao.listCauHoiOnMaDe.Add(temp); } this.LoadDanhSachCauHoi(); this.LoadDanhSachCauHoi2(); }
public ActionResult TuVan(int?pape, FormCollection colection) { List <tuvan> tv = laytuvan(); int SoSP = 9; int SoTrang = (pape ?? 1); if (Session["TaiKhoan"] == null) { ViewBag.ThongBao = "Bạn phải đăng nhập để gửi thư"; return(View(tv.ToPagedList(SoTrang, SoSP))); } else { string cauhoi = colection["cauhoi"]; if (cauhoi == "") { ViewBag.ThongBao = "Hãy nhập câu hỏi"; return(View(tv.ToPagedList(SoTrang, SoSP))); } else { KhachHang kh = (KhachHang)Session["TaiKhoan"]; CauHoi c = new CauHoi(); c.MaKH = kh.MaKH; c.NoiDung = cauhoi; c.TraLoi = 0; data.CauHois.InsertOnSubmit(c); data.SubmitChanges(); tv = laytuvan(); return(View(tv.ToPagedList(SoTrang, SoSP))); } } return(View(tv.ToPagedList(SoTrang, SoSP))); }
public CauHoi GetOneCauHoi(int MaCauHoi) { /* * Kiếm câu hỏi thông qua mã câu hỏi * Nếu không tìm thấy mã câu hỏi -> trả về null * Nếu tìm thấy câu hỏi -> trả về câu hỏi */ using (DataContextDataContext DB = new DataContextDataContext()) { CauHoi cauHoi = new CauHoi(); var findCauHoi = from cau in DB.CauHois where cau.MaCauHoi == MaCauHoi select cau; if (findCauHoi.Count() == 0) { return(null); } foreach (var mem in findCauHoi) { cauHoi.MaCauHoi = mem.MaCauHoi; cauHoi.CauA = mem.CauA; cauHoi.CauB = mem.CauB; cauHoi.CauC = mem.CauC; cauHoi.CauD = mem.CauD; cauHoi.CauDung = mem.CauDung; cauHoi.DoKho1 = mem.DoKho1; cauHoi.Khoi = mem.Khoi; cauHoi.NoiDung = mem.NoiDung; } return(cauHoi); } }
public void NapCauHoi(List <CauHoi> dsCauHoi, int index) { txtAwsA.Visibility = Visibility.Visible; txtAwsB.Visibility = Visibility.Visible; txtAwsC.Visibility = Visibility.Visible; txtAwsD.Visibility = Visibility.Visible; if (dsCauHoi.Count > index) { ClearDapAn(); CauHoi cauHoi = dsCauHoi[index]; txtContentQes.Text = cauHoi.NoiDung; txtAwsA.Text = "A. " + cauHoi.DanhSachDapAn[0].NoiDung; txtAwsB.Text = "B. " + cauHoi.DanhSachDapAn[1].NoiDung; txtAwsC.Text = "C. " + cauHoi.DanhSachDapAn[2].NoiDung; txtAwsD.Text = "D. " + cauHoi.DanhSachDapAn[3].NoiDung; grQuest.Header = "Câu số " + (index + 1); isChoose = ""; awsTrue = cauHoi.DanhSachDapAn[0].IsTrue ? "A" : cauHoi.DanhSachDapAn[1].IsTrue ? "B" : cauHoi.DanhSachDapAn[2].IsTrue ? "C" : "D"; awsTrueint = cauHoi.DanhSachDapAn[0].IsTrue ? 1 : cauHoi.DanhSachDapAn[1].IsTrue ? 2 : cauHoi.DanhSachDapAn[2].IsTrue ? 3 : 4; } foreach (var item in Levels) { item.Background = ""; } if (index > 0) { Levels[Levels.Count - index - 1].Background = "Image/bg_btn_red.png"; } else { Levels[Levels.Count - 1].Background = "Image/bg_btn_red.png"; } dataContext.ItemsSource = null; dataContext.ItemsSource = Levels; }
public async Task <IActionResult> Edit(int id, [Bind("IDBlog,TieuDe,HinhAnh,TomTat,NoiDung,IDLoai,IDNguoiTao,NgayTao,NgayDuyet,View,IDNguoiDuyet,TrangThai")] CauHoi cauHoi) { if (id != cauHoi.IDBlog) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(cauHoi); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CauHoiExists(cauHoi.IDBlog)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["IDLoai"] = new SelectList(_context.Loais, "IDLoai", "IDLoai", cauHoi.IDLoai); return(View(cauHoi)); }
public CauHoiResponse(CauHoi cauHoi, List <DapAnResponse> dapAn) { Id = cauHoi.Id; NoiDung = cauHoi.NoiDung; NhieuDapAn = cauHoi.NhieuDapAn; DsDapAn = dapAn; }
// GET: Admin/CauHoiManagement/Edit/5 public ActionResult Edit(int id) { CauHoi cauHoi = cauHoiRepository.GetById(id); ViewBag.MonHocID = new SelectList(monHocRepository.GetAll(), "MonHocID", "TenMH", cauHoi.MonHocID); return(View(cauHoi)); }
public IEnumerable <CauHoi> Get_cauhoitheodieukien(string tenmonhoc, string tenchude) { string mamonhoc = ""; string machude = ""; SqlConnection conn = DataProvider.Connect(); conn.Open(); StringBuilder sQuery = new StringBuilder(); sQuery.Append("select CD.MaMonHoc, CD.MaCD "); sQuery.Append("FROM ChuDe CD "); sQuery.Append("inner join MonHoc MH on CD.MaMonHoc = MH.MaMonHoc "); sQuery.AppendFormat("WHERE MH.TenMonHoc = N'{0}' AND CD.TenCD = N'{1}'", tenmonhoc, tenchude); SqlCommand com = new SqlCommand(sQuery.ToString(), conn); SqlDataReader dr = com.ExecuteReader(); while (dr.Read()) { mamonhoc = dr.GetString(0); machude = dr.GetString(1); } conn.Close(); List <CauHoi> Dsachcauhoi_monhoc_chude = CauHoi.DsachCauhoi_theodieukien(mamonhoc, machude); return(Dsachcauhoi_monhoc_chude); }
public IHttpActionResult PutCauHoi(int id, CauHoi cauHoi) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != cauHoi.IDCauHoi) { return(BadRequest()); } db.Entry(cauHoi).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!CauHoiExists(id)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public ActionResult EditQuestion(CauHoi qGet) { List <Category> list = db.Categories.ToList(); ViewBag.List = new SelectList(list, "ID_Category", "TênCategory"); var qList = db.CauHois.Where(model => model.IDCauHoi == qGet.IDCauHoi).FirstOrDefault(); qList.IDCauHoi = qGet.IDCauHoi; qList.CauHoi1 = qGet.CauHoi1; qList.A = qGet.A; qList.B = qGet.B; qList.C = qGet.C; qList.D = qGet.D; qList.DanAnDung = qGet.DanAnDung; db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <ActionResult <CauHoi> > PostCauHoi(CauHoi cauHoi) { _context.CauHois.Add(cauHoi); await _context.SaveChangesAsync(); return(CreatedAtAction("GetCauHoi", new { id = cauHoi.IDBlog }, cauHoi)); }
public async Task <IActionResult> Edit(int id, [Bind("Id,Ten,CauTraLoi1,CauTraLoi2,CauTraLoi3,CauTraLoi4,TheLoaiId")] CauHoi cauHoi) { if (id != cauHoi.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(cauHoi); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CauHoiExists(cauHoi.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } ViewData["TheLoaiId"] = new SelectList(_context.TheLoais, "Id", "Id", cauHoi.TheLoaiId); return(View(cauHoi)); }
public ActionResult Update(CauHoiModel cauhoi) { using (ELearningDB db = new ELearningDB()) { if (ModelState.IsValid) { TimeZoneInfo date = TimeZoneInfo.FindSystemTimeZoneById("SE Asia Standard Time"); DateTime utc = DateTime.UtcNow; DateTime now = TimeZoneInfo.ConvertTimeFromUtc(utc, date); CauHoi ch = db.CauHois.Find(cauhoi.MaCauHoi); ch.NoiDung = cauhoi.NoiDung; ch.BieuThuc = cauhoi.BieuThuc; ch.CauA = cauhoi.CauA; ch.BieuThucA = cauhoi.BieuThucA; ch.CauB = cauhoi.CauB; ch.BieuThucB = cauhoi.BieuThucB; ch.CauC = cauhoi.CauC; ch.BieuThucC = cauhoi.BieuThucC; ch.CauD = cauhoi.CauD; ch.BieuThucD = cauhoi.BieuThucD; ch.DapAn = cauhoi.DapAn; ch.DoKho = cauhoi.DoKho; ch.ChuongID = cauhoi.ChuongID; ch.NgaySua = now; db.SaveChanges(); return(RedirectToAction("CauHoi", "CauHoi", new { id = ch.MaMonHoc })); } return(View(cauhoi)); } }
// GET: Admin/CauHoiManagement/Delete/5 public ActionResult Delete(int id) { CauHoi entity = cauHoiRepository.GetById(id); cauHoiRepository.Delete(entity); return(RedirectToAction("Index")); }
private void btnAddDeThi_Click(object sender, EventArgs e) { for (int i = 0; i < listCauHoiDuaTrenKhoi.CheckedItems.Count; i++) { CauHoi cauHoi = new CauHoi(); cauHoi = cauHoiBUS_HT.GetOneCauHoi(Int32.Parse(listCauHoiDuaTrenKhoi.CheckedItems[i].Text)); cauHoisThemVaoDe.Add(cauHoi); } foreach (var mem in cauHoisThemVaoDe) { foreach (var mem2 in cauHoisThemVaoDe) { if (mem.MaKhoi != mem2.MaKhoi) { cauHoisThemVaoDe.Clear(); MessageBox.Show("loi"); return; } } } AdDeThi adDeThi = new AdDeThi(cauHoisThemVaoDe); adDeThi.ShowDialog(); }
public List <CauHoi> getAllCauHoiCauHoiOnMaKhoi(int MaKhoi) { /* * Lấy ra danh sách câu hỏi trả về list */ using (DataContextDataContext DB = new DataContextDataContext()) { List <CauHoi> cauHois = new List <CauHoi>(); var cauhois = from cauHoi in DB.CauHois where cauHoi.HocSinhDongGop == false && cauHoi.MaKhoi == MaKhoi select cauHoi; foreach (var cauhoi in cauhois) { CauHoi temp = new CauHoi(); temp.MaCauHoi = cauhoi.MaCauHoi; temp.NoiDung = cauhoi.NoiDung; temp.CauA = cauhoi.CauA; temp.CauB = cauhoi.CauB; temp.CauC = cauhoi.CauC; temp.CauD = cauhoi.CauD; temp.CauDung = cauhoi.CauDung; temp.DoKho1 = cauhoi.DoKho1; temp.Khoi = cauhoi.Khoi; cauHois.Add(temp); } return(cauHois); } }
private void btnSave_Click(object sender, EventArgs e) { CauHoi question = (from c in db.CauHois where c.ID == int.Parse(lbIDCauHoi.Text) select c).SingleOrDefault(); question.CauHoi1 = txtCauHoi.Text; question.DapAn_A = txtA.Text; question.DapAn_B = txtB.Text; question.DapAn_C = txtC.Text; question.DapAn_D = txtD.Text; question.DapAnDung = char.Parse(cbDADung.SelectedValue.ToString()); question.Khoi = int.Parse(cbKhoi.SelectedValue.ToString()); question.DoKho = cbDoKho.SelectedValue.ToString(); question.MaMH = cbMaMH.SelectedValue.ToString(); try { db.SubmitChanges(); MessageBox.Show("Lưu thành công"); } catch { MessageBox.Show("Lưu thất bại"); } }
public async Task <IActionResult> Create([Bind("IDBlog,TieuDe,HinhAnh,TomTat,NoiDung,IDLoai,IDNguoiTao,NgayTao,NgayDuyet,View,IDNguoiDuyet,TrangThai")] CauHoi cauhoi, IFormFile ful) { if (ModelState.IsValid) { _context.Add(cauhoi); await _context.SaveChangesAsync(); var parth = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot/cauhoi", cauhoi.IDBlog + "." + ful.FileName.Split(".")[ful.FileName.Split(".").Length - 1]); using (var stream = new FileStream(parth, FileMode.Create)) { await ful.CopyToAsync(stream); } cauhoi.HinhAnh = cauhoi.IDBlog + "." + ful.FileName.Split(".")[ful.FileName.Split(".").Length - 1]; _context.Update(cauhoi); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } ViewData["IDLoai"] = new SelectList(_context.Loais, "IDLoai", "TieuDe", cauhoi.IDLoai); return(View(cauhoi)); }
// event chọn câu hỏi private void LvLoadCauHoi_SelectedIndexChanged(object sender, EventArgs e) { if (lvLoadCauHoi.SelectedIndices.Count > 0) { lvDapAn.Items.Clear(); int stt = int.Parse(lvLoadCauHoi.SelectedItems[0].SubItems[0].Text); ch = dsCauHoi.Where(i => i.id == stt).First(); txtNoiDung.Text = ch.noidung; using (var qltn = Utils.QLTN.getInstance()) { dsDapAn = qltn.DapAns.Where(d => d.cauhoiid == ch.id).ToList(); } int STT = 0; string CheckTF; foreach (var item in dsDapAn) { ListViewItem lvi = new ListViewItem(); lvi.Text = (STT += 1).ToString(); lvi.SubItems.Add(item.noidung); if (item.dungsai == true) { CheckTF = "Đúng"; } else { CheckTF = "Sai"; } lvi.SubItems.Add(CheckTF); lvDapAn.Items.Add(lvi); } } }
public void UpdateCTKQ(int mactkq, string kq) { ChiTietKetQua ct = thi.ChiTietKetQuas.Where(t => t.MaChiTietKQ == mactkq).FirstOrDefault(); if (ct != null) { ct.DapAnChon = kq; string[] dapan = kq.Split(new char[] { '.', '?', '!', ' ', ';', ':', ',' }, StringSplitOptions.RemoveEmptyEntries); CauHoi ch = thi.CauHois.Where(t => t.MaCauHoi == ct.MaCauHoi).FirstOrDefault(); string dp = ch.DapAnDung.ToString().Trim() + ","; string[] source = dp.Split(new char[] { '.', '?', '!', ' ', ';', ':', ',' }, StringSplitOptions.RemoveEmptyEntries); int dem = 0; for (int i = 0; i < source.Length; i++) { var matchQuery = from word in dapan where word == source[i] select word; dem = matchQuery.Count(); } if (dem == dapan.Length) { ct.KetQua = true; } else { ct.KetQua = false; } thi.SubmitChanges(); } }
public async Task <IActionResult> PutCauHoi(int id, CauHoi cauHoi) { if (id != cauHoi.IDBlog) { return(BadRequest()); } _context.Entry(cauHoi).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CauHoiExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public int InsertCauHoi(string NoiDung, string CauA, string CauB, string CauC, string CauD, string CauDung, int MaKhoi, int DoKho) { /* * Thêm 1 câu hỏi vào trong cơ sơ dữ liệu trong bảng câu hỏi * Nếu CauDung không phải là A , B , C , D -> trả về 1 * Nếu MaKhoi không tồn tại -> trả về 2 * Nếu DoKho không tồn tại -> trả về 3 * Nếu Nội dung trùng -> trả về 4 * Nếu thành công -> trả về 0 */ using (DataContextDataContext DB = new DataContextDataContext()) { if (CauDung != "A" && CauDung != "B" && CauDung != "C" && CauDung != "D") { return(1); } var CountMaKhoi = from khois in DB.Khois where khois.MaKhoi == MaKhoi select khois; if (CountMaKhoi.Count() == 0) { return(2); } var CountDoKho = from dokho in DB.DoKhos where dokho.maDoKho == DoKho select dokho; if (CountDoKho.Count() == 0) { return(3); } var CountNoiDung = from cauhoi in DB.CauHois where cauhoi.NoiDung == NoiDung select cauhoi; if (CountNoiDung.Count() != 0) { return(4); } CauHoi cauHoi = new CauHoi(); cauHoi.NoiDung = NoiDung; cauHoi.CauA = CauA; cauHoi.CauB = CauB; cauHoi.CauC = CauC; cauHoi.CauD = CauD; cauHoi.CauDung = CauDung; cauHoi.DoKho = DoKho; cauHoi.MaKhoi = MaKhoi; cauHoi.HocSinhDongGop = false; DB.CauHois.InsertOnSubmit(cauHoi); DB.SubmitChanges(); return(0); } }
public static void AddRequest(CauHoi request) { using (var db = new QLTNDataContext()) { db.CauHois.InsertOnSubmit(request); db.SubmitChanges(); } }
public ActionResult DeleteConfirmed(int id) { CauHoi cauHoi = db.CauHois.Find(id); db.CauHois.Remove(cauHoi); db.SaveChanges(); return(RedirectToAction("Index", new { stringId = TempData["IdTemplate"] })); }
public ActionResult DeleteConfirmed(int id) { CauHoi cauHoi = db.CauHois.Find(id); db.CauHois.Remove(cauHoi); db.SaveChanges(); return(RedirectToAction("Index")); }
public int DeleteCauHoi(CauHoi pCauHoi) { var CauHoi = Context.CauHois.FirstOrDefault(p => p.MaCauHoi == pCauHoi.MaCauHoi); Context.CauHois.Remove(CauHoi); return(Context.SaveChanges()); }
public ActionResult Edit(CauHoi cauHoi, DapAn dapan1, DapAn dapan2, DapAn dapan3, DapAn dapan4, HttpPostedFileBase file) { try { if (db.CauHois.Any(x => x.MaCauHoiMoi == cauHoi.MaCauHoiMoi && x.MaCauHoi != cauHoi.MaCauHoi)) { ModelState.AddModelError("MaCauHoiMoi", "Mã câu hỏi này đã tồn tại. Bạn hãy kiểm tra lại."); } List <DapAn> dapAns = new List <DapAn>(); if (dapan1.MaDapAn != 0) { dapAns.Add(dapan1); } if (dapan2.MaDapAn != 0) { dapAns.Add(dapan2); } if (dapan3.MaDapAn != 0) { dapAns.Add(dapan3); } if (dapan4.MaDapAn != 0) { dapAns.Add(dapan4); } if (dapAns.Any(x => x.DapAnDung == true) == false) { ModelState.AddModelError("", "Bạn cần chỉ định ít nhất 1 đáp án là đáp án đúng!"); } if (ModelState.IsValid) { foreach (DapAn dapAnItem in dapAns) { db.Entry(dapAnItem).State = System.Data.Entity.EntityState.Modified; } if (file != null && file.ContentLength > 0) { string fileName = DateTime.Now.Ticks.ToString() + System.IO.Path.GetExtension(file.FileName); cauHoi.Hinh = fileName; file.SaveAs(Server.MapPath("~/Content/images/" + fileName)); } db.Entry(cauHoi).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Edit", new { Id = cauHoi.MaCauHoi, message = "Sửa thành công" })); } ViewBag.MaChuyenMuc = new SelectList(db.ChuyenMucCauHois, "MaChuyenMuc", "TenChuyenMuc", cauHoi.MaChuyenMuc); cauHoi.DapAns = db.CauHois.Find(cauHoi.MaCauHoi).DapAns.ToList(); return(View(cauHoi)); } catch (Exception ex) { ModelState.AddModelError("", ex.Message); ViewBag.MaChuyenMuc = new SelectList(db.ChuyenMucCauHois, "MaChuyenMuc", "TenChuyenMuc", cauHoi.MaChuyenMuc); cauHoi.DapAns = db.CauHois.Find(cauHoi.MaCauHoi).DapAns.ToList(); return(View(cauHoi)); } }