public ActionResult lichsumuatin() { ViewData["listgoitin"] = new GOITINDAL().listgoitin(); var mer = (merchantlogin)Session[constant.MERCHANT_SESSION]; LICHSUMUATIN ls = new LICHSUMUATIN(); var list = new GOITINDAL().listalltindamua(mer.MAMERCHANT); ViewData["tongtien"] = list.Where(x => x.TRANGTHAI == 1).Sum(x => x.GOITIN.SOTIEN); ViewData["phaitra"] = list.Where(x => x.TRANGTHAI == 0).Sum(x => x.GOITIN.SOTIEN); return(View(list)); }
public ActionResult themgoi(int magoi) { var mer = (merchantlogin)Session[constant.MERCHANT_SESSION]; LICHSUMUATIN l = new LICHSUMUATIN(); l.MAMERCHANT = mer.MAMERCHANT; l.MAGOITIN = magoi; l.NGAYMUA = DateTime.Today; l.TRANGTHAI = 0; GOITINDAL dal = new GOITINDAL(); dal.addlichsumuatin(l); return(Json(1, JsonRequestBehavior.AllowGet)); }
public List <MERCHANTMUATINViewModel> listall() { GOITINDAL dal = new GOITINDAL(); var listlichsu = dal.listlichsu(); var listthongke = (from l in listlichsu select new MERCHANTMUATINViewModel() { MAMERCHANT = l.MAMERCHANT, TENMERCHANT = l.MERCHANT.TENMERCHANT, MAGOITIN = l.MAGOITIN, SOTIN = l.GOITIN.SOTIN, SOTIEN = l.GOITIN.SOTIEN, NGAYMUA = l.NGAYMUA }).ToList(); ViewData["tongcong"] = listthongke.Sum(x => x.SOTIEN); return(listthongke); }