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