private void save()
{
euk = new EntUkurSasaran();
etc = new EntRemoteTransactionClient();
foreach (DataGridViewRow row in dgvDataUkurSasaran.Rows)
{
euk.Idsasaran = Convert.ToInt32(row.Cells["idsasarankerja"].Value.ToString());
euk.Idrealisasi = Convert.ToInt32(row.Cells["idrealisasi"].Value.ToString());
euk.Perhitungan = Convert.ToDouble(row.Cells["perhitungan"].Value.ToString());
euk.Capaian = Convert.ToDouble(row.Cells["capaian"].Value.ToString());
etc.Text = DateTime.Now.ToString("dd/MM/yyyy") + " " + DateTime.Now.ToString("hh:mm:ss") + " " + "[" + "Insert Ukur Sasaran Kerja" + "]" + "" +
"" + " " + sendIpAddress + " " + sendNama;
condition = iuk.save(euk, etc);
}
if (condition)
{
sendDataToServer();
FrmDataUkurSasaran frm = new FrmDataUkurSasaran(viewForm, sendIpAddress, sendNama, sendJabatan);
viewForm(frm);
}
else
{
message = "Data gagal disimpan";
MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void setDataUkurSasaran()
{
euk = new EntUkurSasaran();
euk.Jabatan = sendJabatan;
euk.Periodeawal = sendPeriodeAwal;
euk.Periodeakhir = sendPeriodeAkhir;
dgvDataUkurSasaran.DataSource = iuk.selectUkurSasaran(euk);
}
private void setDataUkurSasaran()
{
euk = new EntUkurSasaran();
euk.Jabatan = sendJabatan;
euk.Periodeawal = dtPeriodeAwal.Value.Date.ToString("yyyy-MM-dd");
euk.Periodeakhir = dtPeriodeAkhir.Value.Date.ToString("yyyy-MM-dd");
dgvDataUkurSasaran.DataSource = iuk.selectDataUkurSasaran(euk);
}
public bool save(EntUkurSasaran et, EntRemoteTransactionClient rtc)
{
query = "SpInsertUkurSasaran";
dbParams = new SqlParameter[]
{
new SqlParameter("@idsasaran", et.Idsasaran),
new SqlParameter("@idrealisasi", et.Idrealisasi),
new SqlParameter("@perhitungan", et.Perhitungan),
new SqlParameter("@capaian", et.Capaian)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeSaveLogTransactionClient(rtc.Text);
return(condition);
}
public DataTable selectDataUkurSasaran(EntUkurSasaran et)
{
query = "SpSelectDataUkurSasaran";
table = "UkurSasaranKerja";
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);
}
