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)); }
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; } }
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); }
partial void UpdateBaiTap(BaiTap instance);
partial void DeleteBaiTap(BaiTap instance);
partial void InsertBaiTap(BaiTap instance);
private void detach_BaiTaps(BaiTap entity) { this.SendPropertyChanging(); entity.LopHoc = null; }
private void attach_BaiTaps(BaiTap entity) { this.SendPropertyChanging(); entity.LopHoc = this; }
// // GET: /BaiTap/Create public ActionResult Create() { BaiTap newBaiTap = new BaiTap(); return(View(newBaiTap)); }
public int Insert(BaiTap entity) { db.BaiTaps.Add(entity); db.SaveChanges(); return entity.ID; }