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