// Set All Pengirim Datas that has been retrieve to its Entity Set Functions void GetPengirimDetail() { DataTable dt = intfeditdata.getDataPengirim(data_edit.getIdPengirim()); foreach (DataRow row in dt.Rows) { data_edit.setNamaPengirim(Convert.ToString(row["nama_pengirim"])); data_edit.setJkPengirim(Convert.ToChar(row["jk"])); data_edit.setNoHubPengirim(Convert.ToString(row["no_hub"])); data_edit.setKodePosPengirim(Convert.ToString(row["kode_pos"])); data_edit.setAlamatPengirim(Convert.ToString(row["alamat"])); data_edit.setRtPengirim(Convert.ToString(row["rt"])); data_edit.setRwPengirim(Convert.ToString(row["rw"])); data_edit.setDesaPengirim(Convert.ToString(row["desa"])); data_edit.setKecPengirim(Convert.ToString(row["kec"])); if (row["id_kabupaten"] == DBNull.Value) { data_edit.setId_KabPengirim(0); } else { data_edit.setId_KabPengirim(Convert.ToInt32(row["id_kabupaten"])); } if (row["id_provinsi"] == DBNull.Value) { data_edit.setId_ProvPengirim(0); } else { data_edit.setId_ProvPengirim(Convert.ToInt32(row["id_provinsi"])); } } }
// 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 Pengirim Duplicate on Database private void txt_id_pengirim_TextChanged(object sender, EventArgs e) { if (txt_id_pengirim.TextLength == 16) { // Get DataTable with 1 column and 1 row, to check for duplicate DataTable dtcd = intfadddata.get_dt_cekduplikat_id_pengirim(txt_id_pengirim.Text); foreach (DataRow rowx in dtcd.Rows) { if (txt_id_pengirim.Text == Convert.ToString(rowx["id_pengirim"])) { data_add.setStatusDuplikatPengirim(true); data_add.setIdPengirim(txt_id_pengirim.Text); // Get DataTabe of 1 record with all columns include DataTable dt = intfadddata.getDataPengirim(data_add.getIdPengirim()); foreach (DataRow row in dt.Rows) { // Retrieve Data Pengirim data_add.setNamaPengirim(Convert.ToString(row["nama_pengirim"])); data_add.setJkPengirim(Convert.ToChar(row["jk"])); data_add.setNoHubPengirim(Convert.ToString(row["no_hub"])); data_add.setKodePosPengirim(Convert.ToString(row["kode_pos"])); data_add.setAlamatPengirim(Convert.ToString(row["alamat"])); data_add.setRtPengirim(Convert.ToString(row["rt"])); data_add.setRwPengirim(Convert.ToString(row["rw"])); data_add.setDesaPengirim(Convert.ToString(row["desa"])); data_add.setKecPengirim(Convert.ToString(row["kec"])); if (row["id_kabupaten"] == DBNull.Value) { data_add.setId_KabPengirim(0); } else { data_add.setId_KabPengirim(Convert.ToInt32(row["id_kabupaten"])); } if (row["id_provinsi"] == DBNull.Value) { data_add.setId_ProvPengirim(0); } else { data_add.setId_ProvPengirim(Convert.ToInt32(row["id_provinsi"])); } } // Diplay the data on Textboxes and else txt_nama_pengirim.Text = data_add.getNamaPengirim(); txt_nohub_pengirim.Text = data_add.getNoHubPengirim(); txt_alamat_pengirim.Text = data_add.getAlamatPengirim(); txt_kodepos_pengirim.Text = data_add.getKodePosPengirim(); txt_rt_pengirim.Text = data_add.getRtPengirim(); txt_rw_pengirim.Text = data_add.getRwPengirim(); txt_desa_pengirim.Text = data_add.getDesaPengirim(); txt_kec_pengirim.Text = data_add.getKecPengirim(); if (data_add.getJkPengirim() == 'L') { rb_L_pengirim.Checked = true; } else { rb_P_pengirim.Checked = true; } cmbProvPengirim.Items.Clear(); cmbProvPengirim.DataSource = null; // Because the combobox might be bound to datatable cmbProvPengirim.ResetText(); // Make the combobox text empty cmbKabPengirim.Items.Clear(); cmbKabPengirim.DataSource = null; // Because the combobox might be bound to datatable cmbKabPengirim.ResetText(); // Make the combobox text empty fillcombo4(); if (data_add.getId_ProvPengirim() != 0) { cmbProvPengirim.SelectedItem = intfadddata.getNamaCombo4(data_add.getId_ProvPengirim()); } if (data_add.getId_KabPengirim() != 0) { cmbKabPengirim.SelectedItem = intfadddata.getNamaComboKab(data_add.getId_KabPengirim()); } } else { data_add.setStatusDuplikatPengirim(false); } } } else { data_add.setStatusDuplikatPengirim(false); // Set The Data Becoming Null data_add.setNamaPengirim(""); data_add.setJkPengirim('\0'); data_add.setNoHubPengirim(""); data_add.setKodePosPengirim(""); data_add.setAlamatPengirim(""); data_add.setRtPengirim(""); data_add.setRwPengirim(""); data_add.setDesaPengirim(""); data_add.setKecPengirim(""); data_add.setId_KabPengirim(0); data_add.setId_ProvPenerima(0); // Empty The Textboxes and else txt_nama_pengirim.Text = ""; txt_nohub_pengirim.Text = ""; txt_alamat_pengirim.Text = ""; txt_kodepos_pengirim.Text = ""; txt_rt_pengirim.Text = ""; txt_rw_pengirim.Text = ""; txt_desa_pengirim.Text = ""; txt_kec_pengirim.Text = ""; rb_L_pengirim.Checked = true; cmbProvPengirim.Items.Clear(); cmbProvPengirim.DataSource = null; // Because the combobox might be bound to datatable cmbProvPengirim.ResetText(); // Make the combobox text empty cmbKabPengirim.Items.Clear(); cmbKabPengirim.DataSource = null; // Because the combobox might be bound to datatable cmbKabPengirim.ResetText(); // Make the combobox text empty fillcombo4(); cmbProvPengirim.SelectedItem = null; cmbKabPengirim.SelectedItem = null; } }