public ActionResult capnhatdanhgiatucus(int iddonhang, int idsp, int idmer, int rating) { //var customer = (customerlogin)Session[constant.CUSTOMER_SESSION]; RATINGDAL rat = new RATINGDAL(); rat.capnhatdanhgiatucus(iddonhang, idsp, idmer, rating); return(RedirectToAction("listratingdangcho")); }
public void luudonhang(DONHANG dh, List <CTDH> ctdh) { DONHANG donhang = new DONHANG { MACUSTOMER = dh.MACUSTOMER, NGAYMUA = dh.NGAYMUA, DIACHI = dh.DIACHI, SDT = dh.SDT, TONGTIEN = dh.TONGTIEN, GHICHU = dh.GHICHU }; db.DONHANGs.Add(donhang); db.SaveChanges(); int iddonhang = donhang.MADH; List <CTDH> listct = new List <CTDH>(); listct = ctdh; var listrating = new List <RATING>(); foreach (var item in listct) { CTDH ct = new CTDH(); ct.MADH = iddonhang; ct.MASP = item.MASP; ct.MAMERCHANT = item.MAMERCHANT; ct.SOLUONG = item.SOLUONG; ct.THANHTIEN = item.THANHTIEN; ct.TINHTRANG = item.TINHTRANG; ct.MAKICHCO = item.MAKICHCO; ct.GIAGIAM = item.GIAGIAM; db.CTDHs.Add(ct); db.SaveChanges(); if (listrating.Exists(x => x.MADH == item.MADH) && listrating.Exists(x => x.MASP == item.MASP)) { } else { listrating.Add(new RATING() { MADH = item.MADH, MASP = item.MASP }); RATING rating = new RATING(); rating.MADH = iddonhang; rating.MASP = item.MASP; rating.MAMERCHANT = item.MAMERCHANT; rating.MACUSTOMER = dh.MACUSTOMER; rating.RATING_M = null; rating.RATING_C = null; rating.NGAYRATING = null; rating.TRANGTHAI = 0; RATINGDAL ratingdal = new RATINGDAL(); ratingdal.addrating(rating); db.SaveChanges(); } } }
public ActionResult listratingdangcho() { var customer = (customerlogin)Session[constant.CUSTOMER_SESSION]; var listrat = new RATINGDAL().listchocustomerrating(customer.MACUSTOMER); //var listmer = new Entity.MDAL.MERCHANTDAL().listallmer(); //var listdh = new DONGHANGDAL().listdh(customer.MACUSTOMER); var list = (from l in listrat select new RATINGViewModel() { MADH = l.MADH, MASP = l.SANPHAM.MASP, TENSP = l.SANPHAM.TENSP, MAUSER = l.MERCHANT.MAMERCHANT, TENUSER = l.MERCHANT.TENMERCHANT, RATING = l.RATING_M }).ToList(); return(PartialView(list)); }