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 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 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 loginUser(EntAdministrator et, string dt)
{
query = "SpLoginAdministrator";
dbParams = new SqlParameter[]
{
new SqlParameter("@user", et.Namapengguna),
new SqlParameter("@pass", et.Passwordpengguna)
};
table = "Administrator";
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.writeLogTrasaction(dt);
}
else
{
status = false;
}
}
return(status);
}
public bool delete(EntUnitKerja et, string dt)
{
query = "SpDeleteUnitKerja";
dbParams = new SqlParameter[]
{
new SqlParameter("@idunit", et.Idunit)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool delete(EntJenisKegiatan et, string dt)
{
query = "SpDeleteJenisKegiatan";
dbParams = new SqlParameter[]
{
new SqlParameter("@idjenis", et.Idjenis)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool delete(EntPegawai et, string dt)
{
query = "SpDeletePegawai";
dbParams = new SqlParameter[]
{
new SqlParameter("@nip", et.Nip)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool delete(EntAtasanPejabatPenilai et, string dt)
{
query = "SpDeleteAtasanPejabatPenilai";
dbParams = new SqlParameter[]
{
new SqlParameter("@idatasanpejabatpenilai", et.Idatasanpenilai)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool save(EntAtasanPejabatPenilai et, string dt)
{
query = "SpInsertAtasanPejabatPenilai";
dbParams = new SqlParameter[]
{
new SqlParameter("@nip", et.Idpegawai),
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool delete(EntDetailKegiatan ed, string dt)
{
query = "SpDeleteDetailKegiatan";
dbParams = new SqlParameter[]
{
new SqlParameter("@iddetailkegiatan", ed.Iddetailkegiatan)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
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 save(EntUnitKerja et, string dt)
{
query = "SpInsertUnitKerja";
dbParams = new SqlParameter[]
{
new SqlParameter("@unit", et.Unitkerja),
new SqlParameter("@alamatunit", et.Alamatunit)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
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 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(EntLoginPegawai et, string dt)
{
query = "SpInsertLogin";
dbParams = new SqlParameter[]
{
new SqlParameter("@nip", et.Nip),
new SqlParameter("@user", et.Namapengguna),
new SqlParameter("@pass", et.Katasandi)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
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(EntAdministrator et, string dt)
{
query = "SpEditAdministrator";
dbParams = new SqlParameter[]
{
new SqlParameter("@idadmin", et.Idadmin),
new SqlParameter("@nama", et.Nama),
new SqlParameter("@jekel", et.Jekel),
new SqlParameter("@namapengguna", et.Namapengguna),
new SqlParameter("@pass", et.Passwordpengguna)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool edit(EntKegiatan et, string dt)
{
query = "SpEditKegiatan";
dbParams = new SqlParameter[]
{
new SqlParameter("@idkegiatan", et.Idkegiatan),
new SqlParameter("@outputkegiatan", et.Outputkegiatan),
new SqlParameter("@satuan", et.Satuan),
new SqlParameter("@idjenis", et.Idjenis),
new SqlParameter("@statuskegiatan", et.Status),
new SqlParameter("@keterangan", et.Keterangan)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
return(condition);
}
public bool edit(EntPegawai et, string dt)
{
query = "SpEditPegawai";
dbParams = new SqlParameter[]
{
new SqlParameter("@nip", et.Nip),
new SqlParameter("@nama", et.Nama),
new SqlParameter("@pagolru", et.Pagolru),
new SqlParameter("@jabatan", et.Jabatan),
new SqlParameter("@idunit", et.Idunit),
new SqlParameter("@keterangan", et.Keterangan)
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
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);
}
