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(); }