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"]));
}
