public ActionResult themsach(CTPTTDAILI ct, int max)
{
if (ct.SOLUONG > max)
{
return(Json(-1));
}
var sach = db.SACHes.Find(ct.MASACH);
DAILITHANHTOANModle ptt = new DAILITHANHTOANModle();
if (Session["ptt"] != null)
{
ptt = (DAILITHANHTOANModle)Session["ptt"];
}
else
{
ptt.ct = new List <CTPTTDAILI>();
}
var sachdaco = (from c in ptt.ct
where c.MASACH == ct.MASACH
select c).SingleOrDefault();
if (sachdaco != null)
{
CTPTTDAILI capnhatsachdaco = new CTPTTDAILI();
capnhatsachdaco.MASACH = ct.MASACH;
int?soluong = sachdaco.SOLUONG + ct.SOLUONG;
if (soluong <= max)
{
ptt.ct.Remove(sachdaco);
capnhatsachdaco.SOLUONG = sachdaco.SOLUONG + ct.SOLUONG;
capnhatsachdaco.THANHTIEN = capnhatsachdaco.SOLUONG * sach.GIABAN;
ptt.ct.Add(capnhatsachdaco);
}
else
{
return(Json(-2));
}
}
else
{
ct.THANHTIEN = ct.SOLUONG * sach.GIABAN;
ptt.ct.Add(ct);
}
Session["ptt"] = ptt;
var join = from p in ptt.ct
join s in db.SACHes
on p.MASACH equals s.MASACH into info
from i in info
select new { i.MASACH, i.TENSACH, p.SOLUONG, i.GIABAN, p.THANHTIEN };
return(Json(join.ToList(), JsonRequestBehavior.AllowGet));//
}
public ActionResult luuphieu(int MADL, DateTime NGAYTT, double TONGTIEN)
{
//int nochophep = (from hs in db.HANGSOes
// select hs.notoida).SingleOrDefault();
//double? nodaili = (from dl in db.DAILies
// where dl.MADL == MADL
// select dl.TIENNO).SingleOrDefault();
//if(nodaili+TONGTIEN>nochophep)
//{
// return Json(-1);
//}
DAILITHANHTOANModle tt = new DAILITHANHTOANModle();
DAILITHANHTOANModle temp = new DAILITHANHTOANModle();
CTPTTDAILI ct = new CTPTTDAILI();
if (Session["ptt"] != null)
{
temp = (DAILITHANHTOANModle)Session["ptt"];
Session["ptt"] = null;
tt.ct = temp.ct;
}
if (ModelState.IsValid)
{
PTTDAILI p = new PTTDAILI
{
MADL = MADL,
NGAYTT = NGAYTT,
TONGTIEN = TONGTIEN
};
db.PTTDAILIs.Add(p);
db.SaveChanges();
int id = p.MPTTDAILI;
foreach (var item in tt.ct)
{
item.MPTTDAILI = id;
db.CTPTTDAILIs.Add(item);
}
db.SaveChanges();
var daili = db.DAILies.Find(MADL);
daili.TIENNO = daili.TIENNO - TONGTIEN;
db.Entry(daili).State = EntityState.Modified;
db.SaveChanges();
}
return(RedirectToAction("Index"));
//return View(tt);
}
