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