Ejemplo n.º 1
0
        // GET: Product
        public ActionResult Index()
        {
            var lsp = UtilsDatabase.getDaTaBase().LoaiSanPhams.ToList();

            ViewBag.lsp = lsp;
            return(View());
        }
Ejemplo n.º 2
0
        public ActionResult CreateOrEditCagetory(int id = -1)
        {
            var lsp = UtilsDatabase.getDaTaBase().LoaiSanPhams.Where(l => l.MaLoai == id).FirstOrDefault();

            ViewBag.lsp = lsp;
            return(View());
        }
Ejemplo n.º 3
0
        public ActionResult CreateOrEditAccount(int id = -1)
        {
            var acc = UtilsDatabase.getDaTaBase().Users.Where(l => l.Id == id).FirstOrDefault();

            ViewBag.acc = acc;
            return(View());
        }
Ejemplo n.º 4
0
        public ActionResult TraCuuDonHang(string keyword = "")
        {
            int madh = 9999;

            try {
                madh = int.Parse(keyword);
            }
            catch {
                madh = 9999;
            }
            var dsdh = from dh in UtilsDatabase.getDaTaBase().DonHangs
                       join ctdh in UtilsDatabase.getDaTaBase().ChiTietDonHangs
                       on dh.MaDonHang equals ctdh.MaDonHang
                       join u in UtilsDatabase.getDaTaBase().Users
                       on dh.IdUser equals u.Id
                       where u.HoTen.Contains(keyword.Trim()) || dh.MaDonHang == madh || dh.GhiChu.Contains(keyword.Trim())
                       orderby dh.MaDonHang descending
                       select new DonHangDTO
            {
                MaDonHang    = dh.MaDonHang,
                TenKhachHang = u.HoTen,
                TTDonHang    = GetInforDonHang(dh.JsonSanPham),
                TongTien     = dh.TongTien,
                NgayTao      = (DateTime)dh.NgayTao,
                GhiChu       = dh.GhiChu,
                IsAccept     = dh.IsAccept,
                NgayHenTra   = dh.NgayHenTra
            };
            var dsDonHang = dsdh.ToList();

            ViewBag.dsDonHang = dsDonHang;
            return(View());
        }
        private void caricaDatiDiTest()
        {
            UtilsDatabase u = new UtilsDatabase(connStr);

            //u.CreateTableCars();
            //UtilsDatabase.CreateTable("Auto");
            //UtilsDatabase.CreateTable("Moto");
            //UtilsDatabase.CreateTableCars("Moto");
            //UtilsDatabase.CreateTableCars("Auto");
            if (UtilsDatabase.first)
            {
                UtilsDatabase.CreateTableCars("cars");
                UtilsDatabase.AddNewCar("Moto", "Honda", "Dominator", "Nero", 1000, 120, DateTime.Now, false, false, 0, 12000, "Quintino", 0);
                UtilsDatabase.AddNewCar("Auto", "Jeep", "Compass", "Blu", 1000, 32, DateTime.Now, false, false, 0, 32500, "/", 8);
            }
            Moto m = new Moto();

            bindingListVeicoli.Add(m);
            m = new Moto("Honda", "Dominator", "Nero", 1000, 120, DateTime.Now, false, false, 0, "Quintino");
            bindingListVeicoli.Add(m);
            //UtilsDatabase.AddNewItem("Moto", "Honda", "Dominator", "Nero", 1000, 120, DateTime.Now, false, false, 0, 12000, 0, "Quintino");
            Auto a = new Auto("Jeep", "Compass", "Blu", 1000, 32, DateTime.Now, false, false, 0, 8);

            bindingListVeicoli.Add(a);
            //UtilsDatabase.AddNewItem("Auto", "Jeep", "Compass", "Blu", 1000, 32, DateTime.Now, false, false, 0, 32500, /*"",*/ 8, "");
        }
Ejemplo n.º 6
0
        public ActionResult QuanLyLoaiSanPham()
        {
            var listLoaiSP = UtilsDatabase.getDaTaBase().LoaiSanPhams.Where(l => l.IsActive == 1).OrderByDescending(p => p.MaLoai).ToList();

            ViewBag.listLoaiSP = listLoaiSP;
            return(View());
        }
Ejemplo n.º 7
0
        public ActionResult CreateOrEditAccount(User user)
        {
            if (user.Id > 0)
            {
                // update
                var acccansua = UtilsDatabase.getDaTaBase().Users.Where(p => p.Id == user.Id).First();
                acccansua.IsActive    = 1;
                acccansua.HoTen       = user.HoTen;
                acccansua.DiaChi      = user.DiaChi;
                acccansua.SoDienThoai = user.SoDienThoai;
                acccansua.TenDangNhap = user.TenDangNhap;
                acccansua.MatKhau     = user.MatKhau;
                UpdateModel(acccansua);
                UtilsDatabase.getDaTaBase().SubmitChanges();
            }
            else
            {
                // add
                var acccansua = new User();
                acccansua.IsActive    = 1;
                acccansua.HoTen       = user.HoTen;
                acccansua.DiaChi      = user.DiaChi;
                acccansua.SoDienThoai = user.SoDienThoai;
                acccansua.TenDangNhap = user.TenDangNhap;
                acccansua.MatKhau     = user.MatKhau;
                acccansua.Quyen       = 2;
                acccansua.IsActive    = 1;

                UtilsDatabase.getDaTaBase().Users.InsertOnSubmit(acccansua);
                UtilsDatabase.getDaTaBase().SubmitChanges();
            }
            return(RedirectToAction("QuanLyTaikhoan", "Admin"));
        }
Ejemplo n.º 8
0
        public ActionResult QuanLyTaiKhoan()
        {
            var listACC = UtilsDatabase.getDaTaBase().Users.Where(l => l.IsActive == 1).OrderByDescending(p => p.Id).ToList();

            ViewBag.listACC = listACC;
            return(View());
        }
Ejemplo n.º 9
0
        public ActionResult Login(string username = "", string pass = "")
        {
            if (username.Equals("admin") && pass.Equals("123"))
            {
                return(RedirectToAction("Index", "Admin"));
            }
            var user = UtilsDatabase.getDaTaBase().Users.Where(t => t.TenDangNhap == username && t.MatKhau == pass).FirstOrDefault();

            if (user != null)
            {
                HttpCookie myCookie = new HttpCookie("AccountCookie");
                DateTime   now      = DateTime.Now;

                var acc = new Users();
                acc.Id          = user.Id;
                acc.HoTen       = user.HoTen;
                acc.DiaChi      = user.DiaChi;
                acc.SoDienThoai = user.SoDienThoai;
                acc.TenDangNhap = user.TenDangNhap;
                acc.MatKhau     = user.MatKhau;
                acc.Quyen       = user.Quyen;
                acc.IsActive    = user.IsActive;
                var jsonUser = JsonConvert.SerializeObject(acc);
                // Set the cookie value.
                Response.Cookies["acc"].Value   = jsonUser;
                Response.Cookies["acc"].Expires = DateTime.Now.AddDays(200);

                return(RedirectToAction("Index", "Home"));
            }
            return(this.Login());
        }
Ejemplo n.º 10
0
        // GET: Product
        public ActionResult Index(int?page)
        {
            var listSP     = UtilsDatabase.getDaTaBase().Products.ToList();
            int phanDu     = listSP.Count % 8;
            int numberPage = 0;

            if (phanDu > 0)
            {
                numberPage = listSP.Count / 8 + 1;
            }
            else
            {
                numberPage = listSP.Count / 8;
            }
            if (page.HasValue)
            {
                listSP = listSP.GetRange((int)((page - 1) * 8) - 1, 8);
            }
            else
            {
                if (listSP.Count < 8)
                {
                    listSP = (List <Product>)listSP.Take(listSP.Count);
                }
                else
                {
                    listSP = listSP.GetRange(0, 8);
                }
            }
            ViewBag.numberPage = numberPage;
            ViewBag.listSP     = listSP;
            return(View());
        }
Ejemplo n.º 11
0
        public ActionResult DatHang(Users user)
        {
            try
            {
                // đặt hàng
                var cart = Session["cart"];//get key cart
                if (cart == null)
                {
                    return(this.ThanhToan());
                }
                else
                {
                    int tongtien = 0;
                    int slsp     = 0;
                    List <CartItemDTO> listCart    = JsonConvert.DeserializeObject <List <CartItemDTO> >(cart.ToString());
                    string             jsonDonHang = JsonConvert.SerializeObject(listCart);
                    foreach (var item in listCart)
                    {
                        tongtien += (Convert.ToInt32(item.Gia) * Convert.ToInt32(item.SoLuong));
                        slsp     += item.SoLuong;
                    }
                    // insert to DB
                    user.Id = 1;
                    DonHang dh = new DonHang();
                    dh.NgayTao        = DateTime.Now;
                    dh.TongTien       = tongtien;
                    dh.SoLuongSanPham = slsp;
                    dh.GhiChu         = "Giao cho Anh/chị  " + user.HoTen + " ,Đ/c: " + user.DiaChi + ", Số điện thoại " + user.SoDienThoai;
                    dh.IsAccept       = 0;
                    dh.IdUser         = user.Id;
                    dh.JsonSanPham    = jsonDonHang;

                    UtilsDatabase.getDaTaBase().DonHangs.InsertOnSubmit(dh);
                    UtilsDatabase.getDaTaBase().SubmitChanges();
                    // updateSoLuongDaBanSanPham(listCart);

                    int IDdonHang = dh.MaDonHang;
                    List <ChiTietDonHang> listCTDH = new List <ChiTietDonHang>();
                    foreach (var item in listCart)
                    {
                        ChiTietDonHang ctdh = new ChiTietDonHang();
                        ctdh.MaSanPham = Convert.ToInt32(item.MaSanPham);
                        ctdh.SoLuong   = item.SoLuong;
                        ctdh.MaDonHang = IDdonHang;
                        listCTDH.Add(ctdh);
                    }
                    UtilsDatabase.getDaTaBase().ChiTietDonHangs.InsertAllOnSubmit(listCTDH);
                    UtilsDatabase.getDaTaBase().SubmitChanges();
                    // reset giỏ hàng
                    string jsonCart = JsonConvert.SerializeObject(new List <CartItemDTO>());
                    Session["cart"] = jsonCart;
                    return(RedirectToAction("Thanks", "Home"));
                }
            }
            catch (Exception e)
            {
                return(this.ThanhToan());
            }
        }
Ejemplo n.º 12
0
        public ActionResult Search(string keyword = "")
        {
            var listSP = UtilsDatabase.getDaTaBase().Products.Where(p => p.ProductName.Contains(keyword.Trim())).ToList();

            ViewBag.keyword = keyword;
            ViewBag.listSP  = listSP;
            return(View());
        }
Ejemplo n.º 13
0
 private void CaricaDati()
 {
     ///prendo i dati dal database  e li carico su bindinglistveicoli
     BindingListVeicoli = UtilsDatabase.OpenDataBaseToList(BindingListVeicoli);
     ///Carico su dgv
     dgvVeicoli.DataSource = BindingListVeicoli;
     
 }
Ejemplo n.º 14
0
        // GET: Cagetory
        public ActionResult Index(int id = 0, int page = 0, int?filter = 0)
        {
            int pageSize   = 4;
            int numberpage = 0;
            var lsp        = UtilsDatabase.getDaTaBase().LoaiSanPhams.ToList();
            var lspMain    = UtilsDatabase.getDaTaBase().LoaiSanPhams.Where(l => l.MaLoai == id).FirstOrDefault();
            var listsp     = UtilsDatabase.getDaTaBase().SanPhams.ToList();

            if (id > 0)
            {
                listsp = UtilsDatabase.getDaTaBase().SanPhams.Where(p => p.MaLoai == id).ToList();
            }
            ViewBag.lsp     = lsp;
            ViewBag.maloai  = id;
            ViewBag.lspMain = lspMain;
            ViewBag.page    = page;
            if (listsp.Count / pageSize - 1 > 0)
            {
                numberpage = listsp.Count / pageSize;
            }
            ViewBag.count = numberpage;
            if (listsp.Count >= pageSize)
            {
                try
                {
                    listsp = listsp.GetRange((page * pageSize), pageSize);
                }
                catch
                {
                    listsp = listsp.GetRange((page * pageSize), listsp.Count - (page * pageSize));
                }
            }
            if (filter.HasValue)
            {
                switch (filter)
                {
                case 1:
                    listsp = listsp.OrderBy(p => p.Gia).ToList();
                    break;

                case 2:
                    listsp = listsp.OrderByDescending(p => p.Gia).ToList();
                    break;

                case 3:
                    listsp = listsp.OrderBy(p => p.TenSanPham).ToList();
                    break;

                case 4:
                    listsp = listsp.OrderByDescending(p => p.TenSanPham).ToList();
                    break;
                }
            }
            ViewBag.listsp = listsp;


            return(View());
        }
Ejemplo n.º 15
0
        // administration
        public ActionResult  createOrEditProduct(int id = -1)
        {
            var listlsp = UtilsDatabase.getDaTaBase().LoaiSanPhams.ToList();
            var sp      = UtilsDatabase.getDaTaBase().SanPhams.Where(p => p.MaSanPham == id).FirstOrDefault();

            ViewBag.lsp = listlsp;
            ViewBag.sp  = sp;
            return(View());
        }
Ejemplo n.º 16
0
        public ActionResult Detail(int id = 0)
        {
            var sp         = UtilsDatabase.getDaTaBase().SanPhams.Where(p => p.MaSanPham == id).FirstOrDefault();
            var spLienQuan = UtilsDatabase.getDaTaBase().SanPhams.Where(p => p.LoaiSanPham == sp.LoaiSanPham && p.MaSanPham != sp.MaSanPham).ToList();

            ViewBag.sp         = sp;
            ViewBag.spLienQuan = spLienQuan;
            return(View());
        }
Ejemplo n.º 17
0
        // GET: Admin
        public ActionResult Index(DateTime?from, DateTime?to)
        {
            var         currenYear = DateTime.Now.Year;
            var         listInYear = UtilsDatabase.getDaTaBase().HoaDons.Where(r => r.NgayLap.Value.Year == currenYear).ToList();
            DoanhThuDTO dt         = new DoanhThuDTO();

            dt.Thang1  = listInYear.Where(x => x.NgayLap.Value.Month == 1).Sum(x => x.TongTien);
            dt.Thang2  = listInYear.Where(x => x.NgayLap.Value.Month == 2).Sum(x => x.TongTien);
            dt.Thang3  = listInYear.Where(x => x.NgayLap.Value.Month == 3).Sum(x => x.TongTien);
            dt.Thang4  = listInYear.Where(x => x.NgayLap.Value.Month == 4).Sum(x => x.TongTien);
            dt.Thang5  = listInYear.Where(x => x.NgayLap.Value.Month == 5).Sum(x => x.TongTien);
            dt.Thang6  = listInYear.Where(x => x.NgayLap.Value.Month == 6).Sum(x => x.TongTien);
            dt.Thang7  = listInYear.Where(x => x.NgayLap.Value.Month == 7).Sum(x => x.TongTien);
            dt.Thang8  = listInYear.Where(x => x.NgayLap.Value.Month == 8).Sum(x => x.TongTien);
            dt.Thang9  = listInYear.Where(x => x.NgayLap.Value.Month == 9).Sum(x => x.TongTien);
            dt.Thang10 = listInYear.Where(x => x.NgayLap.Value.Month == 10).Sum(x => x.TongTien);
            dt.Thang11 = listInYear.Where(x => x.NgayLap.Value.Month == 11).Sum(x => x.TongTien);
            dt.Thang12 = listInYear.Where(x => x.NgayLap.Value.Month == 12).Sum(x => x.TongTien);
            // lấy ra mã sp số lượng bán chạy nhất
            var slspMax = UtilsDatabase.getDaTaBase().ChiTietDonHangs.Max(p => p.SoLuong);
            var spMax   = UtilsDatabase.getDaTaBase().ChiTietDonHangs.Where(p => p.SoLuong == slspMax).FirstOrDefault();

            // get list SP bán từ ngày = > ngày
            var listsp = from p in UtilsDatabase.getDaTaBase().SanPhams
                         join ctdh in UtilsDatabase.getDaTaBase().ChiTietDonHangs
                         on p.MaSanPham equals ctdh.MaSanPham
                         join dh in UtilsDatabase.getDaTaBase().DonHangs
                         on ctdh.MaDonHang equals dh.MaDonHang
                         where p.MaSanPham == spMax.MaSanPham
                         select new CartItemDTO
            {
                MaSanPham  = p.MaSanPham.ToString(),
                TenSanPham = p.TenSanPham,
                Gia        = p.Gia.ToString(),
                MoTa       = p.MoTa,
                GhiChu     = "",
                SoLuong    = ctdh.SoLuong,
                NgayTao    = (DateTime)dh.NgayTao,
                LinkAnh    = p.LinkAnh
            };
            var TongDoanhThu = 0;

            TongDoanhThu = UtilsDatabase.getDaTaBase().DonHangs.Sum(p => p.TongTien);
            if (from.HasValue && to.HasValue)
            {
                listsp.Where(p => p.NgayTao >= from && p.NgayTao <= to);
                TongDoanhThu = UtilsDatabase.getDaTaBase().DonHangs.Where(dh => dh.NgayTao >= from && dh.NgayTao <= to).Sum(p => p.TongTien);
            }
            ViewBag.TongDoanhThu = TongDoanhThu;
            ViewBag.listsp       = listsp.ToList();
            ViewBag.dt           = dt;


            return(View());
        }
Ejemplo n.º 18
0
        public List <String> getstringSuggest(string keyword)
        {
            var listString = new List <String>();
            var dssp       = UtilsDatabase.getDaTaBase().SanPhams.Where(o => o.TenSanPham.Contains(keyword.Trim())).ToList();

            foreach (var item in dssp)
            {
                listString.Add(item.TenSanPham);
            }
            return(listString);
        }
Ejemplo n.º 19
0
        public ActionResult deleteCagetory(int id = -1)
        {
            var lsp = UtilsDatabase.getDaTaBase().LoaiSanPhams.Where(p => p.MaLoai == id).FirstOrDefault();

            if (lsp != null)
            {
                lsp.IsActive = 0;
                UtilsDatabase.getDaTaBase().SubmitChanges();
            }
            return(RedirectToAction("QuanLyLoaiSanPham", "Admin"));
        }
Ejemplo n.º 20
0
        public ActionResult deleteAcc(int id = -1)
        {
            var acccansua = UtilsDatabase.getDaTaBase().Users.Where(p => p.Id == id).FirstOrDefault();

            if (acccansua != null)
            {
                acccansua.IsActive = 0;
                UtilsDatabase.getDaTaBase().SubmitChanges();
            }
            return(RedirectToAction("QuanLyTaikhoan", "Admin"));
        }
Ejemplo n.º 21
0
        public ActionResult deleteProduct(int id = -1)
        {
            var sp = UtilsDatabase.getDaTaBase().SanPhams.Where(p => p.MaSanPham == id).FirstOrDefault();

            if (sp != null)
            {
                UtilsDatabase.getDaTaBase().SanPhams.DeleteOnSubmit(sp);
                UtilsDatabase.getDaTaBase().SubmitChanges();
            }
            return(RedirectToAction("QuanLySanPham", "Admin"));
        }
Ejemplo n.º 22
0
        public ActionResult createOrEditProduct(SanPham sp, HttpPostedFileBase file)
        {
            try
            {
                if (sp.MaSanPham > 0)
                {
                    // update
                    var spcansua = UtilsDatabase.getDaTaBase().SanPhams.Where(p => p.MaSanPham == sp.MaSanPham).First();
                    if (file != null)
                    {
                        var fileName = System.IO.Path.GetFileName(file.FileName);
                        var path     = Server.MapPath("~/Images/" + fileName);
                        file.SaveAs(path);
                        spcansua.LinkAnh = "/Images/" + fileName;
                    }
                    spcansua.IsActive   = 1;
                    spcansua.TenSanPham = sp.TenSanPham;
                    spcansua.Gia        = sp.Gia;
                    spcansua.SoLuong    = sp.SoLuong;
                    spcansua.MoTa       = sp.MoTa;
                    spcansua.KhuyenMai  = sp.KhuyenMai;
                    UpdateModel(spcansua);
                    UtilsDatabase.getDaTaBase().SubmitChanges();
                }
                else
                {
                    // add
                    var spAdd = new SanPham();
                    if (file != null)
                    {
                        var fileName = System.IO.Path.GetFileName(file.FileName);
                        var path     = Server.MapPath("~/Images/" + fileName);
                        file.SaveAs(path);
                        spAdd.LinkAnh = "/Images/" + fileName;
                    }
                    spAdd.IsActive   = 1;
                    spAdd.TenSanPham = sp.TenSanPham;
                    spAdd.Gia        = sp.Gia;
                    spAdd.SoLuong    = sp.SoLuong;
                    spAdd.MoTa       = sp.MoTa;
                    spAdd.KhuyenMai  = sp.KhuyenMai;
                    spAdd.MaLoai     = sp.MaLoai;
                    UtilsDatabase.getDaTaBase().SanPhams.InsertOnSubmit(spAdd);
                    UtilsDatabase.getDaTaBase().SubmitChanges();
                }
            }
            catch (Exception e)
            {
                return(RedirectToAction("QuanLySanPham", "Admin"));
            }


            return(RedirectToAction("QuanLySanPham", "Admin"));
        }
Ejemplo n.º 23
0
        public string getCagetory(int id)
        {
            LoaiSanPham lspNew        = new LoaiSanPham();
            var         lsp           = UtilsDatabase.getDaTaBase().LoaiSanPhams.Where(p => p.MaLoai == id).FirstOrDefault();
            string      jsonLSPString = "";

            if (lsp != null)
            {
                jsonLSPString = Json(lsp, JsonRequestBehavior.AllowGet).ToString();
            }
            jsonLSPString = Json(lspNew, JsonRequestBehavior.AllowGet).ToString();
            return(jsonLSPString);
        }
Ejemplo n.º 24
0
        public ActionResult Thanks()
        {
            var listSPNew = UtilsDatabase.getDaTaBase().SanPhams.OrderByDescending(p => p.MaSanPham).OrderBy(p => Guid.NewGuid())
                            .Take(8).ToList();
            var listSPSale = UtilsDatabase.getDaTaBase().SanPhams.Where(p => p.KhuyenMai >= 20).OrderByDescending(p => p.KhuyenMai).OrderBy(p => Guid.NewGuid())
                             .Take(8).ToList();
            var lsp = UtilsDatabase.getDaTaBase().LoaiSanPhams.ToList();

            ViewBag.listSPNew  = listSPNew;
            ViewBag.listSPSale = listSPSale;
            ViewBag.lsp        = lsp;
            return(View());
        }
Ejemplo n.º 25
0
        public ActionResult Index(string keyword = "", int page = 0)
        {
            var lsp = UtilsDatabase.getDaTaBase().LoaiSanPhams.ToList();

            ViewBag.lsp = lsp;
            var listSP = UtilsDatabase.getDaTaBase().SanPhams.Where(p => p.TenSanPham.ToLower().Contains(keyword.Trim().ToLower()) || p.MoTa.ToLower().Contains(keyword.Trim().ToLower())).ToList();

            ViewBag.listSP  = listSP;
            ViewBag.sl      = listSP.Count;
            ViewBag.keyword = keyword;
            ViewBag.listsp  = listSP;

            return(View());
        }
Ejemplo n.º 26
0
 private void updateSoLuongDaBanSanPham(List <CartItemDTO> listCart)
 {
     foreach (var item in listCart)
     {
         var SP = UtilsDatabase.getDaTaBase().SanPhams.Where(o => o.MaSanPham == Convert.ToInt32(item.MaSanPham)).FirstOrDefault();
         if (SP != null)
         {
             SP.SoLuongDaBan = SP.SoLuongDaBan + item.SoLuong;
             SP.SoLuong      = SP.SoLuong - item.SoLuong;
             UpdateModel(SP);
             UtilsDatabase.getDaTaBase().SubmitChanges();
         }
     }
 }
Ejemplo n.º 27
0
        public ActionResult addCart(CartItemDTO cartItem)
        {
            var carrt = cartItem;
            var cart  = Session["cart"];//get key cart

            // cập nhật số lượng đã bán bảng LoaiSanPham
            var SP = UtilsDatabase.getDaTaBase().SanPhams.Where(o => o.MaSanPham == Convert.ToInt32(cartItem.MaSanPham)).FirstOrDefault();

            if (SP != null)
            {
                var LSP = UtilsDatabase.getDaTaBase().LoaiSanPhams.Where(o => o.MaLoai == Convert.ToInt32(SP.MaLoai)).FirstOrDefault();
                if (LSP != null)
                {
                    LSP.SoLuongDaBan = SP.SoLuongDaBan + cartItem.SoLuong;
                    UpdateModel(SP);
                    UtilsDatabase.getDaTaBase().SubmitChanges();
                }
                UpdateModel(SP);
                UtilsDatabase.getDaTaBase().SubmitChanges();
            }

            if (cart == null)
            {
                List <CartItemDTO> listCart = new List <CartItemDTO>();
                listCart.Add(cartItem);
                string jsonCart = JsonConvert.SerializeObject(listCart);
                Session["cart"] = jsonCart;
            }
            else
            {
                List <CartItemDTO> listCart = JsonConvert.DeserializeObject <List <CartItemDTO> >(cart.ToString());
                bool check = true;
                for (int i = 0; i < listCart.Count; i++)
                {
                    if (listCart[i].MaSanPham == cartItem.MaSanPham)
                    {
                        listCart[i].SoLuong += cartItem.SoLuong;
                        check = false;
                    }
                }
                if (check)
                {
                    listCart.Add(cartItem);
                }
                string jsonCart = JsonConvert.SerializeObject(listCart);
                Session["cart"] = jsonCart;
            }

            return(RedirectToAction("Index", "Home"));
        }
Ejemplo n.º 28
0
        public ActionResult detail(int?id = 0)
        {
            var sp            = UtilsDatabase.getDaTaBase().Products.Where(p => p.ProductID == id).FirstOrDefault();
            var listAttribute = UtilsDatabase.getDaTaBase().ProductAttributes.Where(p => p.ProductID == id).ToList();
            var listGallery   = UtilsDatabase.getDaTaBase().ProductGalleries.Where(p => p.ProductID == id).ToList();

            if (listGallery == null)
            {
                listGallery = new List <ProductGallery>();
            }
            ViewBag.sp            = sp;
            ViewBag.listAttribute = listAttribute;
            ViewBag.listGallery   = listGallery;
            return(View());
        }
Ejemplo n.º 29
0
        public ActionResult Register(User user)
        {
            var userRes = new User();

            userRes.HoTen       = user.HoTen;
            userRes.DiaChi      = user.DiaChi;
            userRes.SoDienThoai = user.SoDienThoai;
            userRes.TenDangNhap = user.TenDangNhap;
            userRes.MatKhau     = user.MatKhau;
            userRes.Quyen       = 2;
            userRes.IsActive    = 1;
            UtilsDatabase.getDaTaBase().Users.InsertOnSubmit(userRes);
            UtilsDatabase.getDaTaBase().SubmitChanges();

            return(RedirectToAction("Login", "Account"));
        }
Ejemplo n.º 30
0
        public ActionResult QuanLySanPham(string keyword = "")
        {
            var listSPNew = new List <SanPham>();

            if (String.IsNullOrEmpty(keyword))
            {
                listSPNew = UtilsDatabase.getDaTaBase().SanPhams.Where(p => p.IsActive == 1).OrderByDescending(p => p.MaSanPham).ToList();
            }
            else
            {
                listSPNew = UtilsDatabase.getDaTaBase().SanPhams.Where(p => p.IsActive == 1 && p.TenSanPham.Trim().Contains(keyword)).OrderByDescending(p => p.MaSanPham).ToList();
            }

            ViewBag.listSP = listSPNew;
            return(View());
        }