private void Button_Click(object sender, RoutedEventArgs e)
{
string username = Tbusername.Text;
string password = Tbpassword.Password;
if (username == "" || password == "")
{
ModernDialog.ShowMessage("USERNAME DAN PASSWORD TIDAK BOLEH KOSONG !", "KESALAHAN !", MessageBoxButton.OK);
}
else
{
com = "SELECT username FROM logon WHERE username='******' and password='******'";
log_db = sql.tampil_data_dw(com);
if (log_db.Rows.Count < 1)
{
ModernDialog.ShowMessage("USERNAME ATAU PASSWORD SALAH !", "KESALAHAN !", MessageBoxButton.OK);
}
else
{
var login_window = Window.GetWindow(this);
TDepan a = new TDepan();
a.Show();
if (login_window != null)
{
login_window.Close();
}
}
}
}
private void ListData()
{
DataTable dt = new DataTable();
Koneksi koneksi = new Koneksi();
dt = koneksi.tampil_data_dw("SELECT paj_id as 'PAJAK ID',paj_no_bukti as 'NOMOR BUKTI',paj_kd_bidang as 'KODE BIDANG',paj_kd_prog as 'KODE PROGRAM',paj_kd_keg as 'KODE KEGIATAN',paj_penyetor as 'NAMA PENYETOR',paj_keterangan as 'KETERANGAN' FROM dim_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]);
}
}
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 unit_id as 'UNIT ID',unit_kd_unit as 'KODE UNIT',unit_nama as 'NAMA UNIT' FROM dim_unit");
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 pend_id as 'PENDAPATAN ID',pend_kd_bidang as 'KODE BIDANG',pend_kd_unit as 'KODE UNIT',pend_keterangan as 'KETERANGAN',pend_satuan as 'BANYAK PENDAPATAN',pend_nilai as 'NILAI PENDAPATAN' FROM dim_pendapatan");
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 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
private void ListData()
{
DataTable dt = new DataTable();
Koneksi koneksi = new Koneksi();
dt = koneksi.tampil_data_dw("SELECT ind_id as 'INDIKATOR ID', ind_kd_bidang as 'KODE BIDANG', ind_kd_prog as 'KODE PROGRAM', ind_kd_keg as 'KODE KEGIATAN', ind_uraian as 'URAIAN' FROM dim_indikator");
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 prog_id as 'PROGRAM ID',prog_kd_prog as 'KODE PROGRAM',prog_keterangan as 'KETERANGAN' FROM dim_program");
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 fpk_tahun as 'TAHUN',fpk_kd_prog as 'KODE PROGRAM',fpk_kd_keg as 'KODE KEGIATAN',fpk_kd_bidang as 'KODE BIDANG',fpk_anggaran as 'TOTAL ANGGARAN' FROM fakta_p_k");
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 fbel_tahun as 'TAHUN',fbel_id as 'BELANJA ID',fbel_kd_keg as 'KODE KEGIATAN',fbel_satuan as 'BANYAK SATUAN',fbel_nilai as 'NILAI',fbel_total as 'TOTAL BELANJA' FROM fakta_belanja");
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 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 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 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
