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);
}
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);
}
public bool loginClient(EntLoginPegawai et, EntRemoteTransactionClient rtc)
{
query = "SpLoginPegawai";
dbParams = new SqlParameter[]
{
new SqlParameter("@namapengguna", et.Namapengguna),
new SqlParameter("@jabatan", et.Jabatan),
new SqlParameter("@katasandi", et.Katasandi)
};
table = "Pegawai";
dtb = new DataTable();
condition = connect.eksekusiQuery(query, dbParams, false);
if (condition)
{
connect.viewTable(table).Fill(dtb);
if (dtb.Rows.Count > 0)
{
status = true;
ls = new ImpLogServer();
ls.writeSaveLogTransactionClient(rtc.Text);
}
else
{
status = false;
}
}
return(status);
}
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(EntLoginPegawai et, EntRemoteTransactionClient rtc)
{
query = "SpEditLogin";
dbParams = new SqlParameter[]
{
new SqlParameter("@namapengguna", et.Namapengguna),
new SqlParameter("@pass", et.Katasandi)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeSaveLogTransactionClient(rtc.Text);
return(condition);
}
public bool edit(EntLCKH et, EntRemoteTransactionClient rtc)
{
query = "SpEditLCKHNoSync";
dbParams = new SqlParameter[]
{
new SqlParameter("@jumlah", et.Jumlah),
new SqlParameter("@idcapian", et.Idcapaian)
};
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);
}
public bool save(EntLCKH et, EntRemoteTransactionClient rtc)
{
query = "SpInsertLCKH";
dbParams = new SqlParameter[]
{
new SqlParameter("@iddetailkegiatan", et.Idetailkegiatan),
new SqlParameter("@jumlah", et.Jumlah),
new SqlParameter("@keterangan", et.Keterangan)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeSaveLogTransactionClient(rtc.Text);
return(condition);
}
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 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);
}