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