public ActionResult DeleteConfirmed(int id)
{
tabel_peminjaman tabel_peminjaman = db.tabel_peminjaman.Find(id);
db.tabel_peminjaman.Remove(tabel_peminjaman);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "id_pengembalian,id_peminjaman, tanggal_kembali,denda")] tabel_pengembalian tabel_pengembalian, tabel_buku tabel_buku, tabel_peminjaman tabel_peminjaman)
{
try
{
var peminjaman = (from a in db.tabel_peminjaman where a.id_peminjaman == tabel_pengembalian.id_peminjaman && a.status == 1 select a).Single();
if (peminjaman == null)
{
db.tabel_pengembalian.Add(tabel_pengembalian);
//tabel_buku buku = db.tabel_buku.Find(tabel_peminjaman);
//buku.stok_buku += 1;
tabel_peminjaman status = db.tabel_peminjaman.Find(tabel_pengembalian.id_peminjaman);
status.status = 1;
tabel_peminjaman cari_buku = db.tabel_peminjaman.Find(tabel_pengembalian.id_peminjaman);
cari_buku.tabel_buku.stok_buku += 1;
db.SaveChanges();
return(RedirectToAction("Index"));
ViewBag.id_peminjaman = new SelectList(db.tabel_peminjaman, "id_peminjaman", "id_peminjaman");
return(View(tabel_pengembalian));
}
return(View("ErrorPage"));
}
catch (Exception e) {
db.tabel_pengembalian.Add(tabel_pengembalian);
//tabel_buku buku = db.tabel_buku.Find(tabel_peminjaman);
//buku.stok_buku += 1;
tabel_peminjaman status = db.tabel_peminjaman.Find(tabel_pengembalian.id_peminjaman);
status.status = 1;
tabel_peminjaman cari_buku = db.tabel_peminjaman.Find(tabel_pengembalian.id_peminjaman);
cari_buku.tabel_buku.stok_buku += 1;
db.SaveChanges();
return(RedirectToAction("Index"));
ViewBag.id_peminjaman = new SelectList(db.tabel_peminjaman, "id_peminjaman", "id_peminjaman");
return(View(tabel_pengembalian));
}
/*if (ModelState.IsValid)
* {
* db.tabel_pengembalian.Add(tabel_pengembalian);
* //tabel_buku buku = db.tabel_buku.Find(tabel_peminjaman);
* //buku.stok_buku += 1;
* tabel_peminjaman status = db.tabel_peminjaman.Find(tabel_pengembalian.id_peminjaman);
* status.status = 1;
* tabel_peminjaman cari_buku = db.tabel_peminjaman.Find(tabel_pengembalian.id_peminjaman);
* cari_buku.tabel_buku.stok_buku += 1;
* db.SaveChanges();
* return RedirectToAction("Index");
* }*/
ViewBag.id_peminjaman = new SelectList(db.tabel_peminjaman, "id_peminjaman", "id_peminjaman");
return(View(tabel_pengembalian));
}
public ActionResult Edit([Bind(Include = "id_peminjaman,id_peminjam,id_pegawai,id_buku,tanggal_peminjaman,tanggal_harus_kembali,status")] tabel_peminjaman tabel_peminjaman)
{
if (ModelState.IsValid)
{
db.Entry(tabel_peminjaman).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.id_buku = new SelectList(db.tabel_buku, "id_buku", "nama_buku", tabel_peminjaman.id_buku);
ViewBag.id_pegawai = new SelectList(db.tabel_pegawai, "id_pegawai", "nama_pegawai", tabel_peminjaman.id_pegawai);
ViewBag.id_peminjam = new SelectList(db.tabel_peminjam, "id_peminjam", "nama_peminjam", tabel_peminjaman.id_peminjam);
return(View(tabel_peminjaman));
}
// GET: peminjaman/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tabel_peminjaman tabel_peminjaman = db.tabel_peminjaman.Find(id);
if (tabel_peminjaman == null)
{
return(HttpNotFound());
}
return(View(tabel_peminjaman));
}
// GET: peminjaman/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tabel_peminjaman tabel_peminjaman = db.tabel_peminjaman.Find(id);
if (tabel_peminjaman == null)
{
return(HttpNotFound());
}
ViewBag.id_buku = new SelectList(db.tabel_buku, "id_buku", "nama_buku", tabel_peminjaman.id_buku);
ViewBag.id_pegawai = new SelectList(db.tabel_pegawai, "id_pegawai", "nama_pegawai", tabel_peminjaman.id_pegawai);
ViewBag.id_peminjam = new SelectList(db.tabel_peminjam, "id_peminjam", "nama_peminjam", tabel_peminjaman.id_peminjam);
return(View(tabel_peminjaman));
}
public ActionResult Create([Bind(Include = "id_peminjaman,id_peminjam,id_pegawai,id_buku,tanggal_peminjaman,tanggal_harus_kembali,status")] tabel_peminjaman tabel_peminjaman, tabel_buku tabel_buku)
{
if (ModelState.IsValid)
{
db.tabel_peminjaman.Add(tabel_peminjaman);
// Mengurangi Stock
tabel_buku buku = db.tabel_buku.Find(tabel_peminjaman.id_buku);
buku.stok_buku -= 1;
db.SaveChanges();
return(RedirectToAction("Index"));
}
//db.SaveChanges();
ViewBag.id_buku = new SelectList(db.tabel_buku, "id_buku", "nama_buku", tabel_peminjaman.id_buku);
ViewBag.id_pegawai = new SelectList(db.tabel_pegawai, "id_pegawai", "nama_pegawai", tabel_peminjaman.id_pegawai);
ViewBag.id_peminjam = new SelectList(db.tabel_peminjam, "id_peminjam", "nama_peminjam", tabel_peminjaman.id_peminjam);
return(View(tabel_peminjaman));
}
