public ActionResult Edit(LapanganModel lapanganModel) { if (Session["id"] == null) { return(RedirectToAction("Masuk", "Pengguna")); } else if (Session["type"].ToString() != ("Admin")) { return(RedirectToAction("ErrorAuth", "Home")); } using (SqlConnection sqlCon = new SqlConnection(connectionString)) { sqlCon.Open(); string query = "UPDATE Lapangan SET NamaLapangan = @NamaLapangan, Harga = @Harga, Keterangan = @Keterangan, Panjang = @Panjang, Lebar = @Lebar WHERE IDLapangan = @IDLapangan"; SqlCommand sqlCmd = new SqlCommand(query, sqlCon); sqlCmd.Parameters.AddWithValue("@IDLapangan", lapanganModel.IDLapangan); sqlCmd.Parameters.AddWithValue("@NamaLapangan", lapanganModel.NamaLapangan); sqlCmd.Parameters.AddWithValue("@Harga", lapanganModel.Harga); sqlCmd.Parameters.AddWithValue("@Panjang", lapanganModel.Panjang); sqlCmd.Parameters.AddWithValue("@Lebar", lapanganModel.Lebar); sqlCmd.Parameters.AddWithValue("@Keterangan", lapanganModel.Keterangan); sqlCmd.ExecuteNonQuery(); } return(RedirectToAction("Index")); }
public ActionResult Detail(int id) { LapanganModel lapanganModel = new LapanganModel(); DataTable dtblLapangan = new DataTable(); using (SqlConnection sqlCon = new SqlConnection(connectionString)) { sqlCon.Open(); string query = "SELECT * FROM Lapangan Where IDLapangan = @IDLapangan"; SqlDataAdapter sqlDa = new SqlDataAdapter(query, sqlCon); sqlDa.SelectCommand.Parameters.AddWithValue("@IDLapangan", id); sqlDa.Fill(dtblLapangan); } if (dtblLapangan.Rows.Count == 1) { lapanganModel.IDLapangan = Convert.ToInt32(dtblLapangan.Rows[0][0].ToString()); lapanganModel.NamaLapangan = dtblLapangan.Rows[0][1].ToString(); lapanganModel.Harga = Convert.ToInt32(dtblLapangan.Rows[0][2].ToString()); lapanganModel.Panjang = Convert.ToDouble(dtblLapangan.Rows[0][3].ToString()); lapanganModel.Lebar = Convert.ToDouble(dtblLapangan.Rows[0][4].ToString()); lapanganModel.Keterangan = dtblLapangan.Rows[0][5].ToString(); return(View(lapanganModel)); } else { return(RedirectToAction("Index")); } }
public ActionResult Create(LapanganModel lapanganModel) { if (Session["id"] == null) { return(RedirectToAction("Masuk", "Pengguna")); } else if (Session["type"].ToString() != ("Admin")) { return(RedirectToAction("ErrorAuth", "Home")); } using (SqlConnection sqlCon = new SqlConnection(connectionString)) { sqlCon.Open(); string query = "INSERT INTO Lapangan(NamaLapangan, Harga, Panjang, Lebar, Keterangan) VALUES (@NamaLapangan, @Harga,@Panjang,@Lebar,@Keterangan)"; SqlCommand sqlCmd = new SqlCommand(query, sqlCon); sqlCmd.Parameters.AddWithValue("@NamaLapangan", lapanganModel.NamaLapangan); sqlCmd.Parameters.AddWithValue("@Harga", lapanganModel.Harga); sqlCmd.Parameters.AddWithValue("@Panjang", lapanganModel.Panjang); sqlCmd.Parameters.AddWithValue("@Lebar", lapanganModel.Lebar); sqlCmd.Parameters.AddWithValue("@Keterangan", lapanganModel.Keterangan); sqlCmd.ExecuteNonQuery(); } return(RedirectToAction("Index")); }
// GET: Lapangan/Edit/5 public ActionResult Edit(int id) { if (Session["id"] == null) { return(RedirectToAction("Masuk", "Pengguna")); } else if (Session["type"].ToString() != ("Admin")) { return(RedirectToAction("ErrorAuth", "Home")); } LapanganModel lapanganModel = new LapanganModel(); DataTable dtblLapangan = new DataTable(); using (SqlConnection sqlCon = new SqlConnection(connectionString)) { sqlCon.Open(); string query = "SELECT * FROM Lapangan Where IDLapangan = @IDLapangan"; SqlDataAdapter sqlDa = new SqlDataAdapter(query, sqlCon); sqlDa.SelectCommand.Parameters.AddWithValue("@IDLapangan", id); sqlDa.Fill(dtblLapangan); } if (dtblLapangan.Rows.Count == 1) { lapanganModel.IDLapangan = Convert.ToInt32(dtblLapangan.Rows[0][0].ToString()); lapanganModel.NamaLapangan = dtblLapangan.Rows[0][1].ToString(); lapanganModel.Harga = Convert.ToInt32(dtblLapangan.Rows[0][2].ToString()); lapanganModel.Panjang = Convert.ToDouble(dtblLapangan.Rows[0][3].ToString()); lapanganModel.Lebar = Convert.ToDouble(dtblLapangan.Rows[0][4].ToString()); lapanganModel.Keterangan = dtblLapangan.Rows[0][5].ToString(); return(View(lapanganModel)); } else { return(RedirectToAction("Index")); } }