public JsonResult AddToCart(ItemEntry VE, int itemcd)
{
try
{
Random rnd = new Random();
int id = rnd.Next(0, 9999);
int uid = Convert.ToInt32(Session["USER_ID"].ToString());
var cartid = DB.CART.Where(a => a.USER_ID == uid && a.STATUS == "A").Select(b => b.CART_ID).ToList();
if (cartid != null && cartid.Count() > 0)
{
int cart_id = cartid[0];
var Q = DB.CART_ITEM.Where(M => M.CART_ID == cart_id && M.ITEM_CD == itemcd).FirstOrDefault();
if (Q != null)
{
var max_qnty = Q.QNTY;
Q.ITEM_CD = itemcd;
Q.QNTY = max_qnty + 1;
DB.SaveChanges();
}
else
{
CART_ITEM CARTITEM = new CART_ITEM();
CARTITEM.CI_ID = id;
CARTITEM.CART_ID = cart_id;
CARTITEM.ITEM_CD = itemcd;
CARTITEM.QNTY = 1;
DB.CART_ITEM.Add(CARTITEM);
DB.SaveChanges();
}
}
else
{
CART CART = new CART();
CART.CART_ID = id;
CART.USER_ID = Convert.ToInt32(Session["USER_ID"].ToString());
CART.STATUS = "A";
CART.CART_TIME = System.DateTime.Now;
DB.CART.Add(CART);
DB.SaveChanges();
CART_ITEM CARTITEM = new CART_ITEM();
CARTITEM.CI_ID = id;
CARTITEM.CART_ID = CART.CART_ID;
CARTITEM.ITEM_CD = itemcd;
CARTITEM.QNTY = 1;
DB.CART_ITEM.Add(CARTITEM);
DB.SaveChanges();
}
return(Json("Success", JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex.Message + ex.InnerException, JsonRequestBehavior.AllowGet));
}
}
//
public ActionResult DeleteCartItem(string masp, string kt)
{
if (Session["kh"] == null)
{
return(RedirectToAction("Signin", "KhachHang"));
}
KHACHHANG kh = Session["kh"] as KHACHHANG;
CART_ITEM c = db.CART_ITEMs.Where(s => s.MASANPHAM == masp && s.USERNAME == kh.USERNAME && s.KICHTHUOC == kt).Single();
db.CART_ITEMs.DeleteOnSubmit(c);
db.SubmitChanges();
return(RedirectToAction("GioHang", "DatHang"));
}
public int Them(string masp, string username, string tensp, string kt, double gia, string hinh, int sl)
{
CART_ITEM sp = list.SingleOrDefault(s => s.MASANPHAM == masp && s.KICHTHUOC == kt);
bool hasitem = db.CART_ITEMs.Where(s => s.MASANPHAM == masp && s.USERNAME == username && s.KICHTHUOC == kt).Count() > 0;
if (sp == null)
{
CART_ITEM item = new CART_ITEM();
item.MASANPHAM = masp;
item.USERNAME = username;
item.SOLUONG = sl;
item.TRANGTHAI = 0;
item.GIA = gia;
item.TENSANPHAM = tensp;
item.HINH = hinh;
item.THANHTIEN = long.Parse((item.SOLUONG * item.GIA).ToString());
if (item == null)
{
return(-1);
}
if (kt != null)
{
item.KICHTHUOC = kt;
}
else
{
item.KICHTHUOC = "Không có";
}
list.Add(item);
db.CART_ITEMs.InsertOnSubmit(item);
db.SubmitChanges();
}
else
{
sp.SOLUONG++;
sp.THANHTIEN = long.Parse((sp.SOLUONG * sp.GIA).ToString());
CART_ITEM itemhas = db.CART_ITEMs.Where(s => s.MASANPHAM == masp && username == s.USERNAME && s.KICHTHUOC == kt).Single();
itemhas.SOLUONG++;
itemhas.THANHTIEN = long.Parse((itemhas.SOLUONG * itemhas.GIA).ToString());
db.SubmitChanges();
}
return(1);
}
//
// GET: /DatHang/
public ActionResult ThemMatHang(string masp, FormCollection c)
{
if (Session["kh"] == null)
{
return(RedirectToAction("Signin", "KhachHang"));
}
else
{
SANPHAM sptt = db.SANPHAMs.Where(sp => sp.MASANPHAM == masp).Single();
double gia;
if (sptt.GIAM == null)
{
gia = sptt.GIAGOC ?? default(double);
}
else
{
gia = sptt.GIABAN ?? default(double);
}
string kt = c["rdoKichThuoc"];
if (kt == null)
{
kt = "Không có";
}
int sl = int.Parse(c["txtQuantity"]);
KHACHHANG k = Session["kh"] as KHACHHANG;
List <CART_ITEM> gh = db.CART_ITEMs.Where(s => s.USERNAME == k.USERNAME).ToList();
ShopCart shop = new ShopCart();
if (gh != null)
{
shop.list = gh;
}
CART_ITEM cc = db.CART_ITEMs.Where(ct => ct.MASANPHAM == masp && ct.USERNAME == k.USERNAME && ct.KICHTHUOC == kt).FirstOrDefault();
if (cc == null)
{
shop.Them(masp, k.USERNAME, sptt.TENSANPHAM, kt, gia, sptt.HINHMINHHOA, sl);
}
else
{
cc.SOLUONG += sl;
db.SubmitChanges();
}
return(Redirect(HttpContext.Request.UrlReferrer.AbsoluteUri));
}
}
