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;
                    }
                }
            }
        }
예제 #3
0
        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();
        }
예제 #5
0
        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)));
        }
예제 #6
0
        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);
            }
        }
예제 #7
0
 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;
 }
예제 #8
0
        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));
        }
예제 #9
0
 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);
        }
예제 #12
0
        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));
        }
예제 #15
0
        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));
        }
예제 #16
0
        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));
            }
        }
예제 #17
0
        // GET: Admin/CauHoiManagement/Delete/5
        public ActionResult Delete(int id)
        {
            CauHoi entity = cauHoiRepository.GetById(id);

            cauHoiRepository.Delete(entity);
            return(RedirectToAction("Index"));
        }
예제 #18
0
        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();
        }
예제 #19
0
        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);
            }
        }
예제 #20
0
        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));
        }
예제 #22
0
 // 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);
         }
     }
 }
예제 #23
0
        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());
        }
예제 #25
0
        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);
            }
        }
예제 #26
0
 public static void AddRequest(CauHoi request)
 {
     using (var db = new QLTNDataContext())
     {
         db.CauHois.InsertOnSubmit(request);
         db.SubmitChanges();
     }
 }
예제 #27
0
        public ActionResult DeleteConfirmed(int id)
        {
            CauHoi cauHoi = db.CauHois.Find(id);

            db.CauHois.Remove(cauHoi);
            db.SaveChanges();
            return(RedirectToAction("Index", new { stringId = TempData["IdTemplate"] }));
        }
예제 #28
0
        public ActionResult DeleteConfirmed(int id)
        {
            CauHoi cauHoi = db.CauHois.Find(id);

            db.CauHois.Remove(cauHoi);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
예제 #29
0
        public int DeleteCauHoi(CauHoi pCauHoi)
        {
            var CauHoi = Context.CauHois.FirstOrDefault(p => p.MaCauHoi == pCauHoi.MaCauHoi);

            Context.CauHois.Remove(CauHoi);

            return(Context.SaveChanges());
        }
예제 #30
0
        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));
            }
        }