public ActionResult Register(RegisterModel model) { if (ModelState.IsValid) { using (ELearningDB db = new ELearningDB()) { TaiKhoan tk = new TaiKhoan(); tk.Username = model.UserName; tk.Password = Encryptor.MD5Hash(model.Password); tk.Role = 4; tk.TrangThai = false; var res = db.TaiKhoans.Where(x => x.Username == model.UserName).Count(); var res1 = db.NguoiDungs.Where(x => x.Email == model.Email).Count(); if (res != 0) { ViewBag.UserNameError = "Tên người dùng đã tồn tại"; return(View(model)); } if (res1 != 0) { ViewBag.EmailError = "Email đã sử dụng"; return(View(model)); } if (res == 0 && res1 == 0) { db.TaiKhoans.Add(tk); db.SaveChanges(); } TaiKhoan ID = db.TaiKhoans.Where(x => x.Username == model.UserName).FirstOrDefault(); NguoiDung u = db.NguoiDungs.Find(ID.ID); u.HoVaTen = model.FullName; u.Email = model.Email; u.Image = ID.ID + ".jpg"; u.SoDu = 20000; u.MaXacNhan = GenerateCode(); db.SaveChanges(); var domain = Request.Url.Scheme + System.Uri.SchemeDelimiter + Request.Url.Host + (Request.Url.IsDefaultPort ? "" : ":" + Request.Url.Port); var sub = "Kích hoạt tài khoản"; var emailBody = string.Format("Xin chào {0} <br />Cảm ơn vì đã đăng ký thành viên, vui lòng nhấn vào đường dẫn sau để kích hoạt tài khoản của bạn<br /> {1}/Login/ActiveAccount/{2}/{3} ", u.HoVaTen, domain, u.ID, u.MaXacNhan); SendEmail(u, sub, emailBody); TempData["RegisterResult"] = "Đăng ký thành công"; return(RedirectToAction("Login", "Login")); } } return(View(model)); }
public JsonResult Update(HocVienModel updatedHV) { var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION]; using (ELearningDB db = new ELearningDB()) { HocVien existingSinhVien = db.HocViens.Find(session.ID); if (existingSinhVien == null) { return(Json(new { success = false })); } else { existingSinhVien.Email = updatedHV.Email; existingSinhVien.SoDienThoai = updatedHV.SDT; existingSinhVien.NgaySinh = updatedHV.NgaySinh; if (updatedHV.Image != null) { existingSinhVien.Image = updatedHV.Image; } db.SaveChanges(); return(Json(new { success = true })); } } }
public JsonResult Insert(LopModel lop) { using (ELearningDB db = new ELearningDB()) { var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION]; if (lop != null && db.Lops.Where(x => x.MaGiangVien == session.ID).Count() < 5) { Lop l = new Lop(); l.TenLop = lop.TenLop; l.TrangThai = true; l.MaGiangVien = session.ID; l.MaMonHoc = lop.MaMonHoc; l.NgayBatDau = lop.StartDate; l.Image = lop.Image; l.SiSo = 0; l.MoTa = lop.MoTa; db.Lops.Add(l); db.SaveChanges(); return(Json(new { success = true })); } else { return(Json(new { success = false })); } } }
public JsonResult InsertCmt(CommentModel comment) { if (comment != null) { using (ELearningDB db = new ELearningDB()) { TimeZoneInfo date = TimeZoneInfo.FindSystemTimeZoneById("SE Asia Standard Time"); DateTime utc = DateTime.UtcNow; DateTime now = TimeZoneInfo.ConvertTimeFromUtc(utc, date); var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION]; Comment com = new Comment(); com.NoiDung = comment.NoiDung; com.CreateDate = now; com.CreateBy = session.ID; com.ClassID = comment.ClassID; db.Comments.Add(com); db.SaveChanges(); return(Json(new { success = true })); } } else { return(Json(new { success = false })); } }
public ActionResult Edit(BaiGiangModel baigiang) { using (ELearningDB db = new ELearningDB()) { if (ModelState.IsValid) { BaiGiang bg = db.BaiGiangs.Find(baigiang.MaBaiGiang); if (baigiang.URL != null) { string removestr = "watch?v="; string replacestr = "embed/"; string str1 = baigiang.URL; if (str1.Contains("youtube.com/watch?v=")) { string str2 = ReplaceFirst(str1, removestr, replacestr); bg.URL = str2; } } bg.TenBaiGiang = baigiang.TenBaiGiang; bg.NoiDung = baigiang.NoiDung; db.SaveChanges(); return(RedirectToAction("Details", new { id = baigiang.MaBaiGiang })); } return(View(baigiang)); } }
public JsonResult KetQua(KetQuaModel kq) { TimeZoneInfo date = TimeZoneInfo.FindSystemTimeZoneById("SE Asia Standard Time"); DateTime utc = DateTime.UtcNow; DateTime now = TimeZoneInfo.ConvertTimeFromUtc(utc, date); try { BaiLam bailam = new BaiLam(); bailam.MaLopKiemTra = kq.MaLopKiemTra; bailam.MaHocVien = kq.ID; bailam.TongDiem = kq.Diem; bailam.NgayKiemTra = now; using (ELearningDB db = new ELearningDB()) { var bl = db.BaiLams.Where(x => x.MaHocVien == kq.ID).ToList(); foreach (var item in bl) { if (item.MaHocVien == kq.ID && item.MaLopKiemTra == kq.MaLopKiemTra) { return(Json(false)); } } db.BaiLams.Add(bailam); db.SaveChanges(); return(Json(true)); } } catch (Exception) { return(Json(false)); } }
public JsonResult Insert(ThongBaoModel thongbao) { var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION]; if (session == null || session.loai != 2) { return(Json(new { success = false })); } using (ELearningDB db = new ELearningDB()) { TimeZoneInfo date = TimeZoneInfo.FindSystemTimeZoneById("SE Asia Standard Time"); DateTime utc = DateTime.UtcNow; DateTime now = TimeZoneInfo.ConvertTimeFromUtc(utc, date); ThongBao tb = new ThongBao(); tb.NoiDung = thongbao.NoiDung; tb.NgayTao = now; tb.CreatedBy = session.ID; tb.LopID = thongbao.LopID; db.ThongBaos.Add(tb); db.SaveChanges(); } return(Json(new { success = true })); }
public ActionResult Create(BaiGiangModel bg) { using (ELearningDB db = new ELearningDB()) { if (ModelState.IsValid) { var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION]; BaiGiang baigiang = new BaiGiang(); baigiang.TenBaiGiang = bg.TenBaiGiang; baigiang.NoiDung = bg.NoiDung; baigiang.URL = bg.URL; baigiang.MaGiangVien = session.ID; baigiang.TrangThai = true; if (baigiang.URL != null) { string removestr = "watch?v="; string replacestr = "embed/"; string str1 = baigiang.URL; if (str1.Contains("youtube.com/watch?v=")) { string str2 = ReplaceFirst(str1, removestr, replacestr); baigiang.URL = str2; } } db.BaiGiangs.Add(baigiang); db.SaveChanges(); return(RedirectToAction("QuanLyBaiGiang", "BaiGiang")); } return(View()); } }
public JsonResult Add_CauHoi_DeThi(CauHoiDeThiModel c) { using (ELearningDB db = new ELearningDB()) { try { var cauhoi = db.CauHois.Find(c.CauHoiID); var dethi = db.DeThis.Find(c.DeThiID); if (dethi.CauHois.Count < dethi.SoCauHoi) { if (dethi.CauHois.Contains(cauhoi)) { return(Json(new { success = false })); } dethi.CauHois.Add(cauhoi); db.SaveChanges(); return(Json(new { success = true })); } return(Json(new { success = false })); } catch (Exception) { return(Json(new { success = false })); } } }
public ActionResult ActiveAccount(long ID, string AuthenticationCode) { using (ELearningDB db = new ELearningDB()) { NguoiDung res = db.NguoiDungs.Where(x => x.ID == ID).FirstOrDefault(); if (res != null) { //if (res.MaXacNhan == null) //{ // TempData["ActiveResult"] = "Tài khoản đã được kích hoạt trước đó"; // return RedirectToAction("TrangChu", "Home"); //} TaiKhoan tk = db.TaiKhoans.Find(ID); if (tk.TrangThai) { TempData["ActiveResult"] = "Tài khoản đã được kích hoạt trước đó"; return(RedirectToAction("GuessHomePage", "Home")); } if (res.MaXacNhan == AuthenticationCode) { tk.TrangThai = true; res.MaXacNhan = null; db.SaveChanges(); TempData["ActiveResult"] = "Tài khoản vừa được kích hoạt"; return(RedirectToAction("Index", "Login")); } } TempData["ActiveResult"] = "Tài khoản chưa được kích hoạt"; return(RedirectToAction("TrangChu", "Home")); } }
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)); } }
public JsonResult InsertRep(CommentModel reply) { if (reply != null) { using (ELearningDB db = new ELearningDB()) { TimeZoneInfo date = TimeZoneInfo.FindSystemTimeZoneById("SE Asia Standard Time"); DateTime utc = DateTime.UtcNow; DateTime now = TimeZoneInfo.ConvertTimeFromUtc(utc, date); var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION]; Reply rep = new Reply(); rep.NoiDung = reply.NoiDung; rep.CreateDate = now; rep.CreateBy = session.ID; rep.CommentID = (long)reply.ParentCommentID; db.Replies.Add(rep); db.SaveChanges(); return(Json(new { success = true })); } } else { return(Json(new { success = false })); } }
public JsonResult Update(GVModel updatedGV) { var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION]; using (ELearningDB db = new ELearningDB()) { GiangVien existingGV = db.GiangViens.Find(session.ID); if (existingGV == null) { return(Json(new { success = false })); } else { existingGV.Email = updatedGV.Email; existingGV.SoDienThoai = updatedGV.SDT; existingGV.MaMonHoc = updatedGV.MaMonHoc; if (updatedGV.Image != null) { existingGV.Image = updatedGV.Image; } db.SaveChanges(); return(Json(new { success = true })); } } }
public ActionResult FirstLogin(GiangVienModel gv) { using (ELearningDB db = new ELearningDB()) { if (ModelState.IsValid) { GiangVien giangvien = db.GiangViens.Find(gv.ID); TaiKhoan tk = db.TaiKhoans.Find(gv.ID); giangvien.HoVaTen = gv.HoVaTen; giangvien.Email = gv.Email; giangvien.GioiTinh = gv.GioiTinh; giangvien.MaMonHoc = gv.MaMonHoc; giangvien.SoDienThoai = gv.SDT; tk.Password = Encryptor.MD5Hash(gv.NewPass); db.SaveChanges(); return(RedirectToAction("TrangChu", "HomeGV", new { area = "GV" })); } var lstMonHoc = db.MonHocs; List <MonHocModel> MonHocs = new List <MonHocModel>(); foreach (var item in lstMonHoc) { MonHocModel mh = new MonHocModel(); mh.MaMonHoc = item.MaMonHoc; mh.TenMonHoc = item.TenMonHoc; MonHocs.Add(mh); } SelectList lstMon = new SelectList(MonHocs, "MaMonHoc", "TenMonHoc"); ViewBag.ListMonHoc = lstMon; return(View(gv)); } }
public JsonResult AddNew(AddNewHS_LOPModel data) { using (ELearningDB db = new ELearningDB()) { HocVien hv = db.HocViens.Find(data.ID); LopKiemTra l = db.LopKiemTras.Find(data.MaLop); l.HocViens.Add(hv); db.SaveChanges(); return(Json(new { success = true })); } }
public ActionResult Edit(HocVien hv) { using (ELearningDB db = new ELearningDB()) { HocVien hocvien = db.HocViens.Find(hv.ID); hocvien.HoVaTen = hv.HoVaTen; hocvien.Email = hv.Email; hocvien.NgaySinh = hv.NgaySinh; db.SaveChanges(); return(RedirectToAction("Index")); } }
public JsonResult Delete(DeThi dethi) { using (ELearningDB db = new ELearningDB()) { DeThi dt = db.DeThis.Find(dethi.MaDeThi); if (dt == null) { return(Json(new { success = false })); } db.DeThis.Remove(dt); db.SaveChanges(); return(Json(new { success = true })); } }
public JsonResult Delete(LopKTModel lop) { using (ELearningDB db = new ELearningDB()) { if (lop != null) { LopKiemTra lopkt = db.LopKiemTras.Find(lop.ID); db.LopKiemTras.Remove(lopkt); db.SaveChanges(); return(Json(new { success = true })); } return(Json(new { success = false })); } }
public JsonResult Delete(int id) { using (ELearningDB db = new ELearningDB()) { CauHoi sv = db.CauHois.Find(id); if (sv == null) { return(Json(new { success = false })); } db.CauHois.Remove(sv); db.SaveChanges(); return(Json(new { success = true })); } }
public JsonResult RemoveBaiGiang(BaiGiangModel data) { using (ELearningDB db = new ELearningDB()) { Lop l = db.Lops.Find(data.MaLop); BaiGiang bg = db.BaiGiangs.Find(data.MaBaiGiang); if (l != null && bg != null) { bg.Lops.Remove(l); db.SaveChanges(); return(Json(new { success = true })); } return(Json(new { success = false })); } }
private void CreateCourseDetail() { var User = (TaiKhoan)Session["User"]; using (ELearningDB db = new ELearningDB()) { CourseDetail cd = new CourseDetail() { CourseID = (long)Session["CourseID"], UserID = User.ID }; db.CourseDetails.Add(cd); db.SaveChanges(); } }
public JsonResult AddBaiGiangToLop(BaiGiangModel data) { using (ELearningDB db = new ELearningDB()) { BaiGiang bg = db.BaiGiangs.Find(data.MaBaiGiang); if (bg == null) { return(Json(new { success = false })); } Lop l = db.Lops.Find(data.MaLop); l.BaiGiangs.Add(bg); db.SaveChanges(); return(Json(new { success = true })); } }
public ActionResult ChangeStatus(int id) { using (ELearningDB db = new ELearningDB()) { BaiGiang bg = db.BaiGiangs.Find(id); if (bg == null) { TempData["error"] = "<script>alert('Không tìm thấy bài giảng');</script>"; return(RedirectToAction("QuanLyBaiGiang", "BaiGiang")); } bg.TrangThai = !bg.TrangThai; db.SaveChanges(); return(RedirectToAction("QuanLyBaiGiang", "BaiGiang")); } }
public ActionResult Delete(int id) { using (ELearningDB db = new ELearningDB()) { BaiGiang bg = db.BaiGiangs.Find(id); if (bg == null) { TempData["error"] = "<script>alert('Không tìm thấy bài giảng cần xóa');</script>"; return(RedirectToAction("QuanLyBaiGiang", "BaiGiang")); } db.BaiGiangs.Remove(bg); db.SaveChanges(); return(RedirectToAction("QuanLyBaiGiang", "BaiGiang")); } }
public ActionResult ChangeUserPassword(TaiKhoanDTO t) { var User = (TaiKhoan)Session["User"]; if (User == null) { return(RedirectToAction("Login", "Login")); } using (ELearningDB db = new ELearningDB()) { var data = db.TaiKhoans.Find(t.ID); data.Password = t.Password; db.SaveChanges(); return(Json(1, JsonRequestBehavior.AllowGet)); } }
public JsonResult Create(MonHocModel mh) { try { ELearningDB db = new ELearningDB(); MonHoc mon = new MonHoc(); mon.TenMonHoc = mh.TenMonHoc; db.MonHocs.Add(mon); db.SaveChanges(); return(Json(new { success = true })); } catch (Exception) { return(Json(new { success = false })); } }
public JsonResult CreateChuong(ChuongModel c) { using (ELearningDB db = new ELearningDB()) { if (c != null) { Chuong chuong = new Chuong(); chuong.Name = c.Name; chuong.MaMonHoc = c.MaMonHoc; db.Chuongs.Add(chuong); db.SaveChanges(); return(Json(new { success = true })); } return(Json(new { success = false })); } }
public ActionResult Delete(int id) { using (ELearningDB db = new ELearningDB()) { Chuong c = db.Chuongs.Find(id); int mamon = (int)c.MaMonHoc; if (c != null) { db.Chuongs.Remove(c); db.SaveChanges(); return(RedirectToAction("Chuong", "MonHoc", new { id = mamon })); } ViewBag.error = "Xóa không thành công"; return(RedirectToAction("Chuong", "Chuong", new { id = mamon })); } }
public ActionResult Recharge(TaiKhoanDTO t) { var User = (TaiKhoan)Session["User"]; if (User == null) { return(RedirectToAction("Login", "Login")); } using (ELearningDB db = new ELearningDB()) { var data = db.TaiKhoans.Find(t.ID); data.NguoiDung.SoDu = t.Balance; db.SaveChanges(); return(Json(1, JsonRequestBehavior.AllowGet)); } }
public JsonResult Update(DeThi dethi) { using (ELearningDB db = new ELearningDB()) { DeThi dt = db.DeThis.Find(dethi.MaDeThi); if (dt == null) { return(Json(new { success = false })); } dt.TenDeThi = dethi.TenDeThi; dt.SoCauHoi = dethi.SoCauHoi; dt.NgayThi = dethi.NgayThi; db.SaveChanges(); return(Json(new { success = true })); } }