private void BtnSimpanClick(object sender, EventArgs e)
{
//cek data
if (txtNama.Text.Trim() == string.Empty || cmbKriteria.Text.Trim() == string.Empty)
{
MessageBox.Show("Data Belum Lengkap");
return;
}
//tambahkan data baru ke dtGridView
//dtGridView.Rows.Add(txtNama.Text, "True");
//tbl_kriteria
//kode,nama,aktif
var a = string.Format("INSERT INTO tbl_kriteria_items(kode_kriteria,nama) " +
"VALUES('{0}','{1}')", KodeKriteria(), txtNama.Text);
_dbConnect.ExecuteNonQuery(a);
_selectedkode = -1; //set to "-1" agar disign sebagai databaru
ClassHelper.ClearTextBox(this);
LoadData();
}
private void LoadData()
{
dtGridView.Rows.Clear();
ClassHelper.ClearTextBox(this);
var datatable =
_dbConnect.GetRecord("SELECT kode as id," +
" kode_mk as Kode," +
" nama as Nama," +
" sks as SKS," +
" semester as Semester," +
" aktif as Aktif," + //checkbox
" jenis as Jenis " + //combobox
"FROM mata_kuliah ORDER BY nama");
for (var count = 0; count <= datatable.Rows.Count - 1; count++)
{
dtGridView.Rows.Add(
datatable.Rows[count][0].ToString(), //kode
datatable.Rows[count][1].ToString(), //kodeMK
datatable.Rows[count][2].ToString(), //nama
datatable.Rows[count][3].ToString(), //SKS
datatable.Rows[count][4].ToString(), //Semester
datatable.Rows[count][5].ToString(), //Aktif
datatable.Rows[count][6].ToString() //Jenis
);
}
dtGridView.Columns[0].Visible = false;
}
private void loadData()
{
ClassHelper.ClearTextBox(this);
dtGridView.Rows.Clear();
var dtTable = _dbConnect.GetRecord(
string.Format(
"SELECT kode,nama,aktif " +
"FROM tbl_kriteria " +
//"WHERE aktif='True' "+
"ORDER BY kode")
);
//dtGridView.DataSource = dtTable;
for (var i = 0; i < dtTable.Rows.Count; i++)
{
dtGridView.Rows.Add(
dtTable.Rows[i][0].ToString(),
dtTable.Rows[i][1].ToString(),
dtTable.Rows[i][2].ToString()
);
}
dtGridView.Columns[0].Visible = false;
}
private void LoadData(int tipe)
{
//kode,kode_mk,nama mk,kode dosen,nama dosen,kelas,tahun akademik
ClassHelper.ClearTextBox(this);
var dataTable = _dbConnect.GetRecord(
string.Format(
"SELECT a.kode as Kode," +
" b.kode as `Kode MK`," +
" b.nama as `Nama MK`," +
" c.kode as `Kode Dosen`," +
" c.nama as `Nama Dosen`," +
" a.kelas as Kelas," +
" a.tahun_akademik as `Tahun Akademik` " +
"FROM pengampu a " +
"LEFT JOIN mata_kuliah b " +
"ON a.kode_mk = b.kode " +
"LEFT JOIN dosen c " +
"ON a.kode_dosen = c.kode " +
"WHERE b.semester%2={0} AND a.tahun_akademik = '{1}' " +
"ORDER BY b.nama,a.kelas", tipe, cmbTahunAkademik.Text));
dtGridView.DataSource = dataTable;
dtGridView.Columns[0].Visible = false; //kode
dtGridView.Columns[1].Visible = false; //kode MK
dtGridView.Columns[3].Visible = false; //kode dosen
//load dosen
//cbDosen.Items.Clear();
var dosen_dt = _dbConnect.GetRecord(
"SELECT kode,nama " +
"FROM dosen " +
"ORDER BY nama");
cmbDosen.DataSource = dosen_dt;
cmbDosen.DisplayMember = "nama";
cmbDosen.ValueMember = "kode";
//load mata kuliah
//cbMataKuliah.Items.Clear();
var mk_dt = _dbConnect.GetRecord(string.Format(
"SELECT * " +
"FROM mata_kuliah " +
"WHERE semester%2={0} " +
"ORDER BY nama", tipe));
cmbMataKuliah.DataSource = mk_dt;
cmbMataKuliah.DisplayMember = "nama";
cmbMataKuliah.ValueMember = "kode";
}
private void LoadData()
{
ClassHelper.ClearTextBox(this);
var dataTable = _dbConnect.GetRecord(
"SELECT kode," +
" nama as Nama," +
" alamat as Alamat," +
" telp as Telp " +
"FROM tbl_anggota " +
"ORDER BY kode");
dtGridView.DataSource = dataTable;
//dtGridView.Columns[0].Visible = false;
}
private void LoadData()
{
dtGridView.Rows.Clear();
ClassHelper.ClearTextBox(this);
var dt = _dbConnect.GetRecord("SELECT * FROM ruang");
for (var count = 0; count <= dt.Rows.Count - 1; count++)
{
dtGridView.Rows.Add(
dt.Rows[count][0].ToString(), //kode
dt.Rows[count][1].ToString(), //Nama
dt.Rows[count][2].ToString(), //Kapasitas
dt.Rows[count][3].ToString() //Jenis
);
}
dtGridView.Columns[0].Visible = false;
}
private void btnSimpan_Click(object sender, EventArgs e)
{
if (txtNama.Text.Trim() == "")
{
MessageBox.Show("Data Belum Lengkap!");
return;
}
if (_selectedkode != -1)
{//update data
var q =
string.Format(
"UPDATE tbl_anggota " +
"SET nama = '{0}', " +
" alamat = '{1}', " +
" telp = '{2}' " +
"WHERE kode = {3}",
txtNama.Text, txtAlamat.Text,
txtTelp.Text, _selectedkode);
_dbConnect.ExecuteNonQuery(q);
}
else
{//new data
var q = string.Format(
"INSERT INTO tbl_anggota(nama,alamat,telp) " +
"VALUES('{0}','{1}','{2}')",
txtNama.Text, txtAlamat.Text,
txtTelp.Text);
//MessageBox.Show(q);
_dbConnect.ExecuteNonQuery(q);
}
_selectedkode = -1; //set to "-1" agar disign sebagai databaru
ClassHelper.ClearTextBox(this);
SetEnabledOnBtn(true, false, false);
LoadData();
}
private void btnSimpan_Click(object sender, EventArgs e)
{
//cek data
if (txtNama.Text.Trim() == string.Empty)
{
MessageBox.Show("Data Belum Lengkap");
return;
}
//tambahkan data baru ke dtGridView
//dtGridView.Rows.Add(txtNama.Text, "True");
//tbl_kriteria
//kode,nama,aktif
if (_selectedkode != -1)
{
//update data
var a = string.Format(
"UPDATE tbl_kriteria " +
"SET nama='{0}' " +
"WHERE kode={1} "
, txtNama.Text, _selectedkode);
_dbConnect.ExecuteNonQuery(a);
}
else
{
//insert data
var a = string.Format("INSERT INTO tbl_kriteria(nama,aktif) " +
"VALUES('{0}','{1}')", txtNama.Text, "True");
_dbConnect.ExecuteNonQuery(a);
}
_selectedkode = -1; //set to "-1" agar disign sebagai databaru
ClassHelper.ClearTextBox(this);
loadData();
}
private void btnSimpan_Click(object sender, System.EventArgs e)
{
//pengampu
//kode,kode_mk,kode_dosen,kelas,tahun_akademik
if (txtKelas.Text.Trim() == "")
{
MessageBox.Show("Data belum lengkap");
return;
}
var rowDosen = ((DataTable)cmbDosen.DataSource).Rows[cmbDosen.SelectedIndex];
var kodeDosen = (int)rowDosen["kode"];
var rowMK = ((DataTable)cmbMataKuliah.DataSource).Rows[cmbMataKuliah.SelectedIndex];
var kodeMK = (int)rowMK["kode"];
if (_selectedkode != -1)
{//update data
var check = string.Format("SELECT CAST(COUNT(*) AS CHAR(1)) " +
"FROM pengampu " +
"WHERE kode_mk='{0}' AND " +
" kode_dosen={1} AND " +
" kelas = '{2}' AND " +
" tahun_akademik='{3}' " +
" AND kode <> {4}",
kodeMK, kodeDosen, txtKelas.Text, cmbTahunAkademik.Text, _selectedkode);
var i = int.Parse(_dbConnect.ExecuteScalar(check));
if (i != 0)
{
MessageBox.Show("Data ini sudah ada!");
return;
}
var q =
string.Format(
"UPDATE pengampu " +
"SET kode_mk = {0}," +
" kode_dosen = {1}, " +
" kelas = '{2}', " +
" tahun_akademik = '{3}' " +
"WHERE kode = {4}",
kodeMK, kodeDosen, txtKelas.Text, cmbTahunAkademik.Text, _selectedkode);
_dbConnect.ExecuteNonQuery(q);
}
else
{//new data
var check = string.Format("SELECT CAST(COUNT(*) AS CHAR(1)) " +
"FROM pengampu " +
"WHERE kode_mk='{0}' AND " +
" kode_dosen={1} AND " +
" kelas = '{2}' AND " +
" tahun_akademik='{3}'",
kodeMK, kodeDosen, txtKelas.Text, cmbTahunAkademik.Text);
var i = int.Parse(_dbConnect.ExecuteScalar(check));
if (i != 0)
{
MessageBox.Show("Data ini sudah ada!");
return;
}
var q = string.Format(
"INSERT INTO pengampu(kode_mk,kode_dosen,kelas,tahun_akademik) " +
"VALUES({0},{1},'{2}','{3}')",
kodeMK, kodeDosen, txtKelas.Text, cmbTahunAkademik.Text);
_dbConnect.ExecuteNonQuery(q);
}
_selectedkode = -1; //set to "-1" agar disign sebagai databaru
ClassHelper.ClearTextBox(this);
SetEnabledOnBtn(true, false, false);
LoadData(cmbSemester.Text == "GANJIL" ? GANJIL : GENAP);
}
private void btnBatal_Click(object sender, System.EventArgs e)
{
ClassHelper.ClearTextBox(this);
SetEnabledOnBtn(true, false, false);
}
private void btnBaru_Click(object sender, System.EventArgs e)
{
ClassHelper.ClearTextBox(this);
SetEnabledOnBtn(false, true, true);
_selectedkode = -1;
}
private void BtnSimpanClick(object sender, EventArgs e)
{
//kode,nip,nama,alamat,telp
if (txtKode.Text.Trim() == "" || txtNIDN.Text.Trim() == "" || txtNama.Text.Trim() == "")
{
MessageBox.Show("Data Belum Lengkap!");
return;
}
if (_selectedkode != -1)
{//update data
var check = string.Format("SELECT CAST(COUNT(*) AS CHAR(1)) " +
"FROM dosen " +
"WHERE (kode={0} OR nidn='{1}') AND kode <> {2}",
int.Parse(txtKode.Text), txtNama.Text, _selectedkode);
var i = int.Parse(_dbConnect.ExecuteScalar(check));
if (i != 0)
{
MessageBox.Show("Kode Atau NIDN ini sudah ada!");
return;
}
var q =
string.Format(
"UPDATE dosen " +
"SET kode = {0}," +
" nidn = '{1}', " +
" nama = '{2}', " +
" alamat = '{3}', " +
" telp = '{4}' " +
"WHERE kode = {5}",
txtKode.Text, txtNIDN.Text,
txtNama.Text, txtAlamat.Text,
txtTelp.Text, _selectedkode);
_dbConnect.ExecuteNonQuery(q);
//update waktu_tidak_bersedia
string q_1 =
string.Format(
"UPDATE waktu_tidak_bersedia " +
"SET kode_dosen = {0} " +
"WHERE kode_dosen = {1}",
txtKode.Text,
_selectedkode);
_dbConnect.ExecuteNonQuery(q_1);
}
else
{//new data
var check = string.Format("SELECT CAST(COUNT(*) AS CHAR(1)) " +
"FROM dosen " +
"WHERE kode={0} OR nidn='{1}'",
int.Parse(txtKode.Text), txtNIDN.Text);
var i = int.Parse(_dbConnect.ExecuteScalar(check));
if (i != 0)
{
MessageBox.Show("Kode Atau NIDN ini sudah ada!");
return;
}
var q = string.Format(
"INSERT INTO dosen(kode,nidn,nama,alamat,telp) " +
"VALUES({0},'{1}','{2}','{3}','{4}')",
txtKode.Text, txtNIDN.Text,
txtNama.Text, txtAlamat.Text,
txtTelp.Text);
_dbConnect.ExecuteNonQuery(q);
}
_selectedkode = -1; //set to "-1" agar disign sebagai databaru
ClassHelper.ClearTextBox(this);
SetEnabledOnBtn(true, false, false);
LoadData();
}
private void btnSimpan_Click(object sender, EventArgs e)
{
//tablename = mata_kuliah
//kode,nama,sks,semester,aktif,jenis
if (txtKode.Text.Trim() == "" || txtNama.Text.Trim() == "" ||
txtSKS.Text.Trim() == "" || txtSemester.Text.Trim() == "")
{
MessageBox.Show("Data Belum Lengkap!");
return;
}
const string _aktif = "True"; //cbAktif.Checked ? "True" : "False";
var _sks = int.Parse(txtSKS.Text);
var _semester = int.Parse(txtSemester.Text);
if (_selectedkode != -1)
{//update data
var check = string.Format("SELECT CAST(COUNT(*) AS CHAR(1)) " +
"FROM mata_kuliah " +
"WHERE (kode_mk='{0}' OR nama='{1}') AND kode <> {2}",
txtKode.Text, txtNama.Text, _selectedkode);
var i = int.Parse(_dbConnect.ExecuteScalar(check));
if (i != 0)
{
MessageBox.Show("Kode Atau Nama ini sudah ada!");
return;
}
var q =
string.Format(
"UPDATE mata_kuliah " +
"set kode_mk = '{0}', " +
" nama = '{1}', " +
" sks = {2}, " +
" semester = {3}," +
" aktif ='{4}'," +
" jenis = '{5}' " +
"where kode = {6}",
txtKode.Text, txtNama.Text, _sks, _semester, _aktif, cmbKategori.Text, _selectedkode);
_dbConnect.ExecuteNonQuery(q);
}
else
{//new data
var check = string.Format("SELECT CAST(COUNT(*) AS CHAR(1)) " +
"FROM mata_kuliah " +
"WHERE kode_mk ='{0}' OR nama='{1}'",
txtKode.Text, txtNama.Text);
var i = int.Parse(_dbConnect.ExecuteScalar(check));
if (i != 0)
{
MessageBox.Show("Kode Atau Nama ini sudah ada!");
return;
}
var q = string.Format("INSERT INTO mata_kuliah(kode_mk,nama,sks,semester,aktif,jenis) " +
"VALUES('{0}','{1}',{2},{3},'{4}','{5}')",
txtKode.Text, txtNama.Text, _sks, _semester, _aktif, cmbKategori.Text);
_dbConnect.ExecuteNonQuery(q);
}
_selectedkode = -1; //set to "-1" agar disign sebagai databaru
ClassHelper.ClearTextBox(this);
SetEnabledOnBtn(true, false, false);
LoadData();
}
private void btnSimpan_Click(object sender, System.EventArgs e)
{
//ruang:kode,nama,kapasitas,jenis
if (txtNama.Text.Trim() == "" || txtKapasitas.Text.Trim() == "")
{
MessageBox.Show("Data Belum Lengkap!");
return;
}
var _kapasitas = int.Parse(txtKapasitas.Text);
if (_selectedkode != -1)
{//update data
var check = string.Format("SELECT CAST(COUNT(*) AS CHAR(1)) " +
"FROM ruang " +
"WHERE nama='{0}' AND kode <> {1}",
txtNama.Text, _selectedkode);
var i = int.Parse(_dbConnect.ExecuteScalar(check));
if (i != 0)
{
MessageBox.Show("Nama ini sudah ada!");
return;
}
var q =
string.Format(
"UPDATE ruang " +
"SET nama = '{0}', " +
" kapasitas = {1}, " +
" jenis = '{2}' " +
"WHERE kode = {3}",
txtNama.Text,
_kapasitas,
cmbJenis.Text,
_selectedkode);
_dbConnect.ExecuteNonQuery(q);
}
else
{//new data
var check = string.Format("SELECT CAST(COUNT(*) AS CHAR(1)) " +
"FROM ruang " +
"WHERE nama='{0}'",
txtNama.Text);
var i = int.Parse(_dbConnect.ExecuteScalar(check));
if (i != 0)
{
MessageBox.Show("Nama ini sudah ada!");
return;
}
var q = string.Format(
"INSERT INTO ruang(nama,kapasitas,jenis) " +
"VALUES('{0}',{1},'{2}')",
txtNama.Text, _kapasitas, cmbJenis.Text);
_dbConnect.ExecuteNonQuery(q);
}
_selectedkode = -1; //set to "-1" agar disign sebagai databaru
ClassHelper.ClearTextBox(this);
SetEnabledOnBtn(true, false, false);
LoadData();
}
