// GET: Pinjaman/Edit/5 public ActionResult Edit(int id) { if (Session["id"] == null) { return(RedirectToAction("Index", "Login")); } PinjamanModel pinjam = new PinjamanModel(); DataTable dtbSimpan = new DataTable(); using (SqlConnection sqlcon = new SqlConnection(connectionString)) { sqlcon.Open(); string query = "SELECT * FROM pinjaman where kd_pinj = @kd_pinj"; SqlDataAdapter sqlCmd = new SqlDataAdapter(query, sqlcon); sqlCmd.SelectCommand.Parameters.AddWithValue("@kd_pinj", id); sqlCmd.Fill(dtbSimpan); } if (dtbSimpan.Rows.Count == 1) { pinjam.kd_pinj = dtbSimpan.Rows[0][0].ToString(); pinjam.jns_pinj = dtbSimpan.Rows[0][1].ToString(); pinjam.max_pinj = Convert.ToDouble(dtbSimpan.Rows[0][2].ToString()); pinjam.max_ang = Convert.ToDouble(dtbSimpan.Rows[0][3].ToString()); pinjam.bunga = Convert.ToDouble(dtbSimpan.Rows[0][4].ToString()); return(View(pinjam)); } else { return(RedirectToAction("Index")); } }
public ActionResult Create(PinjamanModel pinjam) { using (SqlConnection sqlcon = new SqlConnection(connectionString)) { string query = "INSERT INTO pinjaman VALUES(@jns_pinj, @max_pinj, @max_ang, @bunga)"; SqlCommand sqlCmd = new SqlCommand(query, sqlcon); sqlCmd.Connection.Open(); sqlCmd.Parameters.AddWithValue("@jns_pinj", pinjam.jns_pinj); sqlCmd.Parameters.AddWithValue("@max_pinj", pinjam.max_pinj); sqlCmd.Parameters.AddWithValue("@max_ang", pinjam.max_ang); sqlCmd.Parameters.AddWithValue("@bunga", pinjam.bunga); sqlCmd.ExecuteNonQuery(); } return(RedirectToAction("Index")); }
public ActionResult Edit(PinjamanModel pinjam) { using (SqlConnection sqlcon = new SqlConnection(connectionString)) { sqlcon.Open(); string query = "UPDATE pinjaman SET jns_pinj=@jns_pinj, max_pinj=@max_pinj, max_ang=@max_ang, bunga=@bunga Where kd_pinj = @kd_pinj"; SqlCommand sqlCmd = new SqlCommand(query, sqlcon); sqlCmd.Parameters.AddWithValue("@kd_pinj", pinjam.kd_pinj); sqlCmd.Parameters.AddWithValue("@jns_pinj", pinjam.jns_pinj); sqlCmd.Parameters.AddWithValue("@max_pinj", pinjam.max_pinj); sqlCmd.Parameters.AddWithValue("@max_ang", pinjam.max_ang); sqlCmd.Parameters.AddWithValue("@bunga", pinjam.bunga); sqlCmd.ExecuteNonQuery(); } return(RedirectToAction("Index")); }