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