// Trigger event when cmbProvPengirim selected
private void cmbProvPengirim_SelectedIndexChanged(object sender, EventArgs e)
{
// Clear it so it wouldn't get display twice or more
cmbKabPengirim.Items.Clear();
cmbKabPengirim.DataSource = null; // Because the combobox might be bound to datatable
cmbKabPengirim.ResetText(); // Make the combobox text empty
data_add.setId_ProvPengirim(intfadddata.getIdCombo4(cmbProvPengirim.SelectedItem.ToString()));
DataTable dCb5 = intfadddata.getComboKab(data_add.getId_ProvPengirim());
for (int i = 0; i < dCb5.Rows.Count; i++)
{
cmbKabPengirim.Items.Add(dCb5.Rows[i]["nama_kabupaten"]);
}
}
// 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 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);
}
// Method To Get Combobox, RadioButton, and Datetimepicker to its position
void PositPengirimPenerima()
{
// Set Radio Button Position base on data it's retrieve
if (data_edit.getJkPengirim() == 'L')
{
rb_L_pengirim.Checked = true;
jk_pengirim = 'L';
}
else
{
rb_P_pengirim.Checked = true;
jk_pengirim = 'P';
}
if (data_edit.getJkPenerima() == 'L')
{
rb_L_penerima.Checked = true;
jk_penerima = 'L';
}
else
{
rb_P_penerima.Checked = true;
jk_penerima = 'P';
}
// Fill combobox provinsi & kabupaten of Pengirim
cmbProvPengirim.Items.Clear();
cmbProvPengirim.DataSource = null; // Because the combobox is bound to datatable
cmbProvPengirim.ResetText(); // Make the combobox text empty
cmbKabPengirim.Items.Clear();
cmbKabPengirim.DataSource = null; // Because the combobox is bound to datatable
cmbKabPengirim.ResetText(); // Make the combobox text empty
fillcombo4();
if (data_edit.getId_ProvPengirim() != 0)
{
cmbProvPengirim.SelectedItem = intfadddata.getNamaCombo4(data_edit.getId_ProvPengirim());
}
if (data_edit.getId_KabPengirim() != 0)
{
cmbKabPengirim.SelectedItem = intfadddata.getNamaComboKab(data_edit.getId_KabPengirim());
}
// Fill combobox provinsi & kabupaten of Penerima
cmbProvPenerima.Items.Clear();
cmbProvPenerima.DataSource = null; // Because the combobox is bound to datatable
cmbProvPenerima.ResetText(); // Make the combobox text empty
cmbKabPenerima.Items.Clear();
cmbKabPenerima.DataSource = null; // Because the combobox is bound to datatable
cmbKabPenerima.ResetText(); // Make the combobox text empty
fillcombo5();
if (data_edit.getId_ProvPenerima() != 0)
{
cmbProvPenerima.SelectedItem = intfadddata.getNamaCombo4(data_edit.getId_ProvPenerima());
}
if (data_edit.getId_KabPenerima() != 0)
{
cmbKabPenerima.SelectedItem = intfadddata.getNamaComboKab(data_edit.getId_KabPenerima());
}
// Convert datetimepicker String values to DateTime value
dateTimePicker1.Value = DateTime.Parse(data_edit.getTglTransaksi());
// Load Combobox Kota Pengiriman
cmbKotaPengiriman.Items.Clear();
cmbKotaPengiriman.DataSource = null; // Because the combobox is bound to datatable
cmbKotaPengiriman.ResetText(); // Make the combobox text empty
fillcombo1();
cmbKotaPengiriman.SelectedItem = data_edit.getKotaPengiriman();
// Load Combobox Kota Tujuan
cmbKotaTujuan.Items.Clear();
cmbKotaTujuan.DataSource = null; // Because the combobox is bound to datatable
cmbKotaTujuan.ResetText(); // Make the combobox text empty
fillcombo2();
cmbKotaTujuan.SelectedItem = data_edit.getKotaTujuan();
// Load Combobox Tipe Barang
cmbTipeBarang.Items.Clear();
cmbTipeBarang.DataSource = null; // Because the combobox is bound to datatable
cmbTipeBarang.ResetText(); // Make the combobox text empty
fillcombo3();
if (data_edit.getTipeBarang() == 'P')
{
cmbTipeBarang.SelectedItem = "Package";
}
else
{
cmbTipeBarang.SelectedItem = "Document";
}
// Set Textboxes to It's position and the value
txt_lama_pengiriman.Text = data_edit.getLamaHari().ToString();
txt_tarif.Text = data_edit.getOngkos().ToString();
txt_berat.Text = data_edit.getBerat().ToString();
txt_total_biaya.Text = (data_edit.getBerat() * data_edit.getOngkos()).ToString();
}
