public ActionResult DanhSachYeuThich()
        {
            TempData.Keep();
            DanhSach model = (DanhSach)TempData["DanhSach"];

            return(View(model));
        }
        public JsonResult GetDanhSachYeuThich(List <int> IdYeuThics)
        {
            string listids = string.Join(",", IdYeuThics);
            IList <ProductFrontPageMapping.ProductBox>     products   = _menuRepository.LaySanPhamYeuThichs(listids);
            IList <PromotionMapping.PromotionCheckProduct> promotions = _promotionRepository.GetActives();

            PromotionMapping.PromotionCheck promotion = _promotionRepository.GetCurrentPromotion();
            foreach (var sp in products)
            {
                if (promotions.Any())
                {
                    foreach (var pr in promotions)
                    {
                        var promotionDetail = pr.PromotionDetails.FirstOrDefault(dt => dt.ProductId == sp.id_);
                        if (promotionDetail != null)
                        {
                            sp.HasPromotion   = true;
                            sp.PricePromotion = (int)promotionDetail.PriceDiscount;
                            sp.Discount       = (short)promotionDetail.Percent;
                            break;
                        }
                    }
                }
            }
            DanhSach model = new DanhSach()
            {
                DanhSachYeuThichs = products
            };

            TempData["DanhSach"] = model;

            return(Json(new { success = true }, JsonRequestBehavior.AllowGet));
        }
        public ActionResult DeleteConfirmed(int id)
        {
            DanhSach danhsach = db.DanhSaches.Find(id);

            db.DanhSaches.Remove(danhsach);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "IDQN,HoTen,CB,CV,DonVi,ThanhPhan")] DanhSach user)
 {
     if (ModelState.IsValid)
     {
         context.Edit(user);
         return(RedirectToAction("Index"));
     }
     return(View(user));
 }
        //
        // GET: /DanhSach/Details/5

        public ActionResult Details(int id = 0)
        {
            DanhSach danhsach = db.DanhSaches.Find(id);

            if (danhsach == null)
            {
                return(HttpNotFound());
            }
            return(View(danhsach));
        }
Example #6
0
 public void Insert(DanhSach user)
 {
     object[] sqlParams =
     {
         new SqlParameter("@HoTen",     user.HoTen),
         new SqlParameter("@CB",        user.CB),
         new SqlParameter("@CV",        user.CV),
         new SqlParameter("@DonVi",     user.DonVi),
         new SqlParameter("@ThanhPhan", user.ThanhPhan)
     };
     var command = context.Database.ExecuteSqlCommand("Sp_InsertDanhSach @HoTen,@CB,@CV,@DonVi,@ThanhPhan", sqlParams);
 }
        //
        // GET: /DanhSach/Edit/5

        public ActionResult Edit(int id = 0)
        {
            DanhSach danhsach = db.DanhSaches.Find(id);

            if (danhsach == null)
            {
                return(HttpNotFound());
            }
            ViewBag.IdLopMonHoc = new SelectList(db.LopMonHocs, "IdLopMonHoc", "MaLopMonHoc", danhsach.IdLopMonHoc);
            ViewBag.IdNguoiDung = new SelectList(db.NguoiDungs, "IdNguoiDung", "DuongDanAnh", danhsach.IdNguoiDung);
            return(View(danhsach));
        }
 public ActionResult Edit(DanhSach danhsach)
 {
     if (ModelState.IsValid)
     {
         db.Entry(danhsach).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.IdLopMonHoc = new SelectList(db.LopMonHocs, "IdLopMonHoc", "MaLopMonHoc", danhsach.IdLopMonHoc);
     ViewBag.IdNguoiDung = new SelectList(db.NguoiDungs, "IdNguoiDung", "DuongDanAnh", danhsach.IdNguoiDung);
     return(View(danhsach));
 }
        public ActionResult Create(DanhSach danhsach)
        {
            if (ModelState.IsValid)
            {
                db.DanhSaches.Add(danhsach);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            ViewBag.IdLopMonHoc = new SelectList(db.LopMonHocs, "IdLopMonHoc", "MaLopMonHoc", danhsach.IdLopMonHoc);
            ViewBag.IdNguoiDung = new SelectList(db.NguoiDungs, "IdNguoiDung", "DuongDanAnh", danhsach.IdNguoiDung);
            return(View(danhsach));
        }
        public ActionResult DanhSach(int?page, string linkth)
        {
            int          pageNumber = (page ?? 1);
            int          id         = _menuRepository.GetidDanhMucByLink(linkth);
            IList <Menu> sanPhams   =
                _menuRepository.getSanPhamThuocThuongHieu(linkth).OrderByDescending(o => o.sDate).OrderBy(o => o.SapXepSanPham).Where(o => o.ok && o.HasValue).ToList();
            IList <ProductFrontPageMapping.ProductBox> sanPhamsCuaDanhMuc = new List <ProductFrontPageMapping.ProductBox>();

            //lay duong dan cua san pham
            ViewData["duongdancha"] = _menuRepository.GetTenDanhMucCha(linkth);
            ViewData["duongdancon"] = _menuRepository.GetTenDanhMuc(linkth);
            IList <PromotionMapping.PromotionCheckProduct> promotions = _promotionRepository.GetActives();

            foreach (var sanpham in sanPhams)
            {
                ProductFrontPageMapping.ProductBox sp = new ProductFrontPageMapping.ProductBox()
                {
                    Img         = sanpham.Img,
                    NameProduct = sanpham.NameProduct,
                    PricePro    = sanpham.PricePro,
                    id_         = sanpham.id_,
                    Link        = sanpham.Link,
                    HasOnHand   = sanpham.HasOnHand,
                    NgayHetHang = sanpham.NgayHetHang
                };
                #region check promotion
                if (promotions.Any())
                {
                    foreach (var pr in promotions)
                    {
                        var promotionDetail = pr.PromotionDetails.FirstOrDefault(dt => dt.ProductId == sp.id_);
                        if (promotionDetail != null)
                        {
                            sp.HasPromotion   = true;
                            sp.PricePromotion = (int)promotionDetail.PriceDiscount;
                            sp.Discount       = (short)promotionDetail.Percent;
                            break;
                        }
                    }
                }

                #endregion
                sanPhamsCuaDanhMuc.Add(sp);
            }
            DanhSach model = new DanhSach()
            {
                DanhMuc             = _menuRepository.GetById(id),
                SanPhamTheoDanhMucs = sanPhamsCuaDanhMuc.ToPagedList(pageNumber, pageSize),
            };
            return(View(model));
        }
        // GET: DanhSaches/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            List <DanhSach> List = context.List_ID(id);
            DanhSach        user = List[0];

            if (user == null)
            {
                return(HttpNotFound());
            }
            return(View(user));
        }
        /// <summary>
        /// Danh sách tag cho sản phẩm
        /// </summary>
        /// <param name="tentag"></param>
        /// <returns></returns>
        public ActionResult DanhSach(string tentag)
        {
            ViewData["tentag"] = tentag.Replace("-", " ");
            IList <ProductFrontPageMapping.ProductBox>     products   = _menuRepository.LayTatCaSanphamTheoTag(tentag.Replace("-", " "));
            IList <PromotionMapping.PromotionCheckProduct> promotions = _promotionRepository.GetActives();

            PromotionMapping.GetPromotion(promotions, products);
            DanhSach model = new DanhSach()
            {
                SanPhamTheoTags = products,
                DanhSachTag     = _danhSachTagRepository.GetSeoTag(tentag.Replace("-", " "))
            };

            return(View("DanhSach", model));
        }
        public ActionResult DanhSach100BanChay(int?page)
        {
            int          pageNumber = (page ?? 1);
            IList <Menu> sanPhams   = _menuRepository.GetMany(o => o.Bestseller && o.ok && o.HasOnHand && o.HasValue)
                                      .ToList();
            IList <ProductFrontPageMapping.ProductBox> sanPhamsCuaDanhMuc = new List <ProductFrontPageMapping.ProductBox>();

            IList <PromotionMapping.PromotionCheckProduct> promotions = _promotionRepository.GetActives();

            foreach (var sanpham in sanPhams)
            {
                ProductFrontPageMapping.ProductBox sp = new ProductFrontPageMapping.ProductBox()
                {
                    Img         = sanpham.Img,
                    NameProduct = sanpham.NameProduct,
                    PricePro    = sanpham.PricePro,
                    id_         = sanpham.id_,
                    Link        = sanpham.Link,
                    HasOnHand   = sanpham.HasOnHand,
                    NgayHetHang = sanpham.NgayHetHang
                };
                #region check promotion
                if (promotions.Any())
                {
                    foreach (var pr in promotions)
                    {
                        var promotionDetail = pr.PromotionDetails.FirstOrDefault(dt => dt.ProductId == sp.id_);
                        if (promotionDetail != null)
                        {
                            sp.HasPromotion   = true;
                            sp.PricePromotion = (int)promotionDetail.PriceDiscount;
                            sp.Discount       = (short)promotionDetail.Percent;
                            break;
                        }
                    }
                }

                #endregion
                sanPhamsCuaDanhMuc.Add(sp);
            }
            DanhSach model = new DanhSach()
            {
                SanPhamTheoDanhMucs = sanPhamsCuaDanhMuc.ToPagedList(pageNumber, pageSize),
            };
            return(View("DanhSach100BanChay", model));
        }
        public JsonResult getTaiKhoanByIdCuocThi(string id)
        {
            List <DanhSach> lst_map                 = new List <DanhSach>();
            var             list_tai_khoan          = DanhSachThiRepository.Instance.GetDanhSachThiByIdCuocThi(id);
            var             lst_thuoc_tinh_cuoc_thi = list_tai_khoan.Where(x => x.thuoc_tinh != null).SelectMany(x => x.thuoc_tinh).ToList();

            //var lst_tt_by_gia_tri = ThuocTinhRepository.Instance.GetManyByGiaTri(lst_thuoc_tinh_cuoc_thi.Distinct(), LoaiThuocTinh.DANH_SACH_THI);
            foreach (var item in list_tai_khoan)
            {
                var      cuoc_thi  = CuocThiRepository.Instance.GetById(item?.id_cuoc_thi);
                var      tai_khoan = TaiKhoanRepository.Instance.GetTaiKhoanByUsername(item?.id_tai_khoan);
                DanhSach map       = new DanhSach(cuoc_thi, tai_khoan, item);
                lst_map.Add(map);
            }

            return(Json(new { data = lst_map }));
        }
Example #15
0
        static void Main(string[] args)
        {
            DanhSach sv = new DanhSach();

            sv.NhapDS();

            Console.WriteLine(" ma sinh vien duoc sap xep la:");
            sv.SapXep();



            Console.WriteLine("sinh vien co diem tren 8.5");
            sv.DSSV();
            sv.XuatDS();

            Console.Read();;
        }
        public ActionResult Index(int?page)
        {
            int          pageNumber   = (page ?? 1);
            IList <int>  productIds   = new List <int>();
            CookieHelper cookieHelper = new CookieHelper("product_watched");

            if (cookieHelper.GetCookie() != null)
            {
                string json = HttpUtility.UrlDecode(cookieHelper.GetCookie().Values["product_watched"]);
                if (!string.IsNullOrEmpty(json))
                {
                    productIds = json.Split(',').Select(o => Convert.ToInt32(o)).ToList();
                }
            }
            IList <ProductFrontPageMapping.ProductBox> products = new List <ProductFrontPageMapping.ProductBox>();

            if (productIds.Any())
            {
                var allMenus = _menuRepository.GetAllMenuCache();
                products = (from m in allMenus
                            where productIds.Contains(m.id_) && m.idControl == 11 && m.ok && m.HasValue
                            select new ProductFrontPageMapping.ProductBox
                {
                    id_ = m.id_,
                    Img = m.Img,
                    NameProduct =
                        m.NameProduct,
                    PricePro = m.PricePro,
                    Link = m.Link,
                    HasOnHand = m.HasOnHand,
                    NgayHetHang = m.NgayHetHang
                }).Take(9).ToList();
            }
            IList <PromotionMapping.PromotionCheckProduct> promotions = _promotionRepository.GetActives();

            PromotionMapping.GetPromotion(promotions, products);
            DanhSach model = new DanhSach()
            {
                SanPhamTheoDanhMucs = products.ToPagedList(pageNumber, pageSize),
            };

            return(View("DanhSach", model));
        }
Example #17
0
        static void Main(string[] args)
        {
            //SinhVien nv = new SinhVien();

            //nv.nhap();
            //nv.TinhDiemTB();
            //nv.InThongTin();
            //Console.ReadLine();

            DanhSach sv = new DanhSach();

            sv.nhapDS();
            Console.WriteLine(" ma sinh vien da duoc sap xep la:");
            sv.SapXep();
            Console.WriteLine("sinh vien co diem tren 8.0 la:");
            sv.DSSV();
            sv.XuatDS();


            Console.ReadLine();
        }
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            // declare model
            DanhSachMainModel model = new DanhSachMainModel();
            //
            List <DanhSach> List   = context.List_ID(id);
            DanhSach        user   = List[0];
            List <ViewKQ>   listKQ = context.List_Statistic_ID(id);

            //
            model.user   = user;
            model.listKQ = listKQ;
            if (user == null)
            {
                return(HttpNotFound());
            }
            return(View(model));
        }
Example #19
0
        //
        // GET: /YeuCauThamGia/Accept
        public ActionResult Accept(int id = 0)
        {
            LopMonHoc LopMonHocCurrent = (LopMonHoc)Session["LopMonHocCurrent"];

            DanhSachController DanhSachCon = new DanhSachController();

            YeuCauThamGia yeucauthamgia = db.YeuCauThamGias.Find(id);

            DanhSach newDanhSach = new DanhSach();

            // dummydata
            newDanhSach.IdLopMonHoc = LopMonHocCurrent.IdLopMonHoc;

            if (DanhSachCon.KiemTraTonTaiNguoiDung(yeucauthamgia.NguoiDung.UserName))
            {
                newDanhSach.IdNguoiDung = yeucauthamgia.IdNguoiDung;

                if (DanhSachCon.KiemTraLaSinhVien(yeucauthamgia.IdNguoiDung))
                {
                    if (false == DanhSachCon.KiemTraDanhSachTrung(newDanhSach.IdLopMonHoc, newDanhSach.IdNguoiDung))
                    {
                        db.DanhSaches.Add(newDanhSach);
                        db.SaveChanges();
                        TempData["Message"] = "Sinh viên '"
                                              + yeucauthamgia.NguoiDung.HoTen
                                              + "-"
                                              + yeucauthamgia.NguoiDung.UserName
                                              + "' đã được thêm vào lớp thành công";
                        // Nếu lớp này đã bắt đầu và có buổi điểm danh
                        var LopCurrent = db.LopMonHocs.Find(((LopMonHoc)Session["LopMonHocCurrent"]).IdLopMonHoc);
                        if (LopCurrent.BuoiHocs.Count() > 0)
                        {
                            // Thì với mỗi buổi học đã điểm danh,
                            // Gán cho sinh viên này tình trạng nghỉ có phép và ghi chú là nhập học muộn
                            foreach (var buoihoc in LopCurrent.BuoiHocs)
                            {
                                DiemDanh newDiemDanh = new DiemDanh();
                                newDiemDanh.IdBuoiHoc        = buoihoc.IdBuoiHoc;
                                newDiemDanh.IdNguoiDung      = newDanhSach.IdNguoiDung;
                                newDiemDanh.IdTinhTrangDiHoc = 3; //3 = nghỉ có phép
                                newDiemDanh.NhanXet          = "Đăng ký vào lớp muộn";
                                db.DiemDanhs.Add(newDiemDanh);
                                db.SaveChanges();
                            }
                        }
                    }
                    else
                    {
                        // sinh viên đã có trong lớp học
                        DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai();
                        BanGhiThatBai.MaNguoiDung = yeucauthamgia.NguoiDung.UserName;
                        TempData["Message"]       = "Sinh viên "
                                                    + yeucauthamgia.NguoiDung.HoTen
                                                    + "-"
                                                    + yeucauthamgia.NguoiDung.UserName
                                                    + " đã có trong lớp học";
                    }
                }
                else
                {
                    // nếu không phải là sinh viên
                    DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai();
                    BanGhiThatBai.MaNguoiDung = yeucauthamgia.NguoiDung.UserName;
                    TempData["Message"]       = "Sinh viên "
                                                + yeucauthamgia.NguoiDung.HoTen
                                                + "-"
                                                + yeucauthamgia.NguoiDung.UserName
                                                + " không phải là sinh viên";
                }
            }
            else
            {
                // nếu người dùng k tồn tại
                DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai();
                BanGhiThatBai.MaNguoiDung = yeucauthamgia.NguoiDung.UserName;
                TempData["Message"]       = "Sinh viên "
                                            + yeucauthamgia.NguoiDung.HoTen
                                            + "-"
                                            + yeucauthamgia.NguoiDung.UserName
                                            + " không tồn tại";
            }
            db.YeuCauThamGias.Remove(yeucauthamgia);
            db.SaveChanges();
            int YeuCauCount = (from y in db.YeuCauThamGias
                               where y.IdLopMonHoc == LopMonHocCurrent.IdLopMonHoc
                               select y).Count();

            Session["YeuCauCount"] = YeuCauCount;
            return(RedirectToAction("Index"));
        }
        public ActionResult ThemSinhVienThuCong(FormCollection formCollection)
        {
            List <DanhSach>            ListDanhSachThanhCong = new List <DanhSach>();
            List <DanhSachThemThatBai> ListDanhSachThatBai   = new List <DanhSachThemThatBai>();
            List <NguoiDung>           ListSinhVien          = (List <NguoiDung>)Session["ListSinhVien"];

            foreach (NguoiDung n in ListSinhVien)
            {
                DanhSach newDanhSach = new DanhSach();
                // dummydata
                newDanhSach.IdLopMonHoc = ((LopMonHoc)Session["LopMonHocCurrent"]).IdLopMonHoc;

                if (KiemTraTonTaiNguoiDung(n.UserName))
                {
                    newDanhSach.IdNguoiDung = n.IdNguoiDung;

                    if (KiemTraLaSinhVien(n.IdNguoiDung))
                    {
                        if (false == KiemTraDanhSachTrung(newDanhSach.IdLopMonHoc, newDanhSach.IdNguoiDung))
                        {
                            db.DanhSaches.Add(newDanhSach);
                            db.SaveChanges();
                            ListDanhSachThanhCong.Add(newDanhSach);
                            // Nếu lớp này đã bắt đầu và có buổi điểm danh
                            var LopCurrent = db.LopMonHocs.Find(((LopMonHoc)Session["LopMonHocCurrent"]).IdLopMonHoc);
                            if (LopCurrent.BuoiHocs.Count() > 0)
                            {
                                // Thì với mỗi buổi học đã điểm danh,
                                // Gán cho sinh viên này tình trạng nghỉ có phép và ghi chú là nhập học muộn
                                foreach (var buoihoc in LopCurrent.BuoiHocs)
                                {
                                    DiemDanh newDiemDanh = new DiemDanh();
                                    newDiemDanh.IdBuoiHoc        = buoihoc.IdBuoiHoc;
                                    newDiemDanh.IdNguoiDung      = n.IdNguoiDung;
                                    newDiemDanh.IdTinhTrangDiHoc = 3; //3 = nghỉ có phép
                                    newDiemDanh.NhanXet          = "Đăng ký vào lớp muộn";
                                    db.DiemDanhs.Add(newDiemDanh);
                                    db.SaveChanges();
                                }
                            }
                        }
                        else
                        {
                            // sinh viên đã có trong lớp học
                            DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai();
                            BanGhiThatBai.MaNguoiDung = n.UserName;
                            BanGhiThatBai.MoTa        = "đã có trong lớp học";
                            ListDanhSachThatBai.Add(BanGhiThatBai);
                        }
                    }
                    else
                    {
                        // nếu không phải là sinh viên
                        DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai();
                        BanGhiThatBai.MaNguoiDung = n.UserName;
                        BanGhiThatBai.MoTa        = "không phải là sinh viên";
                        ListDanhSachThatBai.Add(BanGhiThatBai);
                    }
                }
                else
                {
                    // nếu người dùng k tồn tại
                    DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai();
                    BanGhiThatBai.MaNguoiDung = n.UserName;
                    BanGhiThatBai.MoTa        = "không tồn tại";
                    ListDanhSachThatBai.Add(BanGhiThatBai);
                }
            }
            Session["ListDanhSachThanhCong"] = ListDanhSachThanhCong;
            Session["ListDanhSachThatBai"]   = ListDanhSachThatBai;
            Session["ListSinhVien"]          = null;
            return(RedirectToAction("KetQuaThemVaoDanhSach", new
            {
                ListDanhSachThanhCong = ListDanhSachThanhCong,
                ListDanhSachThatBai = ListDanhSachThatBai
            }));
        }
        public ActionResult BrowseDanhSach(FormCollection formCollection)
        {
            if (Request != null)
            {
                HttpPostedFileBase file = Request.Files["UploadedDanhSach"];
                if ((file != null) && (file.ContentLength > 0) && !string.IsNullOrEmpty(file.FileName))
                {
                    string fileName        = file.FileName;
                    string fileContentType = file.ContentType;
                    byte[] fileBytes       = new byte[file.ContentLength];
                    var    data            = file.InputStream.Read(fileBytes, 0, Convert.ToInt32(file.ContentLength));

                    // Khai báo biến
                    if (Session["LopMonHocCurrent"] != null)
                    {
                        int                        IdLopMonHocCurrent    = ((LopMonHoc)Session["LopMonHocCurrent"]).IdLopMonHoc;
                        List <DanhSach>            ListDanhSachThanhCong = new List <DanhSach>();
                        List <DanhSachThemThatBai> ListDanhSachThatBai   = new List <DanhSachThemThatBai>();
                        string                     MaSinhVienFromFile    = "";

                        using (var package = new ExcelPackage(file.InputStream))
                        {
                            var currentSheet = package.Workbook.Worksheets;
                            var workSheet    = currentSheet.First();
                            var noOfCol      = workSheet.Dimension.End.Column;
                            var noOfRow      = workSheet.Dimension.End.Row;

                            for (int rowIterator = 2; rowIterator <= noOfRow; rowIterator++)
                            {
                                DanhSach DanhSach = new DanhSach();
                                DanhSach.IdLopMonHoc = IdLopMonHocCurrent;
                                MaSinhVienFromFile   = workSheet.Cells[rowIterator, 2].Value.ToString();

                                if (KiemTraTonTaiNguoiDung(MaSinhVienFromFile))
                                {
                                    DanhSach.IdNguoiDung = (from t in db.NguoiDungs
                                                            where t.UserName == MaSinhVienFromFile
                                                            select t.IdNguoiDung).ToList().First();

                                    if (KiemTraLaSinhVien(DanhSach.IdNguoiDung))
                                    {
                                        if (false == KiemTraDanhSachTrung(DanhSach.IdLopMonHoc, DanhSach.IdNguoiDung))
                                        {
                                            db.DanhSaches.Add(DanhSach);
                                            db.SaveChanges();
                                            ListDanhSachThanhCong.Add(DanhSach);
                                            // Nếu lớp này đã bắt đầu và có buổi điểm danh
                                            var LopCurrent = db.LopMonHocs.Find(((LopMonHoc)Session["LopMonHocCurrent"]).IdLopMonHoc);
                                            if (LopCurrent.BuoiHocs.Count() > 0)
                                            {
                                                // Thì với mỗi buổi học đã điểm danh,
                                                // Gán cho sinh viên này tình trạng nghỉ có phép và ghi chú là nhập học muộn
                                                foreach (var buoihoc in LopCurrent.BuoiHocs)
                                                {
                                                    DiemDanh newDiemDanh = new DiemDanh();
                                                    newDiemDanh.IdBuoiHoc        = buoihoc.IdBuoiHoc;
                                                    newDiemDanh.IdNguoiDung      = DanhSach.IdNguoiDung;
                                                    newDiemDanh.IdTinhTrangDiHoc = 3; //3 = nghỉ có phép
                                                    newDiemDanh.NhanXet          = "Đăng ký vào lớp muộn";
                                                    db.DiemDanhs.Add(newDiemDanh);
                                                    db.SaveChanges();
                                                }
                                            }
                                        }
                                        else
                                        {
                                            // sinh viên đã có trong lớp học
                                            DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai();
                                            BanGhiThatBai.MaNguoiDung = workSheet.Cells[rowIterator, 2].Value.ToString();
                                            BanGhiThatBai.MoTa        = "đã có trong lớp học";
                                            ListDanhSachThatBai.Add(BanGhiThatBai);
                                        }
                                    }
                                    else
                                    {
                                        // nếu không phải là sinh viên
                                        DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai();
                                        BanGhiThatBai.MaNguoiDung = workSheet.Cells[rowIterator, 2].Value.ToString();
                                        BanGhiThatBai.MoTa        = "không phải là sinh viên";
                                        ListDanhSachThatBai.Add(BanGhiThatBai);
                                    }
                                }
                                else
                                {
                                    // nếu người dùng k tồn tại
                                    DanhSachThemThatBai BanGhiThatBai = new DanhSachThemThatBai();
                                    BanGhiThatBai.MaNguoiDung = workSheet.Cells[rowIterator, 2].Value.ToString();
                                    BanGhiThatBai.MoTa        = "không tồn tại";
                                    ListDanhSachThatBai.Add(BanGhiThatBai);
                                }
                            }
                        }

                        Session["ListDanhSachThanhCong"] = ListDanhSachThanhCong;
                        Session["ListDanhSachThatBai"]   = ListDanhSachThatBai;

                        return(RedirectToAction("KetQuaThemVaoDanhSach", new
                        {
                            ListDanhSachThanhCong = ListDanhSachThanhCong,
                            ListDanhSachThatBai = ListDanhSachThatBai
                        }));
                    }
                    else
                    {
                        // Chưa chọn lớp môn học
                    }
                }
            }
            return(View("BrowseDanhSach"));
        }
Example #22
0
        static void Main(string[] args)
        {
            int     Chon;
            ThuVien thuvien = new ThuVien();

            thuvien.NhapThuVien();
            thuvien.NhapHDMuon();

            int Temp;     // bien dung cho viec quay lai menu

            do
            {
                Console.WriteLine("Cap nhat lai tinh hinh thu vien ");
                Console.Write("\n");
                thuvien.CapNhatLai();
                Console.Write("\n");
                //Console.WriteLine("Chuong trinh quan ly thu vien ");
                Console.WriteLine("Cac tuy chon: ");
                Console.WriteLine(" 1.Dang nhap tai khoan doc gia va su dung ");
                Console.WriteLine(" 2.Dang ky tai khoan doc gia moi ");
                Console.WriteLine(" 3.Tim kiem thong tin 1 dau sach bat ky ");
                Console.WriteLine(" 4.Cac tinh nang thong ke va sap xep thu vien ");
                Console.WriteLine(" 5.Xoa hoac them moi sach vao thu vien ");
                Console.WriteLine(" 6.Danh sach luong nhan vien thu vien ");
                Console.Write("Xin hay nhap vao lua chon: ");
                Chon = Convert.ToInt32(Console.ReadLine());
                switch (Chon)
                {
                case 1:
                {
                    int    ChonChon;
                    String Ten_Temp;
                    Console.WriteLine(" Nhap ten hoac ma doc gia: ");
                    Ten_Temp = Console.ReadLine();
                    KiemTra kt           = new KiemTra(thuvien.KiemTraViTriNguoiDocTrongListHD);
                    int     ViTriDG_Temp = kt(Ten_Temp);
                    if (ViTriDG_Temp != -1)
                    {
                        Console.WriteLine("Cac tuy chon: ");
                        Console.WriteLine(" 1.Muon sach ");
                        Console.WriteLine(" 2.Tra sach ");
                        Console.WriteLine(" 3.KT thong tin ");
                        Console.WriteLine(" 4.Nap them tien vao tai khoan ");
                        Console.WriteLine(" 5.Gia han the thu vien ");
                        Console.Write("Chon: ");
                        ChonChon = Convert.ToInt32(Console.ReadLine());
                        switch (ChonChon)
                        {
                        case 1:
                        {
                            if ((thuvien.DSHDMuon[ViTriDG_Temp].SoLuongSachMuon > 10))
                            {
                                Console.Write(" Tra sach truoc khi tiep tuc muon, ban da muon du 10 cuon sach ");
                                int ChonChonChon;
                                Console.WriteLine(" Ban co muon tra sach ngay:(0 la khong, 1 la co) ");
                                ChonChonChon = Convert.ToInt32(Console.ReadLine());
                                switch (ChonChonChon)
                                {
                                case 0:
                                {
                                    break;
                                }

                                case 1:
                                {
                                    Console.WriteLine("Nhap tua sach hoac ma dau sach: ");
                                    string Tua = Console.ReadLine();
                                    Console.WriteLine("Nhap ma quyen sach: ");
                                    int     Quyen = Convert.ToInt32(Console.ReadLine());
                                    TraSach ts    = new TraSach(thuvien.TraSach);
                                    ts(ViTriDG_Temp, Tua, Quyen);
                                    break;
                                }

                                default:
                                {
                                    Console.WriteLine(" Nhap sai ");
                                    break;
                                }
                                }
                                break;
                            }
                            else
                            {
                                if ((thuvien.DSHDMuon[ViTriDG_Temp].NguoiMuon.NgayHetHanThe < thuvien.Today))
                                {
                                    Console.Write(" Gia han the truoc khi duoc quyen tiep tuc muon ");
                                    // Gia han the
                                    Console.WriteLine("Chon gia han ngay (0 la khong dong y, 1 la dong y) : ");
                                    int ChonChonCHon = Convert.ToInt32(Console.ReadLine());
                                    switch (ChonChonCHon)
                                    {
                                    case 1:
                                    {
                                        XacDinhNgay xd         = new XacDinhNgay(thuvien.XacDinhToday);
                                        ThoiGian    Today_Temp = xd();
                                        thuvien.DSHDMuon[ViTriDG_Temp].NguoiMuon.GiaHanThem(Today_Temp);
                                        break;
                                    }

                                    case 0:
                                    {
                                        break;
                                    }

                                    default:
                                    {
                                        Console.WriteLine("Nhap sai");
                                        break;
                                    }
                                    }
                                }
                                else
                                {
                                    if ((thuvien.DSHDMuon[ViTriDG_Temp].NguoiMuon.TaiKhoan < 10000))
                                    {
                                        Console.Write(" Nap them vao tai khoan truoc khi duoc quyen tiep tuc muon ");
                                        //Nap them tien
                                        Console.WriteLine("Chon nap vao tai khoan ngay (0 la khong dong y, 1 la dong y) : ");
                                        int ChonChonCHon = Convert.ToInt32(Console.ReadLine());
                                        switch (ChonChonCHon)
                                        {
                                        case 1:
                                        {
                                            Console.WriteLine(" Nhap so tien can nap: ");
                                            double Tien = Convert.ToDouble(Console.ReadLine());
                                            Tien   nt   = new Tien(thuvien.DSHDMuon[ViTriDG_Temp].NguoiMuon.Tien);
                                            nt(Tien);
                                            break;
                                        }

                                        case 0:
                                        {
                                            break;
                                        }

                                        default:
                                        {
                                            Console.WriteLine("Nhap sai");
                                            break;
                                        }
                                        }
                                    }
                                }
                            }
                            CongViec ms = new CongViec(thuvien.MuonSach);
                            ms(ViTriDG_Temp);
                            break;
                        }

                        case 2:
                        {
                            Console.WriteLine("Nhap tua sach hoac ma dau sach: ");
                            string Tua = Console.ReadLine();
                            Console.WriteLine("Nhap ma quyen sach: ");
                            int     Quyen = Convert.ToInt32(Console.ReadLine());
                            TraSach ts    = new TraSach(thuvien.TraSach);
                            ts(ViTriDG_Temp, Tua, Quyen);
                            break;
                        }

                        case 3:
                        {
                            CongViec xd = new CongViec(thuvien.ThongTinNguoiDocTrongHD);
                            Console.Write("\n\n");
                            xd(ViTriDG_Temp);
                            break;
                        }

                        case 4:
                        {
                            Console.WriteLine(" Nhap so tien can nap: ");
                            double Tien = Convert.ToDouble(Console.ReadLine());
                            Tien   nt   = new Tien(thuvien.DSHDMuon[ViTriDG_Temp].NguoiMuon.Tien);
                            nt(Tien);
                            break;
                        }

                        case 5:
                        {
                            XacDinhNgay xd         = new XacDinhNgay(thuvien.XacDinhToday);
                            ThoiGian    Today_Temp = xd();
                            thuvien.DSHDMuon[ViTriDG_Temp].NguoiMuon.GiaHanThem(Today_Temp);
                            break;
                        }

                        default:
                        {
                            Console.WriteLine("Nhap sai ");
                            break;
                        }
                        }
                    }
                    else
                    {
                        int ChonChonChon;
                        Console.WriteLine(" Chua ton tai tai khoan ");
                        Console.WriteLine(" 1.Dang ky tai khoan ");
                        Console.WriteLine(" 2.Thoat ");
                        Console.Write("Xin moi nhap vao lua chon: ");
                        ChonChonChon = Convert.ToInt32(Console.ReadLine());
                        switch (ChonChonChon)
                        {
                        case 1:
                        {
                            XacDinhNgay xd         = new XacDinhNgay(thuvien.XacDinhToday);
                            ThoiGian    Today_Temp = xd();
                            Ngay        dk         = new Ngay(thuvien.DangKyTaiKhoanMoi);
                            dk(Today_Temp);
                            break;
                        }

                        case 2:
                        {
                            break;
                        }

                        default:
                        {
                            Console.WriteLine("Nhap sai ");
                            break;
                        }
                        }
                    }
                    break;
                }

                case 2:
                {
                    XacDinhNgay xd         = new XacDinhNgay(thuvien.XacDinhToday);
                    ThoiGian    Today_Temp = xd();
                    Ngay        dk         = new Ngay(thuvien.DangKyTaiKhoanMoi);
                    dk(Today_Temp);
                    break;
                }

                case 3:
                {
                    Console.Write("Hay nhap vao ma sach hoac tua sach: ");
                    string Ma_Temp = Console.ReadLine();
                    Them   t       = new Them(thuvien.TimKiemThongTinDauSach);
                    t(Ma_Temp);
                    break;
                }

                case 4:
                {
                    int ChonChon;
                    Console.WriteLine("Cac lua chon: ");
                    Console.WriteLine(" 1.Danh sach sach khoa hoc dang trong tinh trang bi muon ");
                    Console.WriteLine(" 2.Danh sach khoa hoc dang nam trong thu vien ");
                    Console.WriteLine(" 3.Danh sach giao trinh dang trong tinh trang bi muon ");
                    Console.WriteLine(" 4.Danh sach giao trinh dang nam trong thu vien ");
                    Console.WriteLine(" 5.Danh sach doc gia ");
                    Console.WriteLine(" 6.Danh sach sach co gia tri lon hon 1 so tien cu the ");
                    Console.WriteLine(" 7.Danh sach nhung cuon sach sap toi han tra");
                    Console.WriteLine(" 8.Danh sach nhung doc gia sap het han the (duoi 30 ngay ke tu hom nay la het han) ");
                    Console.WriteLine(" 9.Danh sach nhung doc gia muon nhieu sach nhat ");
                    Console.WriteLine(" 10.Thong ke so luong sach duoc muon va phan tram so voi so sach ban dau ");
                    Console.WriteLine(" 11.Sap xep danh sach doc gia theo thu tu tang dan ngay het han the ");
                    Console.WriteLine(" 12.Xuat ra man hinh danh sach sach giao trinh theo thu tu gia tang dan ");
                    Console.WriteLine(" 13.Xuat ra man hinh danh sach sap xep doc gia theo thu tu tang dan tong so sach dang muon  ");
                    Console.WriteLine(" 14.Xuat ra man hinh danh sach sach khoa hoc theo thu tu gia giam dan ");
                    Console.WriteLine(" 15.Xuat ra man hinh danh sach tat ca cac ban hop dong ");
                    Console.Write(" Chon:  ");
                    ChonChon = Convert.ToInt32(Console.ReadLine());
                    switch (ChonChon)
                    {
                    case 1:
                    {
                        Console.WriteLine("/n Danh sach sach khoa hoc dang trong tinh trang bi muon:");
                        DanhSach ds = new DanhSach(thuvien.XuatRaTatCaSachKHDaDuocMuon);
                        ds();
                        break;
                    }

                    case 2:
                    {
                        Console.WriteLine("/n Danh sach sach khoa hoc dang nam trong thu vien:");
                        DanhSach ds = new DanhSach(thuvien.XuatRaTatCaSachKHNamTrongThuVien);
                        ds();
                        break;
                    }

                    case 3:
                    {
                        Console.WriteLine("/n Danh sach sach giao trinh dang trong tinh trang bi muon:");
                        DanhSach ds = new DanhSach(thuvien.XuatRaTatCaSachGTDaDuocMuon);
                        ds();
                        break;
                    }

                    case 4:
                    {
                        Console.WriteLine("/n Danh sach sach giao trinh dang nam trong thu vien:");
                        DanhSach ds = new DanhSach(thuvien.XuatRaTatCaSachGTNamTrongThuVien);
                        ds();
                        break;
                    }

                    case 5:
                    {
                        Console.WriteLine("/n Danh sach sach doc gia trong thu vien:");
                        DanhSach ds = new DanhSach(thuvien.XuatRaDanhSachNguoiDoc);
                        ds();
                        break;
                    }

                    case 6:
                    {
                        double tien;
                        Console.Write("Hay nhap vao so tien: ");
                        tien = Convert.ToDouble(Console.ReadLine());
                        Tien t = new Tien(thuvien.SachLonHonTienCuThe);
                        t(tien);
                        break;
                    }

                    case 7:
                    {
                        DanhSach ds = new DanhSach(thuvien.SachLonSapToiHanTra);
                        ds();
                        break;
                    }

                    case 8:
                    {
                        DanhSach ds = new DanhSach(thuvien.NguoiDocSapHetHanThe);
                        ds();
                        break;
                    }

                    case 9:
                    {
                        DanhSach ds = new DanhSach(thuvien.NguoiDocMuonNhieuNhat);
                        ds();
                        break;
                    }

                    case 10:
                    {
                        DanhSach ds = new DanhSach(thuvien.ThongKeSoSach);
                        ds();
                        break;
                    }

                    case 11:
                    {
                        thuvien.SortIncreasingTheThoiGianOfCustomer(0, thuvien.DSNguoiDoc.Count - 1);
                        DanhSach ds = new DanhSach(thuvien.XuatRaDanhSachNguoiDoc);
                        ds();
                        break;
                    }

                    case 12:
                    {
                        DanhSach ds = (thuvien.SapXepDanhSachSachGTTheoGiaTangDan);
                        ds();
                        break;
                    }

                    case 13:
                    {
                        CongViec cv = new CongViec(thuvien.SapXepNguoiDocTheoSoSachMuonTangDan);
                        cv(thuvien.DSHDMuon.Count);
                        break;
                    }

                    case 14:
                    {
                        DanhSach ds = new DanhSach(thuvien.SapXepDanhSachSachKHTheoGiaGiamDan);
                        ds();
                        break;
                    }

                    case 15:
                    {
                        DanhSach ds = new DanhSach(thuvien.TatCaHopDong);
                        ds();
                        break;
                    }
                    }
                    break;
                }

                case 5:
                {
                    Console.WriteLine("Cac lua chon:");
                    Console.WriteLine(" 1.Them sach ");
                    Console.WriteLine(" 2.Xoa bot sach ");
                    Console.Write("Nhap vao lua chon: ");
                    int ChonChon = Convert.ToInt32(Console.ReadLine());
                    switch (ChonChon)
                    {
                    case 1:
                    {
                        Console.WriteLine(" Lua chon them sach GT hay sach KH (0 la khoa hoc, 1 la giao trinh): ");
                        Console.Write(" Chon:");
                        int ChonChonChon = Convert.ToInt32(Console.ReadLine());
                        switch (ChonChonChon)
                        {
                        case 0:
                        {
                            Console.WriteLine("Hay nhap vao ma sach hoac tua sach: ");
                            string Ma_Temp = Console.ReadLine();
                            Them   th      = new Them(thuvien.ThemSachKH);
                            th(Ma_Temp);
                            break;
                        }

                        case 1:
                        {
                            Console.WriteLine("Hay nhap vao ma sach hoac tua sach: ");
                            string Ma_Temp = Console.ReadLine();
                            Them   th      = new Them(thuvien.ThemSachGT);
                            th(Ma_Temp);
                            break;
                        }

                        default:
                        {
                            Console.WriteLine("Nhap sai ");
                            break;
                        }
                        }
                        break;
                    }

                    case 2:
                    {
                        Console.WriteLine(" Lua chon xoa sach GT hay sach KH (0 la khoa hoc, 1 la giao trinh): ");
                        Console.Write(" Chon:");
                        int ChonChonChon = Convert.ToInt32(Console.ReadLine());
                        switch (ChonChonChon)
                        {
                        case 0:
                        {
                            Console.WriteLine("Hay nhap vao ma sach hoac tua sach: ");
                            string Ma_Temp = Console.ReadLine();
                            Them   th      = new Them(thuvien.XoaSachKH);
                            th(Ma_Temp);
                            break;
                        }

                        case 1:
                        {
                            Console.WriteLine("Hay nhap vao ma sach hoac tua sach: ");
                            string Ma_Temp = Console.ReadLine();
                            Them   th      = new Them(thuvien.XoaSachGT);
                            th(Ma_Temp);
                            break;
                        }

                        default:
                        {
                            Console.WriteLine("Nhap sai ");
                            break;
                        }
                        }
                        break;
                    }

                    default:
                    {
                        Console.WriteLine("Nhap sai ");
                        break;
                    }
                    }
                    break;
                }

                case 6:
                {
                    DanhSach ds = new DanhSach(thuvien.XuatTatCaThuThu);
                    ds();
                    Console.WriteLine(" Nhap them nhan vien(0 la thoat, 1 la nhap): ");
                    int ChonChonChon = Convert.ToInt32(Console.ReadLine());
                    switch (ChonChonChon)
                    {
                    case 0:
                    {
                        break;
                    }

                    case 1:
                    {
                        thuvien.DangKyThuThuMoi();
                        break;
                    }

                    default:
                    {
                        break;
                    }
                    }
                    break;
                }

                default:
                {
                    Console.WriteLine("Nhap sai ");
                    break;
                }
                }
                Console.Write("\n Nhan phim so 0 + Enter de ket thuc        or        Nhan phim so khac 0 + Enter de tro ve Menu:       ");
                Temp = Convert.ToInt32(Console.ReadLine());
                Console.Write("\n\n");
            } while (Temp != 0);
        }