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