public bool validationInsert(EntPrilakukerja et)
{
query = "SpValidationInsertPrilakuKerja";
dbParams = new SqlParameter[]
{
new SqlParameter("@periodeawal", et.Periodeawal),
new SqlParameter("@periodeakhir", et.Periodeakhir),
new SqlParameter("@jabatan", et.Jabatan)
};
table = "PrilakuKerja";
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 save(EntPrilakukerja et, EntRemoteTransactionClient rtc)
{
query = "SpInsertPrilakuKerja";
dbParams = new SqlParameter[]
{
new SqlParameter("@nip", et.Nip),
new SqlParameter("@orientasi", et.Orientasi),
new SqlParameter("@integritas", et.Integritas),
new SqlParameter("@disiplin", et.Disiplin),
new SqlParameter("@kerjasama", et.Kerjasama),
new SqlParameter("@periodeawal", et.Periodeawal),
new SqlParameter("@periodeakhir", et.Periodeakhir),
new SqlParameter("@idatasanpenilai", et.Idatasanpenilai),
new SqlParameter("@idpejabatpenilai", et.Idpejabatpenilai),
new SqlParameter("@kepemimpinan", et.Kepemimpinam),
new SqlParameter("@komitmen", et.Komitmen),
new SqlParameter("@jumlah", et.Jumlah),
new SqlParameter("@ratarata", et.Ratarata)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeSaveLogTransactionClient(rtc.Text);
return(condition);
}
private void edit()
{
epk = new EntPrilakukerja();
etc = new EntRemoteTransactionClient();
epk.Idprilaku = Convert.ToInt32(sendIdPrilaku);
epk.Orientasi = Convert.ToDouble(txtOrientasi.Text);
epk.Integritas = Convert.ToDouble(txtIntegritas.Text);
epk.Disiplin = Convert.ToDouble(txtDisiplin.Text);
epk.Kerjasama = Convert.ToDouble(txtKerjasama.Text);
epk.Kepemimpinam = Convert.ToDouble(txtKepemimpinan.Text);
epk.Komitmen = Convert.ToDouble(txtKomitmen.Text);
epk.Jumlah = Convert.ToDouble(txtJumlah.Text);
epk.Ratarata = Convert.ToDouble(txtNilaiRata.Text);
etc.Text = setData();
condition = ipl.edit(epk, etc);
if (condition)
{
sendDataToServer();
setVisibleNotifikasiEditSucces();
}
else
{
message = "Data gagal diubah";
MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void setCmbNIP()
{
epk = new EntPrilakukerja();
epk.Jabatan = sendJabatan;
cmbNip.DataSource = ipk.setCmbNIP(epk);
cmbNip.DisplayMember = "nip";
cmbNip.ValueMember = "nip";
}
private void setDataPrilakuKerja()
{
epk = new EntPrilakukerja();
epk.Jabatan = sendJabatan;
epk.Periodeawal = dtPeriodeAwal.Value.Date.ToString("yyyy-MM-dd");
epk.Periodeakhir = dtPeriodeAkhir.Value.Date.ToString("yyyy-MM-dd");
dgvDataPrilakuKerja.DataSource = ipl.selectPrilakuKerja(epk);
}
private void save()
{
epk = new EntPrilakukerja();
etc = new EntRemoteTransactionClient();
epk.Periodeawal = sendPeriodeAwal;
epk.Periodeakhir = sendPeriodeAkhir;
epk.Idatasanpenilai = sendidatasanpenilai;
epk.Idpejabatpenilai = sendidpenilai;
epk.Nip = cmbNip.SelectedValue.ToString();
epk.Orientasi = Convert.ToDouble(txtOrientasi.Text);
epk.Integritas = Convert.ToDouble(txtIntegritas.Text);
epk.Disiplin = Convert.ToDouble(txtDisiplin.Text);
epk.Kerjasama = Convert.ToDouble(txtKerjasama.Text);
epk.Kepemimpinam = Convert.ToDouble(txtKepemimpinan.Text);
epk.Komitmen = Convert.ToDouble(txtKomitmen.Text);
epk.Jumlah = Convert.ToDouble(txtJumlah.Text);
epk.Ratarata = Convert.ToDouble(txtNilaiRata.Text);
epk.Jabatan = sendJabatan;
etc.Text = setData();
validation = ipk.validationInsert(epk);
if (validation)
{
message = "Anda sudah menginputkan data nilai pada periode " + sendPeriodeAwal + " - " + sendPeriodeAkhir;
MessageBox.Show(message, "Informasi - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
condition = ipk.save(epk, etc);
if (condition)
{
sendDataToServer();
clearData();
setVisibleNotifikasiSave(false);
}
else
{
message = "Data gagal disimpan";
MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
public DataTable setCmbNIP(EntPrilakukerja et)
{
query = "SpSetCmbNip";
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 selectPrilakuKerja(EntPrilakukerja et)
{
query = "SpSelectPrilakuKerja";
table = "PrilakuKerja";
dt = new DataTable();
dbParams = new SqlParameter[]
{
new SqlParameter("@periodeawal", et.Periodeawal),
new SqlParameter("@periodeakhir", et.Periodeakhir),
new SqlParameter("@jabatan", et.Jabatan)
};
condition = connect.eksekusiQuery(query, dbParams, false);
if (condition)
{
connect.viewTable(table).Fill(dt);
}
return(dt);
}
public bool edit(EntPrilakukerja et, EntRemoteTransactionClient rtc)
{
query = "SpEditPrilakuKerja";
dbParams = new SqlParameter[]
{
new SqlParameter("@idprilaku", et.Idprilaku),
new SqlParameter("@orientasi", et.Orientasi),
new SqlParameter("@integritas", et.Integritas),
new SqlParameter("@disiplin", et.Disiplin),
new SqlParameter("@kerjasama", et.Kerjasama),
new SqlParameter("@kepemimpinan", et.Kepemimpinam),
new SqlParameter("@komitmen", et.Komitmen),
new SqlParameter("@jumlah", et.Jumlah),
new SqlParameter("@ratarata", et.Ratarata)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeSaveLogTransactionClient(rtc.Text);
return(condition);
}
