public bool validationReportAtasanPenilai(EntLaporan et) { query = "SpLaporanAtasanPenilai"; dbParams = new SqlParameter[] { new SqlParameter("@jabatan", et.Jabatan), new SqlParameter("@periodeawal", et.Periodeawal), new SqlParameter("@periodeakhir", et.Periodeakhir) }; table = "Pegawai"; dt = new DataTable(); condition = connect.eksekusiQuery(query, dbParams, false); if (condition) { connect.viewTable(table).Fill(dt); if (dt.Rows.Count > 0) { status = true; } else { status = false; } } return(status); }
public bool validationReportCapaian(EntLaporan et) { query = "SpLaporanHarianLCKH"; dbParams = new SqlParameter[] { new SqlParameter("@jabatan", et.Jabatan), new SqlParameter("@tanggal", et.Tanggal) }; table = "CapaianKinerjaHarian"; dt = new DataTable(); condition = connect.eksekusiQuery(query, dbParams, false); if (condition) { connect.viewTable(table).Fill(dt); if (dt.Rows.Count > 0) { status = true; } else { status = false; } } return(status); }
private void getEntiy() { el = new EntLaporan(); el.Jabatan = sendJabatan; el.Periodeawal = periodeawal; el.Periodeakhir = periodeakhir; }
private void getEntiy() { el = new EntLaporan(); el.Jabatan = sendJabatan; el.Periodeawalmutasi = dtPeriodeAwalMutasi.Value.ToString("yyyy-MM-dd"); el.Periodeakhirmutasi = dtPeriodeAkhirMutasi.Value.ToString("yyyy-MM-dd"); }
private void getEntiy() { el = new EntLaporan(); el.Jabatan = sendJabatan; el.Periodeawal = dtPeriodeAwal.Value.ToString("yyyy-MM-dd"); el.Periodeakhir = dtPeriodeAkhir.Value.ToString("yyyy-MM-dd"); el.Tanggal = dtTanggal.Value.ToString("yyyy-MM-dd"); }
public DataTable reportYangDiniali(EntLaporan et) { query = "SpLaporanYangDinilai"; table = "Pegawai"; dt = new DataTable(); dbParams = new SqlParameter[] { new SqlParameter("@jabatan", et.Jabatan) }; condition = connect.eksekusiQuery(query, dbParams, false); if (condition) { connect.viewTable(table).Fill(dt); } return(dt); }
public DataTable reportCapaian(EntLaporan et) { query = "SpLaporanHarianLCKH"; table = "CapaianKinerjaHarian"; dt = new DataTable(); dbParams = new SqlParameter[] { new SqlParameter("@jabatan", et.Jabatan), new SqlParameter("@tanggal", et.Tanggal) }; condition = connect.eksekusiQuery(query, dbParams, false); if (condition) { connect.viewTable(table).Fill(dt); } return(dt); }
public DataTable reportPeriode(EntLaporan et) { query = "SpLaporanPeriode"; table = "SasaranKerja"; dt = new DataTable(); dbParams = new SqlParameter[] { new SqlParameter("@periodeawal", et.Periodeawal), new SqlParameter("@periodeakhir", et.Periodeakhir) }; condition = connect.eksekusiQuery(query, dbParams, false); if (condition) { connect.viewTable(table).Fill(dt); } return(dt); }
public DataTable reportAtasanPenilai(EntLaporan et) { query = "SpLaporanAtasanPenilai"; table = "Pegawai"; dt = new DataTable(); dbParams = new SqlParameter[] { new SqlParameter("@jabatan", et.Jabatan), new SqlParameter("@periodeawal", et.Periodeawal), new SqlParameter("@periodeakhir", et.Periodeakhir) }; condition = connect.eksekusiQuery(query, dbParams, false); if (condition) { connect.viewTable(table).Fill(dt); } return(dt); }
public DataTable reportUkurSasaranMutasi(EntLaporan et) { query = "SpLaporanUkurSasaranMutasi"; table = "Realisasi"; dt = new DataTable(); dbParams = new SqlParameter[] { new SqlParameter("@jabatan", et.Jabatan), new SqlParameter("@mperiodeawal", et.Periodeawalmutasi), new SqlParameter("@mperiodeakhir", et.Periodeakhirmutasi) }; condition = connect.eksekusiQuery(query, dbParams, false); if (condition) { connect.viewTable(table).Fill(dt); } return(dt); }
private void printPreview() { et = new EntLaporan(); et.Jabatan = jabatan; et.Periodeawal = periodeawal; et.Periodeakhir = periodeakhir; et.Tanggal = tanggal; et.Periodeawalmutasi = periodeawalmutasi; et.Periodeakhirmutasi = periodeakhirmutasi; #region Cover if (procces.Equals("Cover", StringComparison.InvariantCultureIgnoreCase)) { if (status.Equals("Depan", StringComparison.InvariantCultureIgnoreCase)) { try { CrpCoverDepan cryRpt = new CrpCoverDepan(); cryRpt.Database.Tables["YangDinilai"].SetDataSource(ir.reportYangDiniali(et)); cryRpt.Database.Tables["LaporanPeriode"].SetDataSource(ir.reportPeriode(et)); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); } catch { setMessage(); } } else if (status.Equals("Data Pegawai", StringComparison.InvariantCultureIgnoreCase)) { try { CrpCover cryRpt = new CrpCover(); cryRpt.Database.Tables["Penilai"].SetDataSource(ir.reportPenilai(et)); cryRpt.Database.Tables["AtasanPenilai"].SetDataSource(ir.reportAtasanPenilai(et)); cryRpt.Database.Tables["YangDinilai"].SetDataSource(ir.reportYangDiniali(et)); cryRpt.Database.Tables["LaporanPeriode"].SetDataSource(ir.reportPeriode(et)); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); } catch { setMessage(); } } } #endregion #region Capaian Harian else if (procces.Equals("Capaian Harian", StringComparison.InvariantCultureIgnoreCase)) { try { CrpLCKH cryRpt = new CrpLCKH(); cryRpt.Database.Tables["Penilai"].SetDataSource(ir.reportPenilai(et)); cryRpt.Database.Tables["CapaianHarian"].SetDataSource(ir.reportCapaian(et)); cryRpt.Database.Tables["YangDinilai"].SetDataSource(ir.reportYangDiniali(et)); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); } catch { setMessage(); } } #endregion #region Sasaran Kerja else if (procces.Equals("Sasaran Kerja", StringComparison.InvariantCultureIgnoreCase)) { try { CrpWorksheet cryRpt = new CrpWorksheet(); cryRpt.Database.Tables["YangDinilai"].SetDataSource(ir.reportYangDiniali(et)); cryRpt.Database.Tables["Penilai"].SetDataSource(ir.reportPenilai(et)); cryRpt.Database.Tables["SKPAwal"].SetDataSource(ir.reportSasaranKerja(et)); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); } catch { setMessage(); } } #endregion #region Ukur Sasaran else if (procces.Equals("Ukur Sasaran", StringComparison.InvariantCultureIgnoreCase)) { try { CrpUkurSasaran cryRpt = new CrpUkurSasaran(); cryRpt.Database.Tables["Penilai"].SetDataSource(ir.reportPenilai(et)); cryRpt.Database.Tables["UkurSasaran"].SetDataSource(ir.reportUkurSasaran(et)); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); } catch { setMessage(); } } #endregion #region Perilaku Kerja else if (procces.Equals("Perilaku Kerja", StringComparison.InvariantCultureIgnoreCase)) { if (status.Equals("Perilaku Kerja Biasa", StringComparison.InvariantCultureIgnoreCase)) { try { CrpPrilakuKerja cryRpt = new CrpPrilakuKerja(); cryRpt.Database.Tables["Penilai"].SetDataSource(ir.reportPenilai(et)); cryRpt.Database.Tables["UkurSasaran"].SetDataSource(ir.reportUkurSasaran(et)); cryRpt.Database.Tables["PerilakuKerja"].SetDataSource(ir.reportPerilaku(et)); cryRpt.Database.Tables["YangDinilai"].SetDataSource(ir.reportYangDiniali(et)); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); } catch { setMessage(); } } else if (status.Equals("Perilaku Kerja Mutasi", StringComparison.InvariantCultureIgnoreCase)) { try { CrpPrilakuKerjaMutasi cryRpt = new CrpPrilakuKerjaMutasi(); cryRpt.Database.Tables["Penilai"].SetDataSource(ir.reportPenilai(et)); cryRpt.Database.Tables["UkurSasaran"].SetDataSource(ir.reportUkurSasaran(et)); cryRpt.Database.Tables["UkurSasaranMutasi"].SetDataSource(ir.reportUkurSasaranMutasi(et)); cryRpt.Database.Tables["PerilakuKerja"].SetDataSource(ir.reportPerilaku(et)); cryRpt.Database.Tables["YangDinilai"].SetDataSource(ir.reportYangDiniali(et)); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); } catch { setMessage(); } } } #endregion #region Prestasi Kerja else if (procces.Equals("Prestasi Kerja", StringComparison.InvariantCultureIgnoreCase)) { if (status.Equals("Prestasi Kerja Biasa", StringComparison.InvariantCultureIgnoreCase)) { try { CrpPenilaianPrestasi cryRpt = new CrpPenilaianPrestasi(); cryRpt.Database.Tables["AtasanPenilai"].SetDataSource(ir.reportAtasanPenilai(et)); cryRpt.Database.Tables["Penilai"].SetDataSource(ir.reportPenilai(et)); cryRpt.Database.Tables["UkurSasaran"].SetDataSource(ir.reportUkurSasaran(et)); cryRpt.Database.Tables["PerilakuKerja"].SetDataSource(ir.reportPerilaku(et)); cryRpt.Database.Tables["YangDinilai"].SetDataSource(ir.reportYangDiniali(et)); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); } catch { setMessage(); } } else if (status.Equals("Prestasi Kerja Mutasi", StringComparison.InvariantCultureIgnoreCase)) { try { CrpPenilaianPrestasiMutasi cryRpt = new CrpPenilaianPrestasiMutasi(); cryRpt.Database.Tables["AtasanPenilai"].SetDataSource(ir.reportAtasanPenilai(et)); cryRpt.Database.Tables["Penilai"].SetDataSource(ir.reportPenilai(et)); cryRpt.Database.Tables["UkurSasaran"].SetDataSource(ir.reportUkurSasaran(et)); cryRpt.Database.Tables["UkurSasaranMutasi"].SetDataSource(ir.reportUkurSasaran(et)); cryRpt.Database.Tables["PerilakuKerja"].SetDataSource(ir.reportPerilaku(et)); cryRpt.Database.Tables["YangDinilai"].SetDataSource(ir.reportYangDiniali(et)); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); } catch { setMessage(); } } } #endregion #region Lampiran else if (procces.Equals("Lampiran", StringComparison.InvariantCultureIgnoreCase)) { if (status.Equals("Awal", StringComparison.InvariantCultureIgnoreCase)) { try { CrpLampiranAwal cryRpt = new CrpLampiranAwal(); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); } catch { setMessage(); } } else if (status.Equals("Akhir", StringComparison.InvariantCultureIgnoreCase)) { try { CrpLampiranAkhir cryRpt = new CrpLampiranAkhir(); cryRpt.Database.Tables["AtasanPenilai"].SetDataSource(ir.reportAtasanPenilai(et)); cryRpt.Database.Tables["Penilai"].SetDataSource(ir.reportPenilai(et)); cryRpt.Database.Tables["YangDinilai"].SetDataSource(ir.reportYangDiniali(et)); crystalReportViewer1.ReportSource = cryRpt; crystalReportViewer1.Refresh(); } catch { setMessage(); } } } #endregion }