private void ListData()
{
DataTable dt = new DataTable();
Koneksi koneksi = new Koneksi();
dt = koneksi.tampil_data_dw("SELECT pemb_id as 'PEMBIAYAAN ID',pemb_kd_bidang as 'KODE BIDANG',pemb_keterangan as 'KETERANGAN' FROM dim_pembiayaan");
try
{
paging_PageIndex = 1;
if (dt.Rows.Count > 0)
{
DataTable tmpTable = new DataTable();
tmpTable = dt.Clone();
if (dt.Rows.Count >= paging_NoOfRecPerPage)
{
for (int i = 0; i < paging_NoOfRecPerPage; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
listDatadimensi.DataContext = tmpTable.DefaultView;
tmpTable.Dispose();
dt_TempData = dt;
}
else
{
// MessageBox.Show("Message");
}
}
catch (Exception ex)
{
MessageBox.Show("Error Message" + ex);
}
} //void closing
private void ListData()
{
DataTable dt = new DataTable();
Koneksi koneksi = new Koneksi();
dt = koneksi.tampil_data_dw("SELECT fpan_tahun as 'TAHUN',fpan_id as 'KERJASAMA ID',fpan_bidang as 'KODE BIDANG',fpan_no as 'NOMOR KERJASAMA',fpan_usulan as 'NILAI USULAN (Rp.)',fpan_realisasi as 'NILAI REALISASI (Rp.)' FROM fakta_kerjasama");
try
{
paging_PageIndex = 1;
if (dt.Rows.Count > 0)
{
DataTable tmpTable = new DataTable();
tmpTable = dt.Clone();
if (dt.Rows.Count >= paging_NoOfRecPerPage)
{
for (int i = 0; i < paging_NoOfRecPerPage; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
listDatafakta.DataContext = tmpTable.DefaultView;
tmpTable.Dispose();
dt_TempData = dt;
}
else
{
// MessageBox.Show("Message");
}
}
catch (Exception ex)
{
MessageBox.Show("Error Message" + ex);
}
} //void closing
private void ListData()
{
DataTable dt = new DataTable();
Koneksi koneksi = new Koneksi();
dt = koneksi.tampil_data_dw("SELECT fcap_tahun as 'TAHUN',fcap_id as 'CAPAIAN ID',fcap_kd_bidang as 'KODE BIDANG',fcap_kd_prog as 'KODE PROGRAM',fcap_target as 'TARGET ANGKA',fcap_satuan as 'SATUAN' FROM fakta_capaian");
try
{
paging_PageIndex = 1;
if (dt.Rows.Count > 0)
{
DataTable tmpTable = new DataTable();
tmpTable = dt.Clone();
if (dt.Rows.Count >= paging_NoOfRecPerPage)
{
for (int i = 0; i < paging_NoOfRecPerPage; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
listDatafakta.DataContext = tmpTable.DefaultView;
tmpTable.Dispose();
dt_TempData = dt;
}
else
{
// MessageBox.Show("Message");
}
}
catch (Exception ex)
{
MessageBox.Show("Error Message" + ex);
}
} //void closing
private void ListData()
{
DataTable dt = new DataTable();
Koneksi koneksi = new Koneksi();
dt = koneksi.tampil_data_dw("SELECT wkt_id as 'ID WAKTU', wkt_detail as 'TAHUN' FROM dim_waktu");
try
{
paging_PageIndex = 1;
if (dt.Rows.Count > 0)
{
DataTable tmpTable = new DataTable();
tmpTable = dt.Clone();
if (dt.Rows.Count >= paging_NoOfRecPerPage)
{
for (int i = 0; i < paging_NoOfRecPerPage; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
listDatadimensi.DataContext = tmpTable.DefaultView;
tmpTable.Dispose();
dt_TempData = dt;
}
else
{
// MessageBox.Show("Message");
}
}
catch (Exception ex)
{
MessageBox.Show("Error Message" + ex);
}
} //void closing
private void ListData()
{
DataTable dt = new DataTable();
Koneksi koneksi = new Koneksi();
dt = koneksi.tampil_data_dw("SELECT fpaj_tahun as 'TAHUN',fpaj_id as 'PAJAK ID', fpaj_kd_keg as 'KODE KEGIATAN', fpaj_nilai as 'NILAI PAJAK' FROM fakta_pajak");
try
{
paging_PageIndex = 1;
if (dt.Rows.Count > 0)
{
DataTable tmpTable = new DataTable();
tmpTable = dt.Clone();
if (dt.Rows.Count >= paging_NoOfRecPerPage)
{
for (int i = 0; i < paging_NoOfRecPerPage; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
listDatafakta.DataContext = tmpTable.DefaultView;
tmpTable.Dispose();
dt_TempData = dt;
}
else
{
// MessageBox.Show("Message");
}
}
catch (Exception ex)
{
MessageBox.Show("Error Message" + ex);
}
} //void closing
private void ListData()
{
DataTable dt = new DataTable();
Koneksi koneksi = new Koneksi();
dt = koneksi.tampil_data_dw("SELECT panj_id as 'PANJAR ID',panj_no_bukt as 'NOMOR BUKTI', panj_penerima as 'PENERIMA',panj_kd_bidang as 'KODE BIDANG',panj_kd_prog as 'KODE PROGRAM',panj_kd_keg as 'KODE KEGIATAN',panj_keterangan as 'KETERANGAN PANJAR' FROM dim_panjar");
try
{
paging_PageIndex = 1;
if (dt.Rows.Count > 0)
{
DataTable tmpTable = new DataTable();
tmpTable = dt.Clone();
if (dt.Rows.Count >= paging_NoOfRecPerPage)
{
for (int i = 0; i < paging_NoOfRecPerPage; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
listDatadimensi.DataContext = tmpTable.DefaultView;
tmpTable.Dispose();
dt_TempData = dt;
}
else
{
// MessageBox.Show("Message");
}
}
catch (Exception ex)
{
MessageBox.Show("Error Message" + ex);
}
} //void closing
private void ListData()
{
DataTable dt = new DataTable();
Koneksi koneksi = new Koneksi();
dt = koneksi.tampil_data_dw("SELECT keg_id as 'KEGIATAN ID',keg_kd_keg as 'KODE KEGIATAN', keg_kd_bidang as 'KODE BIDANG',keg_kd_prog as 'KODE PROGRAM', keg_uraian as 'URAIAN KEGIATAN' FROM dim_kegiatan");
try
{
paging_PageIndex = 1;
if (dt.Rows.Count > 0)
{
DataTable tmpTable = new DataTable();
tmpTable = dt.Clone();
if (dt.Rows.Count >= paging_NoOfRecPerPage)
{
for (int i = 0; i < paging_NoOfRecPerPage; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
listDatadimensi.DataContext = tmpTable.DefaultView;
tmpTable.Dispose();
dt_TempData = dt;
}
else
{
// MessageBox.Show("Message");
}
}
catch (Exception ex)
{
MessageBox.Show("Error Message" + ex);
}
} //void closing
private void ListData()
{
DataTable dt = new DataTable();
Koneksi koneksi = new Koneksi();
dt = koneksi.tampil_data_dw("SELECT kont_id as 'KONTRAK ID',kont_spp as 'KODE SPP',kont_nomor as 'NOMOR KONTRAK',kont_nama as 'NAMA PERUSAHAAN',kont_bentuk as 'BENTUK PERUSAHAAN',kont_alamat as 'ALAMAT',kont_pimpinan as 'NAMA PIMPINAN PERUSAHAAN',kont_keperlian as 'KEPERLUAN KERJASAMA' FROM dim_kontrak");
try
{
paging_PageIndex = 1;
if (dt.Rows.Count > 0)
{
DataTable tmpTable = new DataTable();
tmpTable = dt.Clone();
if (dt.Rows.Count >= paging_NoOfRecPerPage)
{
for (int i = 0; i < paging_NoOfRecPerPage; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
listDatadimensi.DataContext = tmpTable.DefaultView;
tmpTable.Dispose();
dt_TempData = dt;
}
else
{
// MessageBox.Show("Message");
}
}
catch (Exception ex)
{
MessageBox.Show("Error Message" + ex);
}
} //void closing
private void ListData()
{
DataTable dt = new DataTable();
Koneksi koneksi = new Koneksi();
dt = koneksi.tampil_data_dw("SELECT fper_id_unit as 'UNIT ID',fper_id_subunit as 'SUB UNIT ID',fper_nama as 'NAMA',fper_angg as 'PENGGUNAAN ANGGARAN (Rp.)' FROM fakta_perangkat");
try
{
paging_PageIndex = 1;
if (dt.Rows.Count > 0)
{
DataTable tmpTable = new DataTable();
tmpTable = dt.Clone();
if (dt.Rows.Count >= paging_NoOfRecPerPage)
{
for (int i = 0; i < paging_NoOfRecPerPage; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
listDatafakta.DataContext = tmpTable.DefaultView;
tmpTable.Dispose();
dt_TempData = dt;
}
else
{
// MessageBox.Show("Message");
}
}
catch (Exception ex)
{
MessageBox.Show("Error Message" + ex);
}
} //void closing
private void ListData()
{
DataTable dt = new DataTable();
Koneksi koneksi = new Koneksi();
dt = koneksi.tampil_data_dw("SELECT subu_id as 'SUB UNIT ID',subu_kd_unit as 'KODE UNIT', subu_nama as 'NAMA',subu_nip as 'NIP',subu_jabatan as 'JABATAN' FROM dim_subunit");
try
{
paging_PageIndex = 1;
if (dt.Rows.Count > 0)
{
DataTable tmpTable = new DataTable();
tmpTable = dt.Clone();
if (dt.Rows.Count >= paging_NoOfRecPerPage)
{
for (int i = 0; i < paging_NoOfRecPerPage; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
listDatadimensi.DataContext = tmpTable.DefaultView;
tmpTable.Dispose();
dt_TempData = dt;
}
else
{
// MessageBox.Show("Message");
}
}
catch (Exception ex)
{
MessageBox.Show("Error Message" + ex);
}
} //void closing
private void ListData()
{
DataTable dt = new DataTable();
Koneksi koneksi = new Koneksi();
dt = koneksi.tampil_data_dw("SELECT log_id as 'NOMOR ID',username as 'USERNAME',keterangan as 'LEVEL USER',tingkat as 'JABATAN PENGGUNA' FROM logon");
try
{
paging_PageIndex = 1;
if (dt.Rows.Count > 0)
{
DataTable tmpTable = new DataTable();
tmpTable = dt.Clone();
if (dt.Rows.Count >= paging_NoOfRecPerPage)
{
for (int i = 0; i < paging_NoOfRecPerPage; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
listDatauser.DataContext = tmpTable.DefaultView;
tmpTable.Dispose();
dt_TempData = dt;
}
else
{
// MessageBox.Show("Message");
}
}
catch (Exception ex)
{
MessageBox.Show("Error Message" + ex);
}
} //void closing
private void ListData()
{
DataTable dt = new DataTable();
Koneksi koneksi = new Koneksi();
dt = koneksi.tampil_data_dw("SELECT fang_tahun as 'TAHUN',fang_kd_bidang as 'KODE BIDANG',fang_pend_id as 'PENDAPATAN ID',fang_pend_satuan as 'BANYAK SATUAN',fang_pend_nilai as 'NILAI PENDAPATAN',fang_pend_total as 'TOTAL PENDAPATAN',fang_pemb_id as 'PEMBIAYAAN ID',fang_pemb_satuan as 'BANYAK SATUAN',fang_nilai as 'NILAI PEMBIAYAAN',fang_pemb_total as 'TOTAL PEMBIAYAAN' FROM fakta_anggaran");
try
{
paging_PageIndex = 1;
if (dt.Rows.Count > 0)
{
DataTable tmpTable = new DataTable();
tmpTable = dt.Clone();
if (dt.Rows.Count >= paging_NoOfRecPerPage)
{
for (int i = 0; i < paging_NoOfRecPerPage; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
tmpTable.ImportRow(dt.Rows[i]);
}
}
listDatafakta.DataContext = tmpTable.DefaultView;
tmpTable.Dispose();
dt_TempData = dt;
}
else
{
// MessageBox.Show("Message");
}
}
catch (Exception ex)
{
MessageBox.Show("Error Message" + ex);
}
} //void closing