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 ChildClick(object sender, EventArgs e)
{
ToolStripMenuItem menuItem = sender as ToolStripMenuItem;
if (menuItem.Name == "mPendidikanPengajaran")
{
if (!CekInitTahun("select id from t_pendidikan_pengajaran_init where idUser = "******"hjYir83K") +
" and nama_bulan = " + DateTime.Now.Month + " and nama_tahun = " + DateTime.Now.Year + ""))
{
MessageBox.Show("Anda Belum Menentukan Target\nSilahkan Klik Setting > Inisiasi");
return;
}
if (CekInitTahun("select id from t_pendidikan_pengajaran where idUser = "******"hjYir83K") +
" and nama_bulan = " + DateTime.Now.Month + " and nama_tahun = " + DateTime.Now.Year + ""))
{
if (MessageBox.Show("Anda sudah Mengisi Remun Bulan ini\nLanjut load data?", "Konfirmasi", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
}
ENTRY.fPendidikanPengajaran _fPendidikanPengajaran;
if ((_fPendidikanPengajaran = (ENTRY.fPendidikanPengajaran)FormSudahDibuat(typeof(ENTRY.fPendidikanPengajaran))) == null)
{
_fPendidikanPengajaran = new ENTRY.fPendidikanPengajaran();
_fPendidikanPengajaran.ID_USER = ID_USER;
_fPendidikanPengajaran.MdiParent = this;
_fPendidikanPengajaran.WindowState = FormWindowState.Maximized;
_fPendidikanPengajaran.Show();
}
else
{
//_fPendidikanPengajaran.ID_USER = CStringCipher.Encrypt(idUser, "hjYir83K");
//_fPendidikanPengajaran.Load_Pegawai();
//_fPendidikanPengajaran.Location = new Point(200, 200);
_fPendidikanPengajaran.WindowState = FormWindowState.Maximized;
_fPendidikanPengajaran.Select();
}
}
if (menuItem.Name == "mPenelitian")
{
ENTRY.fPenelitian _fPenelitian;
if ((_fPenelitian = (ENTRY.fPenelitian)FormSudahDibuat(typeof(ENTRY.fPenelitian))) == null)
{
_fPenelitian = new ENTRY.fPenelitian();
_fPenelitian.MdiParent = this;
_fPenelitian.WindowState = FormWindowState.Maximized;
_fPenelitian.Show();
}
else
{
_fPenelitian.WindowState = FormWindowState.Maximized;
_fPenelitian.Select();
}
}
if (menuItem.Name == "mPendidikanPengajaran_init")
{
if (CekInitTahun("select id from t_pendidikan_pengajaran_init where idUser = "******"hjYir83K") +
" and nama_bulan = " + DateTime.Now.Month + ""))
{
if (MessageBox.Show("Anda sudah menentukan target bulan ini, load data?", "Konfirmasi", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
}
{
SETTING.fPendidikanPengajaranInit _fPendidikanPengajaran_init;
if ((_fPendidikanPengajaran_init = (SETTING.fPendidikanPengajaranInit)FormSudahDibuat(typeof(SETTING.fPendidikanPengajaranInit))) == null)
{
_fPendidikanPengajaran_init = new SETTING.fPendidikanPengajaranInit();
_fPendidikanPengajaran_init.ID_USER = ID_USER;
_fPendidikanPengajaran_init.MdiParent = this;
_fPendidikanPengajaran_init.WindowState = FormWindowState.Maximized;
_fPendidikanPengajaran_init.Show();
}
else
{
//_fPendidikanPengajaran.ID_USER = CStringCipher.Encrypt(idUser, "hjYir83K");
//_fPendidikanPengajaran.Load_Pegawai();
//_fPendidikanPengajaran.Location = new Point(200, 200);
_fPendidikanPengajaran_init.WindowState = FormWindowState.Maximized;
_fPendidikanPengajaran_init.Select();
}
}
}
else
{
return;
}
}
private void fill_LinqGroup()
{
Thread.CurrentThread.CurrentCulture = CultureInfo.GetCultureInfo("en-US");
foreach (DataGridViewRow dgROW in dataGridView1.Rows)
{
//MessageBox.Show(dgROW.Cells[1].Value.ToString() + " | " + dgROW.Cells[2].Value.ToString() + " | " + " | " + dgROW.Cells[3].Value.ToString() +
// " | " + " | " + dgROW.Cells[4].Value.ToString() + " | " + " | " + dgROW.Cells[5].Value.ToString() + " | " + dgROW.Cells[6].Value.ToString());
_Pendidikan_Pengajaran_save.Add(new Pendidikan_Pengajaran(null, //1
Convert.ToInt16(dgROW.Cells[1].Value), //2
dgROW.Cells[2].Value.ToString(), //3
Convert.ToInt16(dgROW.Cells[3].Value), //4
Convert.ToDecimal(dgROW.Cells[4].Value), //5
Convert.ToDecimal(dgROW.Cells[5].Value), //6
Convert.ToDecimal(dgROW.Cells[6].Value), //7
Convert.ToDecimal(dgROW.Cells[7].Value), //8
Convert.ToDecimal(dgROW.Cells[8].Value), //9
Convert.ToDecimal(dgROW.Cells[9].Value), //10
Convert.ToDecimal(dgROW.Cells[10].Value), //11
Convert.ToDecimal(dgROW.Cells[11].Value), //12
Convert.ToDecimal(dgROW.Cells[12].Value), //13
Convert.ToDecimal(dgROW.Cells[13].Value), //14
Convert.ToDecimal(dgROW.Cells[14].Value), //15
Convert.ToDecimal(dgROW.Cells[15].Value), //16
Convert.ToDecimal(dgROW.Cells[16].Value), //17
Convert.ToDecimal(dgROW.Cells[17].Value), //18
Convert.ToDecimal(dgROW.Cells[18].Value), //19
Convert.ToDecimal(dgROW.Cells[19].Value), //20
Convert.ToDecimal(dgROW.Cells[20].Value), //21
Convert.ToDecimal(dgROW.Cells[21].Value), //22
Convert.ToDecimal(dgROW.Cells[22].Value), //23
Convert.ToDecimal(dgROW.Cells[23].Value), //24
Convert.ToDecimal(dgROW.Cells[24].Value), //25
Convert.ToDecimal(dgROW.Cells[25].Value), //26
Convert.ToDecimal(dgROW.Cells[26].Value), //27
Convert.ToDecimal(dgROW.Cells[27].Value), //28
Convert.ToDecimal(dgROW.Cells[28].Value), //29
Convert.ToDecimal(dgROW.Cells[29].Value), //30
Convert.ToInt16(CStringCipher.Decrypt(ID_USER, "hjYir83K")), //31
String.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now), //32
DateTime.Now.Month.ToString(), //33
DateTime.Now.Year.ToString(), //34
"1" //35
));
}
}
private void bSimpan_Click(object sender, EventArgs e)
{
Thread.CurrentThread.CurrentCulture = CultureInfo.GetCultureInfo("en-US");
if (bSimpan.Text == "Save")
{
if (MessageBox.Show("Apakah sudah fix?", "Konfirmasi", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
bSimpan.Text = "FIX?";
bSimpan.BackColor = Color.Red;
int noUrut = 1;
if (lvTampil.Items.Count > 0)
{
noUrut = lvTampil.Items.Count + 1;
}
foreach (ListViewItem items in lvTampil.Items)
{
if (items.SubItems[7].Text == "0" || items.SubItems[7].Text == "3")
{
_Pendidikan_Pengajaran_Init.Add(new Pendidikan_Pengajaran_Init(null, noUrut++, items.SubItems[1].Text,
Convert.ToInt16(items.SubItems[2].Text.Replace(",", ".")), Convert.ToDecimal(items.SubItems[3].Text.Replace(",", ".")),
Convert.ToDecimal(items.SubItems[4].Text.Replace(",", ".")), Convert.ToDecimal(items.SubItems[5].Text.Replace(",", ".")),
Convert.ToDecimal(items.SubItems[6].Text.Replace(",", ".")), 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Convert.ToInt16(CStringCipher.Decrypt(ID_USER, "hjYir83K")),
String.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now), DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString(), "1"));
}
if (items.SubItems[7].Text == "3")
{
_Pendidikan_Pengajaran_Init_temp.Add(new Pendidikan_Pengajaran_Init(Convert.ToInt16(items.SubItems[8].Text), noUrut++, items.SubItems[1].Text,
Convert.ToInt16(items.SubItems[2].Text), Convert.ToDecimal(items.SubItems[3].Text), Convert.ToDecimal(items.SubItems[4].Text),
Convert.ToDecimal(items.SubItems[5].Text), Convert.ToDecimal(items.SubItems[6].Text), 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, Convert.ToInt16(CStringCipher.Decrypt(ID_USER, "hjYir83K")),
String.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now), DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString(), "1"));
}
}
}
}
else if (bSimpan.Text == "FIX?")
{
if (MessageBox.Show("Dengan menekan tombol ini maka anda setuju sudah FIX",
"Confirmasi", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
bSimpan.Text = "Save";
bSimpan.BackColor = Color.LightGray;
Bersih2();
lvTampil.Items.Clear();
CommitLinqtoDb(_Pendidikan_Pengajaran_Init);
UpdateCommitLinqtoDb(_Pendidikan_Pengajaran_Init_temp);
_Pendidikan_Pengajaran_Init.Clear();
}
}
}
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();
}
private void contextMenuStrip1_MouseClick(object sender, MouseEventArgs e)
{
_Pendidikan_Pengajaran_Init_temp.Add(new Pendidikan_Pengajaran_Init(Convert.ToInt16(lvTampil.SelectedItems[0].SubItems[8].Text), 0, "0",
0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0,
Convert.ToInt16(CStringCipher.Decrypt(ID_USER, "hjYir83K")),
String.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now), DateTime.Now.Month.ToString(), DateTime.Now.Year.ToString(), "1"));
lvTampil.SelectedItems[0].Remove();
}
