public ActionResult GetBuku() { BukuEntities db = new BukuEntities(); var coll = db.tblM_Buku.ToList(); return(Json(coll, JsonRequestBehavior.AllowGet)); }
public JsonResult Tambah(Peminjaman a) { bool status = false; if (ModelState.IsValid) { using (BukuEntities op = new BukuEntities()) { buku aspek = new buku { judul = a.judul }; notaPinjam nota = new notaPinjam { tanggalPinjam = a.tanggalPinjam }; foreach (var item in a.detailpinjam) { aspek.detailPinjam.Add(item); nota.detailPinjam.Add(item); } op.buku.Add(aspek); op.notaPinjam.Add(nota); op.SaveChanges(); status = true; } } else { status = false; } return(new JsonResult { Data = new { status = status } }); }
public JsonResult SavePinjam(Peminjaman O) { bool status = false; if (ModelState.IsValid) { using (BukuEntities dc = new BukuEntities()) { detailPinjam order = new detailPinjam(); notaPinjam not = new notaPinjam { tanggalPinjam = O.tanggalPinjam }; foreach (var i in O.detailpinjam) { not.detailPinjam.Add(i); } //dc.detailPinjam.Add(order); dc.notaPinjam.Add(not); dc.SaveChanges(); status = true; } } else { status = false; } return(new JsonResult { Data = new { status = status } }); }
// GET: Buku public ActionResult Index() { List <buku> p; using (var r = new BukuEntities()) { p = r.buku.ToList(); } return(View(p)); }
public ActionResult Edit_Get(int code) { var BukuModel = new buku(); TryUpdateModel(BukuModel); using (var r = new BukuEntities()) { BukuModel = r.buku.Where(x => x.Id == code).FirstOrDefault(); } return(View(BukuModel)); }
public ActionResult Create_Post() { var BukuModel = new buku(); TryUpdateModel(BukuModel); using (var r = new BukuEntities()) { r.buku.Add(BukuModel); r.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult Edit_Post(int code) { var BukuModel = new buku(); TryUpdateModel(BukuModel); using (var r = new BukuEntities()) { var b = r.buku.Where(x => x.Id == code).FirstOrDefault(); TryUpdateModel(b); r.SaveChanges(); } return(RedirectToAction("Index")); }
public ActionResult ExportData() { BukuEntities db = new BukuEntities(); List <TblM_Transaksi> TblM_Transaksi = db.TblM_Transaksi.ToList(); List <transaksiModel> transaksiLs = new List <transaksiModel>(); foreach (TblM_Transaksi item in TblM_Transaksi) { transaksiModel TransaksiItem = new transaksiModel(); string NamaUser = db.AspNetUsers.Where(x => x.Id == item.UserId).FirstOrDefault().UserName; string NamaBuku = db.tblM_Buku.Where(x => x.ID == item.BukuId).FirstOrDefault().Nama; TransaksiItem.ID = item.ID; TransaksiItem.NamaUser = NamaUser; TransaksiItem.NamaBuku = NamaBuku; TransaksiItem.Jumlah = item.Jumlah; TransaksiItem.Total = item.Total; transaksiLs.Add(TransaksiItem); } DataTable dt = ConvertToDataTable(transaksiLs); using (XLWorkbook wb = new XLWorkbook()) { var ws = wb.Worksheets.Add(dt, "transaksi"); ws.Tables.FirstOrDefault().ShowAutoFilter = false; MemoryStream stream = GetStream(wb); Response.Clear(); Response.Buffer = true; Response.AddHeader("content-disposition", "attachment; filename=transaksi.xlsx"); Response.ContentType = "application/octet-stream"; Response.BinaryWrite(stream.ToArray()); Response.End(); } return(null); }