Exemple #1
0
 protected void btnCreate_Click(object sender, EventArgs e)
 {
     if (txtHanNop.Text != "" && !Regex.IsMatch(txtHanNop.Text, @"^(?<Day>[0-2]\d|[3][0-1])\/(?<Month>[0]\d|[1][0-2])\/(?<Year>(?:[2][01]|[1][6-9])\d{2})\s(?:(?<Hour>[0-1]\d|[2][0-4]):(?<Min>[0-5]\d){1,2}:(?<Sec>[0-5]\d){1,2})$"))
     {
         lblKQ.Text = "Đề nghị nhập ngày cho đúng với định dạng [dd/mm/yyyy hh:mm:ss]";
         return;
     }
     string AttachFile ="";
     if (fUpLoad.FileName.Length > 0)
     {
         string fileName = MaLop + "_" + DateTime.Now.Year.ToString("0000") + DateTime.Now.Month.ToString("00") + DateTime.Now.Day.ToString("00") + "_"
                                 + DateTime.Now.Hour.ToString("00") + "h" + DateTime.Now.Minute.ToString("00") + "m" + DateTime.Now.Second.ToString("00") + "s.zip";
         string FilePath = Server.MapPath(@"~\Upload\GiaoVien");
         string FullName = FilePath + @"\" + fileName;
         fUpLoad.SaveAs(FullName);
         AttachFile = @"\Upload\GiaoVien\" + fileName;
     }
         MyContextDataContext db = new MyContextDataContext();
         BaiTap bt = new BaiTap() { AttachFile = AttachFile, MaLop = MaLop, Ten = txtTenBai.Text, MoTa = txtMota.Text };
         var Match = Regex.Match(txtHanNop.Text, @"^(?<Day>[0-2]\d|[3][0-1])\/(?<Month>[0]\d|[1][0-2])\/(?<Year>(?:[2][01]|[1][6-9])\d{2})\s(?:(?<Hour>[0-1]\d|[2][0-4]):(?<Min>[0-5]\d){1,2}:(?<Sec>[0-5]\d){1,2})$");
         bt.HanNop = new DateTime(int.Parse(Match.Groups["Year"].Value), int.Parse(Match.Groups["Month"].Value), int.Parse(Match.Groups["Day"].Value), int.Parse(Match.Groups["Hour"].Value), int.Parse(Match.Groups["Min"].Value), int.Parse(Match.Groups["Sec"].Value));
         db.BaiTaps.InsertOnSubmit(bt);
         db.SubmitChanges();
         Response.Redirect("/GiaoVien/Details.aspx?ID=" + MaLop);
 }
        public ActionResult DeleteConfirmed(int id)
        {
            BaiTap baitap = db.BaiTaps.Find(id);

            db.BaiTaps.Remove(baitap);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
        //
        // GET: /BaiTap/Delete/5

        public ActionResult Delete(int id = 0)
        {
            BaiTap baitap = db.BaiTaps.Find(id);

            if (baitap == null)
            {
                return(HttpNotFound());
            }
            return(View(baitap));
        }
 public ActionResult Edit(BaiTap baitap)
 {
     if (ModelState.IsValid)
     {
         db.Entry(baitap).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.IdLopMonHoc = new SelectList(db.LopMonHocs, "IdLopMonHoc", "TenLopMonHoc", baitap.IdLopMonHoc);
     return(View(baitap));
 }
        //
        // GET: /BaiTap/Edit/5

        public ActionResult Edit(int id = 0)
        {
            BaiTap baitap = db.BaiTaps.Find(id);

            if (baitap == null)
            {
                return(HttpNotFound());
            }
            ViewBag.IdLopMonHoc = new SelectList(db.LopMonHocs, "IdLopMonHoc", "TenLopMonHoc", baitap.IdLopMonHoc);
            return(View(baitap));
        }
        //
        // GET: /BaiLam/SuaDiem

        public ActionResult SuaDiem(int id = 0)
        {
            List <BaiLam> ListBaiLamDaCham = (List <BaiLam>)(from b in db.BaiLams
                                                             where b.IdBaiTap == id && b.Diem != null
                                                             select b).ToList();
            BaiTap BaiTapCurrent = (BaiTap)((from b in db.BaiTaps
                                             where b.IdBaiTap == id
                                             select b).First());

            ViewBag.BaiTapCurrent = BaiTapCurrent;

            return(View(ListBaiLamDaCham));
        }
        public ActionResult Create(HttpPostedFileBase DeBaiTapUpload,
                                   FormCollection collection,
                                   BaiTap baitap)
        {
            NguoiDung NguoiDungCurrent = (NguoiDung)Session["NguoiDungCurrent"];
            TaiLieu   tailieu          = null;

            // Thêm đề cương bài giảng vào csdl và vào lớp
            string TenTaiLieu = Convert.ToString(collection["TenTaiLieu"]);

            if (Request != null)
            {
                HttpPostedFileBase file = Request.Files["DeBaiTapUpload"];
                if ((file != null) && !string.IsNullOrEmpty(file.FileName))
                {
                    tailieu = new TaiLieu();
                    string filePath = Path.Combine(Server.MapPath(TaiLieuPath), file.FileName);
                    file.SaveAs(filePath);
                    tailieu.TenTaiLieu    = TenTaiLieu;
                    tailieu.DinhDang      = Path.GetExtension(file.FileName);
                    tailieu.DuongDan      = file.FileName;
                    tailieu.DungLuong     = file.ContentLength.ToString();
                    tailieu.IdNguoiDung   = NguoiDungCurrent.IdNguoiDung;
                    tailieu.IdLoaiTaiLieu = 5; // 5 = đề bài tập

                    // Thêm đề cương bài giảng vào csdl
                    db.TaiLieux.Add(tailieu);
                    db.SaveChanges();
                }
                else
                {
                    return(View());
                }
            }

            if (ModelState.IsValid)
            {
                LopMonHoc LopMonHocCurrent = (LopMonHoc)Session["LopMonHocCurrent"];
                if (tailieu != null)
                {
                    baitap.IdDeBaiTap = tailieu.IdTaiLieu;
                }
                baitap.IdLopMonHoc = LopMonHocCurrent.IdLopMonHoc;
                db.BaiTaps.Add(baitap);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.IdLopMonHoc = new SelectList(db.LopMonHocs, "IdLopMonHoc", "TenLopMonHoc", baitap.IdLopMonHoc);
            return(View(baitap));
        }
        //
        // GET: /BaiTap/Details/5

        public ActionResult Details(int id = 0)
        {
            List <BaiLam> ListBaiLam = (List <BaiLam>)(from b in db.BaiLams
                                                       where b.IdBaiTap == id
                                                       select b).ToList();
            BaiTap baitap = db.BaiTaps.Find(id);

            if (baitap == null)
            {
                return(HttpNotFound());
            }
            ViewBag.ListBaiLam   = ListBaiLam;
            ViewBag.TongSoBaiLam = ListBaiLam.Count();
            return(View(baitap));
        }
Exemple #9
0
 public bool Update(BaiTap entity)
 {
     try
     {
         var tl = db.BaiTaps.Find(entity.ID);
         tl.ghiChu = entity.ghiChu;
         tl.tenBT = entity.tenBT;
         tl.thoiGianLamBai = entity.thoiGianLamBai;
         tl.ngayNop = entity.ngayNop;
         tl.trangThai = entity.trangThai;
        
         db.SaveChanges(); 
         return true;
     }catch( Exception ex)
     {
         return false;
     }
 }
Exemple #10
0
        protected override void OnNavigatedTo(NavigationEventArgs e)
        {
            // lấy thông tin từ  trang muc tap
            mucTap muctap = (mucTap)e.Parameter;

            tenBt      = muctap.tenBaiTap;
            level      = muctap.level;
            tenBT.Text = tenBt;
            nguoidung  = TrangChu.nguoidung;
            muctieu    = TrangChu.muctieu;


            //image
            List <Uri> uriLst = new List <Uri>();

            if (tenBt == "Gập bụng")
            {
                for (int i = 1; i <= 4; i++)
                {
                    uriLst.Add(new Uri("ms-appx:///Assets/gapbung" + i + ".png"));
                }
            }
            else
            {
                for (int i = 1; i <= 6; i++)
                {
                    uriLst.Add(new Uri("ms-appx:///Assets/hitdat" + i + ".png"));
                }
            }

            for (int i = 0; i < 4; i++)
            {
                imgLst.Add(new BitmapImage(uriLst[i]));
            }

            threadImg = ThreadPoolTimer.CreatePeriodicTimer(UpdateSprite, TimeSpan.FromMilliseconds(200));


            // lay thong tin bai tap bung hay hit dat dua vao ten
            baiTapBung = connection.Table <BaiTap>().Where(r => r.TenBaiTap == tenBt).FirstOrDefault();
            idBT       = baiTapBung.IdBaiTap;

            if (muctieu != null)
            {
                thongKeNgay    = TrangChu.getThongKeNgayHienTai(muctieu);
                thongKeTapBung = connection.Table <ThongKeBaiTap>().Where(r => r.IdThongKeNgay == thongKeNgay.IdThongKeNgay && r.IdBaiTap == idBT).FirstOrDefault();
                if (thongKeTapBung == null)
                {
                    thongKeTapBung = new ThongKeBaiTap()
                    {
                        IdThongKeNgay    = thongKeNgay.IdThongKeNgay,
                        IdBaiTap         = idBT,
                        LuongKaloTieuHao = 0,
                        SoLan            = 0
                    };
                    connection.Insert(thongKeTapBung);
                }
            }
            else
            {
                thongKeTapBung = new ThongKeBaiTap();
            }
        }
        public IActionResult QuanLyBaiTap(IFormCollection collection)
        {
            if (!IsLogin())
            {
                return(null);
            }

            int code = Convert.ToInt16(collection["code"]);

            if (code == 1)
            {
                var idBaiTap = Convert.ToInt16(collection["idBaiTap"]);
                var result   = (from baiTap in csdl.BaiTaps
                                where baiTap.BaiTapId == idBaiTap
                                select new
                {
                    ten = baiTap.Ten,
                    idListCauHoi = (from cauHoi in csdl.CauHois
                                    where cauHoi.BaiTapId == baiTap.BaiTapId
                                    select new
                    {
                        id = cauHoi.CauHoiId
                    }).ToList()
                }).First();
                return(Json(result));
            }

            if (code == 2)
            {
                var idCauHoi = Convert.ToInt16(collection["idCauHoi"]);
                var result   = (from cauHoi in csdl.CauHois
                                where cauHoi.CauHoiId == idCauHoi
                                select new
                {
                    noiDung = cauHoi.NoiDung,
                    cauTraLoi1 = cauHoi.CauTraLoi1,
                    cauTraLoi2 = cauHoi.CauTraLoi2,
                    cauTraLoi3 = cauHoi.CauTraLoi3,
                    cauTraLoi4 = cauHoi.CauTraLoi4,
                    cauDung = cauHoi.CauDung
                }).First();
                return(Json(result));
            }

            if (code == 3)
            {
                var idCauHoi = Convert.ToInt16(collection["idCauHoi"]);
                var cauDung  = Convert.ToInt16(collection["cauDung"]);

                var result = csdl.CauHois.FirstOrDefault(x => x.CauHoiId == idCauHoi);
                if (result != null)
                {
                    result.CauDung = cauDung;
                    csdl.SaveChanges();
                }
                return(Json("Updated"));
            }

            if (code == 4)
            {
                var idBaiHoc = Convert.ToInt16(collection["idBaiHoc"]);

                int newOrder = 1;

                if (csdl.BaiTaps.Any())
                {
                    newOrder = (from baiTap in csdl.BaiTaps
                                where baiTap.BaiHocId == idBaiHoc
                                orderby baiTap.Order descending
                                select baiTap.Order).First() + 1;
                }

                var tenBaiTap = collection["tenBaiTap"];
                var newBaiTap = new BaiTap()
                {
                    Ten      = tenBaiTap,
                    BaiHocId = idBaiHoc,
                    Order    = newOrder,
                    Hide     = 0
                };
                csdl.BaiTaps.Add(newBaiTap);
                csdl.SaveChanges();
                return(Json(newBaiTap.BaiTapId));
            }

            if (code == 5)
            {
                var idBaiTap       = Convert.ToInt16(collection["idBaiTap"]);
                var baiTapToDelete = csdl.BaiTaps.First(b => b.BaiTapId == idBaiTap);
                if (baiTapToDelete != null)
                {
                    csdl.BaiTaps.Remove(baiTapToDelete);
                }
                csdl.SaveChanges();
                return(Json("Deleted"));
            }

            if (code == 6)
            {
                var idBaiTap  = Convert.ToInt16(collection["idBaiTap"]);
                var newCauHoi = new CauHoi()
                {
                    NoiDung    = "Chưa có nội dung",
                    CauTraLoi1 = "Chưa có câu trả lời 1",
                    CauTraLoi2 = "Chưa có câu trả lời 2",
                    CauTraLoi3 = "Chưa có câu trả lời 3",
                    CauTraLoi4 = "Chưa có câu trả lời 4",
                    BaiTapId   = idBaiTap,
                    CauDung    = 1
                };
                csdl.CauHois.Add(newCauHoi);
                csdl.SaveChanges();
                return(Json(newCauHoi.CauHoiId));
            }

            if (code == 7)
            {
                var idCauHoi     = Convert.ToInt16(collection["idCauHoi"]);
                var cauDung      = Convert.ToInt16(collection["cauDung"]);
                var changeCauHoi = csdl.CauHois.First(c => c.CauHoiId == idCauHoi);
                switch (cauDung)
                {
                case 1:
                    if (changeCauHoi != null)
                    {
                        changeCauHoi.CauTraLoi1 = collection["noiDungCauTraLoi"];
                    }
                    break;

                case 2:
                    if (changeCauHoi != null)
                    {
                        changeCauHoi.CauTraLoi2 = collection["noiDungCauTraLoi"];
                    }
                    break;

                case 3:
                    if (changeCauHoi != null)
                    {
                        changeCauHoi.CauTraLoi3 = collection["noiDungCauTraLoi"];
                    }
                    break;

                case 4:
                    if (changeCauHoi != null)
                    {
                        changeCauHoi.CauTraLoi4 = collection["noiDungCauTraLoi"];
                    }
                    break;
                }
                csdl.SaveChanges();
                return(Json("Updated"));
            }

            if (code == 8)
            {
                var idCauHoi     = Convert.ToInt16(collection["idCauHoi"]);
                var noiDungHtml  = collection["noiDungHtml"];
                var changeCauHoi = csdl.CauHois.First(c => c.CauHoiId == idCauHoi);
                if (changeCauHoi != null)
                {
                    changeCauHoi.NoiDung = noiDungHtml;
                }
                csdl.SaveChanges();
                return(Json("Updated"));
            }

            if (code == 9)
            {
                var idCauHoi = Convert.ToInt16(collection["idCauHoi"]);
                csdl.CauHois.Remove(csdl.CauHois.First(c => c.CauHoiId == idCauHoi));
                csdl.SaveChanges();
                return(Json("Deleted"));
            }

            return(null);
        }
Exemple #12
0
 partial void UpdateBaiTap(BaiTap instance);
Exemple #13
0
 partial void DeleteBaiTap(BaiTap instance);
Exemple #14
0
 partial void InsertBaiTap(BaiTap instance);
Exemple #15
0
	private void detach_BaiTaps(BaiTap entity)
	{
		this.SendPropertyChanging();
		entity.LopHoc = null;
	}
Exemple #16
0
	private void attach_BaiTaps(BaiTap entity)
	{
		this.SendPropertyChanging();
		entity.LopHoc = this;
	}
        //
        // GET: /BaiTap/Create

        public ActionResult Create()
        {
            BaiTap newBaiTap = new BaiTap();

            return(View(newBaiTap));
        }
Exemple #18
0
 public int Insert(BaiTap entity)
 {
     db.BaiTaps.Add(entity);
     db.SaveChanges();
     return entity.ID;
 }