public void Load_Pegawai()
{
toolStripStatusLabel1.Text = "";
toolStripStatusLabel2.Text = "";
string errMsg = "";
_connection = _connect.Connect(_configurationManager, ref errMsg, "GhY873LhT");
if (errMsg != "")
{
MessageBox.Show(errMsg);
return;
}
_sqlQuery = "select * from t_user where id = '" + CStringCipher.Decrypt(ID_USER, "hjYir83K") + "'";
MySqlDataReader reader = _connect.Reading(_sqlQuery, _connection, ref errMsg);
if (errMsg != "")
{
MessageBox.Show(errMsg);
return;
}
try
{
if (reader.HasRows)
{
while (reader.Read())
{
_Pegawai.Add(new Pegawai(Convert.ToInt16(reader[0]), Convert.ToString(reader[1]), Convert.ToString(reader[2]),
Convert.ToString(reader[3]), Convert.ToString(reader[4]), Convert.ToString(reader[5]), Convert.ToString(reader[6]),
Convert.ToString(reader[7]), Convert.ToString(reader[8]), Convert.ToString(reader[9]), Convert.ToString(reader[10])));
}
reader.Close();
var query = (from i in _Pegawai select i);
foreach (var item in query)
{
toolStripStatusLabel1.Text = "Nama: " + item.Nama;
toolStripStatusLabel2.Text = " | NIP: " + item.Nip;
statusPegawai = Convert.ToInt16(item.IsDosen);
}
}
else
{
MessageBox.Show("User atau password salah", "ERROR");
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
Load_Menu();
}
private void Load_Kegiatan()
{
string errMsg = "";
_connection = _connect.Connect(_configurationManager, ref errMsg, "GhY873LhT");
if (errMsg != "")
{
MessageBox.Show(errMsg);
return;
}
_sqlQuery = "select * from t_pendidikan_pengajaran where idUser = '******'";
MySqlDataReader reader = _connect.Reading(_sqlQuery, _connection, ref errMsg);
if (errMsg != "")
{
MessageBox.Show(errMsg); lanjut dengan update t_pendidikan_pengajaran jika data ditemukan
return;
}
try
{
if (reader.HasRows)
{
int noUrut = 1;
while (reader.Read())
{
_Pendidikan_Pengajaran.Add(new Pendidikan_Pengajaran(Convert.ToInt16(reader[0]), noUrut++, Convert.ToString(reader[2]), Convert.ToInt16(reader[3]),
Convert.ToDecimal(reader[4]), Convert.ToDecimal(reader[5]), Convert.ToDecimal(reader[6]), Convert.ToDecimal(reader[7]),
Convert.ToDecimal(reader[8]), Convert.ToDecimal(reader[9]), Convert.ToDecimal(reader[10]), Convert.ToDecimal(reader[11]),
Convert.ToDecimal(reader[12]), Convert.ToDecimal(reader[13]), Convert.ToDecimal(reader[14]), Convert.ToDecimal(reader[15]),
Convert.ToDecimal(reader[16]), Convert.ToDecimal(reader[17]), Convert.ToDecimal(reader[18]), Convert.ToDecimal(reader[19]),
Convert.ToDecimal(reader[20]), Convert.ToDecimal(reader[21]), Convert.ToDecimal(reader[22]), Convert.ToDecimal(reader[23]),
Convert.ToDecimal(reader[24]), Convert.ToDecimal(reader[25]), Convert.ToDecimal(reader[26]), Convert.ToDecimal(reader[27]),
Convert.ToDecimal(reader[28]), Convert.ToDecimal(reader[29]), Convert.ToInt16(reader[30]), Convert.ToString(reader[31]),
Convert.ToString(reader[32]), Convert.ToString(reader[33]), Convert.ToString(reader[34])));
}
reader.Close();
}
else
{
Load_Kegiatan_Init();
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
}
private void CekLogin()
{
string idUser = "";
string password = "";
string errMsg = "";
_sqlQuery = "";
_connection = _connect.Connect(_configurationManager, ref errMsg, "GhY873LhT");
if (errMsg != "")
{
MessageBox.Show(errMsg);
return;
}
_sqlQuery = "select id, passwd from t_user where nip = '" + txtNIP.Text + "'";
MySqlDataReader reader = _connect.Reading(_sqlQuery, _connection, ref errMsg);
if (errMsg != "")
{
MessageBox.Show(errMsg);
return;
}
try
{
if (reader.HasRows)
{
reader.Read();
idUser = reader[0].ToString();
password = reader[1].ToString();
reader.Close();
}
else
{
MessageBox.Show("User atau password salah", "ERROR");
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
if (CStringCipher.Decrypt(password, "hjsu939LpTie") == txtPasswd.Text)
{
if ((_fMainMenu = (ENTRY.fMainMenu)FormSudahDibuat(typeof(ENTRY.fMainMenu))) == null)
{
_fMainMenu = new ENTRY.fMainMenu();
_fMainMenu.ID_USER = CStringCipher.Encrypt(idUser, "hjYir83K");
_fMainMenu.Show();
}
else
{
_fMainMenu.ID_USER = CStringCipher.Encrypt(idUser, "hjYir83K");
_fMainMenu.Load_Pegawai();
_fMainMenu.Select();
}
Close();
}
else
{
MessageBox.Show("User atau password salah", "ERROR");
}
_connection.Close();
}
private void LoadInitTahun(int loadMode)
{
string errMsg = string.Empty;
_sqlQuery = "";
_connection = _connect.Connect(_configurationManager, ref errMsg, "GhY873LhT");
if (errMsg != "")
{
MessageBox.Show(errMsg);
return;
}
if (loadMode == 0)
{
_sqlQuery = "select * from t_pendidikan_pengajaran_init where idUser = "******"hjYir83K") +
" and nama_bulan = '" + DateTime.Now.Month + "' and nama_tahun = '" + DateTime.Now.Year + "' and status = 1";
}
else if (loadMode == 1)
{
_sqlQuery = "select * from t_pendidikan_pengajaran_init where idUser = "******"hjYir83K") +
" and nama_bulan = '" + cbBulan.Text + "' and nama_tahun = '" + cbTahun.Text + "' and status = 1";
}
MySqlDataReader reader = _connect.Reading(_sqlQuery, _connection, ref errMsg);
if (errMsg != "")
{
MessageBox.Show(errMsg);
return;
}
try
{
if (reader.HasRows)
{
int nomorUrut = 1;
while (reader.Read())
{
ListViewItem items = new ListViewItem(Convert.ToString(nomorUrut++.ToString()));
items.SubItems.Add(Convert.ToString(reader[2]));
items.SubItems.Add(Convert.ToString(reader[3]));
items.SubItems.Add(Convert.ToString(reader[4]));
items.SubItems.Add(Convert.ToString(reader[5]));
items.SubItems.Add(Convert.ToString(reader[6]));
items.SubItems.Add(Convert.ToString(reader[7]));
items.SubItems.Add("1");
items.SubItems.Add(Convert.ToString(reader[0]));
lvTampil.Items.Add(items);
}
lvTampil.Columns[7].Width = 0;
lvTampil.Columns[8].Width = 0;
lvTampil.Columns[9].Width = 0;
}
else
{
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return;
}
_connection.Close();
}
