public async Task <ActionResult> DeleteConfirmed(int id)
{
KreditDetail kreditDetail = await db.KreditDetail.FindAsync(id);
db.KreditDetail.Remove(kreditDetail);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public JsonResult SaveOrder(ViewModels.KreditDetailVM _kreditdetail)
{
bool status = false;
if (ModelState.IsValid)
{
var currentdate = DateTime.UtcNow;
var currentuser = db.Users.Where(x => x.UserName == User.Identity.Name).SingleOrDefault();
var kredit = new TransaksiKredit();
kredit.IdApprove = _kreditdetail.IdApprove;
kredit.Created = currentdate;
kredit.CreatedBy = currentuser;
db.TransaksiKredit.Add(kredit);
db.SaveChanges();
foreach (var item in _kreditdetail.KreditDetailList)
{
var inputkredit = new KreditDetail()
{
IdKredit = kredit.IdKredit,
Idunit = item.Idunit,
IdApprove = _kreditdetail.IdApprove,
DP = item.DP,
JumlahPinjam = item.JumlahPinjam,
Angsuran = item.Angsuran,
Periode = item.Periode,
Created = currentdate,
CreatedBy = currentuser,
Jumlah = item.Jumlah
};
db.KreditDetail.Add(inputkredit);
db.SaveChanges();
//update stok di barang
var unit = db.Units.Find(item.Idunit);
unit.Stok = unit.Stok - item.Jumlah;
db.Entry(unit).State = EntityState.Modified;
db.SaveChanges();
}
//db.SaveChanges();
status = true;
//update status valid idApprove
var idpermohonan = db.Permohonan.Find(_kreditdetail.IdApprove);
idpermohonan.IsnotValid = true;
db.Entry(idpermohonan).State = EntityState.Modified;
db.SaveChanges();
}
else
{
status = false;
}
return(new JsonResult {
Data = new { status = status }
});
}
public async Task <ActionResult> Edit([Bind(Include = "IdKreditDetail,IdKredit,IdApprove,DP,JumlahPinjam,Angsuran,Periode,IsDeleted,Created,Updated,Deleted,Approved")] KreditDetail kreditDetail)
{
if (ModelState.IsValid)
{
db.Entry(kreditDetail).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.IdApprove = new SelectList(db.Permohonan, "IdApprove", "Kode", kreditDetail.IdApprove);
ViewBag.IdKredit = new SelectList(db.TransaksiKredit, "IdKredit", "IdKredit", kreditDetail.IdKredit);
return(View(kreditDetail));
}
// GET: KreditDetails/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
KreditDetail kreditDetail = await db.KreditDetail.FindAsync(id);
if (kreditDetail == null)
{
return(HttpNotFound());
}
return(View(kreditDetail));
}
// GET: KreditDetails/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
KreditDetail kreditDetail = await db.KreditDetail.Include(x => x.Permohonan).Include(x => x.TransaksiKredit).Include(x => x.Unit).Include(x => x.Unit.NamaKategori).Where(x => x.IdKreditDetail == id).SingleOrDefaultAsync();
//KreditDetail kreditDetail = await db.KreditDetail.FindAsync(id);
if (kreditDetail == null)
{
return(HttpNotFound());
}
return(View(kreditDetail));
}
// GET: KreditDetails/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
KreditDetail kreditDetail = await db.KreditDetail.FindAsync(id);
if (kreditDetail == null)
{
return(HttpNotFound());
}
ViewBag.IdApprove = new SelectList(db.Permohonan, "IdApprove", "Kode", kreditDetail.IdApprove);
ViewBag.IdKredit = new SelectList(db.TransaksiKredit, "IdKredit", "IdKredit", kreditDetail.IdKredit);
return(View(kreditDetail));
}
public async Task <ActionResult> Create(ViewModels.KreditDetailVM _kreditdetail)
{
if (ModelState.IsValid)
{
var currentdate = DateTime.UtcNow;
var currentuser = await db.Users.Where(x => x.UserName == User.Identity.Name).SingleOrDefaultAsync();
var kredit = new TransaksiKredit();
kredit.IdApprove = _kreditdetail.IdApprove;
kredit.Created = currentdate;
kredit.CreatedBy = currentuser;
db.TransaksiKredit.Add(kredit);
await db.SaveChangesAsync();
var inputkredit = new KreditDetail()
{
IdKredit = kredit.IdKredit,
Idunit = _kreditdetail.Idunit,
IdApprove = _kreditdetail.IdApprove,
DP = _kreditdetail.DP,
JumlahPinjam = _kreditdetail.JumlahPinjam,
Angsuran = _kreditdetail.Angsuran,
Periode = _kreditdetail.Periode,
Created = currentdate,
CreatedBy = currentuser,
Jumlah = _kreditdetail.Jumlah
};
db.KreditDetail.Add(inputkredit);
await db.SaveChangesAsync();
//update status valid idApprove
var idpermohonan = await db.Permohonan.FindAsync(_kreditdetail.IdApprove);
idpermohonan.IsnotValid = true;
db.Entry(idpermohonan).State = EntityState.Modified;
await db.SaveChangesAsync();
//update stok di barang
var unit = await db.Units.FindAsync(_kreditdetail.Idunit);
unit.Stok = unit.Stok - _kreditdetail.Jumlah;
db.Entry(idpermohonan).State = EntityState.Modified;
await db.SaveChangesAsync();
//viewbag
var unit_category = await db.Categories.Where(x => x.IsDeleted == false).Select(i => new SelectListItem()
{
Text = i.Nama_kategori,
Value = i.Idkategori,
Selected = false
}).ToArrayAsync();
ViewBag.Category = unit_category;
return(RedirectToAction("Index"));
}
//ViewBag.IdApprove = new SelectList(db.Permohonan, "IdApprove", "Kode", kreditDetail.IdApprove);
//ViewBag.IdKredit = new SelectList(db.TransaksiKredit, "IdKredit", "IdKredit", kreditDetail.IdKredit);
return(View(_kreditdetail));
}
