コード例 #1
0
        public RedirectToRouteResult ThemVaoGio(string SanPhamID)
        {
            if (Session["giohang"] == null)                    // Nếu giỏ hàng chưa được khởi tạo
            {
                Session["giohang"] = new List <GioHangItem>(); // Khởi tạo Session["giohang"] là 1 List<CartItem>
            }

            List <GioHangItem> giohang = Session["giohang"] as List <GioHangItem>;  // Gán qua biến giohang dễ code

            // Kiểm tra xem sản phẩm khách đang chọn đã có trong giỏ hàng chưa


            if (giohang.FirstOrDefault(m => m.SanPhamID == SanPhamID) == null) // ko co sp nay trong gio hang
            {
                var     db = new PetproShopConnectionDB();
                SanPham sp = db.Query <SanPham>("select * From SanPham where MaSP='" + SanPhamID + "'").FirstOrDefault();


                //SanPham sp = db.SanPhams.Find(SanPhamID);  // tim sp theo sanPhamID

                GioHangItem newItem = new GioHangItem()
                {
                    SanPhamID  = SanPhamID,
                    TenSanPham = sp.TenSP,
                    SoLuong    = 1,
                    Hinh       = sp.HinhChinh,
                    DonGia     = sp.Gia.Value
                };                    // Tạo ra 1 CartItem mới

                giohang.Add(newItem); // Thêm CartItem vào giỏ
            }
            else
            {
                // Nếu sản phẩm khách chọn đã có trong giỏ hàng thì không thêm vào giỏ nữa mà tăng số lượng lên.
                GioHangItem cardItem = giohang.FirstOrDefault(m => m.SanPhamID == SanPhamID);
                cardItem.SoLuong++;
            }

            // Action này sẽ chuyển hướng về trang chi tiết sp khi khách hàng đặt vào giỏ thành công. Bạn có thể chuyển về chính trang khách hàng vừa đứng bằng lệnh return Redirect(Request.UrlReferrer.ToString()); nếu muốn.
            //  return RedirectToAction("ChiTiet", "SanPham", new { id = SanPhamID });
            return(RedirectToAction("Index", "GioHang"));
        }
コード例 #2
0
        public static IEnumerable <NhaSanXuat> DanhSachAdmin()
        {
            var db = new PetproShopConnectionDB();

            return(db.Query <NhaSanXuat>("select * From NhaSanXuat "));
        }
コード例 #3
0
        //--------------Admin
        public static void ThemNSX(NhaSanXuat nsx)
        {
            var db = new PetproShopConnectionDB();

            db.Insert(nsx);
        }
コード例 #4
0
        public static IEnumerable <SanPham> ChiTiet(String id)
        {
            var db = new PetproShopConnectionDB();

            return(db.Query <SanPham>("select * From SanPham where MaNSX='" + id + "'"));
        }
コード例 #5
0
        public static IEnumerable <SanPham> Top5Hot()
        {
            var db = new PetproShopConnectionDB();

            return(db.Query <SanPham>("select Top 5* From SanPham where ChucNang =N'HOT'"));
        }
コード例 #6
0
        public static void UpdateHD(String id, ThanhToan tt)
        {
            var db = new PetproShopConnectionDB();

            db.Update(tt, id);
        }
コード例 #7
0
        public static IEnumerable <ThanhToan> DanhSachKH()
        {
            var db = new PetproShopConnectionDB();

            return(db.Query <ThanhToan>("select * From ThanhToan "));
        }
コード例 #8
0
        //-----------Khách Hàng-------
        public static IEnumerable <LoaiSanPham> DanhSach()
        {
            var db = new PetproShopConnectionDB();

            return(db.Query <LoaiSanPham>("select * From LoaiSanPham where TinhTrang=0"));
        }
コード例 #9
0
        //-----------Admin------------
        public static void ThemLSP(LoaiSanPham lsp)
        {
            var db = new PetproShopConnectionDB();

            db.Insert(lsp);
        }
コード例 #10
0
        public static void ThemSP(SanPham sp)
        {
            var db = new PetproShopConnectionDB();

            db.Insert(sp);
        }
コード例 #11
0
        public static void UpdateSP(string id, SanPham sp)
        {
            var db = new PetproShopConnectionDB();

            db.Update(sp, id);
        }
コード例 #12
0
        public static IEnumerable <SanPham> DanhSachSP()
        {
            var db = new PetproShopConnectionDB();

            return(db.Query <SanPham>("select * From SanPham"));
        }
コード例 #13
0
        public static IEnumerable <SanPham> KhuyenMaiHome()
        {
            var db = new PetproShopConnectionDB();

            return(db.Query <SanPham>("select Top 9* From SanPham where ChucNang =N'KM'"));
        }
コード例 #14
0
        public static IEnumerable <SanPham> SucKhoeHome()
        {
            var db = new PetproShopConnectionDB();

            return(db.Query <SanPham>("select Top 5* From SanPham where GhiChu =N'SK'"));
        }
コード例 #15
0
        public static NhaSanXuat ChiTietAdmin(String id)
        {
            var db = new PetproShopConnectionDB();

            return(db.SingleOrDefault <NhaSanXuat>("select * From NhaSanXuat where MaNSX='" + id + "'"));
        }
コード例 #16
0
        public static IEnumerable <LoaiSanPham> DanhSachLSPAdmin()
        {
            var db = new PetproShopConnectionDB();

            return(db.Query <LoaiSanPham>("select * From LoaiSanPham"));
        }
コード例 #17
0
        public static void UpdateNSX(String id, NhaSanXuat nsx)
        {
            var db = new PetproShopConnectionDB();

            db.Update(nsx, id);
        }
コード例 #18
0
        public static LoaiSanPham ChiTietLSPAdmin(String id)
        {
            var db = new PetproShopConnectionDB();

            return(db.SingleOrDefault <LoaiSanPham>("select * From LoaiSanPham where MaLoaiSP='" + id + "'"));
        }
コード例 #19
0
        //public static IEnumerable<SanPham> ChiTiet(String id)
        //{
        //    var db = new PetproShopConnectionDB();
        //    return db.Query<SanPham>("select * From SanPham where MaNSX='" + id + "'");
        //}
        //--------------Admin
        public static void ThemHD(ThanhToan tt)
        {
            var db = new PetproShopConnectionDB();

            db.Insert(tt);
        }
コード例 #20
0
        public static void UpdateLSP(String id, LoaiSanPham lsp)
        {
            var db = new PetproShopConnectionDB();

            db.Update(lsp, id);
        }
コード例 #21
0
        public static ThanhToan ChiTietKH(String id)
        {
            var db = new PetproShopConnectionDB();

            return(db.SingleOrDefault <ThanhToan>("select * From ThanhToan where MaTT='" + id + "'"));
        }
コード例 #22
0
        //--------------Khách Hàng
        public static IEnumerable <NhaSanXuat> DanhSach()
        {
            var db = new PetproShopConnectionDB();

            return(db.Query <NhaSanXuat>("select * From NhaSanXuat where TinhTrang=0"));
        }
コード例 #23
0
ファイル: PTTTBUS.cs プロジェクト: war-man/do-an-chuyen-nganh
        //--------------Khách Hàng
        public static IEnumerable <PhuongThucThanhToan> DanhSachPT()
        {
            var db = new PetproShopConnectionDB();

            return(db.Query <PhuongThucThanhToan>("select * From PhuongThucThanhToan where TinhTrang=0"));
        }
コード例 #24
0
        public static SanPham ChiTiet(String a)
        {
            var db = new PetproShopConnectionDB();

            return(db.SingleOrDefault <SanPham>("select * From SanPham where MaSP = @0", a));
        }