private void btnUpdate_Click(object sender, EventArgs e)
{
ClassHarga m = new ClassHarga();
m.Jenis_hrg = cbService.Text;
m.Total_hrg = tbHarga.Text;
md.updateHarga(m, idHarga);
viewData();
}
private void btnSubmit_Click(object sender, EventArgs e)
{
ClassHarga m = new ClassHarga();
m.Jenis_hrg = cbService.Text;
m.Total_hrg = tbHarga.Text;
md.insertHarga(m);
viewData();
}
public bool updateHarga(ClassHarga m, string id)
{
Boolean stat = false;
try
{
koneksi.Open();
perintah = new MySqlCommand();
perintah.Connection = koneksi;
perintah.CommandType = CommandType.Text;
perintah.CommandText = "UPDATE harga SET jenis_harga='" + m.Jenis_hrg + "', total_harga='" + m.Total_hrg + "' WHERE id='" + id + "'";
perintah.ExecuteNonQuery();
stat = true;
koneksi.Close();
}
catch (MySqlException) { }
return(stat);
}
public bool insertHarga(ClassHarga m)
{
Boolean stat = false;
try
{
koneksi.Open();
perintah = new MySqlCommand();
perintah.Connection = koneksi;
perintah.CommandType = CommandType.Text;
perintah.CommandText = "INSERT INTO harga VALUES('" + "" + "','" + m.Jenis_hrg + "', '" + m.Total_hrg + "')";
perintah.ExecuteNonQuery();
stat = true;
koneksi.Close();
}
catch (MySqlException) { }
return(stat);
}
