Esempio n. 1
0
        public ActionResult DetailHB()
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                int     id_hs   = (int)Session["id_hsDetail"];
                HOCSINH hocsinh = db.HOCSINHs.Find(id_hs);
                if (hocsinh.id_HB > 0)
                {
                    ViewBag.ThongbaoHB = "OK";
                    HOCBA         hb         = db.HOCBAs.Find(hocsinh.id_HB);
                    List <NAMHOC> listNamHoc = db.NAMHOCs.Where(n => n.id_HB == hocsinh.id_HB).ToList();
                    ViewBag.listNamHoc = listNamHoc; //load nam hoc
                    List <DiemKyHoc> listDiem = new List <DiemKyHoc>();
                    if (listNamHoc.Count > 0)
                    {
                        foreach (var item in listNamHoc)
                        {
                            List <KIHOC> listKH = db.KIHOCs.Where(n => n.id_NAMHOC == item.id).ToList();
                            if (listKH.Count > 0)
                            {
                                DiemKyHoc a = new DiemKyHoc(item, listKH);
                                listDiem.Add(a);
                            }
                        }
                    }
                    ViewBag.listKiHoc = listDiem;
                    return(View(hb));
                }
                ViewBag.ThongbaoHB = "NO";
                return(View());
            }
            return(RedirectToAction("Index", "Home"));
        }
        public JsonResult Themmoi(HOCSINH hocsinh)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                if (ModelState.IsValid)
                {
                    DateTime today = DateTime.Now;
                    hocsinh.timeStart = today.ToString("yyyy");
                    hocsinh.NguoiTao  = quyenNguoiDung.Nhanvien.id;
                    db.HOCSINHs.Add(hocsinh);
                    db.SaveChanges();

                    if (hocsinh.email != null)
                    {
                        Senmail senmail = new Senmail();
                        senmail.SendEmail(hocsinh.email, "Xin chúc mừng bạn \nThông tin bạn đã được lưu trữ thành công trong hệ thống chúng tôi. \nCó gì thắc mắc bạn có thể liên hệ với chúng tôi qua email này ([email protected]). \nRất cảm ơn bạn nhiều. ");
                    }

                    int id_HS = hocsinh.id;
                    Session["id_HS"] = id_HS;
                    return(Json(id_HS, JsonRequestBehavior.AllowGet));
                }
                return(Json("Thêm thất bại!", JsonRequestBehavior.AllowGet));
            }
            return(Json("khong duoc quyen!", JsonRequestBehavior.AllowGet));
        }
        // GET: NguoiDung
        public ActionResult Index(int?page)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && quyenNguoiDung.Quyen.Ten == "Admin")
            {
                int count = db.NHANVIENs.ToList().Count;
                Session["chiasotrang"] = count % 10 == 0 ? count / 10 : count / 10 + 1;
                page = page ?? 1;
                int lineStart = (int)(page - 1) * 10; //dòng bắt đầu
                int soBanGhi  = 10;                   //số bản ghi cần hiện thị mỗi trang
                Session["trangdangload"] = page;

                var idParam1 = new SqlParameter
                {
                    ParameterName = "LineStart",
                    Value         = lineStart
                };
                var idParam2 = new SqlParameter
                {
                    ParameterName = "soBanGhi",
                    Value         = soBanGhi
                };
                var list = db.Database.SqlQuery <NHANVIEN>("exec PhanTrangNguoiDung @LineStart,@soBanGhi ", idParam1, idParam2).ToList <NHANVIEN>();
                return(View(list));
            }
            return(RedirectToAction("Index", "Home"));
        }
        public ActionResult Themmoi(NHANVIEN nhanvien)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && quyenNguoiDung.Quyen.Ten == "Admin")
            {
                NHANVIEN nguoiDung = Session["NguoiDungHT"] as NHANVIEN;
                if (nguoiDung != null)
                {
                    if (ModelState.IsValid)
                    {
                        nhanvien.NguoiTao = nguoiDung.id;
                        nhanvien.NgayTao  = DateTime.Now;
                        Senmail senmail = new Senmail();
                        senmail.SendEmail("*****@*****.**", "Mật khẩu vào hệ thống của bạn \n là " + nhanvien.TenDangNhap);
                        Xuly xuly = new Xuly();
                        nhanvien.MatKhau = xuly.chuoiMaHoa(nhanvien.TenDangNhap);
                        db.NHANVIENs.Add(nhanvien);
                        db.SaveChanges();

                        return(RedirectToAction("Index"));
                    }
                    return(View());
                }
                return(View());
            }
            return(RedirectToAction("Index", "Home"));
        }
        public ActionResult ChinhSuaLoiQueQuan(int id)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                LoiModel  chitietLoi = new LoiModel();
                TABLE_LOI tableLoi   = db.TABLE_LOI.Find(id);
                string    typeLoi    = tableLoi.TypeLOI;
                ViewBag.idLoi   = id;
                ViewBag.typeLoi = typeLoi;
                Xuly xuly = new Xuly();
                ViewBag.HocSinhLoi = xuly.ReturnHoten(id);
                int    id_GKS = tableLoi.id_GKS ?? 0;
                string so_CMT = tableLoi.So_CMT ?? null;
                if (check(id_GKS))
                {
                    chitietLoi.Giaykhaisinh = db.GIAYKHAISINHs.Find(id_GKS);
                }
                if (so_CMT != null)
                {
                    chitietLoi.Cmt = db.CMTs.Find(so_CMT);
                }
            }
            return(RedirectToAction("Index", "Home"));
        }
        public ActionResult ChinhSuaLoiDanToc(int id)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                LoiModel  chitietLoi = new LoiModel();
                TABLE_LOI tableLoi   = db.TABLE_LOI.Find(id);
                string    typeLoi    = tableLoi.TypeLOI;
                ViewBag.typeLoi = typeLoi;
                ViewBag.idLoi   = id;
                Xuly xuly = new Xuly();
                ViewBag.HocSinhLoi = xuly.ReturnHoten(id);
                int id_GKS = tableLoi.id_GKS ?? 0;
                int id_BTN = tableLoi.id_BTN ?? 0;
                int id_HB  = tableLoi.id_HB ?? 0;
                if (check(id_GKS))
                {
                    chitietLoi.Giaykhaisinh = db.GIAYKHAISINHs.Find(id_GKS);
                }
                if (check(id_BTN))
                {
                    chitietLoi.Bangtotnghiep = db.BANGTOTNGHIEPs.Find(id_BTN);
                }
                if (check(id_HB))
                {
                    chitietLoi.Hocba = db.HOCBAs.Find(id_HB);
                }
            }
            return(RedirectToAction("Index", "Home"));
        }
Esempio n. 7
0
        public ActionResult Dangnhap(string tenDangNhap, string matKhau)
        {
            Xuly     xuly       = new Xuly();
            string   matKhauNew = xuly.chuoiMaHoa(matKhau);
            NHANVIEN Listnv     = db.NHANVIENs.SingleOrDefault(n => n.TenDangNhap == tenDangNhap);
            NHANVIEN nv         = Listnv != null ? Listnv : null;

            if (nv != null)
            {
                if (nv.MatKhau == matKhauNew)
                {
                    List <PHANQUYEN>    listPQ         = db.PHANQUYENs.Where(n => n.id_quyen == nv.id_Quyen).ToList();
                    QUYEN               quyen          = db.QUYENs.Find(nv.id_Quyen);
                    ModelQuyenNguoiDung QuyenNguoiDung = new ModelQuyenNguoiDung(nv, quyen);
                    Session["QuyenNguoiDung"] = QuyenNguoiDung;

                    Session["DangNhap"]    = "OK";
                    Session["thongbaoDN"]  = null;
                    Session["NguoiDung"]   = nv.TenDangNhap;
                    Session["NguoiDungHT"] = nv;
                    listTb();
                    return(RedirectToAction("Index", "Home"));
                }
                Session["DangNhap"]   = "NO";
                Session["thongbaoDN"] = "Đăng nhập thất bại";
                return(View());
            }
            else
            {
                Session["DangNhap"]   = "NO";
                Session["thongbaoDN"] = "Đăng nhập thất bại";
                return(View());
            }
        }
Esempio n. 8
0
        // GET: PhanQuyen
        public ActionResult Index()
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && quyenNguoiDung.Quyen.Ten == "Admin")
            {
                return(View(db.PHANQUYENs.ToList()));
            }
            return(RedirectToAction("Index", "Home"));
        }
        public ActionResult IndexTbDo()
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                return(View(db.TABLE_LOI.Where(n => n.TrangThai == "3").ToList()));
            }
            return(RedirectToAction("Index", "Home"));
        }
Esempio n. 10
0
        // GET: NamHoc
        public ActionResult Themmoi()
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                return(View());
            }
            return(RedirectToAction("Index", "Home"));
        }
Esempio n. 11
0
        //GET: Cập nhật quyền

        public ActionResult SuaQuyen(int id)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && quyenNguoiDung.Quyen.Ten == "Admin")
            {
                return(View(db.QUYENs.Find(id)));
            }
            return(RedirectToAction("Index", "Home"));
        }
        public JsonResult SearchKeyName(string keySearch)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                List <HOCSINH> list = db.HOCSINHs.Where(n => n.TenHS.Contains(keySearch) || n.sdt.Contains(keySearch) || n.email.Contains(keySearch)).ToList();
                return(Json(list, JsonRequestBehavior.AllowGet));
            }
            return(Json("Khong co quyen", JsonRequestBehavior.AllowGet));
        }
        //GET: sOLUONG Load san pham
        public JsonResult SearchNam(string Namloc)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                List <HOCSINH> list = db.HOCSINHs.Where(n => n.timeStart == Namloc).ToList();
                return(Json(list, JsonRequestBehavior.AllowGet));
            }
            return(Json("Khong co quyen", JsonRequestBehavior.AllowGet));
        }
        public ActionResult DetailHocsinh(int id)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                HOCSINH hocsinh = db.HOCSINHs.Find(id);
                return(View(hocsinh));
            }
            return(RedirectToAction("Index", "Home"));
        }
Esempio n. 15
0
        public ActionResult listNamHoc(int id_hb)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                var model = db.NAMHOCs.Where(n => n.id_HB == id_hb).ToList();
                return(View(model));
            }
            return(RedirectToAction("Index", "Home"));
        }
        public ActionResult SuaNguoiDung(int id)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && quyenNguoiDung.Quyen.Ten == "Admin")
            {
                ViewBag.listQuyen = db.QUYENs.ToList();
                return(View(db.NHANVIENs.Find(id)));
            }
            return(RedirectToAction("Index", "Home"));
        }
Esempio n. 17
0
        //GET: Thêm
        public ActionResult Themmoi()
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && quyenNguoiDung.Quyen.Ten == "Admin")
            {
                ViewBag.Quyen   = db.QUYENs.ToList();
                ViewBag.QuyenTC = db.QUYENTRUYCAPs.ToList();
                return(View());
            }
            return(RedirectToAction("Index", "Home"));
        }
        public void CapNhatTb()
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                List <TABLE_LOI> listVang = new List <TABLE_LOI>();
                List <TABLE_LOI> listDo   = new List <TABLE_LOI>();
                List <TABLE_LOI> listXanh = new List <TABLE_LOI>();
                DateTime         today    = DateTime.Now;
                var listLoi = db.TABLE_LOI.ToList();
                foreach (var i in listLoi)
                {
                    if (i.TimeEnd > today)
                    {
                        TimeSpan a   = ((DateTime)i.TimeEnd).Subtract(today);
                        double   day = a.TotalDays;
                        if (day > 5)
                        {
                            i.TrangThai = "1"; //mức xanh
                            if (checkNguoiTao(i, quyenNguoiDung.Nhanvien.id) == true)
                            {
                                i.NguoiSua = quyenNguoiDung.Nhanvien.id;
                                listXanh.Add(i);
                            }
                        }
                        else
                        {
                            i.TrangThai = "2";//mức vàng
                            if (checkNguoiTao(i, quyenNguoiDung.Nhanvien.id) == true)
                            {
                                i.NguoiSua = quyenNguoiDung.Nhanvien.id;
                                listVang.Add(i);
                            }
                        }
                    }
                    else
                    {
                        i.TrangThai = "3"; //mức đỏ
                        if (checkNguoiTao(i, quyenNguoiDung.Nhanvien.id) == true)
                        {
                            i.NguoiSua = quyenNguoiDung.Nhanvien.id;
                            listDo.Add(i);
                        }
                    }
                }
                Session["ThongBaoVang"] = listVang;
                Session["ThongBaoDo"]   = listDo;
                Session["ThongBaoXanh"] = listXanh;
                db.SaveChanges();
            }
        }
        // GET: NguoiGiamHo
        public ActionResult Themmoi(int?id_hs)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                HOCSINH hocsinh = db.HOCSINHs.Find(id_hs);

                Session["file"] = null;
                return(View());
            }
            return(RedirectToAction("Index", "Home"));
        }
        public ActionResult ThemmoiR(int?id_hs)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                Session["file"]      = null;
                Session["chuyenTab"] = 2;
                Session["id_HS"]     = id_hs;
                return(View(id_hs));
            }
            return(RedirectToAction("Index", "Home"));
        }
        public ActionResult Detail()
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                int     id_hs   = (int)Session["id_hsDetail"];
                HOCSINH hocsinh = db.HOCSINHs.Find(id_hs);
                CMT     cmt     = db.CMTs.SingleOrDefault(n => n.SoCMT == hocsinh.SoCMT);
                return(View(cmt));
            }
            return(RedirectToAction("Index", "Home"));
        }
        public ActionResult Detail()
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                int     id_hs   = (int)Session["id_hsDetail"];
                HOCSINH hocsinh = db.HOCSINHs.Find(id_hs);

                NGUOIGIAMHO nguoigiamho = db.NGUOIGIAMHOes.Find(hocsinh.id_NgGiamHo);
                return(View(nguoigiamho));
            }
            return(RedirectToAction("Index", "Home"));
        }
Esempio n. 23
0
        public ActionResult SuaHB(int id)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                HOCBA   hb = db.HOCBAs.Find(id);
                HOCSINH hs = db.HOCSINHs.SingleOrDefault(n => n.id_HB == id);
                ViewBag.id_hs        = hs.id;
                Session["chuyenTab"] = 5;
                return(View(hb));
            }
            return(RedirectToAction("Index", "Home"));
        }
Esempio n. 24
0
        public ActionResult SuaBTN(int id)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                Session["file"] = null;
                BANGTOTNGHIEP btn = db.BANGTOTNGHIEPs.Find(id);
                HOCSINH       hs  = db.HOCSINHs.SingleOrDefault(n => n.id_BTN == btn.id);
                ViewBag.id_hs        = hs.id;
                Session["chuyenTab"] = 4;
                return(View(btn));
            }
            return(RedirectToAction("Index", "Home"));
        }
        public ActionResult Giaynhaphoc(GiayNhapHoc gnh)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyHoSo" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                if (ModelState.IsValid)
                {
                    db.GiayNhapHocs.Add(gnh);
                    db.SaveChanges();
                    return(RedirectToAction("Giaynhaphoc/" + gnh.id_hs));
                }
                return(View(gnh));
            }
            return(RedirectToAction("Index", "Home"));
        }
        public ActionResult SuaCMT(string soCMT, int loaiCMT)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                Session["file"] = null;
                CMT cmt = db.CMTs.Find(soCMT);
                ViewBag.LoaiCMT = loaiCMT;
                HOCSINH hs = db.HOCSINHs.SingleOrDefault(n => n.SoCMT == soCMT);
                ViewBag.id_hs        = hs.id;
                Session["chuyenTab"] = 2;
                return(View(cmt));
            }
            return(RedirectToAction("Index", "Home"));
        }
Esempio n. 27
0
        public ActionResult Themmoi(PHANQUYEN Pquyen)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && quyenNguoiDung.Quyen.Ten == "Admin")
            {
                if (ModelState.IsValid)
                {
                    db.PHANQUYENs.Add(Pquyen);
                    db.SaveChanges();
                    return(RedirectToAction("Index"));
                }
                return(View());
            }
            return(RedirectToAction("Index", "Home"));
        }
        public ActionResult ThemmoiR(int?id_hs)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                HOCSINH hocsinh = db.HOCSINHs.Find(id_hs);
                if (quyenNguoiDung.Nhanvien.id == hocsinh.NguoiTao)
                {
                    Session["file"]      = null;
                    Session["chuyenTab"] = 5;
                    Session["id_HS"]     = id_hs;
                    return(View(id_hs));
                }
            }
            return(RedirectToAction("Index", "Home"));
        }
        public ActionResult Index(int?page)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && (quyenNguoiDung.Quyen.Ten == "QuanLyThongTinHocSinh" || quyenNguoiDung.Quyen.Ten == "Admin"))
            {
                Session["chuyenTab"] = null;
                Xuly           xuly    = new Xuly();
                List <string>  listNam = new List <string>();
                List <HOCSINH> lisths  = db.HOCSINHs.OrderByDescending(n => n.timeStart).ToList();
                foreach (var item1 in lisths)
                {
                    if (!xuly.checkTrungTimeStart(item1.timeStart, listNam)) //chưa tồn tại trong list thì thêm vào list
                    {
                        listNam.Add(item1.timeStart);
                    }
                }
                ViewBag.listNam = listNam;
                int count = db.HOCSINHs.Where(n => n.NguoiTao == quyenNguoiDung.Nhanvien.id).ToList().Count;
                ViewBag.All            = count;
                Session["chiasotrang"] = count % 10 == 0 ? count / 10 : count / 10 + 1;
                page = page ?? 1;
                int lineStart = (int)(page - 1) * 10; //dòng bắt đầu
                int soBanGhi  = 10;                   //số bản ghi cần hiện thị mỗi trang
                Session["trangdangload"] = page;

                var idParam0 = new SqlParameter
                {
                    ParameterName = "NguoiTao",
                    Value         = quyenNguoiDung.Nhanvien.id
                };
                var idParam1 = new SqlParameter
                {
                    ParameterName = "LineStart",
                    Value         = lineStart
                };
                var idParam2 = new SqlParameter
                {
                    ParameterName = "soBanGhi",
                    Value         = soBanGhi
                };
                var list = db.Database.SqlQuery <HOCSINH>("exec PhanTrang @NguoiTao,@LineStart,@soBanGhi ", idParam0, idParam1, idParam2).ToList <HOCSINH>();
                return(View(list));
            }
            return(RedirectToAction("Index", "Home"));
        }
        public JsonResult XoaNguoiDung(string id)
        {
            ModelQuyenNguoiDung quyenNguoiDung = Session["QuyenNguoiDung"] as ModelQuyenNguoiDung;

            if (quyenNguoiDung != null && quyenNguoiDung.Quyen.Ten == "Admin")
            {
                if (ModelState.IsValid)
                {
                    NHANVIEN nhanvien = db.NHANVIENs.Find(Convert.ToInt32(id));
                    db.NHANVIENs.Remove(nhanvien);
                    db.SaveChanges();
                    return(Json("Yes", JsonRequestBehavior.AllowGet));
                }
                return(Json("No", JsonRequestBehavior.AllowGet));
            }
            return(Json("No", JsonRequestBehavior.AllowGet));
        }