public ActionResult DiemDanh() { using (HocPhiEntities context = new HocPhiEntities()) { var dsLop = (from lop in context.Lops join hs in context.HocSinhs on lop.MaLop equals hs.MaLop join dd in context.DiemDanhs on hs.MaHocSinh equals dd.HocSinh group dd by new { IDLop = lop.MaLop, TenLopP = lop.TenLop, } into g select new { g.Key.IDLop, TenLopHoc = g.Key.TenLopP, Mindate = g.Min(x => x.NgayDiemDanh) }).ToList(); return(Json(dsLop, JsonRequestBehavior.AllowGet)); } }
public ActionResult DiemDanhUpdate(FormCollection form) { string[] status = form["statuslist"].ToString().Split(new Char[] { ',' }); List <bool> statusbool = status.Select(x => { if (x == "true") { return(true); } else { return(false); } }).ToList(); string[] dsHS = form[1].ToString().Split(new Char[] { ',' }); ViewBag.TongSoHocSinh = (int)Session["TongSoHocSinh"]; using (HocPhiEntities context = new HocPhiEntities()) { using (IDbConnection db = new SqlConnection(context.Database.Connection.ConnectionString)) { if (form["operation"].ToString() == "create") { int i = 0; dsHS.ToList().ForEach( x => { var p = new DynamicParameters(); p.Add("@MahocSinh", x); p.Add("@TrangThai", statusbool[i]); db.Execute("sp_DiemDanhHS", p, commandType: CommandType.StoredProcedure); i++; }); ViewBag.DaDiemDanh = i; } else { int j = 0; dsHS.ToList().ForEach( x => { var q = new DynamicParameters(); q.Add("@MaHs", x); q.Add("@TrangThaiDiemDanh", statusbool[j]); db.Execute("sp_CapNhatTrangThaiDiemDanh", q, commandType: CommandType.StoredProcedure); j++; }); ViewBag.DaDiemDanh = j; } } } return(View()); }
public ActionResult LayDanhSachDiemDanh(FormCollection form) { string MaLop = form[0].ToString(); ViewBag.Operation = "create"; using (HocPhiEntities context = new HocPhiEntities()) { var HsTheoLop = (from hs in context.HocSinhs join lop in context.Lops on hs.Lop.MaLop equals lop.MaLop where hs.Lop.MaLop == MaLop select hs); var DsDiemDanh = (from dd in context.DiemDanhs join hs in HsTheoLop on dd.HocSinh equals hs.MaHocSinh where dd.NgayDiemDanh.Year == DateTime.Now.Year && dd.NgayDiemDanh.Month == DateTime.Now.Month && dd.NgayDiemDanh.Day == DateTime.Now.Day select dd ).ToList(); var HSTheoTrangThaiDiemDanh = HsTheoLop.FullOuterJoin(DsDiemDanh, a => a.MaHocSinh, b => b.HocSinh, (a, b, MaHocSinh) => new { MaHocSinh, a.TenHocSinh, a.GioiTinh, a.NamSinh, a.TenPhuHuynh, a.DienThoai, a.DiaChiLienHe, b?.TrangThaiDiemDanh }); List <DiemDanhViewModel> _hs = new List <DiemDanhViewModel>(); foreach (var hs in HSTheoTrangThaiDiemDanh) { if (hs.TrangThaiDiemDanh != null) { ViewBag.Operation = "edit"; } _hs.Add(new DiemDanhViewModel() { MaHocSinh = hs.MaHocSinh, TenHocSinh = hs.TenHocSinh, GioiTinh = hs.GioiTinh, NamSinh = hs.NamSinh, TenPhuHuynh = hs.TenPhuHuynh, DienThoai = hs.DienThoai, DiaChiLienHe = hs.DiaChiLienHe, TrangThaiDiemDanh = hs.TrangThaiDiemDanh }); } Session["TongSoHocSinh"] = _hs.Count(); return(View("LayDanhSachDiemDanh", _hs)); } }
public ActionResult LichSuDiemDanh(string NgayDiemDanh, string MaLop) { DateTime dt = DateTime.ParseExact(NgayDiemDanh, "dd/MM/yyyy", CultureInfo.InvariantCulture); using (HocPhiEntities context = new HocPhiEntities()) { var HsTheoLop = (from hs in context.HocSinhs join lop in context.Lops on hs.Lop.MaLop equals lop.MaLop where hs.Lop.MaLop == MaLop select hs); var DsDiemDanh = (from dd in context.DiemDanhs join hs in HsTheoLop on dd.HocSinh equals hs.MaHocSinh where dd.NgayDiemDanh.Year == dt.Year && dd.NgayDiemDanh.Month == dt.Month && dd.NgayDiemDanh.Day == dt.Day select dd ).ToList(); var HSTheoTrangThaiDiemDanh = HsTheoLop.FullOuterJoin(DsDiemDanh, a => a.MaHocSinh, b => b.HocSinh, (a, b, MaHocSinh) => new { MaHocSinh, a.TenHocSinh, a.GioiTinh, a.NamSinh, a.TenPhuHuynh, a.DienThoai, a.DiaChiLienHe, b?.TrangThaiDiemDanh }); List <DiemDanhViewModel> _hs = new List <DiemDanhViewModel>(); foreach (var hs in HSTheoTrangThaiDiemDanh) { _hs.Add(new DiemDanhViewModel() { MaHocSinh = hs.MaHocSinh, TenHocSinh = hs.TenHocSinh, GioiTinh = hs.GioiTinh, NamSinh = hs.NamSinh, TenPhuHuynh = hs.TenPhuHuynh, DienThoai = hs.DienThoai, DiaChiLienHe = hs.DiaChiLienHe, TrangThaiDiemDanh = hs.TrangThaiDiemDanh }); } return(PartialView("LichSuDiemDanh", _hs)); } }
public ActionResult Login(Login lg) { if (ModelState.IsValid) { using (HocPhiEntities db = new HocPhiEntities()) { var log = db.Accounts.Where(a => a.Email.Equals(lg.Email) && a.Password.Equals(lg.MatKhau)).FirstOrDefault(); if (log != null) { var getNameAccount = db.GiaoViens.Where(n => n.MaGiaoVien == log.MaGiaoVien).FirstOrDefault(); if (getNameAccount != null) { var getClass = db.Lops.Where(n => n.MaGiaoVien == getNameAccount.MaGiaoVien).FirstOrDefault(); Session["getClass"] = getClass.MaLop.ToString(); Session["Admin"] = getNameAccount.TenGiaoVien; Session["AdHinh"] = log.HinhAnh; Session["dangnhap"] = log.Email; Session["ID"] = log.ID; Session["quyen"] = log.Quyen; return(RedirectToAction("Admin/Index", "Admin")); } else { Session["Admin"] = "Admin"; Session["AdHinh"] = log.HinhAnh; Session["dangnhap"] = log.Email; Session["ID"] = log.ID; Session["quyen"] = log.Quyen; return(RedirectToAction("Admin/Index", "Admin")); } } else { ViewBag.SuccessMessage = "Sai Email hoặc password !"; } } } return(View()); }
public ActionResult ChonLopDiemDanh() { if (Session["quyen"] == null) { var malop = Session["getClass"].ToString(); var dsLop = db.Lops.Where(n => n.MaLop == malop).ToList(); return(View(dsLop)); } else { using (HocPhiEntities context = new HocPhiEntities()) { var dsLop = (from lop in context.Lops select lop).ToList(); //var dsLop = db.Lops.Where(n=>n.MaLop == malop).ToList(); return(View(dsLop)); } } }