public static Boolean Update(GioHangDTO gioHangDTO) { if (GioHangDAO.IsExist(gioHangDTO.TenTaiKhoan, gioHangDTO.MaSP)) { return(GioHangDAO.Update(gioHangDTO)); } return(false); }
public ActionResult ChinhSua(GioHangModel model) { GioHangDAO ghDAO = new GioHangDAO(); ghDAO.updateGH(model.MaCHTDDH, model.SoLuong); return(RedirectToAction("Index")); }
public static Boolean Insert(GioHangDTO gioHangDTO) { if (!GioHangDAO.IsExist(gioHangDTO.TenTaiKhoan, gioHangDTO.MaSP)) { return(GioHangDAO.Insert(gioHangDTO)); } return(false); }
public static Boolean Delete(String tenTaiKhoan, String maSP) { if (GioHangDAO.IsExist(tenTaiKhoan, maSP)) { return(GioHangDAO.Delete(tenTaiKhoan, maSP)); } return(false); }
public ActionResult DeleteItemGH(int idSP, int idDDH) { GioHangDAO ghDAO = new GioHangDAO(); NguoiDungDAO ndDAO = new NguoiDungDAO(); NguoiDung nd = ndDAO.getByTaiKhoan(Session["TAIKHOAN"].ToString()); ghDAO.deleteGH(idSP, idDDH, (List <GioHangModel>)Session["GIOHANG"]); return(RedirectToAction("Index")); }
public static bool ThemGH(GioHangDTO gh) { if (GioHangDAO.KTGHTonTai(gh)) { return(GioHangDAO.SuaGH(gh)); } else { return(GioHangDAO.ThemGH(gh)); } }
public ActionResult AddSP(int idSP) { List <GioHangModel> gh = (List <GioHangModel>)Session["GIOHANG"]; NguoiDungDAO ndDAO = new NguoiDungDAO(); var ghDAO = new GioHangDAO(); NguoiDung nd = ndDAO.getByTaiKhoan(Session["TAIKHOAN"].ToString()); Session["GIOHANG"] = ghDAO.addGH(nd.MaNguoiDung, idSP, gh); return(RedirectToAction("Index")); }
public static int TinhTongTienGH(string tenTK) { DataTable dtbKetQua = GioHangDAO.Lay_GH(tenTK); int tongTien = 0; foreach (DataRow dr in dtbKetQua.Rows) { tongTien += Convert.ToInt32(dr["ThanhTien"]); } return(tongTien); }
public ActionResult ThanhToan1(Models.KhachHangDTO kh) { ShopingCart cart = (ShopingCart)Session[shop]; List <ItemCart> li = new List <ItemCart>(); li = cart.listItem; ViewBag.tongtien = cart.TotalMoney(); ViewBag.soluong = cart.TotalAmmount(); if (ModelState.IsValid) { KhachHang kh1 = new KhachHang(); kh1.tenkhachhang = kh.tenkhachhang; kh1.diachi = kh.diachi; kh1.email = kh.email; kh1.sodienthoai = kh.sodienthoai; KhachHangDao khDAo = new KhachHangDao(); int makhachhang1 = khDAo.ThemKhachHang(kh1); GioHang gh = new GioHang(); gh.makhachhang = makhachhang1; gh.ngaydathang = DateTime.Today; gh.tinhtranggiaohang = false; gh.tongtien = cart.TotalMoney(); GioHangDAO ghDao = new GioHangDAO(); int magiohang = ghDao.ThemGioHang(gh); foreach (ItemCart item in li) { ChiTietGioHang ct = new ChiTietGioHang() { magiohang = magiohang, masanpham = item.sanpham.masanpham, soluong = item.soluong, thanhtien = item.soluong * (item.sanpham.giaban) }; ChiTietGioHangDAO ctDao = new ChiTietGioHangDAO(); ctDao.ThemChiTiet(ct); } Session[shop] = null; return(View("Success")); } else { return(View("ThanhToan", li)); } }
// GET: GioHang public ActionResult Index() { NguoiDungDAO ndDAO = new NguoiDungDAO(); GioHangDAO ghDAO = new GioHangDAO(); NguoiDung nd = ndDAO.getByTaiKhoan(Session["TAIKHOAN"].ToString()); Session["GIOHANG"] = ghDAO.getGioHangByND(nd.MaNguoiDung); int tongDDH = ghDAO.getTongSPByND(nd.MaNguoiDung); int tongGTDDH = ghDAO.getTongGTDDHByND(nd.MaNguoiDung); Session.Add("DDH", tongDDH); Session.Add("GIATRIDDH", tongGTDDH); return(View((List <GioHangModel>)Session["GIOHANG"])); }
public ActionResult Login(LoginModel model) { if (ModelState.IsValid) { var ndDAO = new NguoiDungDAO(); var ghDAO = new GioHangDAO(); var result = ndDAO.Login(model.taikhoan, model.matkhau); if (result) { var nguoidung = ndDAO.getByTaiKhoan(model.taikhoan); var taikhoan = model.taikhoan; string hinhanh = nguoidung.HinhAnh; int tongDDH = ghDAO.getTongSPByND(nguoidung.MaNguoiDung); int tongGTDDH = ghDAO.getTongGTDDHByND(nguoidung.MaNguoiDung); Session.Add("TAIKHOAN", taikhoan); Session.Add("HINHANH", hinhanh); Session.Add("DDH", tongDDH); Session.Add("GIATRIDDH", tongGTDDH); NguoiDung nd = ndDAO.getByTaiKhoan(model.taikhoan); Session["GIOHANG"] = ghDAO.getGioHangByND(nd.MaNguoiDung); if (nguoidung.MaLND == 1) { return(RedirectToAction("Index", "Home", new { area = "Admin" })); } else { return(RedirectToAction("Index", "TrangChu")); } } else { ModelState.AddModelError("", "Đăng nhập không thành công."); } } return(View("Login")); }
public ActionResult ThanhToan1(KhachHangDTO khachHangDTO) { var sess = (Areas.Admin.Models.TaiKhoan)Session["UserLogin"]; ShoppingCart cart = (ShoppingCart)Session[shop]; List <ItemCart> li = new List <ItemCart>(); li = cart.dsItemCart; ViewBag.tongtien = cart.TotalMoney(); ViewBag.soluong = cart.TotalAmount(); if (ModelState.IsValid) { if (sess == null) { KhachHang kh = new KhachHang(); KhachHangDAO khachHangDAO = new KhachHangDAO(); kh.MaKH = khachHangDAO.GetMaxMKH(); kh.TenKh = khachHangDTO.TenKH; kh.SoDT = khachHangDTO.SoDT; kh.Email = khachHangDTO.Email; kh.DiaChi = khachHangDTO.DiaChi; string MaKH = khachHangDAO.ThemKhachHang(kh); GioHang gioHang = new GioHang(); GioHangDAO gioHangDAO = new GioHangDAO(); gioHang.MaGH = gioHangDAO.getMaGH(); gioHang.MaKH = MaKH; gioHang.NgayDatHang = DateTime.Today; gioHang.TinhTrang = false; gioHang.TongTien = cart.TotalMoney(); string MaGH = gioHangDAO.ThemGioHang(gioHang); foreach (ItemCart item in li) { ChiTietGioHang chiTietGioHang = new ChiTietGioHang() { MaGH = MaGH, MaSach = item.sach.MaSach, SoLuong = item.SoLuong, GiaTien = item.SoLuong * (item.sach.GiaTien) }; ChiTietGioHangDAO chiTietGioHangDAO = new ChiTietGioHangDAO(); chiTietGioHangDAO.Them(chiTietGioHang); } Session[shop] = null; return(View("Success")); } else { GioHang gioHang = new GioHang(); GioHangDAO gioHangDAO = new GioHangDAO(); gioHang.MaGH = gioHangDAO.getMaGH(); gioHang.MaKH = sess.MaKH; gioHang.NgayDatHang = DateTime.Today; gioHang.TinhTrang = false; gioHang.TongTien = cart.TotalMoney(); string MaGH = gioHangDAO.ThemGioHang(gioHang); foreach (ItemCart item in li) { ChiTietGioHang chiTietGioHang = new ChiTietGioHang() { MaGH = MaGH, MaSach = item.sach.MaSach, SoLuong = item.SoLuong, GiaTien = item.SoLuong * (item.sach.GiaTien) }; ChiTietGioHangDAO chiTietGioHangDAO = new ChiTietGioHangDAO(); chiTietGioHangDAO.Them(chiTietGioHang); } Session[shop] = null; return(View("Success")); } } else { return(View("ThanhToan", li)); } }
public ActionResult ChiTiet(int id) { GioHangDAO ghDao = new GioHangDAO(); return(View(ghDao.chitietdonhang(id))); }
// GET: Admin/QuanLyDonHang public ActionResult Index(int pageNumber = 1, int pageSize = 8) { GioHangDAO gioHangDAO = new GioHangDAO(); return(View(gioHangDAO.dsDonHang(pageNumber, pageSize))); }
public ActionResult Details(string id, int pageNumber = 1, int pageSize = 8) { GioHangDAO gioHangDAO = new GioHangDAO(); return(View(gioHangDAO.chiTietDH(id, pageNumber, pageSize))); }
public static List <GioHangDTO> Get() { return(GioHangDAO.Get()); }
public ActionResult ChinhSua(int idDDH, int idCT) { var ghDAO = new GioHangDAO(); return(View(ghDAO.getItemGH(idCT, idDDH))); }
public static DataTable giohang_select() { return(GioHangDAO.giohang_select()); }
public static DataTable giohang_selectBySogh(string sogh) { return(GioHangDAO.giohang_selectBySogh(sogh)); }
public static bool XoaGH(GioHangDTO gh) { return(GioHangDAO.XoaGH(gh)); }
public static GioHangDTO GetObjectByPrimaryKey(String tenTaiKhoan, String maSP) { return(GioHangDAO.GetObjectByPrimaryKey(tenTaiKhoan, maSP)); }
public static DataTable LayGH(string tenTK) { return(GioHangDAO.Lay_GH(tenTK)); }
public static void giohang_delete(string sogh) { GioHangDAO.giohang_delete(sogh); }
public static DataTable Giohang_GetbyEmail(string email) { return(GioHangDAO.GetbyEmail(email)); }
public static void Giohang_DeletebyEmail(string email) { GioHangDAO.Giohang_DeleteByEmail(email); }
public static void giohang_insert(Gioihang gh) { GioHangDAO.giohang_insert(gh); }
public static void giohang_update(string sogh, bool tinhtrang) { GioHangDAO.giohang_update(sogh, tinhtrang); }
public static DataTable giohang_selectBytinhtrang(bool tinhtrang) { return(GioHangDAO.giohang_selectBytinhtrang(tinhtrang)); }
public static bool XoaitemGH(string maHoa) { return(GioHangDAO.XoaitemGH(maHoa)); }
public static DataTable LayDSGioHang(string tenTk) { return(GioHangDAO.LayDSGioHang(tenTk)); }