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