public ActionResult Client(int id) { List <SPinjamModel> SP = new List <SPinjamModel>(); var mode = from SPinjam in context.SPinjams where SPinjam.Id == id select new SPinjamModel() { IdUser = SPinjam.IdUser, Id = SPinjam.Id, PBuku = SPinjam.PBuku, WKembali = DateTime.Now, IdBuku = (int)SPinjam.IdBuku, Status = SPinjam.Status }; SP = mode.ToList(); int Id = 0, IdUser = 0, IdBuku = 0; string PBuku = "", Stat = ""; foreach (var s in SP) { Id = s.Id; IdUser = s.IdUser; PBuku = s.PBuku; IdBuku = s.IdBuku; Stat = s.Status; } if (Stat == "Dibalikan") { return(RedirectToAction("Confirm")); } TBaca baca = new TBaca() { Buku = PBuku, ReWaktu = DateTime.Now, IdUser = IdUser }; context.TBacas.InsertOnSubmit(baca); SPinjam buku = context.SPinjams.Where(some => some.Id == Id).Single <SPinjam>(); buku.Status = "Dibalikan"; /*int tmbh = 0; * var Add = from tambah in context.DBukus where tambah.Id == Id select tambah; * foreach (var tmb in Add) * tmbh = tmb.Jumlah;*/ DBuku book = context.DBukus.Where(some => some.Id == IdBuku).Single <DBuku>(); book.Jumlah = book.Jumlah + 1; context.SubmitChanges(); return(RedirectToAction("Confirm")); }
public ActionResult Create(string searchString) { TBaca buku = new TBaca() { Buku = searchString, ReWaktu = DateTime.Now, IdUser = (int)Session["KTP"] }; context.TBacas.InsertOnSubmit(buku); context.SubmitChanges(); return(RedirectToAction("Profil/" + (int)Session["KTP"])); }