// Set All Transaksi Datas that has been retrieve to its Entity Set Functions
void GetTransaksiDetail()
{
DataTable dt = intfeditdata.getTransaksi(data_print.getIdTransaksi());
foreach (DataRow row in dt.Rows)
{
data_print.setTglTransaksi(Convert.ToString(row["tgl_transaksi"]));
data_print.setBerat(Convert.ToInt32(row["berat"]));
data_print.setIdPengirim(Convert.ToString(row["id_pengirim"]));
data_print.setIdTarif(Convert.ToInt32(row["id_tarif"]));
data_print.setIdPenerima(Convert.ToString(row["id_penerima"]));
}
}
// 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);
}
