public ActionResult Edit(TransaksiSimpananModel simpan) { KoperasiEntities2 db = new KoperasiEntities2(); List <anggota> list2 = db.anggotas.ToList(); List <simpanan> list1 = db.simpanans.ToList(); ViewBag.anggotaList2 = new SelectList(list2, "no_anggota", "nama_ang"); ViewBag.simpananList = new SelectList(list1, "kd_simp", "jns_simp"); using (SqlConnection sqlcon = new SqlConnection(connectionString)) { string query = "UPDATE trans_simpanan SET no_simpan=@no_simpan, no_ang = @no_ang, tglsimpan=@tglsimpan, jenis=@jenis, saldo=@saldo Where id_tsimpan = @id_tsimpan"; SqlCommand sqlCmd = new SqlCommand(query, sqlcon); sqlCmd.Connection.Open(); sqlCmd.Parameters.AddWithValue("@id_tsimpan", simpan.id_tsimpan); sqlCmd.Parameters.AddWithValue("@no_simpan", simpan.no_simpan); sqlCmd.Parameters.AddWithValue("@tglsimpan", simpan.tglsimpan); sqlCmd.Parameters.AddWithValue("@jenis", simpan.jenis); sqlCmd.Parameters.AddWithValue("@saldo", simpan.saldo); sqlCmd.Parameters.AddWithValue("@no_ang", simpan.no_ang); sqlCmd.ExecuteNonQuery(); } return(RedirectToAction("Index")); }
// GET: TransaksiPinjaman/Create public ActionResult Create() { if (Session["id"] == null) { return(RedirectToAction("Index", "Login")); } KoperasiEntities2 db = new KoperasiEntities2(); List <anggota> list = db.anggotas.ToList(); List <pinjaman> list1 = db.pinjamen.ToList(); ViewBag.anggotaList = new SelectList(list, "no_anggota", "nama_ang"); ViewBag.pinjamanList = new SelectList(list1, "kd_pinj", "jns_pinj"); return(View()); }
public ActionResult Create(TransaksiPinjamanModel pinjam) { if (Session["id"] == null) { return(RedirectToAction("Index", "Login")); } using (SqlConnection sqlcon = new SqlConnection(connectionString)) { DataTable dtbSimpan = new DataTable(); sqlcon.Open(); KoperasiEntities2 db = new KoperasiEntities2(); List <anggota> list = db.anggotas.ToList(); List <pinjaman> list1 = db.pinjamen.ToList(); ViewBag.anggotaList = new SelectList(list, "no_anggota", "nama_ang"); ViewBag.pinjamanList = new SelectList(list1, "kd_pinj", "jns_pinj"); string query = "SELECT bunga FROM pinjaman where kd_pinj = @kd_pinj"; SqlDataAdapter sqlCmd = new SqlDataAdapter(query, sqlcon); sqlCmd.SelectCommand.Parameters.AddWithValue("@kd_pinj", pinjam.kd_pinj); sqlCmd.Fill(dtbSimpan); trans_pinjaman tpinjam = new trans_pinjaman(); Peminjaman objpinjam = new Peminjaman(); var bunga = Convert.ToDouble(dtbSimpan.Rows[0][0].ToString()); var jumlah = pinjam.jlh; var bungaTot = objpinjam.totalPeminjaman(bunga, jumlah); var total = bungaTot + jumlah; var angsuran = total / pinjam.lama; tpinjam.no_ang = pinjam.no_ang; tpinjam.jlh = pinjam.jlh; tpinjam.keterangan = pinjam.keterangan; tpinjam.lama = pinjam.lama; tpinjam.bunga = Convert.ToDouble(dtbSimpan.Rows[0][0].ToString()); tpinjam.status = "Belum Lunas"; tpinjam.kd_pinj = pinjam.kd_pinj; tpinjam.tglpinj = pinjam.tglpinj; tpinjam.total = total; tpinjam.angsuran = angsuran; db.trans_pinjaman.Add(tpinjam); db.SaveChanges(); } return(RedirectToAction("Index")); }
// GET: TransaksiPinjaman/Edit/5 public ActionResult Edit(int id) { if (Session["id"] == null) { return(RedirectToAction("Index", "Login")); } KoperasiEntities2 db = new KoperasiEntities2(); List <anggota> list = db.anggotas.ToList(); List <pinjaman> list1 = db.pinjamen.ToList(); ViewBag.anggotaList = new SelectList(list, "no_anggota", "nama_ang"); ViewBag.pinjamanList = new SelectList(list1, "kd_pinj", "jns_pinj"); TransaksiPinjamanModel Tpinjam = new TransaksiPinjamanModel(); DataTable dtbSimpan = new DataTable(); using (SqlConnection sqlcon = new SqlConnection(connectionString)) { sqlcon.Open(); string query = "SELECT * FROM trans_pinjaman where no_pinj = @no_pinj"; SqlDataAdapter sqlCmd = new SqlDataAdapter(query, sqlcon); sqlCmd.SelectCommand.Parameters.AddWithValue("@no_pinj", id); sqlCmd.Fill(dtbSimpan); } if (dtbSimpan.Rows.Count == 1) { Tpinjam.no_pinj = Convert.ToInt32(dtbSimpan.Rows[0][0].ToString()); Tpinjam.tglpinj = Convert.ToDateTime(dtbSimpan.Rows[0][1].ToString()); Tpinjam.bunga = Convert.ToDouble(dtbSimpan.Rows[0][2].ToString()); Tpinjam.jlh = Convert.ToDouble(dtbSimpan.Rows[0][3].ToString()); Tpinjam.total = Convert.ToDouble(dtbSimpan.Rows[0][4].ToString()); Tpinjam.angsuran = Convert.ToDouble(dtbSimpan.Rows[0][5].ToString()); Tpinjam.status = dtbSimpan.Rows[0][6].ToString(); Tpinjam.kd_pinj = dtbSimpan.Rows[0][7].ToString(); Tpinjam.no_ang = dtbSimpan.Rows[0][8].ToString(); Tpinjam.keterangan = dtbSimpan.Rows[0][9].ToString(); Tpinjam.lama = Convert.ToDouble(dtbSimpan.Rows[0][10].ToString()); return(View(Tpinjam)); } else { return(RedirectToAction("Index")); } }
public ActionResult Edit(TransaksiPinjamanModel pinjam) { if (Session["id"] == null) { return(RedirectToAction("Index", "Login")); } KoperasiEntities2 db = new KoperasiEntities2(); List <anggota> list = db.anggotas.ToList(); List <pinjaman> list1 = db.pinjamen.ToList(); ViewBag.anggotaList = new SelectList(list, "no_anggota", "nama_ang"); ViewBag.pinjamanList = new SelectList(list1, "kd_pinj", "jns_pinj"); using (SqlConnection sqlcon = new SqlConnection(connectionString)) { DataTable dtbSimpan = new DataTable(); sqlcon.Open(); string query2 = "SELECT bunga FROM pinjaman where kd_pinj = @kd_pinj"; SqlDataAdapter sqlCmd2 = new SqlDataAdapter(query2, sqlcon); sqlCmd2.SelectCommand.Parameters.AddWithValue("@kd_pinj", pinjam.kd_pinj); sqlCmd2.Fill(dtbSimpan); var total = (Convert.ToDouble(dtbSimpan.Rows[0][0].ToString()) * pinjam.jlh) / 100; var angsuran = total / pinjam.lama; string query = "UPDATE trans_pinjaman SET tglpinj=@tglpinj, bunga=@bunga, jlh=@jlh, total=@total, angsuran=@angsuran, status=@status, kd_pinj=@kd_pinj, no_ang=@no_ang, keterangan=@keterangan, lama=@lama Where no_pinj = @no_pinj"; SqlCommand sqlCmd = new SqlCommand(query, sqlcon); sqlCmd.Parameters.AddWithValue("@no_pinj", pinjam.no_pinj); sqlCmd.Parameters.AddWithValue("@tglpinj", pinjam.tglpinj); sqlCmd.Parameters.AddWithValue("@bunga", Convert.ToDouble(dtbSimpan.Rows[0][0].ToString())); sqlCmd.Parameters.AddWithValue("@jlh", pinjam.jlh); sqlCmd.Parameters.AddWithValue("@total", total); sqlCmd.Parameters.AddWithValue("@angsuran", angsuran); sqlCmd.Parameters.AddWithValue("@status", "Belum Lunas"); sqlCmd.Parameters.AddWithValue("@kd_pinj", pinjam.kd_pinj); sqlCmd.Parameters.AddWithValue("@no_ang", pinjam.no_ang); sqlCmd.Parameters.AddWithValue("@keterangan", pinjam.keterangan); sqlCmd.Parameters.AddWithValue("@lama", pinjam.lama); sqlCmd.ExecuteNonQuery(); } return(RedirectToAction("Index")); }
// GET: TransaksiSimpanan/Edit/5 public ActionResult Edit(int id) { if (Session["id"] == null) { return(RedirectToAction("Index", "Login")); } TransaksiSimpananModel Tsimpan = new TransaksiSimpananModel(); DataTable dtbSimpan = new DataTable(); KoperasiEntities2 db = new KoperasiEntities2(); List <anggota> list2 = db.anggotas.ToList(); List <simpanan> list1 = db.simpanans.ToList(); ViewBag.anggotaList2 = new SelectList(list2, "no_anggota", "nama_ang"); ViewBag.simpananList = new SelectList(list1, "kd_simp", "jns_simp"); using (SqlConnection sqlcon = new SqlConnection(connectionString)) { sqlcon.Open(); string query = "SELECT * FROM trans_simpanan where id_tsimpan = @id_tsimpan"; SqlDataAdapter sqlCmd = new SqlDataAdapter(query, sqlcon); sqlCmd.SelectCommand.Parameters.AddWithValue("@id_tsimpan", id); sqlCmd.Fill(dtbSimpan); } if (dtbSimpan.Rows.Count == 1) { Tsimpan.id_tsimpan = Convert.ToInt32(dtbSimpan.Rows[0][0].ToString()); Tsimpan.no_simpan = dtbSimpan.Rows[0][1].ToString(); Tsimpan.tglsimpan = Convert.ToDateTime(dtbSimpan.Rows[0][2].ToString()); Tsimpan.jenis = dtbSimpan.Rows[0][3].ToString(); Tsimpan.saldo = Convert.ToDouble(dtbSimpan.Rows[0][4].ToString()); Tsimpan.no_ang = dtbSimpan.Rows[0][5].ToString(); return(View(Tsimpan)); } else { return(RedirectToAction("Index")); } }
public ActionResult Create(TransaksiSimpananModel simpan) { if (Session["id"] == null) { return(RedirectToAction("Index", "Login")); } using (SqlConnection sqlcon = new SqlConnection(connectionString)) { DataTable dtbSimpan = new DataTable(); sqlcon.Open(); KoperasiEntities2 db = new KoperasiEntities2(); AnggotaModel anggota = new AnggotaModel(); List <anggota> list = db.anggotas.ToList(); List <simpanan> list1 = db.simpanans.ToList(); ViewBag.anggotaList = new SelectList(list, "no_anggota", "nama_ang"); ViewBag.anggotaList1 = new SelectList(list, "no_simp", "nama_ang"); ViewBag.simpananList = new SelectList(list1, "kd_simp", "jns_simp"); string query = "SELECT no_simp FROM anggota where no_anggota = @no_anggota"; SqlDataAdapter sqlCmd = new SqlDataAdapter(query, sqlcon); sqlCmd.SelectCommand.Parameters.AddWithValue("@no_anggota", simpan.no_ang); sqlCmd.Fill(dtbSimpan); trans_simpanan tsimpan = new trans_simpanan(); tsimpan.no_ang = simpan.no_ang; tsimpan.tglsimpan = simpan.tglsimpan; tsimpan.jenis = simpan.jenis; tsimpan.saldo = simpan.saldo; tsimpan.no_simpan = dtbSimpan.Rows[0][0].ToString(); db.trans_simpanan.Add(tsimpan); db.SaveChanges(); } return(RedirectToAction("Index")); }