示例#1
0
        private void delete()
        {
            esk = new EntSasaranKerja();
            etc = new EntRemoteTransactionClient();

            esk.Idsasarankerja = id;

            etc.Text = setData();

            condition = isk.delete(esk, etc);

            if (condition)
            {
                sendDataToServer();

                message = "Data berhasil di hapus";

                MessageBox.Show(message, "Informasi - SIMKAP 1.0.0",
                                MessageBoxButtons.OK, MessageBoxIcon.Information);

                setDataSKP();
            }
            else
            {
                message = "Data gagal di hapus";

                MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
                                MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        public bool save(EntSasaranKerja et, EntRemoteTransactionClient rtc)
        {
            query = "SpInsertSasaranKerja";

            dbParams = new SqlParameter[]
            {
                new SqlParameter("@idekegiatan", et.Iddetailkegiatan),
                new SqlParameter("@idpenilai", et.Idpenilai),
                new SqlParameter("@idatasanpenilai", et.Idatasanpenilai),
                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);
        }
        private void edit()
        {
            esk = new EntSasaranKerja();
            etc = new EntRemoteTransactionClient();

            esk.Periodeawal  = sendperiodeawal.Text;
            esk.Periodeakhir = dtPeriodeAkhir.Value.Date.ToString("yyyy-MM-dd");
            esk.Jabatan      = sendjabatan;

            etc.Text = setData();

            condition = isk.edit(esk, etc);

            if (condition)
            {
                sendDataToServer();
                setVisibleNotifikasiEditSucces();
            }
            else
            {
                message = "Data gagal diubah";

                MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
                                MessageBoxButtons.OK, MessageBoxIcon.Error);
            }
        }
        public bool delete(EntSasaranKerja et, EntRemoteTransactionClient rtc)
        {
            query = "SpDeleteSasaranKerja";

            dbParams = new SqlParameter[]
            {
                new SqlParameter("@idsasarankerja", et.Idsasarankerja)
            };

            condition = connect.eksekusiQuery(query, dbParams, false);

            ls = new ImpLogServer();
            ls.writeSaveLogTransactionClient(rtc.Text);

            return(condition);
        }
        public bool edit(EntSasaranKerja et, EntRemoteTransactionClient rtc)
        {
            query = "SpEditSasaranKerja";

            dbParams = new SqlParameter[]
            {
                new SqlParameter("@periodeawal", et.Periodeawal),
                new SqlParameter("@periodeakhir", et.Periodeakhir),
                new SqlParameter("@jabatan", et.Jabatan)
            };

            condition = connect.eksekusiQuery(query, dbParams, false);

            ls = new ImpLogServer();
            ls.writeSaveLogTransactionClient(rtc.Text);

            return(condition);
        }