public ActionResult Create([Bind(Include = "id_histori_stok,nama_buku,penerbit_buku,tambahan_stok_buku")] tabel_history_stok_buku tabel_history_stok_buku)
{
tabel_buku buku = new tabel_buku();
var contex = new perpustakaan3Entities();
var add = (from a in db.tabel_buku where a.nama_buku == tabel_history_stok_buku.nama_buku && a.penerbit_buku == tabel_history_stok_buku.penerbit_buku select a).SingleOrDefault();
if (add != null)
{
add.stok_buku += tabel_history_stok_buku.tambahan_stok_buku;
db.tabel_history_stok_buku.Add(tabel_history_stok_buku);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else if (add == null)
{
buku.nama_buku = tabel_history_stok_buku.nama_buku;
buku.penerbit_buku = tabel_history_stok_buku.penerbit_buku;
buku.stok_buku = tabel_history_stok_buku.tambahan_stok_buku;
db.tabel_buku.Add(buku);
db.tabel_history_stok_buku.Add(tabel_history_stok_buku);
db.SaveChanges();
return(RedirectToAction("Index"));
}
/*
* if (ModelState.IsValid)
* {
* db.tabel_history_stok_buku.Add(tabel_history_stok_buku);
* db.SaveChanges();
* return RedirectToAction("Index");
* }*/
return(View(tabel_history_stok_buku));
}
public ActionResult DeleteConfirmed(int id)
{
tabel_buku tabel_buku = db.tabel_buku.Find(id);
db.tabel_buku.Remove(tabel_buku);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id_buku,nama_buku,penerbit_buku,stok_buku")] tabel_buku tabel_buku)
{
if (ModelState.IsValid)
{
db.Entry(tabel_buku).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tabel_buku));
}
public ActionResult Create([Bind(Include = "id_buku,nama_buku,penerbit_buku,stok_buku")] tabel_buku tabel_buku)
{
if (ModelState.IsValid)
{
db.tabel_buku.Add(tabel_buku);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tabel_buku));
}
// GET: buku/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tabel_buku tabel_buku = db.tabel_buku.Find(id);
if (tabel_buku == null)
{
return(HttpNotFound());
}
return(View(tabel_buku));
}
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));
}
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));
}
