// Set All Penerima Datas that has been retrieve to its Entity Set Functions void GetPenerimaDetail() { DataTable dt = intfeditdata.getDataPenerima(data_edit.getIdPenerima()); foreach (DataRow row in dt.Rows) { data_edit.setNamaPenerima(Convert.ToString(row["nama_penerima"])); data_edit.setJkPenerima(Convert.ToChar(row["jk"])); data_edit.setNoHubPenerima(Convert.ToString(row["no_hub"])); data_edit.setKodePosPenerima(Convert.ToString(row["kode_pos"])); data_edit.setAlamatPenerima(Convert.ToString(row["alamat"])); data_edit.setRtPenerima(Convert.ToString(row["rt"])); data_edit.setRwPenerima(Convert.ToString(row["rw"])); data_edit.setDesaPenerima(Convert.ToString(row["desa"])); data_edit.setKecPenerima(Convert.ToString(row["kec"])); data_edit.setId_KabPenerima(Convert.ToInt32(row["id_kabupaten"])); data_edit.setId_ProvPenerima(intfadddata.getIdComboProv(data_edit.getId_KabPenerima())); } }
// 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); }
// Trigger Event To Check Whether There is a Penerima Duplicate on Database private void txt_id_penerima_TextChanged(object sender, EventArgs e) { if (txt_id_penerima.TextLength == 16) { // Get DataTable with 1 column and 1 row, to check for duplicate DataTable dtcd = intfadddata.get_dt_cekduplikat_id_penerima(txt_id_penerima.Text); foreach (DataRow rowx in dtcd.Rows) { if (txt_id_penerima.Text == Convert.ToString(rowx["id_penerima"])) { data_add.setStatusDuplikatPenerima(true); data_add.setIdPenerima(txt_id_penerima.Text); // Get DataTabe of 1 record with all columns include DataTable dt = intfadddata.getDataPenerima(data_add.getIdPenerima()); foreach (DataRow row in dt.Rows) { // Retrieve Data Penerima data_add.setNamaPenerima(Convert.ToString(row["nama_penerima"])); data_add.setJkPenerima(Convert.ToChar(row["jk"])); data_add.setNoHubPenerima(Convert.ToString(row["no_hub"])); data_add.setKodePosPenerima(Convert.ToString(row["kode_pos"])); data_add.setAlamatPenerima(Convert.ToString(row["alamat"])); data_add.setRtPenerima(Convert.ToString(row["rt"])); data_add.setRwPenerima(Convert.ToString(row["rw"])); data_add.setDesaPenerima(Convert.ToString(row["desa"])); data_add.setKecPenerima(Convert.ToString(row["kec"])); data_add.setId_KabPenerima(Convert.ToInt32(row["id_kabupaten"])); data_add.setId_ProvPenerima(intfadddata.getIdComboProv(data_add.getId_KabPenerima())); } // Diplay the data on Textboxes and else txt_nama_penerima.Text = data_add.getNamaPenerima(); txt_nohub_penerima.Text = data_add.getNoHubPenerima(); txt_alamat_penerima.Text = data_add.getAlamatPenerima(); txt_kodepos_penerima.Text = data_add.getKodePosPenerima(); txt_rt_penerima.Text = data_add.getRtPenerima(); txt_rw_penerima.Text = data_add.getRwPenerima(); txt_desa_penerima.Text = data_add.getDesaPenerima(); txt_kec_penerima.Text = data_add.getKecPenerima(); if (data_add.getJkPenerima() == 'L') { rb_L_penerima.Checked = true; } else { rb_P_penerima.Checked = true; } cmbProvPenerima.Items.Clear(); cmbProvPenerima.DataSource = null; // Because the combobox might be bound to datatable cmbProvPenerima.ResetText(); // Make the combobox text empty cmbKabPenerima.Items.Clear(); cmbKabPenerima.DataSource = null; // Because the combobox might be bound to datatable cmbKabPenerima.ResetText(); // Make the combobox text empty fillcombo5(); if (data_add.getId_ProvPenerima() != 0) { cmbProvPenerima.SelectedItem = intfadddata.getNamaCombo4(data_add.getId_ProvPenerima()); } if (data_add.getId_KabPenerima() != 0) { cmbKabPenerima.SelectedItem = intfadddata.getNamaComboKab(data_add.getId_KabPenerima()); } } else { data_add.setStatusDuplikatPenerima(false); } } } else { data_add.setStatusDuplikatPenerima(false); // Set The Data Becoming Null data_add.setNamaPenerima(""); data_add.setJkPenerima('\0'); data_add.setNoHubPenerima(""); data_add.setKodePosPenerima(""); data_add.setAlamatPenerima(""); data_add.setRtPenerima(""); data_add.setRwPenerima(""); data_add.setDesaPenerima(""); data_add.setKecPenerima(""); data_add.setId_KabPenerima(0); data_add.setId_ProvPenerima(0); // Empty The Textboxes and else txt_nama_penerima.Text = ""; txt_nohub_penerima.Text = ""; txt_alamat_penerima.Text = ""; txt_kodepos_penerima.Text = ""; txt_rt_penerima.Text = ""; txt_rw_penerima.Text = ""; txt_desa_penerima.Text = ""; txt_kec_penerima.Text = ""; rb_L_penerima.Checked = true; cmbProvPenerima.Items.Clear(); cmbProvPenerima.DataSource = null; // Because the combobox might be bound to datatable cmbProvPenerima.ResetText(); // Make the combobox text empty cmbKabPenerima.Items.Clear(); cmbKabPenerima.DataSource = null; // Because the combobox might be bound to datatable cmbKabPenerima.ResetText(); // Make the combobox text empty fillcombo5(); cmbProvPenerima.SelectedItem = null; cmbKabPenerima.SelectedItem = null; } }