public ActionResult Create([Bind(Include = "ID,SachID,HocSinhID,NgayMuon,HanTra,NgayTra")] MuonTraSach muonTraSach, string tenHS, string tenSach) { string temp_tenHS = tenHS; string temp_tenSach = tenSach; var hoc_sinh = from h in db.HocSinh select h; var sach = from s in db.Sach select s; if (!string.IsNullOrEmpty(tenHS)) { hoc_sinh = hoc_sinh.Where(h => h.TenHS.Contains(temp_tenHS)); } if (!string.IsNullOrEmpty(tenSach)) { sach = sach.Where(s => s.TenSach.Contains(temp_tenSach)); } if (ModelState.IsValid) { // kiểm tra số luọng sách học sinh đã mượn var mts = from m in db.MuonTraSach where m.HocSinhID == muonTraSach.HocSinhID && m.NgayTra == null select m; if (mts.Count() < 5) // nếu nhỏ hơn 5 thì cho mượn sách { // kiểm tra đã quá hạn trả sách chưa var mts2 = from m in mts where m.HanTra < DateTime.Now select m; if (mts2.Count() > 0) //có sách quá hạn trả { return(RedirectToAction("Create", new { tenHS = temp_tenHS, confirmed = "yes", stt = "expired" })); } else //không có sách đến hạn trả, đc phếp mượn { // update trạng thái sach Sach s = db.Sach.Single(c => c.ID == muonTraSach.SachID); s.TrangThai = TrangThai.DangMuon; db.SaveChanges(); // cho mượn db.MuonTraSach.Add(muonTraSach); db.SaveChanges(); return(RedirectToAction("Create", new { tenHS = temp_tenHS, confirmed = "yes" })); } } else { return(RedirectToAction("Create", new { tenHS = temp_tenHS, confirmed = "yes", stt = "limited" })); } } ViewBag.HocSinhID = new SelectList(db.HocSinh, "ID", "TenHS", muonTraSach.HocSinhID); ViewBag.SachID = new SelectList(db.Sach, "ID", "SachID", muonTraSach.SachID); return(View(muonTraSach)); }
public ActionResult ExportToExcel(string id) { MuonTraSach obj = db.MuonTraSaches.Find(id); XLWorkbook workbook = new XLWorkbook(); IXLWorksheet worksheet = workbook.Worksheets.Add("newSheet"); worksheet.Cell(1, 1).SetValue("PHIẾU MƯỢN SÁCH"); worksheet.Cell(3, 1).SetValue("Mã mượ trả: " + obj.MaMuonTra); worksheet.Cell(4, 1).SetValue("Mã số thẻ: " + obj.MaSoThe); worksheet.Cell(5, 1).SetValue("Mã sách: " + obj.MaSach); worksheet.Cell(6, 1).SetValue("Tên sách: " + obj.Sach.TenSach); worksheet.Cell(7, 1).SetValue("Ngày mượn sách: " + obj.NgayMuonSach.Value.ToShortDateString()); worksheet.Cell(8, 1).SetValue("Hạn trả sách: " + obj.HanTraSach.Value.ToShortDateString()); worksheet.Cell(9, 1).SetValue("Tình trạng khi mượn: " + obj.TinhTrangKhiMuon); worksheet.Cell(10, 1).SetValue("Ghi chú: " + obj.GhiChu); worksheet.Cell(12, 1).SetValue("Yêu cầu bạn đọc giữ gìn sách cẩn thận, trả sách đúng hạn."); worksheet.Cell(14, 1).SetValue("Thư viện Học viện Kỹ thuật Quân sự"); MemoryStream MS = new MemoryStream(); workbook.SaveAs(MS); MS.Position = 0; return(new FileStreamResult(MS, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") { FileDownloadName = "Example.xlsx" }); }
public ActionResult DeleteConfirmed(int id) { MuonTraSach muonTraSach = db.MuonTraSach.Find(id); db.MuonTraSach.Remove(muonTraSach); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "MaMuonTra, MaSoThe, MaSach, NgayMuonSach, HanTraSach, TinhTrangKhiMuon, DaTra, NgayTraSach, TinhTrangKhiTra, GhiChu")] MuonTraSach obj) { if (ModelState.IsValid) { db.Entry(obj).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(obj)); }
public ActionResult Edit([Bind(Include = "ID,SachID,HocSinhID,NgayMuon,HanTra,NgayTra")] MuonTraSach muonTraSach) { if (ModelState.IsValid) { db.Entry(muonTraSach).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.HocSinhID = new SelectList(db.HocSinh, "ID", "TenHS", muonTraSach.HocSinhID); ViewBag.SachID = new SelectList(db.Sach, "ID", "SachID", muonTraSach.SachID); return(View(muonTraSach)); }
public ActionResult Create([Bind(Include = "MaMuonTra, MaSoThe, MaSach, NgayMuonSach, HanTraSach, TinhTrangKhiMuon, DaTra, NgayTraSach, TinhTrangKhiTra, GhiChu")] MuonTraSach obj) { if (ModelState.IsValid) { obj.DaTra = false; db.MuonTraSaches.Add(obj); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(obj)); }
// GET: MuonTraSach/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MuonTraSach muonTraSach = db.MuonTraSach.Find(id); if (muonTraSach == null) { return(HttpNotFound()); } return(View(muonTraSach)); }
// GET: TTNhom_QLThuVien/BorrowGiveBack/Details/5 public ActionResult Details(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MuonTraSach obj = db.MuonTraSaches.Find(id); if (obj == null) { return(HttpNotFound()); } return(View(obj)); }
public ActionResult Delete(string id) { try { MuonTraSach obj = db.MuonTraSaches.Find(id); db.MuonTraSaches.Remove(obj); db.SaveChanges(); return(RedirectToAction("Index")); } catch (Exception) { return(View("Error")); } }
public void MuonSach(int id, MuonSachModel model) { var entity = new MuonTraSach() { SachId = id, DocGiaId = model.DocGiaId, // SachId = model.SachId, NgayMuon = model.NgayMuon }; var docGia = _docGiaRepository.Get(model.DocGiaId); _muonTraSachRepository.Insert(entity); docGia.SoSachDangMuon += 1; _docGiaRepository.Update(docGia); }
// GET: MuonTraSach/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MuonTraSach muonTraSach = db.MuonTraSach.Find(id); if (muonTraSach == null) { return(HttpNotFound()); } ViewBag.HocSinhID = new SelectList(db.HocSinh, "ID", "TenHS", muonTraSach.HocSinhID); ViewBag.SachID = new SelectList(db.Sach, "ID", "SachID", muonTraSach.SachID); return(View(muonTraSach)); }
public ActionResult TraSach([Bind(Include = "ID,SachID,HocSinhID,NgayMuon,HanTra,NgayTra")] MuonTraSach muonTraSach) { if (ModelState.IsValid) { // update trạng thái sach Sach s = db.Sach.Single(c => c.ID == muonTraSach.SachID); s.TrangThai = TrangThai.CoSan; db.SaveChanges(); // update muontrasach MuonTraSach mts = db.MuonTraSach.First(m => m.ID == muonTraSach.ID); mts.NgayTra = DateTime.Now; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.HocSinhID = new SelectList(db.HocSinh, "ID", "TenHS", muonTraSach.HocSinhID); ViewBag.SachID = new SelectList(db.Sach, "ID", "IDandTen", muonTraSach.SachID); return(View(muonTraSach)); }
// GET: TTNhom_QLThuVien/BorrowGiveBack/Edit/5 public ActionResult Edit(string id) { List <TheThuVien> card = db.TheThuViens.ToList(); List <Sach> book = db.Saches.ToList(); SelectList cardList = new SelectList(card, "MaSoThe", "MaSoThe", "MaSoThe"); SelectList bookList = new SelectList(book, "MaSach", "TenSach", "MaSach"); ViewBag.CardList = cardList; ViewBag.BookList = bookList; if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } MuonTraSach obj = db.MuonTraSaches.Find(id); if (obj == null) { return(HttpNotFound()); } return(View(obj)); }