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));
}
