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();
}
