private void Dg_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
if (e.ColumnIndex == Dg.GetColumnIndexByHeader("PILIH"))
{
if (Dg.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString().Equals("BELUM"))
{
Dictionary <string, string> data = new Dictionary <string, string>
{
{ "tahunajaran", CbTahunAjaran.Text },
{ "kodekelas", kodekelas[CbKelas.SelectedIndex] },
{ "kelas", CbKelas.Text },
{ "kodepelajaran", Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("KODE PELAJARAN")].Value.ToString() },
{ "kodemapel", Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("KODE MAPEL")].Value.ToString() },
{ "pelajaran", Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("PELAJARAN")].Value.ToString() },
};
FKelolaPengajaran f = new FKelolaPengajaran(data);
f.ShowDialog();
Loaddb();
}
else
{
FKelolaPengajaran f = new FKelolaPengajaran(Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("KODE JADWAL")].Value);
f.ShowDialog();
Dg.LoadIndex(Loaddb, e.ColumnIndex);
}
}
}
}
private void Dg_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
if (e.ColumnIndex == Dg.GetColumnIndexByHeader("UBAH"))
{
Dg.Enabled = false;
TbJenisNilai.Text = Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("JENIS NILAI")].Value.ToString();
TbKeterangan.Text = Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("KETERANGAN")].Value.ToString();
}
else if (e.ColumnIndex == Dg.GetColumnIndexByHeader("HAPUS"))
{
if (Dg.Rows[e.RowIndex].Cells[0].Value.ToString().Equals("JN0000000000001"))
{
MessageBox.Show("Tidak dapat menghapus Jenis nilai ini!!", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
if (MessageBox.Show("Hapus mata pelajaran?", "Pertanyaan", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (A.DBHapus("UPDATE `r_jenisnilai` SET `hapus` = 'Y' WHERE `kode_jenisnilai` = '" + Dg.Rows[e.RowIndex].Cells[0].Value.ToString() + "';"))
{
Loaddb();
}
}
}
}
}
}
private void Dg_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
if (e.ColumnIndex == Dg.GetColumnIndexByHeader("PILIH"))
{
int index = Dg.CurrentRow.Index;
if (Dg.CurrentRow.Cells[Dg.GetColumnIndexByHeader("PILIH")].Value.ToString().Equals("SUDAH"))
{
if (MessageBox.Show("Hapus Kelas?", "Pertanyaan", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (A.ManipulasiData("DELETE FROM `tb_ruangan` " +
"WHERE `kode_ruangan` = '" + Dg.CurrentRow.Cells[Dg.GetColumnIndexByHeader("KODE RUANGAN")].Value.ToString() + "'"))
{
Dg.LoadIndex(loaddb, 2);
}
}
}
else
{
string value = "";
A.InputRichTextBox("Keterangan", "Input", ref value);
A.SetInsert("INSERT INTO `tb_ruangan` (`kode_ruangan`,`kode_kelas`,`kode_siswa`,`tahunajaran`,`keterangan`,`tanggal`,`id_user`) ");
A.SetValues("VALUES ('" + A.GenerateKode("RG", "tb_ruangan", "kode_ruangan") + "', '" + KodeKelas[CbKelas.SelectedIndex] + "', " +
"'" + Dg.Rows[e.RowIndex].Cells[0].Value.ToString() + "', '" + CbTahunAjaran.Text + "', '" + value + "', NOW(), '" + S.GetUserid() + "')");
A.SetQueri(A.GetInsert() + A.GetValues() + ";");
if (A.GetQueri().ManipulasiData())
{
Dg.LoadIndex(loaddb, 2);
}
}
}
}
}
private void Bubah_Click(object sender, EventArgs e)
{
FKelolaUser f = new FKelolaUser(Dg.CurrentRow.Cells[Dg.GetColumnIndexByHeader("ID USER")].Value.ToString());
f.ShowDialog();
Loaddb();
}
private void Dg_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (Dg.SelectedRows.Count > 0 && e.RowIndex >= 0)
{
tbket.Text = Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("KETERANGAN")].Value.ToString();
tbhakakses.Text = Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("HAK AKSES")].Value.ToString();
}
}
private void BUbah_Click(object sender, EventArgs e)
{
if (Dg.Rows.Count >= 0)
{
if (Dg.SelectedRows.Count > 0)
{
FInputSiswa f = new FInputSiswa(Dg.CurrentRow.Cells[Dg.GetColumnIndexByHeader("KODE SISWA")].Value.ToString());
f.ShowDialog();
Dg.LoadIndex(Loaddb, 1);
}
}
else
{
MessageBox.Show("Data Kosong!", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void Bsimpan_Click(object sender, EventArgs e)
{
if (Dg.SelectedRows.Count > 0)
{
if (MessageBox.Show("Simpan?", "Pertanyaan", MessageBoxButtons.OK, MessageBoxIcon.Question) == DialogResult.Yes)
{
A.SetQueri("UPDATE `m_akses` SET `nama_akses`='" + tbhakakses.Text + "', `ket_akses`='" + tbket.Text + "' WHERE `id_akses`=" +
Dg.CurrentRow.Cells[Dg.GetColumnIndexByHeader("ID HAK AKSES")].Value.ToString());
if (A.GetQueri().ManipulasiData())
{
MessageBox.Show("Data berhasil di simpan!", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
tbket.Clear();
tbhakakses.Clear();
Loaddb();
}
}
}
}
private void Dg_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
if (e.ColumnIndex == Dg.GetColumnIndexByHeader("UBAH"))
{
Dg.Enabled = false;
TbKelas.Text = Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("KELAS")].Value.ToString();
TbUrutan.Text = Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("URUTAN")].Value.ToString();
TbKeterangan.Text = Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("KETERANGAN")].Value.ToString();
}
else if (e.ColumnIndex == Dg.GetColumnIndexByHeader("HAPUS"))
{
if (MessageBox.Show("Hapus mata pelajaran?", "Pertanyaan", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (A.DBHapus("UPDATE `r_kelas` SET `hapus` = 'Y' WHERE `kode_kelas` = '" + Dg.Rows[e.RowIndex].Cells[0].Value.ToString() + "';"))
{
Loaddb();
}
}
}
}
}
private void Dg_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex >= 0)
{
if (e.ColumnIndex == Dg.GetColumnIndexByHeader("UBAH"))
{
Dg.Enabled = false;
TbKodeMapel.Text = Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("KODE MAPEL")].Value.ToString();
TbMataPelajaran.Text = Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("MATA PELAJARAN")].Value.ToString();
CbStatus.Text = Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("AKTIF")].Value.ToString();
}
else if (e.ColumnIndex == Dg.GetColumnIndexByHeader("HAPUS"))
{
if (MessageBox.Show("Hapus mata pelajaran?", "Pertanyaan", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (A.DBHapus("UPDATE `r_matapelajaran` SET `hapus` = 'Y' WHERE `kodepelajaran` = '" + Dg.Rows[e.RowIndex].Cells[0].Value.ToString() + "';"))
{
Loaddb();
}
}
}
}
}
private void Dg_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (e.ColumnIndex == Dg.GetColumnIndexByHeader("INPUT"))
{
if (Dg.Rows[e.RowIndex].Cells[e.ColumnIndex].Value.ToString().Equals("INPUT"))
{
string nilai = Dg.CurrentRow.Cells[Dg.GetColumnIndexByHeader("NILAI")].Value.ToString();
if (A.InputTextBox("Input", "Nilai", ref nilai) == DialogResult.OK)
{
string keterangan = Dg.CurrentRow.Cells[Dg.GetColumnIndexByHeader("KETERANGAN")].Value.ToString();
A.InputRichTextBox("Keterangan", "Input", ref keterangan);
A.SetQueri("INSERT INTO `tb_nilai` (`kode_nilai`, `kode_jenisnilai`, `kode_ruangan`, `kode_jadwal`, `tanggal`, `id_user`, `nilai`, `keterangan`) " +
"VALUES ('" + A.GenerateKode("NL", "tb_nilai", "kode_nilai") + "', '" + KodeJenisNilai[CbJenisNilai.SelectedIndex] + "', " +
"'" + Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("KODE RUANGAN")].Value.ToString() + "', " +
"(SELECT `kode_jadwal` FROM `tb_jadwal` WHERE `kode_guru`='" + S.GetKodeGuru() + "' " +
"AND `kode_kelas`='" + KodeKelas[CbKelas.SelectedIndex] + "' AND `kode_pelajaran`= '" + KodePelajaran[CbMataPelajaran.SelectedIndex] + "' " +
"AND `tahunajaran`= '" + CbTahunAjaran.Text + "'), NOW(), '" + S.GetUserid() + "', '" + nilai + "', '" + keterangan + "');");
if (A.GetQueri().ManipulasiData())
{
Dg.LoadIndex(Loaddb, e.ColumnIndex);
}
}
}
else
{
if (MessageBox.Show("Hapus data nilai?", "Pertanyaan", MessageBoxButtons.OK, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (A.DBHapus("DELETE FROM `tb_nilai` WHERE `kode_nilai` = '" + Dg.Rows[e.RowIndex].Cells[Dg.GetColumnIndexByHeader("KODE NILAI")].Value.ToString() + "';"))
{
Loaddb();
}
}
}
}
else if (e.ColumnIndex == Dg.GetColumnIndexByHeader("NILAI"))
{
if (Dg.CurrentRow.Cells[Dg.GetColumnIndexByHeader("INPUT")].Value.ToString().Equals("INPUT"))
{
MessageBox.Show("Klik input!!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
string nilai = Dg.CurrentRow.Cells[Dg.GetColumnIndexByHeader("NILAI")].Value.ToString();
if (A.InputTextBox("Input", "Nilai", ref nilai) == DialogResult.OK)
{
if (A.ManipulasiData("UPDATE `tb_nilai` SET `nilai` = '" + nilai + "' " +
"WHERE `kode_nilai` = '" + Dg.CurrentRow.Cells[Dg.GetColumnIndexByHeader("KODE NILAI")].Value.ToString() + "';"))
{
Dg.LoadIndex(Loaddb, e.ColumnIndex);
}
}
}
}
else if (e.ColumnIndex == Dg.GetColumnIndexByHeader("KETERANGAN"))
{
if (Dg.CurrentRow.Cells[Dg.GetColumnIndexByHeader("INPUT")].Value.ToString().Equals("INPUT"))
{
MessageBox.Show("Klik input!!", "Info", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
string nilai = Dg.CurrentRow.Cells[Dg.GetColumnIndexByHeader("KETERANGAN")].Value.ToString();
if (A.InputRichTextBox("Input", "Keterangan", ref nilai) == DialogResult.OK)
{
if (A.ManipulasiData("UPDATE `tb_nilai` SET `keterangan` = '" + nilai + "' " +
"WHERE `kode_nilai` = '" + Dg.CurrentRow.Cells[Dg.GetColumnIndexByHeader("KODE NILAI")].Value.ToString() + "';"))
{
Dg.LoadIndex(Loaddb, e.ColumnIndex);
}
}
}
}
}
public FKelolaPengajaran(Dictionary <string, string> data)
{
InitializeComponent();
this.SetControlFrom();
Loadawal();
BHapus.Visible = false;
string kodekelas = "", kodepelajaran = "";
foreach (KeyValuePair <string, string> item in data)
{
if (item.Key.Equals("tahunajaran"))
{
TbTahunAjaran.Text = item.Value;
}
else if (item.Key.Equals("kodekelas"))
{
kodekelas = item.Value;
}
else if (item.Key.Equals("kelas"))
{
TbKelas.Text = item.Value;
}
else if (item.Key.Equals("kodepelajaran"))
{
kodepelajaran = item.Value;
}
else if (item.Key.Equals("kodemapel"))
{
TbKodeMapel.Text = item.Value;
}
else if (item.Key.Equals("pelajaran"))
{
TbPelajaran.Text = item.Value;
}
}
BSimpan.Click += (sender, e) =>
{
if (string.IsNullOrEmpty(TbTahunAjaran.Text))
{
MessageBox.Show("Tahun ajaran kosong!", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (string.IsNullOrEmpty(TbKelas.Text))
{
MessageBox.Show("Kelas kosong!", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (string.IsNullOrEmpty(CbGuru.Text))
{
MessageBox.Show("Guru kosong!", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (string.IsNullOrEmpty(TbKodeMapel.Text))
{
MessageBox.Show("Kode mapel kosong!", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (Dg.Rows.Count <= 0)
{
MessageBox.Show("Tabel kosong!", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
string kodejadwal = A.GenerateKode("JD", "tb_jadwal", "kode_jadwal");
A.SetInsert("INSERT INTO `tb_jadwal` (`kode_jadwal`,`kode_guru`,`kode_kelas`,`kode_pelajaran`,`tahunajaran`,`keterangan`,`tanggal`,`id_user`) ");
A.SetValues("VALUES ('" + kodejadwal + "', '" + KodeGuru[CbGuru.SelectedIndex] + "', '" + kodekelas + "', '" + kodepelajaran + "', " +
"'" + TbTahunAjaran.Text + "', '" + TbKeterangan.StrEscape() + "', NOW(), '" + S.GetUserid() + "') ");
A.SetQueri(A.GetInsert() + A.GetValues() + ";");
foreach (DataGridViewRow b in Dg.Rows)
{
A.SetInsert("INSERT INTO `tb_waktupelajaran` (`kode_jadwal`,`totaljam`,`hari`,`waktu`,`id_user`,`tanggal`) ");
A.SetValues("VALUES ('" + kodejadwal + "', '" + CbJumlahJam.Text + "', '" + CbHari.Text + "', " +
"'" + CbJam.Text + ":" + CbMenit.Text + ":00', '" + S.GetUserid() + "', NOW()) ");
A.SetQueri(A.GetQueri() + A.GetInsert() + A.GetValues() + ";");
}
if (A.GetQueri().ManipulasiData())
{
MessageBox.Show("Jadwal telah tersimpan!!", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
}
}
};
Dg.CellClick += (sender, e) =>
{
if (e.RowIndex >= 0)
{
if (e.ColumnIndex == Dg.GetColumnIndexByHeader("HAPUS"))
{
Dg.Rows.RemoveAt(e.RowIndex);
}
}
};
}
public FKelolaPengajaran(object kodejadwal)
{
List <string> deletelist = new List <string>();
InitializeComponent();
this.SetControlFrom();
Loadawal();
string kodekelas = "", kodepelajaran = "";
foreach (DataRow b in A.GetData("SELECT `tahunajaran`, `namakelas`, `kode_guru`, `kodemapel`, `namapelajaran`, " +
"`J`.`keterangan`,`J`.`kode_kelas`, `kodepelajaran` FROM `tb_jadwal` `J` " +
"LEFT JOIN `r_kelas` `K` ON `K`.`kode_kelas`=`J`.`kode_kelas` " +
"LEFT JOIN `r_matapelajaran` `MP` ON `MP`.`kodepelajaran` =`J`.`kode_pelajaran` ").Rows)
{
TbTahunAjaran.Text = b["tahunajaran"].ToString();
TbKelas.Text = b["namakelas"].ToString();
CbGuru.SelectedIndex = KodeGuru.FindIndex(x => x.Equals(b["kode_guru"].ToString()));
TbKodeMapel.Text = b["kodemapel"].ToString();
TbPelajaran.Text = b["namapelajaran"].ToString();
TbKeterangan.Text = b["keterangan"].ToString();
kodekelas = b["kode_kelas"].ToString();
kodepelajaran = b["kodepelajaran"].ToString();
}
A.SetQueri("SELECT `idwaktupelajaran`, `hari`, `waktu`, `totaljam` FROM `tb_waktupelajaran` WHERE `kode_jadwal`='" + kodejadwal + "';");
Dg.QueriToDg();
BSimpan.Click += (sender, e) =>
{
if (string.IsNullOrEmpty(TbTahunAjaran.Text))
{
MessageBox.Show("Tahun ajaran kosong!", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (string.IsNullOrEmpty(TbKelas.Text))
{
MessageBox.Show("Kelas kosong!", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (string.IsNullOrEmpty(CbGuru.Text))
{
MessageBox.Show("Guru kosong!", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else if (string.IsNullOrEmpty(TbKodeMapel.Text))
{
MessageBox.Show("Kode mapel kosong!", "Peringatan", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
A.SetInsert("INSERT INTO `tb_jadwal` (`kode_jadwal`,`kode_guru`,`kode_kelas`,`kode_pelajaran`,`tahunajaran`,`keterangan`,`tanggal`,`id_user`) ");
A.SetValues("VALUES ('" + kodejadwal + "', '" + KodeGuru[CbGuru.SelectedIndex] + "', '" + kodekelas + "', '" + kodepelajaran + "', " +
"'" + TbTahunAjaran.Text + "', '" + TbKeterangan.StrEscape() + "', NOW(), '" + S.GetUserid() + "') ");
A.SetQueri(A.GetInsert() + A.GetValues() + ";");
foreach (DataGridViewRow b in Dg.Rows)
{
if (b.Cells[0].Value.ToString().Equals("0"))
{
A.SetInsert("INSERT INTO `tb_waktupelajaran` (`kode_jadwal`,`totaljam`,`hari`,`waktu`,`id_user`,`tanggal`) ");
A.SetValues("VALUES ('" + kodejadwal + "', '" + CbJumlahJam.Text + "', '" + CbHari.Text + "', " +
"'" + CbJam.Text + ":" + CbMenit.Text + ":00', '" + S.GetUserid() + "', NOW()) ");
A.SetQueri(A.GetQueri() + A.GetInsert() + A.GetValues() + ";");
}
else
{
A.SetUpdate("UPDATE `tb_waktupelajaran` ");
A.SetValues("SET `totaljam` = '" + CbJumlahJam.Text + "', `hari` = '" + CbHari.Text + "', " +
"`waktu` = '" + CbJam.Text + ":" + CbMenit.Text + ":00' ");
A.SetWhere("WHERE `idwaktupelajaran` = '" + b.Cells[0].Value.ToString() + "' ");
A.SetQueri(A.GetQueri() + A.GetInsert() + A.GetValues() + ";");
}
}
foreach (var b in deletelist)
{
A.SetQueri(A.GetQueri() + "DELETE FROM `tb_jadwal` WHERE `idwaktupelajaran` = '" + b + "';");
}
if (A.GetQueri().ManipulasiData())
{
MessageBox.Show("Jadwal telah diubah!!", "Informasi", MessageBoxButtons.OK, MessageBoxIcon.Information);
Close();
}
}
};
BHapus.Click += (sende, e) =>
{
if (MessageBox.Show("Menghapus seluruh data pengajaran??", "Pertanyaan", MessageBoxButtons.OK, MessageBoxIcon.Question) == DialogResult.Yes)
{
A.SetQueri("DELETE FROM `tb_waktupelajaran` WHERE `kode_jadwal` = '" + kodejadwal + "';");
A.SetQueri(A.GetQueri() + "DELETE FROM `tb_jadwal` WHERE `kode_jadwal` = '" + kodejadwal + "'; ");
A.GetQueri().DBHapus();
}
};
Dg.CellClick += (sender, e) =>
{
if (e.RowIndex >= 0)
{
if (e.ColumnIndex == Dg.GetColumnIndexByHeader("HAPUS"))
{
if (Dg.Rows[e.RowIndex].Cells["ID WAKTU"].Value.ToString() != "0")
{
deletelist.Add(Dg.Rows[e.RowIndex].Cells["ID WAKTU"].Value.ToString());
}
Dg.Rows.RemoveAt(e.RowIndex);
}
}
};
}
private void Bdelete_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Hapus penggguna?", "Peringatan", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
if (A.DBHapus("UPDATE `m_user` SET `hapus` = 'Y' WHERE `id_user` = '" + Dg.CurrentRow.Cells[Dg.GetColumnIndexByHeader("ID USER")].Value.ToString() + "';"))
{
Loaddb();
}
}
}