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_history_stok_buku tabel_history_stok_buku = db.tabel_history_stok_buku.Find(id);
db.tabel_history_stok_buku.Remove(tabel_history_stok_buku);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id_histori_stok,nama_buku,penerbit_buku,tambahan_stok_buku")] tabel_history_stok_buku tabel_history_stok_buku)
{
if (ModelState.IsValid)
{
db.Entry(tabel_history_stok_buku).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tabel_history_stok_buku));
}
// GET: historystok/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tabel_history_stok_buku tabel_history_stok_buku = db.tabel_history_stok_buku.Find(id);
if (tabel_history_stok_buku == null)
{
return(HttpNotFound());
}
return(View(tabel_history_stok_buku));
}
