private void EditTipe_Click(object sender, EventArgs e) { Model.TipeMobil tipemobil = new Model.TipeMobil(); tipemobil.Tipe_mobil = TipeMobilBox.Text; UD.UpdateData(tipemobil, id_tipe); TampilTipe(); }
private void TambahTipe_Click(object sender, EventArgs e) { Model.TipeMobil tipemobil = new Model.TipeMobil(); tipemobil.Tipe_mobil = TipeMobilBox.Text; UD.InsertData(tipemobil); TipeMobilBox.Text = ""; TampilTipe(); }
public bool UpdateData(Model.TipeMobil baru, string id_tipe) { Boolean stat = false; try { terhubung.Open(); cmd = new MySqlCommand(); cmd.Connection = terhubung; cmd.CommandType = CommandType.Text; cmd.CommandText = "UPDATE tipemobil SET tipe='" + baru.Tipe_mobil + "' WHERE id_tipe='" + id_tipe + "'"; cmd.ExecuteNonQuery(); stat = true; Notif("Data Berhasil Diubah", Alert.alertTypeEnum.Success); terhubung.Close(); } catch (MySqlException) { Notif("Data Gagal Diubah", Alert.alertTypeEnum.Error); } return(stat); }
public bool InsertData(Model.TipeMobil baru) { Boolean stat = false; try { terhubung.Open(); cmd = new MySqlCommand(); cmd.Connection = terhubung; cmd.CommandType = CommandType.Text; cmd.CommandText = "INSERT INTO tipemobil (tipe) VALUES ('" + baru.Tipe_mobil + "')"; cmd.ExecuteNonQuery(); stat = true; Notif("Data Berhasil Ditambahkan", Alert.alertTypeEnum.Success); terhubung.Close(); } catch (MySqlException) { Notif("Data Gagal Ditambahkan", Alert.alertTypeEnum.Error); } return(stat); }