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