public ActionResult AddToCart(string productID)
{
try
{
var account = Session["account"] as TAIKHOANDANGNHAP;
if (account != null)
{
GIOHANG toUpdate = db.GIOHANGs.FirstOrDefault(a => a.ID_NGUOIMUA == account.ID_THANHVIEN && a.MAHANGHOA == productID);
if (toUpdate == null)
{
GIOHANG giohang = new GIOHANG();
giohang.ID_NGUOIMUA = account.ID_THANHVIEN.Trim();
giohang.MAHANGHOA = productID.Trim();
giohang.NGAYTHEM = DateTime.Now;
giohang.SOLUONG = 1;
db.GIOHANGs.Add(giohang);
db.SaveChanges();
}
else
{
toUpdate.SOLUONG += 1;
db.SaveChanges();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("ProductDetail", "Home", new { @productID = productID }));
}
public ActionResult CheckoutProduct(string productID, string shipping, string voucherID)
{
var account = Session["account"] as TAIKHOANDANGNHAP;
var newCheckout = "";
try
{
const string chars = "0123456789";
DATHANG toAdd = new DATHANG();
DONHANG toAddDonHang = new DONHANG();
var voucherInfo = (from system_voucher in db.VOUCHERs
where system_voucher.MACODE == voucherID
join loai_voucher in db.LOAIVOUCHERs
on system_voucher.LOAIVOUCHER equals loai_voucher.MALOAIVOUCHER
select new
{
mucgia = loai_voucher.MUCGIA,
giamtoida = loai_voucher.GIAMTOIDA,
uudai = loai_voucher.UUDAI
}).SingleOrDefault();
List <DATHANG> found;
Random random = new Random();
toAdd.NGUOIMUA = account.ID_THANHVIEN;
do
{
toAdd.ID_DONHANG = new string(Enumerable.Repeat(chars, 10).Select(s => s[random.Next(s.Length)]).ToArray());
toAddDonHang.ID_DONHANG = toAdd.ID_DONHANG;
found = db.DATHANGs.Where(x => x.ID_DONHANG == toAdd.ID_DONHANG).ToList();
if (found.Count == 0)
{
break;
}
} while (toAdd.ID_DONHANG != "");
toAdd.NGAYDAT = DateTime.Now;
var currentItem = (from GH in db.GIOHANGs
where GH.ID_NGUOIMUA == account.ID_THANHVIEN && GH.MAHANGHOA == productID
join HH in db.HANGHOAs on GH.MAHANGHOA equals HH.MAHANGHOA
select new
{
id_hh = HH.MAHANGHOA,
gianhang = HH.MAGIANHANG,
ten = HH.TENHANGHOA,
giathanh = HH.GIATHANH,
soluong = GH.SOLUONG
}).SingleOrDefault();
toAdd.TONGTIEN = currentItem.giathanh * currentItem.soluong;
toAdd.GIANHANG = currentItem.gianhang;
toAdd.MADVVC = shipping;
toAddDonHang.MASANPHAM = currentItem.id_hh;
toAddDonHang.SOLUONG = currentItem.soluong;
toAddDonHang.DONGIA = currentItem.giathanh;
db.DATHANGs.Add(toAdd);
db.DONHANGs.Add(toAddDonHang);
db.SaveChanges();
newCheckout = toAdd.ID_DONHANG;
}
catch (Exception ex)
{
throw ex;
}
return(RedirectToAction("Payment", "Checkout", new { billID = newCheckout, voucher = voucherID }));
}
