private void BtnHapus_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(LblID.Text))
{
BiayaParkir.Delete(int.Parse(LblID.Text));
Data();
}
//string deleteQuery = "DELETE FROM biaya_parkir WHERE id_kendaraan = " + int.Parse(LblID.Text);
//ExecuteMyQuery(deleteQuery);
//Data();
}
private void BtnUbah_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(LblID.Text) && !string.IsNullOrEmpty(TxtJeniskendaraan.Text) && !string.IsNullOrEmpty(TxtTarif.Text))
{
BiayaParkir.Update(int.Parse(LblID.Text), TxtJeniskendaraan.Text, int.Parse(TxtTarif.Text));
Data();
}
//string deleteQuery = "UPDATE biaya_parkir SET jenis_kendaraan='" + TxtJeniskendaraan.Text + "',Tarif='" + TxtTarif.Text + "' WHERE id_kendaraan = " + int.Parse(LblID.Text);
//ExecuteMyQuery(deleteQuery);
//Data();
}
private void BtnSimpan_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(TxtJeniskendaraan.Text) && !string.IsNullOrEmpty(TxtTarif.Text))
{
BiayaParkir.Insert(TxtJeniskendaraan.Text, int.Parse(TxtTarif.Text));
Data();
}
//string insertQuery = "INSERT INTO biaya_parkir(`jenis_kendaraan`, `Tarif`) VALUES ('" + this.TxtJeniskendaraan.Text + "','" + this.TxtTarif.Text + "');";
//ExecuteMyQuery(insertQuery);
//Data();
}
//public void OpenConnection()
//{
// if (connection.State == ConnectionState.Closed)
// {
// connection.Open();
// }
//}
//public void CloseConnection()
//{
// if (connection.State == ConnectionState.Open)
// {
// connection.Close();
// }
//}
//public void ExecuteMyQuery(string query)
//{
// try
// {
// OpenConnection();
// command = new MySqlCommand(query, connection);
// if (command.ExecuteNonQuery() == 1)
// {
// MessageBox.Show("Selamat Data Anda Berhasil Di Simpan");
// }
// else
// {
// MessageBox.Show("Data Gagal di Simpan");
// }
// }
// catch (Exception ex)
// {
// MessageBox.Show(ex.Message);
// }
// finally
// {
// CloseConnection();
// }
//}
public void Data()
{
biayaParkirBindingSource.DataSource = BiayaParkir.GetListData();
DataGridView1.DataSource = biayaParkirBindingSource;
TxtJeniskendaraan.Enabled = true;
TxtTarif.Enabled = true;
// Koneksi ke MySql data parkir masuk
//try
//{
//string selectQuery = "SELECT `id_kendaraan`, `jenis_kendaraan`, `Tarif` FROM `biaya_parkir`";
//MySqlDataAdapter adapter = new MySqlDataAdapter(selectQuery, connection);
//connection.Open();
//DataSet ds = new DataSet();
//adapter.Fill(ds, "biaya_parkir");
//DataGridView1.DataSource = ds.Tables["biaya_parkir"];
//connection.Close();
//}
//catch (Exception ex)
//{
// MessageBox.Show(ex.Message);
//}
}
