public JsonResult save(XuatSachDetail O) { bool status = false; if (ModelState.IsValid) { XuatSachDetail u = db.XuatSachDetails.Where(x => x.xuatsachID == O.xuatsachID && x.fk_sachID == O.fk_sachID).SingleOrDefault(); if (u != null) { u.soluong += O.soluong; } else { XuatSachDetail order = new XuatSachDetail { xuatsachID = O.xuatsachID, fk_sachID = O.fk_sachID, soluong = O.soluong }; db.XuatSachDetails.Add(order); } XuatSachMaster m = db.XuatSachMasters.Where(x => x.xuatsachID == O.xuatsachID).SingleOrDefault(); Sach s = db.Saches.Where(x => x.sachID == O.fk_sachID).SingleOrDefault(); m.xuatsach_tongtien += O.soluong * s.sach_giaxuat; db.SaveChanges(); status = true; } return(new JsonResult { Data = new { status = status } }); }
public JsonResult DLDatsach(int orderId) { bool result = false; XuatSachMaster h = db.XuatSachMasters.Where(x => x.xuatsachID == orderId).SingleOrDefault(); if (h != null) { if (h.xuatsach_tongtien > 0) { h.xuatsach_trangthai = "Đã Đặt Sách"; db.SaveChanges(); result = true; } } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult TaoMoi() { XuatSachMaster xs = new XuatSachMaster { xuatsach_ngayorder = DateTime.Now, fk_dailyID = int.Parse(Session["DaiLyId"].ToString()), xuatsach_ngayupdate = new DateTime(2000, 01, 01), xuatsach_nguoinhan = "", xuatsach_tongtien = 0, xuatsach_trangthai = "Chưa Đặt Sách" }; db.XuatSachMasters.Add(xs); db.SaveChanges(); return(Json(JsonRequestBehavior.AllowGet)); }
public JsonResult DatSach(int orderID) { bool result; XuatSachMaster k = db.XuatSachMasters.Where(x => x.xuatsachID == orderID && x.xuatsach_trangthai == "Chưa Đặt Sách").SingleOrDefault(); if (k != null) { result = true; } else { result = false; } return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult huyphieu(XuatSachMaster O) { bool status = false; if (ModelState.IsValid) { XuatSachMaster order = db.XuatSachMasters.Where(x => x.xuatsachID == O.xuatsachID).SingleOrDefault(); order.xuatsach_ngayupdate = O.xuatsach_ngayupdate; order.xuatsach_trangthai = "Hủy"; db.SaveChanges(); status = true; } return(new JsonResult { Data = new { status = status } }); }
public JsonResult save(XuatSachMaster O) { int dlyID = int.Parse(Session["dailyID"].ToString()); bool status = false; if (ModelState.IsValid) { XuatSachMaster order = db.XuatSachMasters.Where(x => x.xuatsachID == O.xuatsachID).SingleOrDefault(); order.xuatsach_ngayupdate = O.xuatsach_ngayupdate; order.xuatsach_nguoinhan = O.xuatsach_nguoinhan; order.xuatsach_trangthai = "Hoàn Tất"; List <XuatSachDetail> dt = db.XuatSachDetails.Where(x => x.xuatsachID == O.xuatsachID).ToList(); int sumsl = 0; foreach (var i in dt) { sumsl += int.Parse(i.soluong.ToString()); } foreach (var i in dt) { DaiLyDebt l = db.DaiLyDebts.SingleOrDefault(x => x.fk_sachID == i.fk_sachID && x.fk_dailyID == dlyID); if (l != null) { l.dailydebt_soluong += i.soluong; } else { DaiLyDebt k = new DaiLyDebt { fk_dailyID = dlyID, fk_sachID = i.fk_sachID, dailydebt_soluong = i.soluong }; db.DaiLyDebts.Add(k); } } foreach (var i in dt) { Sach w = db.Saches.SingleOrDefault(x => x.sachID == i.fk_sachID); w.sach_soluong -= i.soluong; } List <DaiLyDebtTien> li = db.DaiLyDebtTiens.Where(x => x.fk_dailyID == dlyID).ToList(); var maxdate = li.Select(x => x.dailydebttien_ngaycapnhat).Max(); DaiLyDebtTien n = db.DaiLyDebtTiens.Where(s => s.fk_dailyID == dlyID && s.dailydebttien_ngaycapnhat == maxdate).FirstOrDefault(); if (n != null) { if (O.xuatsach_ngayupdate == n.dailydebttien_ngaycapnhat) { n.dailydebttien_tien += O.xuatsach_tongtien; n.dailydebttien_sach += sumsl; } else if (O.xuatsach_ngayupdate > n.dailydebttien_ngaycapnhat) { n.dailydebttien_tien += O.xuatsach_tongtien; n.dailydebttien_sach += sumsl; n.fk_dailyID = dlyID; n.dailydebttien_ngaycapnhat = O.xuatsach_ngayupdate; db.DaiLyDebtTiens.Add(n); } else if (O.xuatsach_ngayupdate < n.dailydebttien_ngaycapnhat) { List <DaiLyDebtTien> dd = db.DaiLyDebtTiens.Where(x => x.fk_dailyID == dlyID && x.dailydebttien_ngaycapnhat >= O.xuatsach_ngayupdate).ToList(); foreach (var c in dd) { c.dailydebttien_tien += O.xuatsach_tongtien; c.dailydebttien_sach += sumsl; } DaiLyDebtTien m = db.DaiLyDebtTiens.Where(x => x.fk_dailyID == dlyID && x.dailydebttien_ngaycapnhat == O.xuatsach_ngayupdate).SingleOrDefault(); if (m == null) { DaiLyDebtTien v = new DaiLyDebtTien { fk_dailyID = dlyID, dailydebttien_tien = O.xuatsach_tongtien, dailydebttien_sach = sumsl, dailydebttien_ngaycapnhat = O.xuatsach_ngayupdate }; db.DaiLyDebtTiens.Add(v); } } } else { DaiLyDebtTien q = new DaiLyDebtTien { fk_dailyID = dlyID, dailydebttien_tien = O.xuatsach_tongtien, dailydebttien_sach = sumsl, dailydebttien_ngaycapnhat = O.xuatsach_ngayupdate }; db.DaiLyDebtTiens.Add(q); } foreach (var i in dt) { List <TonKho> la = db.TonKhoes.Where(x => x.fk_sachID == i.fk_sachID).ToList(); var maxdate1 = la.Select(x => x.tonkho_ngaycapnhat).Max(); TonKho u = db.TonKhoes.Where(s => s.fk_sachID == i.fk_sachID && s.tonkho_ngaycapnhat == maxdate1).FirstOrDefault(); if (u != null) { if (O.xuatsach_ngayupdate == u.tonkho_ngaycapnhat) { u.tonkho_soluong += i.soluong; } else if (O.xuatsach_ngayupdate > u.tonkho_ngaycapnhat) { u.tonkho_soluong += i.soluong; u.fk_sachID = i.fk_sachID; u.tonkho_ngaycapnhat = O.xuatsach_ngayupdate; db.TonKhoes.Add(u); } else if (O.xuatsach_ngayupdate < u.tonkho_ngaycapnhat) { List <TonKho> bb = db.TonKhoes.Where(x => x.fk_sachID == i.fk_sachID && x.tonkho_ngaycapnhat >= O.xuatsach_ngayupdate).ToList(); foreach (var c in bb) { c.tonkho_soluong += i.soluong; } TonKho h = db.TonKhoes.Where(x => x.fk_sachID == i.fk_sachID && x.tonkho_ngaycapnhat == O.xuatsach_ngayupdate).SingleOrDefault(); if (h == null) { TonKho a = new TonKho { fk_sachID = i.fk_sachID, tonkho_soluong = i.soluong, tonkho_ngaycapnhat = O.xuatsach_ngayupdate }; db.TonKhoes.Add(a); } } } else { TonKho p = new TonKho { fk_sachID = i.fk_sachID, tonkho_soluong = i.soluong, tonkho_ngaycapnhat = O.xuatsach_ngayupdate }; db.TonKhoes.Add(p); } } } db.SaveChanges(); status = true; return(new JsonResult { Data = new { status = status } }); }