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 void bantat() { List <LICHSUMUATIN> ls = db.LICHSUMUATINs.ToList(); foreach (var item in ls) { if (item.TRANGTHAI == 0) { LICHSUMUATIN l = db.LICHSUMUATINs.Find(item.IDMUATIN); l.TRANGTHAI = 1; db.SaveChanges(); MERCHANT mer = db.MERCHANTS.Where(m => m.MAMERCHANT == l.MAMERCHANT).SingleOrDefault(); mer.SOTINHIENTAI += l.GOITIN.SOTIN; db.SaveChanges(); } } }
public void banhaykhong(int idmuatin, int code) { if (code == 1) { LICHSUMUATIN ls = db.LICHSUMUATINs.Where(i => i.IDMUATIN == idmuatin).SingleOrDefault(); ls.TRANGTHAI = 1; db.SaveChanges(); MERCHANT mer = db.MERCHANTS.Where(m => m.MAMERCHANT == ls.MAMERCHANT).SingleOrDefault(); mer.SOTINHIENTAI += ls.GOITIN.SOTIN; db.SaveChanges(); } else { LICHSUMUATIN ls = db.LICHSUMUATINs.Where(i => i.IDMUATIN == idmuatin).SingleOrDefault(); ls.TRANGTHAI = -1; db.SaveChanges(); } }
public void addlichsumuatin(LICHSUMUATIN l) { db.LICHSUMUATINs.Add(l); db.SaveChanges(); }