public async Task <IActionResult> Edit(int id, [Bind("IdJenisKendaraan,NamaJenisKendaraan")] JenisKendaraan jenisKendaraan)
{
if (id != jenisKendaraan.IdJenisKendaraan)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(jenisKendaraan);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!JenisKendaraanExists(jenisKendaraan.IdJenisKendaraan))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(jenisKendaraan));
}
public ActionResult DeleteConfirmed(int id)
{
JenisKendaraan jeniskendaraan = db.JenisKendaraan.Find(id);
db.JenisKendaraan.Remove(jeniskendaraan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private JenisKendaraan MappingRowToObject(MySqlDataReader dtr)
{
JenisKendaraan jenisKendaraan = new JenisKendaraan();
jenisKendaraan.id = dtr["id"] is Nullable? 0 : (int)dtr["id"];
jenisKendaraan.jenisKendaraan = dtr["jenis_kendaraan"] is DBNull ? string.Empty : dtr["jenis_kendaraan"].ToString();
jenisKendaraan.hargaperjam = dtr["perjam"] is Nullable ? 0 : (int)dtr["perjam"];
jenisKendaraan.hargamaksimal = dtr["maksimal"] is Nullable ? 0 : (int)dtr["maksimal"];
return(jenisKendaraan);
}
public ActionResult Edit([Bind(Include = "ID,Jenis,Model")] JenisKendaraan jeniskendaraan)
{
if (ModelState.IsValid)
{
db.Entry(jeniskendaraan).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(jeniskendaraan));
}
public async Task <IActionResult> Create([Bind("IdJenisKendaraan,NamaJenisKendaraan")] JenisKendaraan jenisKendaraan)
{
if (ModelState.IsValid)
{
_context.Add(jenisKendaraan);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(jenisKendaraan));
}
public ActionResult Create([Bind(Include = "ID,Jenis,Model")] JenisKendaraan jeniskendaraan)
{
if (ModelState.IsValid)
{
db.JenisKendaraan.Add(jeniskendaraan);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(jeniskendaraan));
}
public int Update(JenisKendaraan jenisKendaraan)
{
strSql = "UPDATE jenis_kendaraan SET jenis_kendaraan = @1, perjam= @2 ,maksimal=@3 WHERE id = @4";
using (MySqlCommand cmd = new MySqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", jenisKendaraan.jenisKendaraan);
cmd.Parameters.AddWithValue("@2", jenisKendaraan.hargaperjam);
cmd.Parameters.AddWithValue("@3", jenisKendaraan.hargamaksimal);
cmd.Parameters.AddWithValue("@4", jenisKendaraan.id);
return(cmd.ExecuteNonQuery());
}
}
public int Save(JenisKendaraan jenisKendaraan)
{
strSql = "INSERT INTO jenis_kendaraan (jenis_kendaraan, perjam,maksimal) VALUES (@1, @2, @3)";
using (MySqlCommand cmd = new MySqlCommand(strSql, conn))
{
cmd.Parameters.AddWithValue("@1", jenisKendaraan.jenisKendaraan);
cmd.Parameters.AddWithValue("@2", jenisKendaraan.hargaperjam);
cmd.Parameters.AddWithValue("@3", jenisKendaraan.hargamaksimal);
return(cmd.ExecuteNonQuery());
}
}
// GET: /JenisKendaraan/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
JenisKendaraan jeniskendaraan = db.JenisKendaraan.Find(id);
if (jeniskendaraan == null)
{
return(HttpNotFound());
}
return(View(jeniskendaraan));
}
private void btnSave_Click(object sender, EventArgs e)
{
JenisKendaraan jenisKendaraan = new JenisKendaraan();
jenisKendaraan.jenisKendaraan = txtJenisKendaraan.Text;
jenisKendaraan.hargaperjam = int.Parse(txtHargaPerJam.Text);
jenisKendaraan.hargamaksimal = int.Parse(txtHargaMaksimal.Text);
int result = jenisKendaraandao.Save(jenisKendaraan);
if (result > 0)
{
MessageBox.Show("Data berhasil di Input", "Data berhasil di Input");
}
loadJenisKendaraan();
}
