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 Create([Bind(Include = "id_peminjam,nama_peminjam,alamat_peminjam,password_peminjam")] tabel_peminjam tabel_peminjam) { if (ModelState.IsValid) { db.tabel_peminjam.Add(tabel_peminjam); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tabel_peminjam)); }
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)); }
public ActionResult Create([Bind(Include = "id_pegawai,nama_pegawai,password_pegawai")] tabel_pegawai tabel_pegawai) { if (ModelState.IsValid) { db.tabel_pegawai.Add(tabel_pegawai); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(tabel_pegawai)); }
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 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)); }