// Method To Fill textboxes
void FillTextBox()
{
// TEXTBOX PENGIRIM
txt_id_pengirim.Text = data_edit.getIdPengirim();
txt_nama_pengirim.Text = data_edit.getNamaPengirim();
txt_nohub_pengirim.Text = data_edit.getNoHubPengirim();
txt_alamat_pengirim.Text = data_edit.getAlamatPengirim();
txt_kodepos_pengirim.Text = data_edit.getKodePosPengirim();
txt_rt_pengirim.Text = data_edit.getRtPengirim();
txt_rw_pengirim.Text = data_edit.getRwPengirim();
txt_desa_pengirim.Text = data_edit.getDesaPengirim();
txt_kec_pengirim.Text = data_edit.getKecPengirim();
// TEXTBOX PENERIMA
txt_id_penerima.Text = data_edit.getIdPenerima();
txt_nama_penerima.Text = data_edit.getNamaPenerima();
txt_nohub_penerima.Text = data_edit.getNoHubPenerima();
txt_alamat_penerima.Text = data_edit.getAlamatPenerima();
txt_kodepos_penerima.Text = data_edit.getKodePosPenerima();
txt_rt_penerima.Text = data_edit.getRtPenerima();
txt_rw_penerima.Text = data_edit.getRwPenerima();
txt_desa_penerima.Text = data_edit.getDesaPenerima();
txt_kec_penerima.Text = data_edit.getKecPenerima();
}
// 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;
}
}
