public ActionResult Pinjam(int id) { //int j = int.Parse(Session["User"].ToString()); DBukuModel mode = context.DBukus.Where(model => model.Id == id).Select(model => new DBukuModel() { Judul = model.Judul, Penerbit = model.Penerbit, LTerbit = model.LTerbit, Pengarang = model.Pengarang, Jumlah = model.Jumlah, IdBuku = (int)model.IdBuku, Images = model.Images, Id = model.Id, }).SingleOrDefault(); int ka = (int)Session["KTP"]; DateTime now = DateTime.Now; Pinjam p = new Pinjam() { WPinjam = DateTime.Today, IdUser = (int)Session["KTP"], PBuku = mode.Judul, IdBuku = mode.Id }; context.Pinjams.InsertOnSubmit(p); context.SubmitChanges(); return(RedirectToAction("DaftarBuku")); }
public void DeletePinjam(Pinjam model) { if (model == null) { throw new ArgumentNullException(nameof(model)); } _context.Pinjam.Remove(model); }
public void CreatePinjam(Pinjam model) { if (model == null) { throw new ArgumentNullException(nameof(model)); } _context.Pinjam.Add(model); }
public ActionResult Acc(int id) { List <PinjamModel> SP = new List <PinjamModel>(); var mode = from Pinjam in context.Pinjams join Biodata in context.Biodatas on Pinjam.Id equals id select new PinjamModel() { IdUser = Pinjam.IdUser, Id = Pinjam.Id, User = Biodata.Username, PBuku = Pinjam.PBuku, WPinjam = DateTime.Now, IdBuku = (int)Pinjam.IdBuku }; SP = mode.Distinct().ToList(); int Id = 0, IdUser = 0, IdBuku = 0; string PBuku = ""; foreach (var s in SP) { Id = s.Id; IdUser = s.IdUser; PBuku = s.PBuku; IdBuku = s.IdBuku; } SPinjam spinjam = new SPinjam() { IdUser = IdUser, PBuku = PBuku, IdBuku = IdBuku, Status = "Dipinjam", WKembali = DateTime.Now.AddDays(7) }; DBuku book = context.DBukus.Where(some => some.Id == IdBuku).Single <DBuku>(); book.Jumlah = book.Jumlah - 1; context.SPinjams.InsertOnSubmit(spinjam); context.SubmitChanges(); Pinjam buku = context.Pinjams.Where(some => some.Id == id).Single <Pinjam>(); context.Pinjams.DeleteOnSubmit(buku); context.SubmitChanges(); return(RedirectToAction("Confirm")); }
public IActionResult Create() { Pinjam pinjamModel = new Pinjam(); using (ApplicationDbContext db = new ApplicationDbContext()) { pinjamModel.anggotaCollection = db.Anggota.ToList <Anggota>(); pinjamModel.bukuCollection = db.Buku.ToList <Buku>(); pinjamModel.pegawaiCollection = db.Pegawai.ToList <Pegawai>(); } return(View(pinjamModel)); }
public async Task <IActionResult> Create(Pinjam obj) { if (ModelState.IsValid) { Pinjam p = new Pinjam(); p.TglPinjam = obj.TglPinjam; p.TglKembali = obj.TglKembali; p.Kembali = "0"; p.KodeBuku1 = obj.KodeBuku1; p.Nip1 = obj.Nip1; p.NoKtp1 = obj.NoKtp1; _context.Pinjam.Add(p); _context.SaveChanges(); await _context.SaveChangesAsync(); return(RedirectToAction("Index", "Peminjaman")); } return(View("Index")); }
private void button6_Click(object sender, EventArgs e) { var film_title = cb_filmtitle.SelectedItem.ToString(); var member_name = cb_membername.SelectedItem.ToString(); var rental_date = dt_rentalDate.Value.ToShortDateString(); var return_date = dt_returnDate.Value.ToShortDateString(); var status = cb_status.SelectedItem.ToString(); Pinjam pj = new Pinjam { Title = film_title, MemberName = member_name, RentalDate = DateTime.Parse(rental_date), ReturnDate = DateTime.Parse(return_date), Status = status }; pinjam.InsertOne(pj); ReadDataPinjam(); reset(); }
public void UpdatePinjam(Pinjam model) { // throw new NotImplementedException(); }