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