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