public DataTable selectDgvSyncIII(EntLoginPegawai et)
{
query = "SpSelectSKPSyncIII";
table = "SasaranKerja";
dt = new DataTable();
dbParams = new SqlParameter[]
{
new SqlParameter("@periodeawal", et.Periodeawal),
new SqlParameter("@periodeakhir", et.Periodeakhir),
new SqlParameter("@idjenis", et.Idjenis)
};
table = "SasaranKerja";
dt = new DataTable();
condition = connect.eksekusiQuery(query, dbParams, false);
if (condition)
{
connect.viewTable(table).Fill(dt);
}
return(dt);
}
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);
}
private void loginUser()
{
elp = new EntLoginPegawai();
rc = new EntRemoteTransactionClient();
elp.Namapengguna = txtUser.Text;
elp.Jabatan = cmbJabatan.SelectedValue.ToString();
elp.Katasandi = txtPass.Text;
rc.Text = setData();
condition = rlc.loginClient(elp, rc);
if (condition)
{
sendDataToServer();
setVisibleWarningBox(true);
sendNama = txtUser.Text;
FrmMenuClient frm = new FrmMenuClient(sendNama, sendIpServer, sendHostServer, elp.Jabatan);
frm.Show();
this.Hide();
}
else
{
setVisibleWarningBox(false);
clearTextBox();
}
}
public bool validationInsert(EntLoginPegawai et)
{
query = "SpValidationInsertLoginPegawai";
dbParams = new SqlParameter[]
{
new SqlParameter("@nip", et.Nip)
};
table = "LoginPegawai";
dt = new DataTable();
condition = connect.eksekusiQuery(query, dbParams, false);
if (condition)
{
connect.viewTable(table).Fill(dt);
if (dt.Rows.Count > 0)
{
status = true;
}
else
{
status = false;
}
}
return(status);
}
public DataTable selectKegiatanOthers(EntLoginPegawai et)
{
query = "SpSetKegiatanComboBoxLCKHOthers";
table = "DetailKegiatan";
dt = new DataTable();
dbParams = new SqlParameter[]
{
new SqlParameter("@jabatan", et.Jabatan),
new SqlParameter("@periodeawal", et.Periodeawal),
new SqlParameter("@periodeakhir", et.Periodeakhir),
new SqlParameter("@tanggal", et.Tanggal),
new SqlParameter("@statuskegiatan", et.Statuskegiatan),
new SqlParameter("@keterangan", et.Keterangan)
};
condition = connect.eksekusiQuery(query, dbParams, false);
if (condition)
{
connect.viewTable(table).Fill(dt);
}
return(dt);
}
private void delete()
{
elp = new EntLoginPegawai();
elp.Nip = id;
condition = ilp.delete(elp, logTransactionDelete());
if (condition)
{
message = "Data berhasil di hapus";
MessageBox.Show(message, "Informasi - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Information);
setDataLoginPegawai();
}
else
{
message = "Data gagal di hapus";
MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void setDataLCKH()
{
elp = new EntLoginPegawai();
elp.Jabatan = sendjabatan;
elp.Tanggal = dtDate.Value.Date.ToString("yyyy-MM-dd");
dgvLCKH.DataSource = irl.selectLCKH(elp);
}
private void setDataInformation()
{
elp = new EntLoginPegawai();
elp.Jabatan = sendjabatan;
elp.Periodeawal = periode;
dgvInformationSKP.DataSource = isk.selectInformationSKP(elp);
}
private void setDataSKP()
{
elp = new EntLoginPegawai();
elp.Jabatan = sendjabatan;
elp.Periodeawal = dtPeriodeAwal.Value.Date.ToString("yyyy-MM-dd");
elp.Periodeakhir = dtPeriodeAkhir.Value.Date.ToString("yyyy-MM-dd");
dgvSKP.DataSource = isk.selectSKP(elp);
}
public bool selectPassword(EntLoginPegawai et)
{
query = "SpSelectPasswordLoginPegawai";
dbParams = new SqlParameter[]
{
new SqlParameter("@katasandi", et.Katasandi)
};
condition = connect.eksekusiQuery(query, dbParams, false);
return(condition);
}
private void editLoginPegawai()
{
elp = new EntLoginPegawai();
rtc = new EntRemoteTransactionClient();
elp.Namapengguna = receivenama;
elp.Katasandi = txtConfirmPassword.Text;
rtc.Text = setData();
conditionselect = rcp.selectPassword(elp);
if (conditionselect)
{
if (txtNewPassword.Text == txtConfirmPassword.Text)
{
condition = rcp.edit(elp, rtc);
if (condition)
{
sendDataToServer();
setVisibleNotifikasiSave(false);
clearData();
}
else
{
message = "Data gagal diubah";
MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
message = "Konfirmasi kata sandi baru tidak valid";
MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
else
{
message = "Kata sandi lama tidak valid";
MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public bool delete(EntLoginPegawai et, string dt)
{
query = "SpDeleteLogin";
dbParams = new SqlParameter[]
{
new SqlParameter("@nip", et.Nip),
};
condition = connect.eksekusiQuery(query, dbParams, false);
ls = new ImpLogServer();
ls.writeLogTrasaction(dt);
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 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 DataTable selectDgvSyncIII(EntLoginPegawai et)
{
query = "SpSelectLCKHSyncIII";
table = "CapaianKinerjaHarian";
dt = new DataTable();
dbParams = new SqlParameter[]
{
new SqlParameter("@tanggal", et.Tanggal),
new SqlParameter("@idjenis", et.Idjenis)
};
condition = connect.eksekusiQuery(query, dbParams, false);
if (condition)
{
connect.viewTable(table).Fill(dt);
}
return(dt);
}
private void save()
{
elp = new EntLoginPegawai();
elp.Nip = cmbNamaPegawai.SelectedValue.ToString();
elp.Namapengguna = txtNamaPengguna.Text;
elp.Katasandi = txtKataSandi.Text;
validation = ilp.validationInsert(elp);
if (validation)
{
message = "Pegawai dengan NIP : " + cmbNamaPegawai.SelectedValue.ToString() + "sudah memnpunyai akun login";
MessageBox.Show(message, "Informasi - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
condition = ilp.save(elp, logTransactionSave());
if (condition)
{
setVisibleNotifikasiSave(false);
clearData();
}
else
{
message = "Data gagal disimpan";
MessageBox.Show(message, "Pesan Kesalahan - SIMKAP 1.0.0",
MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
