public List <CTDH_SANPHAM_MERCHANT_KICHCOViewModel> listctdh(int iddonhang) { var listsp = new SANPHAMDAL().getallsanpham(); var listmerchant = new Entity.DAL.MERCHANTDAL().getallmerchant(); var listkichco = new KICHCODAL().getallkc(); var listctdh = new CTDHDAL().listctdh(iddonhang); var list = from kc in listkichco //kich co join ctdh in listctdh on kc.MAKICHCO equals ctdh.MAKICHCO into kc_ctdh from kct in kc_ctdh // kich co join ctdh join sp in listsp on kct.MASP equals sp.MASP into kc_ctdh_sp from kctsp in kc_ctdh_sp // kich co join ctdh join sanpham join m in listmerchant on kctsp.MAMERCHANT equals m.MAMERCHANT into complete //kich co join ctdh join sanpham join merchant from c in complete select new CTDH_SANPHAM_MERCHANT_KICHCOViewModel { MASP = kctsp.MASP, MAKICHCO = kc.MAKICHCO, TENSP = kctsp.TENSP, TENMERCHANT = c.TENMERCHANT, SOLUONG = kct.SOLUONG, THANHTIEN = kct.THANHTIEN, TINHTRANG = kct.TINHTRANG, KICHCO = kc.KICHCO1, GIAGIAM = kctsp.GIAGIAM, GIA = kctsp.GIA }; return(list.ToList()); }
public ActionResult additem(int masp, int makichco, int soluong) { if (Session["USER_SESSION"] == null) { return(Json(-1, JsonRequestBehavior.AllowGet)); } else { var sanpham = new SANPHAMDAL().sanphamnay(masp); var kichco = new KICHCODAL().kichco(makichco); var giohang = Session[ssgiohang]; if (giohang != null) { var list = (List <ITEMGIOHANGViewModel>)giohang; if (list.Exists(m => m.SANPHAM.MASP == masp) && list.Exists(k => k.KICHCO.MAKICHCO == makichco)) { var item = (from l in list where l.SANPHAM.MASP == masp && l.KICHCO.MAKICHCO == makichco select l).SingleOrDefault(); item.SOLUONG = item.SOLUONG + soluong; } else { var otheritem = new ITEMGIOHANGViewModel(); otheritem.SANPHAM = sanpham; otheritem.KICHCO = kichco; otheritem.SOLUONG = soluong; list.Add(otheritem); Session[ssgiohang] = list; } //Session["tongsoluong"] = list.Sum(x => x.SOLUONG); //Session["tongthanhtoan"] = list.Sum(x => x.THANHTIENITEM) - list.Sum(x => x.TIENGIAM); } else { var item = new ITEMGIOHANGViewModel(); item.SANPHAM = sanpham; item.KICHCO = kichco; item.SOLUONG = soluong; var list = new List <ITEMGIOHANGViewModel>(); list.Add(item); Session[ssgiohang] = list; ViewBag.sl = list.Sum(x => x.SOLUONG); //Session["tongsoluong"] = list.Sum(x=>x.SOLUONG); //Session["tongthanhtoan"] = list.Sum(x=>x.THANHTIENITEM)-list.Sum(x=>x.TIENGIAM); } } return(Json(1, JsonRequestBehavior.AllowGet)); //return RedirectToAction("listsanphamtronggiohang"); }