// Set data from object data_print to Labels void GetChangeLabel() { // Pengirim Labels lbl_nama_pengirim.Text = data_print.getNamaPengirim(); lbl_nohub_pengirim.Text = data_print.getNoHubPengirim(); lbl_kota_pengirim.Text = data_print.getKotaPengiriman(); lbl_alamat_pengirim.Text = data_print.getKotaPengiriman(); // Penerima Labels lbl_nama_penerima.Text = data_print.getNamaPenerima(); lbl_nohub_penerima.Text = data_print.getNoHubPenerima(); lbl_kota_penerima.Text = data_print.getKotaTujuan(); lbl_alamat_penerima.Text = data_print.getAlamatPenerima(); lbl_kec_penerima.Text = data_print.getKecPenerima(); lbl_kab_penerima.Text = intfadddata.getNamaComboKab(data_print.getId_KabPengirim()); lbl_prov_penerima.Text = intfadddata.getNamaCombo4(data_print.getId_ProvPengirim()); lbl_desa_penerima.Text = data_print.getDesaPenerima(); lbl_kodepos_penerima.Text = data_print.getKodePosPenerima(); lbl_rt_penerima.Text = data_print.getRtPenerima(); lbl_rw_penerima.Text = data_print.getRwPenerima(); // Data Transaksi Labels lbl_kode_kiriman.Text = data_print.getIdTransaksi().ToString(); lbl_berat.Text = data_print.getBerat().ToString(); if (data_print.getTipeBarang() == 'P') { lbl_tipebarang.Text = "Package"; } else { lbl_tipebarang.Text = "Document"; } // Display Total Pembayaran using Rupiah format int inttotal = (data_print.getBerat() * data_print.getOngkos()); CultureInfo culture = new CultureInfo("id-ID"); lbl_biayapengiriman.Text = inttotal.ToString("C", culture); // The other label of FormSlip lbl_kota_asal.Text = data_print.getKotaPengiriman(); lbl_kota_tujuan.Text = data_print.getKotaTujuan(); lbl_petugas.Text = intfmenuutama.getNamaPegawai(id_petugas); lbl_ttd_pengirim.Text = data_print.getNamaPengirim(); // Display date to normal format var dateAndTimeNota = DateTime.Now; var datenota = dateAndTimeNota.ToString("dd MMMM yyyy"); lbl_tglnota.Text = datenota; }
// Method To Update Data public Boolean updatedata(Entity.EntData ead) { status = false; try { // Query Update Table tb_pengirim string Query1 = "UPDATE tb_pengirim SET nama_pengirim = @namapengirim, jk = @jkpengirim, kode_pos = @kode_pos, no_hub = @no_hub, alamat = @alamat, rt = @rt, rw = @rw, desa = @desa, kec = @kec, id_kabupaten = @kab, id_provinsi = @prov WHERE id_pengirim = @id_pengirim;"; SqlCommand cmdDataBase1 = new SqlCommand(Query1, koneksi); cmdDataBase1.Parameters.AddWithValue("@namapengirim", ead.getNamaPengirim()); cmdDataBase1.Parameters.AddWithValue("@jkpengirim", ead.getJkPengirim()); cmdDataBase1.Parameters.AddWithValue("@kode_pos", ead.getKodePosPengirim()); cmdDataBase1.Parameters.AddWithValue("@no_hub", ead.getNoHubPengirim()); cmdDataBase1.Parameters.AddWithValue("@alamat", ead.getAlamatPengirim()); cmdDataBase1.Parameters.AddWithValue("@rt", ead.getRtPengirim()); cmdDataBase1.Parameters.AddWithValue("@rw", ead.getRwPengirim()); cmdDataBase1.Parameters.AddWithValue("@desa", ead.getDesaPengirim()); cmdDataBase1.Parameters.AddWithValue("@kec", ead.getKecPengirim()); if (ead.getId_KabPengirim() == 0) { cmdDataBase1.Parameters.AddWithValue("@kab", DBNull.Value); } else { cmdDataBase1.Parameters.AddWithValue("@kab", ead.getId_KabPengirim()); } if (ead.getId_ProvPengirim() == 0) { cmdDataBase1.Parameters.AddWithValue("@prov", DBNull.Value); } else { cmdDataBase1.Parameters.AddWithValue("@prov", ead.getId_ProvPengirim()); } cmdDataBase1.Parameters.AddWithValue("@id_pengirim", ead.getIdPengirim()); // Query Update Table tb_penerima string Query2 = "UPDATE tb_penerima SET nama_penerima = @namapenerima, jk = @jkpenerima, kode_pos = @kode_pos, no_hub = @no_hub, alamat = @alamat, rt = @rt, rw = @rw, desa = @desa, kec = @kec, id_kabupaten = @kab WHERE id_penerima = @id_penerima;"; SqlCommand cmdDataBase2 = new SqlCommand(Query2, koneksi); cmdDataBase2.Parameters.AddWithValue("@namapenerima", ead.getNamaPenerima()); cmdDataBase2.Parameters.AddWithValue("@jkpenerima", ead.getJkPenerima()); cmdDataBase2.Parameters.AddWithValue("@kode_pos", ead.getKodePosPenerima()); cmdDataBase2.Parameters.AddWithValue("@no_hub", ead.getNoHubPenerima()); cmdDataBase2.Parameters.AddWithValue("@alamat", ead.getAlamatPenerima()); cmdDataBase2.Parameters.AddWithValue("@rt", ead.getRtPenerima()); cmdDataBase2.Parameters.AddWithValue("@rw", ead.getRwPenerima()); cmdDataBase2.Parameters.AddWithValue("@desa", ead.getDesaPenerima()); cmdDataBase2.Parameters.AddWithValue("@kec", ead.getKecPenerima()); cmdDataBase2.Parameters.AddWithValue("@kab", ead.getId_KabPenerima()); cmdDataBase2.Parameters.AddWithValue("@id_penerima", ead.getIdPenerima()); // Query Update Table tb_transaksi string Query3 = "UPDATE tb_transaksi SET tgl_transaksi = @tgl_transaksi, berat = @berat, nik = @id_pegawai, id_pengirim = @id_pengirim, id_tarif = @id_tarif, id_penerima = @id_penerima WHERE id_transaksi = @id_transaksi"; SqlCommand cmdDataBase3 = new SqlCommand(Query3, koneksi); cmdDataBase3.Parameters.AddWithValue("@tgl_transaksi", ead.getTglTransaksi()); cmdDataBase3.Parameters.AddWithValue("@berat", ead.getBerat()); cmdDataBase3.Parameters.AddWithValue("@id_pegawai", ead.getIdPegawai()); cmdDataBase3.Parameters.AddWithValue("@id_pengirim", ead.getIdPengirim()); cmdDataBase3.Parameters.AddWithValue("@id_tarif", ead.getIdTarif()); cmdDataBase3.Parameters.AddWithValue("@id_penerima", ead.getIdPenerima()); cmdDataBase3.Parameters.AddWithValue("@id_transaksi", ead.getIdTransaksi()); koneksi.Open(); cmdDataBase1.ExecuteNonQuery(); cmdDataBase2.ExecuteNonQuery(); cmdDataBase3.ExecuteNonQuery(); status = true; koneksi.Close(); } catch (SqlException se) { Console.WriteLine("ERROR " + se); } return(status); }
// Method To Save Data public Boolean saveData(Entity.EntData ead) { status = false; SqlCommand cmdDataBase1, cmdDataBase2, cmdDataBase3; String Query1, Query2, Query3; try { // If There is an id_pengirim duplicate if (ead.getStatusDuplikatPengirim() == true) { // QUERY UPDATE Query1 = "UPDATE tb_pengirim SET nama_pengirim = @namapengirim, jk = @jkpengirim, kode_pos = @kode_pos, no_hub = @no_hub, alamat = @alamat, rt = @rt, rw = @rw, desa = @desa, kec = @kec, id_kabupaten = @kab, id_provinsi = @prov WHERE id_pengirim = @id_pengirim;"; cmdDataBase1 = new SqlCommand(Query1, koneksi); cmdDataBase1.Parameters.AddWithValue("@namapengirim", ead.getNamaPengirim()); cmdDataBase1.Parameters.AddWithValue("@jkpengirim", ead.getJkPengirim()); cmdDataBase1.Parameters.AddWithValue("@kode_pos", ead.getKodePosPengirim()); cmdDataBase1.Parameters.AddWithValue("@no_hub", ead.getNoHubPengirim()); cmdDataBase1.Parameters.AddWithValue("@alamat", ead.getAlamatPengirim()); cmdDataBase1.Parameters.AddWithValue("@rt", ead.getRtPengirim()); cmdDataBase1.Parameters.AddWithValue("@rw", ead.getRwPengirim()); cmdDataBase1.Parameters.AddWithValue("@desa", ead.getDesaPengirim()); cmdDataBase1.Parameters.AddWithValue("@kec", ead.getKecPengirim()); if (ead.getId_KabPengirim() == 0) { cmdDataBase1.Parameters.AddWithValue("@kab", DBNull.Value); } else { cmdDataBase1.Parameters.AddWithValue("@kab", ead.getId_KabPengirim()); } if (ead.getId_ProvPengirim() == 0) { cmdDataBase1.Parameters.AddWithValue("@prov", DBNull.Value); } else { cmdDataBase1.Parameters.AddWithValue("@prov", ead.getId_ProvPengirim()); } cmdDataBase1.Parameters.AddWithValue("@id_pengirim", ead.getIdPengirim()); } else { // QUERY INSERT Query1 = "INSERT INTO tb_pengirim VALUES (@id_pengirim, @namapengirim, @jkpengirim, @kode_pos, @no_hub, @alamat, @rt, @rw, @desa, @kec, @kab, @prov);"; cmdDataBase1 = new SqlCommand(Query1, koneksi); cmdDataBase1.Parameters.AddWithValue("@id_pengirim", ead.getIdPengirim()); cmdDataBase1.Parameters.AddWithValue("@namapengirim", ead.getNamaPengirim()); cmdDataBase1.Parameters.AddWithValue("@jkpengirim", ead.getJkPengirim()); cmdDataBase1.Parameters.AddWithValue("@kode_pos", ead.getKodePosPengirim()); cmdDataBase1.Parameters.AddWithValue("@no_hub", ead.getNoHubPengirim()); cmdDataBase1.Parameters.AddWithValue("@alamat", ead.getAlamatPengirim()); cmdDataBase1.Parameters.AddWithValue("@rt", ead.getRtPengirim()); cmdDataBase1.Parameters.AddWithValue("@rw", ead.getRwPengirim()); cmdDataBase1.Parameters.AddWithValue("@desa", ead.getDesaPengirim()); cmdDataBase1.Parameters.AddWithValue("@kec", ead.getKecPengirim()); if (ead.getId_KabPengirim() == 0) { cmdDataBase1.Parameters.AddWithValue("@kab", DBNull.Value); } else { cmdDataBase1.Parameters.AddWithValue("@kab", ead.getId_KabPengirim()); } if (ead.getId_ProvPengirim() == 0) { cmdDataBase1.Parameters.AddWithValue("@prov", DBNull.Value); } else { cmdDataBase1.Parameters.AddWithValue("@prov", ead.getId_ProvPengirim()); } } // If There is an id_penerima duplicate if (ead.getStatusDuplikatPenerima() == true) { // QUERY UPDATE Query2 = "UPDATE tb_penerima SET nama_penerima = @namapenerima, jk = @jkpenerima, kode_pos = @kode_pos, no_hub = @no_hub, alamat = @alamat, rt = @rt, rw = @rw, desa = @desa, kec = @kec, id_kabupaten = @kab WHERE id_penerima = @id_penerima;"; cmdDataBase2 = new SqlCommand(Query2, koneksi); cmdDataBase2.Parameters.AddWithValue("@namapenerima", ead.getNamaPenerima()); cmdDataBase2.Parameters.AddWithValue("@jkpenerima", ead.getJkPenerima()); cmdDataBase2.Parameters.AddWithValue("@kode_pos", ead.getKodePosPenerima()); cmdDataBase2.Parameters.AddWithValue("@no_hub", ead.getNoHubPenerima()); cmdDataBase2.Parameters.AddWithValue("@alamat", ead.getAlamatPenerima()); cmdDataBase2.Parameters.AddWithValue("@rt", ead.getRtPenerima()); cmdDataBase2.Parameters.AddWithValue("@rw", ead.getRwPenerima()); cmdDataBase2.Parameters.AddWithValue("@desa", ead.getDesaPenerima()); cmdDataBase2.Parameters.AddWithValue("@kec", ead.getKecPenerima()); cmdDataBase2.Parameters.AddWithValue("@kab", ead.getId_KabPenerima()); cmdDataBase2.Parameters.AddWithValue("@id_penerima", ead.getIdPenerima()); } else { // QUERY INSERT Query2 = "INSERT INTO tb_penerima VALUES (@id_penerima, @namapenerima, @jkpenerima, @kode_pos, @no_hub, @alamat, @rt, @rw, @desa, @kec, @kab);"; cmdDataBase2 = new SqlCommand(Query2, koneksi); cmdDataBase2.Parameters.AddWithValue("@id_penerima", ead.getIdPenerima()); cmdDataBase2.Parameters.AddWithValue("@namapenerima", ead.getNamaPenerima()); cmdDataBase2.Parameters.AddWithValue("@jkpenerima", ead.getJkPenerima()); cmdDataBase2.Parameters.AddWithValue("@kode_pos", ead.getKodePosPenerima()); cmdDataBase2.Parameters.AddWithValue("@no_hub", ead.getNoHubPenerima()); cmdDataBase2.Parameters.AddWithValue("@alamat", ead.getAlamatPenerima()); cmdDataBase2.Parameters.AddWithValue("@rt", ead.getRtPenerima()); cmdDataBase2.Parameters.AddWithValue("@rw", ead.getRwPenerima()); cmdDataBase2.Parameters.AddWithValue("@desa", ead.getDesaPenerima()); cmdDataBase2.Parameters.AddWithValue("@kec", ead.getKecPenerima()); cmdDataBase2.Parameters.AddWithValue("@kab", ead.getId_KabPenerima()); } // Insert A New Transaction Data Query3 = "INSERT INTO tb_transaksi (tgl_transaksi, berat, nik, id_pengirim, id_tarif, id_penerima) VALUES (@tgl_transaksi, @berat, @id_pegawai, @id_pengirim, @id_tarif, @id_penerima);"; cmdDataBase3 = new SqlCommand(Query3, koneksi); cmdDataBase3.Parameters.AddWithValue("@tgl_transaksi", ead.getTglTransaksi()); cmdDataBase3.Parameters.AddWithValue("@berat", ead.getBerat()); cmdDataBase3.Parameters.AddWithValue("@id_pegawai", ead.getIdPegawai()); cmdDataBase3.Parameters.AddWithValue("@id_pengirim", ead.getIdPengirim()); cmdDataBase3.Parameters.AddWithValue("@id_tarif", ead.getIdTarif()); cmdDataBase3.Parameters.AddWithValue("@id_penerima", ead.getIdPenerima()); koneksi.Open(); cmdDataBase1.ExecuteNonQuery(); cmdDataBase2.ExecuteNonQuery(); cmdDataBase3.ExecuteNonQuery(); status = true; koneksi.Close(); } catch (SqlException se) { Console.WriteLine("ERROR " + se); } return(status); }
// Method To Get Combobox, RadioButton, and Datetimepicker to its position void PositPengirimPenerima() { // Set Radio Button Position base on data it's retrieve if (data_edit.getJkPengirim() == 'L') { rb_L_pengirim.Checked = true; jk_pengirim = 'L'; } else { rb_P_pengirim.Checked = true; jk_pengirim = 'P'; } if (data_edit.getJkPenerima() == 'L') { rb_L_penerima.Checked = true; jk_penerima = 'L'; } else { rb_P_penerima.Checked = true; jk_penerima = 'P'; } // Fill combobox provinsi & kabupaten of Pengirim cmbProvPengirim.Items.Clear(); cmbProvPengirim.DataSource = null; // Because the combobox is bound to datatable cmbProvPengirim.ResetText(); // Make the combobox text empty cmbKabPengirim.Items.Clear(); cmbKabPengirim.DataSource = null; // Because the combobox is bound to datatable cmbKabPengirim.ResetText(); // Make the combobox text empty fillcombo4(); if (data_edit.getId_ProvPengirim() != 0) { cmbProvPengirim.SelectedItem = intfadddata.getNamaCombo4(data_edit.getId_ProvPengirim()); } if (data_edit.getId_KabPengirim() != 0) { cmbKabPengirim.SelectedItem = intfadddata.getNamaComboKab(data_edit.getId_KabPengirim()); } // Fill combobox provinsi & kabupaten of Penerima cmbProvPenerima.Items.Clear(); cmbProvPenerima.DataSource = null; // Because the combobox is bound to datatable cmbProvPenerima.ResetText(); // Make the combobox text empty cmbKabPenerima.Items.Clear(); cmbKabPenerima.DataSource = null; // Because the combobox is bound to datatable cmbKabPenerima.ResetText(); // Make the combobox text empty fillcombo5(); if (data_edit.getId_ProvPenerima() != 0) { cmbProvPenerima.SelectedItem = intfadddata.getNamaCombo4(data_edit.getId_ProvPenerima()); } if (data_edit.getId_KabPenerima() != 0) { cmbKabPenerima.SelectedItem = intfadddata.getNamaComboKab(data_edit.getId_KabPenerima()); } // Convert datetimepicker String values to DateTime value dateTimePicker1.Value = DateTime.Parse(data_edit.getTglTransaksi()); // Load Combobox Kota Pengiriman cmbKotaPengiriman.Items.Clear(); cmbKotaPengiriman.DataSource = null; // Because the combobox is bound to datatable cmbKotaPengiriman.ResetText(); // Make the combobox text empty fillcombo1(); cmbKotaPengiriman.SelectedItem = data_edit.getKotaPengiriman(); // Load Combobox Kota Tujuan cmbKotaTujuan.Items.Clear(); cmbKotaTujuan.DataSource = null; // Because the combobox is bound to datatable cmbKotaTujuan.ResetText(); // Make the combobox text empty fillcombo2(); cmbKotaTujuan.SelectedItem = data_edit.getKotaTujuan(); // Load Combobox Tipe Barang cmbTipeBarang.Items.Clear(); cmbTipeBarang.DataSource = null; // Because the combobox is bound to datatable cmbTipeBarang.ResetText(); // Make the combobox text empty fillcombo3(); if (data_edit.getTipeBarang() == 'P') { cmbTipeBarang.SelectedItem = "Package"; } else { cmbTipeBarang.SelectedItem = "Document"; } // Set Textboxes to It's position and the value txt_lama_pengiriman.Text = data_edit.getLamaHari().ToString(); txt_tarif.Text = data_edit.getOngkos().ToString(); txt_berat.Text = data_edit.getBerat().ToString(); txt_total_biaya.Text = (data_edit.getBerat() * data_edit.getOngkos()).ToString(); }