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); }