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