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
}
