// ////Akhir Tombol Ubah // // ////Tombol Refresh // //private void radButtonRefresh_Click(object sender, EventArgs e) //{ // BindDataTU(); // BindDataSiswa(); // BindDataPembayaran(); // BindDataSurat(); // BindDataDaftar(); // BindDataTabungan(); //} // ////Akhir Tombol Refresh // // ////Tombol Tambah // private void radButtonTambah_Click(object sender, EventArgs e) { if (tombol == "tu") { TambahTU tambahTU = new TambahTU(); tambahTU.ShowDialog(); BindDataTU(); } else if (tombol == "siswa") { TambahSiswa tambahSiswa = new TambahSiswa(); tambahSiswa.ShowDialog(); BindDataSiswa(); } else if (tombol == "pembayaran") { DataSiswa siswa = new DataSiswa(); siswa.idTU = idTU; siswa.button = tombol; siswa.ShowDialog(); BindDataPembayaran(); } else if (tombol == "surat") { TambahSurat surat = new TambahSurat(); surat.idTU = idTU; surat.ShowDialog(); BindDataSurat(); } else if (tombol == "pendaftaran") { DataSiswa siswa = new DataSiswa(); siswa.idTU = idTU; siswa.button = tombol; siswa.ShowDialog(); BindDataDaftar(); } else if (tombol == "tabungan") { DataSiswa siswa = new DataSiswa(); siswa.idTU = idTU; siswa.button = tombol; siswa.ShowDialog(); BindDataTabungan(); } else if (tombol == "tabungankeluar") { DataSiswa siswa = new DataSiswa(); siswa.idTU = idTU; siswa.button = tombol; siswa.ShowDialog(); BindDataTabunganKeluar(); } }
private void radButtonTambah_Click(object sender, EventArgs e) { DateTime date = DateTime.Now; string nis = id; string spp = checkBoxSPP.Text; string cathering = checkBoxCathering.Text; string marching = checkBoxMarching.Text; string bulan = comboBoxBulan.Text; int total = int.Parse(spp) + int.Parse(cathering) + int.Parse(marching); //SqlConnection connection = new SqlConnection(strConnection); koneksi = new Koneksi(); using (koneksi.koneksiDB) { koneksi.koneksiDB.Open(); string insert = "insert into tpembayaran(id_tu,nis,spp,cathering,marching_band,bulan,tanggal,total) values (@id_tu,@nis,@spp,@cathering,@marching_band,@bulan,@tanggal,@total)"; MySqlCommand cmd = new MySqlCommand(insert, koneksi.koneksiDB); cmd.Parameters.AddWithValue("@id_tu", int.Parse(idTU)); cmd.Parameters.AddWithValue("@nis", id); cmd.Parameters.AddWithValue("@spp", int.Parse(spp)); cmd.Parameters.AddWithValue("@cathering", int.Parse(cathering)); cmd.Parameters.AddWithValue("@marching_band", int.Parse(marching)); cmd.Parameters.AddWithValue("@bulan", bulan); cmd.Parameters.AddWithValue("@tanggal", date); cmd.Parameters.AddWithValue("@total", total); int insertResult = cmd.ExecuteNonQuery(); if (insertResult == 1) { MessageBox.Show("Sukses"); DataSiswa siswa = new DataSiswa(); this.Close(); } else { MessageBox.Show("Gagal"); } koneksi.koneksiDB.Close(); } }
private void radButtonTambah_Click(object sender, EventArgs e) { if (tombol == "tu") { TambahTU tambahTU = new TambahTU(); tambahTU.ShowDialog(); } else if (tombol == "siswa") { TambahSiswa tambahSiswa = new TambahSiswa(); tambahSiswa.ShowDialog(); } else if (tombol == "pembayaran") { DataSiswa siswa = new DataSiswa(); siswa.idTU = idTU; siswa.button = tombol; siswa.ShowDialog(); } else if (tombol == "surat") { TambahSurat surat = new TambahSurat(); surat.idTU = idTU; surat.ShowDialog(); } else if (tombol == "pendaftaran") { DataSiswa siswa = new DataSiswa(); siswa.idTU = idTU; siswa.button = tombol; siswa.ShowDialog(); } else if (tombol == "tabungan") { DataSiswa siswa = new DataSiswa(); siswa.idTU = idTU; siswa.button = tombol; siswa.ShowDialog(); } }
private void radButtonTambah_Click(object sender, EventArgs e) { DateTime date = DateTime.Now; string strDate = date.ToString("dd-MM-yyyy"); string nis = id; string spp = checkBoxSPP.Text; string cathering = checkBoxCathering.Text; string marching = checkBoxMarching.Text; string tanggal = strDate; string bulan = comboBoxBulan.Text; int total = int.Parse(spp) + int.Parse(cathering) + int.Parse(marching); //SqlConnection connection = new SqlConnection(strConnection); koneksi = new Koneksi(); using (koneksi.koneksiDB) { koneksi.koneksiDB.Open(); string insert = "insert into tpembayaran(id_tu,nis,spp,cathering,marching_band,bulan,tanggal,total) values (@id_tu,@nis,@spp,@cathering,@marching_band,@bulan,@tanggal,@total)"; MySqlCommand cmd = new MySqlCommand(insert, koneksi.koneksiDB); cmd.Parameters.AddWithValue("@id_tu", int.Parse(idTU)); cmd.Parameters.AddWithValue("@nis", id); cmd.Parameters.AddWithValue("@spp", int.Parse(spp)); cmd.Parameters.AddWithValue("@cathering", int.Parse(cathering)); cmd.Parameters.AddWithValue("@marching_band", int.Parse(marching)); cmd.Parameters.AddWithValue("@bulan", bulan); cmd.Parameters.AddWithValue("@tanggal", tanggal); cmd.Parameters.AddWithValue("@total", total); int insertResult = cmd.ExecuteNonQuery(); if (insertResult == 1) { MessageBox.Show("Sukses"); DataSiswa siswa = new DataSiswa(); this.Close(); } else { MessageBox.Show("Gagal"); } koneksi.koneksiDB.Close(); } }