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