private void save()
{
etc = new EntRemoteTransactionClient();
ers = new EntRealisasi();
foreach (DataGridViewRow row in dgvWorkSheetRealisasi.Rows)
{
ers.Iddetailkegiatan = row.Cells["iddetailkegiatan"].Value.ToString();
ers.Kuantitas = Convert.ToInt32(row.Cells["kuantitas"].Value.ToString());
ers.Kualitas = Convert.ToInt32(row.Cells["kualitas"].Value.ToString());
ers.Jumlahwaktu = Convert.ToInt32(row.Cells["waktu"].Value.ToString());
ers.Satuanwaktu = row.Cells["satuanwaktu"].Value.ToString();
ers.Biaya = Convert.ToDouble(row.Cells["biaya"].Value.ToString());
ers.Periodeawal = sendPeriodeAwal;
ers.Periodeakhir = sendPeriodeAkhir;
etc.Text = setData();
condition = irr.save(ers, etc);
}
if (condition)
{
sendDataToServer();
FrmDataRealisasi frm = new FrmDataRealisasi(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 setDataRealisasi()
{
ers = new EntRealisasi();
ers.Jabatan = sendJabatan;
ers.Periodeawal = dateStart.Value.Date.ToString("yyyy-MM-dd");
ers.Periodeakhir = dateEnd.Value.Date.ToString("yyyy-MM-dd");
dgvDataRealisasi.DataSource = irr.selectDataRealisasi(ers);
}
private void setDataCount()
{
ers = new EntRealisasi();
ers.Jabatan = sendJabatan;
ers.Periodeawal = sendPeriodeAwal;
ers.Periodeakhir = sendPeriodeAkhir;
dgvWorkSheetRealisasi.DataSource = irr.selectRealisasi(ers);
}
public DataTable selectDataRealisasi(EntRealisasi et)
{
query = "SpSelectRealisasi";
dbParams = new SqlParameter[]
{
new SqlParameter("@jabatan", et.Jabatan),
new SqlParameter("@perIodeawal", et.Periodeawal),
new SqlParameter("@periodeakhir", et.Periodeakhir)
};
table = "CapaianKinerjaHarian";
dt = new DataTable();
condition = connect.eksekusiQuery(query, dbParams, false);
if (condition)
{
connect.viewTable(table).Fill(dt);
}
return(dt);
}
public bool save(EntRealisasi et, EntRemoteTransactionClient rtc)
{
query = "SpInsertRealisasi";
dbParams = new SqlParameter[]
{
new SqlParameter("@iddetailkegiatan", et.Iddetailkegiatan),
new SqlParameter("@kuantitas", et.Kuantitas),
new SqlParameter("@kualitas", et.Kualitas),
new SqlParameter("@jumlahwaktu", et.Jumlahwaktu),
new SqlParameter("@satuanwaktu", et.Satuanwaktu),
new SqlParameter("@biaya", et.Biaya),
new SqlParameter("@perodeawal", et.Periodeawal),
new SqlParameter("@periodeakhir", et.Periodeakhir)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeSaveLogTransactionClient(rtc.Text);
return(condition);
}
