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 }));
}
}
