public static PeminjamanViewModel ById(int id)
{
//Id Variant.Id
PeminjamanViewModel result = new PeminjamanViewModel();
using (var db = new XContext())
{
result = (from c in db.x_peminjaman
join d in db.x_book on c.book_id equals d.id into booklf
from d in booklf.DefaultIfEmpty()
join e in db.x_category on d.category_id equals e.Id into catlf
from e in catlf.DefaultIfEmpty()
join f in db.x_biodata on c.biodata_id equals f.id into biolf
from f in biolf.DefaultIfEmpty()
where c.id == id && c.is_delete == false
select new PeminjamanViewModel
{
Id = c.id,
BiodataId = c.biodata_id,
NPM = f.identity_number,
FullName = f.fullname,
CategoryId = d.category_id,
Name = e.name,
BookId = c.book_id,
Judul = d.judul,
Pegawai = c.pegawai,
TanggalPinjam = c.tanggal_pinjam,
TanggalKembali = c.tanggal_kembali,
Status = c.status,
Penulis = d.pengarang,
Penerbit = d.penerbit
}).FirstOrDefault();
}
return(result != null ? result : new PeminjamanViewModel());
}
public ActionResult Delete(PeminjamanViewModel model)
{
ResponseResult result = PeminjamanRepo.Delete(model);
return(Json(new
{
success = result.Success,
message = result.Message,
entity = result.Entity
}, JsonRequestBehavior.AllowGet));
}
//Create and Edit
public static ResponseResult Update(PeminjamanViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XContext())
{
#region Create New / Insert
if (entity.Id == 0)
{
x_peminjaman peminjaman = new x_peminjaman();
peminjaman.biodata_id = entity.BiodataId;
peminjaman.book_id = entity.BookId;
peminjaman.pegawai = entity.Pegawai;
peminjaman.tanggal_pinjam = entity.TanggalPinjam;
peminjaman.tanggal_kembali = entity.TanggalKembali;
peminjaman.status = "Dipinjam";
peminjaman.created_by = 1;
peminjaman.created_on = DateTime.Now;
db.x_peminjaman.Add(peminjaman);
db.SaveChanges();
result.Entity = entity;
}
#endregion
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
//Delete
public static ResponseResult Delete(PeminjamanViewModel entity)
{
ResponseResult result = new ResponseResult();
try
{
using (var db = new XContext())
{
x_peminjaman peminjaman = db.x_peminjaman
.Where(o => o.id == entity.Id)
.FirstOrDefault();
if (peminjaman != null)
{
peminjaman.deleted_by = 1;
peminjaman.deleted_on = DateTime.Now;
peminjaman.is_delete = true;
db.SaveChanges();
result.Entity = entity;
}
else
{
result.Success = false;
result.Message = "Data Not Found ! ";
}
}
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
