public JsonResult GetUser()
{
var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION];
using (ELearningDB db = new ELearningDB())
{
HocVienModel HV = new HocVienModel();
HocVien hv = db.HocViens.Find(session.ID);
HV.ID = hv.ID;
HV.HoVaTen = hv.HoVaTen;
HV.Email = hv.Email;
if (hv.Image != null)
{
HV.Image = hv.Image;
}
else
{
HV.Image = "Noimage";
}
HV.GioiTinh = (bool)hv.GioiTinh;
HV.SDT = hv.SoDienThoai;
HV.BirthDate = hv.NgaySinh.Value.ToString("dd/MM/yyyy");
return(Json(HV, JsonRequestBehavior.AllowGet));
}
}
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 ActionResult CheckEmail(string Email)
{
var User = (TaiKhoan)Session["User"];
if (User == null)
{
return(RedirectToAction("Login", "Login"));
}
using (ELearningDB db = new ELearningDB())
{
var data = db.TaiKhoans.Where(x => x.NguoiDung.Email == Email).FirstOrDefault();
if (db.NguoiDungs.Find(User.ID).Email == Email)
{
return(Json(1, JsonRequestBehavior.AllowGet));
}
else
{
if (data == null)
{
return(Json(1, JsonRequestBehavior.AllowGet));
}
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
}
public JsonResult GetLop()
{
var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION];
using (ELearningDB db = new ELearningDB())
{
List <LopModel> Lops = new List <LopModel>();
List <Lop> lstLop = db.Lops.Where(x => x.MaGiangVien == session.ID).ToList();
foreach (var item in lstLop)
{
LopModel l = new LopModel();
l.MaLop = item.MaLop;
l.TenLop = item.TenLop;
l.TrangThai = item.TrangThai;
l.MaMonHoc = (int)item.MaMonHoc;
l.NgayBatDau = item.NgayBatDau.ToString();
l.NgayKetThuc = item.NgayKetThuc.ToString();
l.Image = item.Image;
l.SiSo = item.SiSo;
l.MoTa = item.MoTa;
Lops.Add(l);
}
return(Json(Lops, JsonRequestBehavior.AllowGet));
}
}
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 FirstLogin(int ID)
{
using (ELearningDB db = new ELearningDB())
{
GiangVien gv = db.GiangViens.Find(ID);
if (gv.HoVaTen != null)
{
Session.Abandon();
return(RedirectToAction("Index", "Login", new { area = "" }));
}
HocVienModel hocvien = new HocVienModel();
GiangVienModel giangvien = new GiangVienModel();
giangvien.ID = gv.ID;
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(giangvien));
}
}
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 DanhSachMonHoc()
{
ELearningDB db = new ELearningDB();
List <MonHoc> MonHocs = db.MonHocs.ToList();
return(View(MonHocs));
}
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 GetCauHoiKT(LopKTModel lop)
{
using (ELearningDB db = new ELearningDB())
{
var lstCauHoi = db.CauHois.Where(x => x.DeThis.Any(r => r.MaDeThi == lop.MaDeThi)).ToList();
List <CauHoiModel> CauHois = new List <CauHoiModel>();
foreach (var item in lstCauHoi)
{
CauHoiModel ch = new CauHoiModel();
ch.NoiDung = item.NoiDung;
ch.BieuThuc = item.BieuThuc;
ch.CauA = item.CauA;
ch.BieuThucA = item.BieuThucA;
ch.CauB = item.CauB;
ch.BieuThucB = item.BieuThucB;
ch.CauC = item.CauC;
ch.BieuThucC = item.BieuThucC;
ch.CauD = item.CauD;
ch.BieuThucD = item.BieuThucD;
ch.DapAn = (int)item.DapAn;
CauHois.Add(ch);
}
return(Json(CauHois, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetTK(TaiKhoanModel tk)
{
using (ELearningDB db = new ELearningDB())
{
var Key = db.KeyAPIs.Where(x => x.Name == "KeyAccount").FirstOrDefault();
if (tk.key == Key.Value)
{
List <TaiKhoan> lstTaiKhoan = db.TaiKhoans.Where(x => x.Role != 1).ToList();
List <TaiKhoanModel> TaiKhoans = new List <TaiKhoanModel>();
foreach (var item in lstTaiKhoan)
{
TaiKhoanModel taikhoan = new TaiKhoanModel();
taikhoan.ID = item.ID;
taikhoan.Username = item.Username;
taikhoan.Role = item.Role;
taikhoan.Username = item.Username;
taikhoan.TrangThai = (bool)item.TrangThai;
TaiKhoans.Add(taikhoan);
}
return(Json(TaiKhoans, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false));
}
}
}
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 GetAllQuestion(int id)
{
var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION];
using (ELearningDB db = new ELearningDB())
{
var lstCauHoi = db.CauHois.Where(x => (x.MaGiangVien == session.ID || x.TrangThai == true) && x.MaMonHoc == id);
List <CauHoiModel> CHs = new List <CauHoiModel>();
foreach (var item in lstCauHoi)
{
CauHoiModel ch = new CauHoiModel();
ch.MaCauHoi = item.MaCauHoi;
ch.NoiDung = item.NoiDung;
ch.BieuThuc = item.BieuThuc;
ch.TenChuong = item.Chuong.Name;
ch.DoKho = (int)item.DoKho;
ch.TrangThai = (bool)item.TrangThai;
ch.ChuongID = (long)item.ChuongID;
ch.TenGV = item.GiangVien.HoVaTen;
CHs.Add(ch);
}
return(Json(CHs, JsonRequestBehavior.AllowGet));
}
}
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 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 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 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(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 GetLopKT()
{
var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION];
using (ELearningDB db = new ELearningDB())
{
var lstLopKT = db.LopKiemTras.Where(x => x.GVID == session.ID);
List <LopKTModel> LopKTs = new List <LopKTModel>();
foreach (var item in lstLopKT)
{
LopKTModel lopKT = new LopKTModel();
lopKT.ID = item.ID;
lopKT.Name = item.Name;
lopKT.TestDate = item.TestDate.Value.ToString("dd/MM/yyyy");
lopKT.GVID = item.GVID;
lopKT.MonHocID = item.MaMonHoc;
lopKT.ThoiGianThi = (int)item.ThoiGianThi;
//lopKT.MaDeThi = item.MaDeThi;
if (item.MaDeThi == null)
{
lopKT.TenDeThi = "Chưa chọn đề thi";
}
else
{
lopKT.TenDeThi = item.DeThi.TenDeThi;
}
LopKTs.Add(lopKT);
}
return(Json(LopKTs, JsonRequestBehavior.AllowGet));
}
}
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 }));
}
// GET: KetQua
public ActionResult Index()
{
var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION];
if (session != null && session.loai == 3)
{
using (ELearningDB db = new ELearningDB())
{
List <KetQuaModel> KetQuas = new List <KetQuaModel>();
var lstKQ = db.BaiLams.Where(x => x.MaHocVien == session.ID).ToList();
foreach (var item in lstKQ)
{
KetQuaModel kq = new KetQuaModel();
kq.TenMonHoc = item.LopKiemTra.MonHoc.TenMonHoc;
kq.MaDeThi = item.LopKiemTra.MaDeThi;
kq.TenDeThi = item.LopKiemTra.Name;
kq.NgayLam = item.NgayKiemTra.Value.ToString("dd/MM/yyyy");
kq.Diem = item.TongDiem;
KetQuas.Add(kq);
}
return(View(KetQuas));
}
}
else
{
TempData["Error"] = "Bạn chưa đăng nhập";
return(RedirectToAction("TrangChu", "Home"));
}
}
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 GetFreeCourse()
{
using (ELearningDB db = new ELearningDB())
{
var freeCourse = db.Courses.Where(x => x.Price == 0).OrderByDescending(x => x.Comments.Select(c => c.Rate).Sum() / x.Comments.Select(c => c.Rate).Count()).ThenByDescending(x => x.CourseDetails.Count()).Take(3).ToList();
List <CourseDTO> data = new List <CourseDTO>();
foreach (var item in freeCourse)
{
var lstCmtID = db.Comments.Where(x => x.CourseID == item.ID).Select(a => a.ID);
var lstRep = db.Replies.Where(x => lstCmtID.Contains(x.CommentID)).ToList();
CourseDTO l = new CourseDTO();
l.ID = item.ID;
l.Name = item.Name;
l.Capacity = item.Capacity;
l.NumOfPeo = db.CourseDetails.Where(x => x.CourseID == item.ID).Count();
l.Description = item.Description;
l.Image = item.Image;
l.Status = item.Status;
l.Price = item.Price;
l.Schedule = item.Schedule;
l.Condition = item.Condition;
l.Type = item.Type;
l.UserID = item.UserID;
l.Comments = item.Comments.Count() + lstRep.Count();
l.Username = item.NguoiDung.HoVaTen;
data.Add(l);
}
return(Json(data, JsonRequestBehavior.AllowGet));
}
}
// GET: GV/DeThi
public ActionResult Index()
{
ELearningDB db = new ELearningDB();
List <MonHoc> mh = db.MonHocs.ToList();
return(View(mh));
}
public ActionResult Edit(int id)
{
using (ELearningDB db = new ELearningDB())
{
HocVien hv = db.HocViens.Find(id);
return(View(hv));
}
}
public ActionResult Chuong(int id)
{
ELearningDB db = new ELearningDB();
var m = db.Chuongs.Where(x => x.MaMonHoc == id);
ViewBag.MaMonHoc = id;
return(View(m));
}
// GET: GV/LopKiemTra
public ActionResult QuanLyKiemTra()
{
var session = (TaiKhoanLogin)Session[CommonConstants.USER_SESSION];
using (ELearningDB db = new ELearningDB())
{
}
return(View());
}
// GET: GV/CauHoi
public ActionResult Index()
{
using (ELearningDB db = new ELearningDB())
{
List <MonHoc> lstMH = new List <MonHoc>();
lstMH = db.MonHocs.ToList();
return(View(lstMH));
}
}
public JsonResult getAllComment(int id)
{
using (ELearningDB db = new ELearningDB())
{
List <Comment> lstCom = db.Comments.Where(x => x.ClassID == id).ToList();
List <CommentModel> Coms = new List <CommentModel>();
foreach (var item in lstCom)
{
CommentModel com = new CommentModel();
com.ID = item.ID;
com.NoiDung = item.NoiDung;
com.CreateDate = item.CreateDate.Value.ToString("dd/MM/yyyy hh:mm tt");
com.CreateBy = item.CreateBy;
if (item.ClassID == null)
{
com.ClassID = -1;
}
else
{
com.ClassID = (int)item.ClassID;
}
if (item.CourseID == null)
{
com.CourseID = -1;
}
else
{
com.CourseID = (int)item.CourseID;
}
if (item.LessionID == null)
{
com.LessionID = -1;
}
else
{
com.LessionID = (int)item.LessionID;
}
com.HoTen = getNamebyID(item.TaiKhoan.ID);
List <Reply> lstRep = db.Replies.Where(x => x.CommentID == item.ID).ToList();
List <CommentModel> reps = new List <CommentModel>();
foreach (var rep in lstRep)
{
CommentModel r = new CommentModel();
r.ID = rep.ID;
r.NoiDung = rep.NoiDung;
r.CreateDate = rep.CreateDate.Value.ToString("dd/MM/yyyy hh:mm tt");
r.CreateBy = rep.CreateBy;
r.HoTen = getNamebyID(rep.TaiKhoan.ID);
reps.Add(r);
}
com.Reps = reps;
Coms.Add(com);
}
return(Json(Coms, JsonRequestBehavior.AllowGet));
}
}
