public ActionResult GetData() { using (OCBCTestEntities1 db = new OCBCTestEntities1()) { List <tm_Nasabah> empList = db.tm_Nasabah.Where(x => x.Status_FK == 1).ToList <tm_Nasabah>(); return(Json(new { data = empList }, JsonRequestBehavior.AllowGet)); } }
public ActionResult Delete(int id) { using (OCBCTestEntities1 db = new OCBCTestEntities1()) { tm_Nasabah emp = db.tm_Nasabah.Where(x => x.AccountID == id).FirstOrDefault <tm_Nasabah>(); emp.Status_FK = 2; db.SaveChanges(); return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult GetPoin(ReportProperty rp) { List <PointoCountList> result = new List <PointoCountList>(); using (OCBCTestEntities1 db = new OCBCTestEntities1()) { result = (from td in db.tt_Transaction join n in db.tm_Nasabah on td.AccountID equals n.AccountID select new PointoCountList { AccountID = td.AccountID, Nama = n.Nama, Amount = td.Amount, Description = td.Description }).ToList(); foreach (var item in result) { if (item.Description == "Beli Pulsa") { if (item.Amount > 30000) { item.poin += Convert.ToInt32((item.Amount / 1000) * 2); } else if (item.Amount > 10000) { item.poin += Convert.ToInt32((item.Amount / 1000)); } } else if (item.Description == "Bayar Listrik") { if (item.Amount > 100000) { item.poin += Convert.ToInt32((item.Amount / 2000) * 2); } else if (item.Amount > 50000) { item.poin += Convert.ToInt32((item.Amount / 2000)); } } } result = result.GroupBy(l => l.AccountID) .Select(cl => new PointoCountList { AccountID = cl.FirstOrDefault().AccountID, Nama = cl.FirstOrDefault().Nama, Description = "", Amount = 0, poin = cl.Sum(x => x.poin), }).ToList();; } return(Json(new { data = result }, JsonRequestBehavior.AllowGet)); }
public ActionResult AddOrEdit(int id = 0) { if (id == 0) { return(View(new tm_Nasabah())); } else { using (OCBCTestEntities1 db = new OCBCTestEntities1()) { return(View(db.tm_Nasabah.Where(x => x.AccountID == id).FirstOrDefault <tm_Nasabah>())); } } }
public ActionResult AddOrEdit(int id = 0) { if (id == 0) { return(View(new tt_Transaction())); } else { using (OCBCTestEntities1 db = new OCBCTestEntities1()) { return(View(db.tt_Transaction.Where(x => x.TransactionID == id).FirstOrDefault <tt_Transaction>())); } } }
// GET: Transaksi public ActionResult InputPage(int id) { if (id == 0) { return(RedirectToAction("Index", "Nasabah")); } else { using (OCBCTestEntities1 db = new OCBCTestEntities1()) { tm_Nasabah emp = db.tm_Nasabah.Where(x => x.AccountID == id).FirstOrDefault <tm_Nasabah>(); return(View(emp)); } } }
public ActionResult AddOrEdit(tt_Transaction emp) { using (OCBCTestEntities1 db = new OCBCTestEntities1()) { if (emp.TransactionID == 0) { db.tt_Transaction.Add(emp); db.SaveChanges(); return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet)); } else { db.Entry(emp).State = EntityState.Modified; db.SaveChanges(); return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet)); } } }
public ActionResult GetData(int id) { List <Transaksi> res = new List <Transaksi>(); using (OCBCTestEntities1 db = new OCBCTestEntities1()) { res = (from x in db.tt_Transaction where x.AccountID == id select new Transaksi { TransactionID = x.TransactionID, AccountID = x.AccountID, TransDate = x.TransDate.ToString(), Description = x.Description, DebitCreditStatus = x.DebitCreditStatus, Amount = x.Amount }).ToList(); } return(Json(new { data = res }, JsonRequestBehavior.AllowGet)); }
public ActionResult GetData(ReportProperty rp) { List <Transaksi> result = new List <Transaksi>(); using (OCBCTestEntities1 db = new OCBCTestEntities1()) { result = (from x in db.tt_Transaction where x.AccountID == rp.Operator && (x.TransDate >= rp.startdate && x.TransDate <= rp.enddate) select new Transaksi { TransactionID = x.TransactionID, AccountID = x.AccountID, TransDate = x.TransDate.ToString(), Description = x.Description, DebitCreditStatus = x.DebitCreditStatus, Amount = x.Amount }).ToList(); } return(Json(new { data = result }, JsonRequestBehavior.AllowGet)); }