private void radButton1_Click(object sender, EventArgs e)
{
string nama = textBoxNama.Text;
string kelas = comboBoxKelas.Text;
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string ubah = "update tsiswa set nama = @nama, kelas = @kelas where nis = @nis";
MySqlCommand cmd = new MySqlCommand(ubah, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", nis);
cmd.Parameters.AddWithValue("@nama", nama);
cmd.Parameters.AddWithValue("@kelas", kelas);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
}
}
//
//Akhir Data Surat
//
//
//Data Pendaftaran
//
private void BindDataDaftar()
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string select = "select daf.id_daftar as ID, daf.nis as NIS, sis.nama as Nama, sis.kelas as Kelas, " +
"daf.jenis as Jenis, daf.jumlah as Jumlah, daf.tanggal as 'Tanggal Bayar', tu.nama as 'Nama TU' " +
"from tdaftar as daf " +
"join tsiswa as sis on(sis.nis = daf.nis) " +
"join ttu as tu on(tu.id_tu = daf.id_tu)";
MySqlCommand cmd = new MySqlCommand(select, koneksi.koneksiDB);
MySqlDataReader reader = cmd.ExecuteReader();
table = new DataTable();
table.Load(reader);
radGridPendaftaran.DataSource = table;
koneksi.koneksiDB.Close();
}
}
public FormLogin()
{
InitializeComponent();
this.WindowState = FormWindowState.Maximized;
//strConnection = ConfigurationManager.ConnectionStrings["AdministrasiConnectionString"].ConnectionString;
koneksi = new Koneksi();
}
private void radButtonSimpan_Click(object sender, EventArgs e)
{
string nama = textBoxNama.Text;
string password = textBoxPassword.Text;
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string ubah = "update ttu set nama = @nama, password = @password where id_tu = @id";
MySqlCommand cmd = new MySqlCommand(ubah, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@nama", nama);
cmd.Parameters.AddWithValue("@password", password);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
}
}
private void radButtonUbah_Click(object sender, EventArgs e)
{
string jumlah = textJumlah.Text;
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string ubah = "update ttabungan set jumlah = @jumlah where id_tabung = @id";
MySqlCommand cmd = new MySqlCommand(ubah, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", int.Parse(id));
cmd.Parameters.AddWithValue("@jumlah", int.Parse(jumlah));
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
}
}
private void ButtonAmbil_Click(object sender, EventArgs e)
{
string jumlah = TextJumlah.Text;
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string ubah = "update ttotal set total = (total - @jumlah) where nis = @id";
MySqlCommand cmd = new MySqlCommand(ubah, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", int.Parse(nis));
cmd.Parameters.AddWithValue("@jumlah", int.Parse(jumlah));
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
}
}
private void ButtonAmbil_Click(object sender, EventArgs e)
{
DateTime date = DateTime.Now;
string jumlah = TextJumlah.Text;
if (int.Parse(saldo) < int.Parse(jumlah))
{
MessageBox.Show("Saldo Anda Tidak Cukup", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string ubah = "update ttotal set total = (total - @jumlah) where nis = @id";
string insert = "insert into ttabungankeluar (nis,jumlah,tanggal,id_tu) values (@nis,@jumlah,@tanggal,@id_tu)";
MySqlCommand cmd = new MySqlCommand(ubah, koneksi.koneksiDB);
MySqlCommand cmdi = new MySqlCommand(insert, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", int.Parse(nis));
cmd.Parameters.AddWithValue("@jumlah", int.Parse(jumlah));
cmdi.Parameters.AddWithValue("@nis", nis);
cmdi.Parameters.AddWithValue("@jumlah", jumlah);
cmdi.Parameters.AddWithValue("@tanggal", date);
cmdi.Parameters.AddWithValue("@id_tu", idTU);
int insertResult = cmd.ExecuteNonQuery();
cmdi.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
}
}
}
private void radButtonSimpan_Click(object sender, EventArgs e)
{
DateTime date = DateTime.Now;
string strDate = date.ToString("dd-MM-yyyy");
string noSurat = textBoxNoSurat.Text;
string lampiran = textBoxLampiran.Text;
string perihal = textBoxPerihal.Text;
string jenis = comboBoxJenis.Text;
string pengirim = textBoxPengirim.Text;
string tanggal = strDate;
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string insert = "insert into tsurat(id_tu,no_surat,lampiran,perihal,jenis,pengirim,tanggal) values (@id,@no_surat,@lampiran,@perihal,@jenis,@pengirim,@tanggal)";
MySqlCommand cmd = new MySqlCommand(insert, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", int.Parse(idTU));
cmd.Parameters.AddWithValue("@no_surat", noSurat);
cmd.Parameters.AddWithValue("@lampiran", lampiran);
cmd.Parameters.AddWithValue("@perihal", perihal);
cmd.Parameters.AddWithValue("@jenis", jenis);
cmd.Parameters.AddWithValue("@pengirim", pengirim);
cmd.Parameters.AddWithValue("@tanggal", tanggal);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Gagal");
}
koneksi.koneksiDB.Close();
}
}
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)
{
DateTime date = DateTime.Now;
string id = textBoxID.Text;
string nama = textBoxNama.Text;
string password = textBoxPassword.Text;
string passwordmd5 = md5_enkripsi(password);
if (statusID(textBoxID.Text) == true)
{
MessageBox.Show("ID " + id + " sudah ada", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string insert = "insert into ttu (id_tu,nama,password,tanggal) values (@id, @nama, @password, @tanggal)";
MySqlCommand cmd = new MySqlCommand(insert, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@nama", nama);
cmd.Parameters.AddWithValue("@password", passwordmd5);
cmd.Parameters.AddWithValue("@tanggal", date);
int inserResult = cmd.ExecuteNonQuery();
if (inserResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Gagal");
}
koneksi.koneksiDB.Close();
}
}
}
private void radButtonSimpan_Click(object sender, EventArgs e)
{
DateTime date = DateTime.Now;
string nis = textBoxNIS.Text;
string nama = textBoxNama.Text;
string kelas = comboBoxKelas.Text;
if (statusNIS(textBoxNIS.Text) == true)
{
MessageBox.Show("NIS " + nis + " sudah ada", "", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string insert = "insert into tsiswa (nis,nama,kelas,tanggal) values (@nis, @nama, @kelas, @tanggal)";
MySqlCommand cmd = new MySqlCommand(insert, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", nis);
cmd.Parameters.AddWithValue("@nama", nama);
cmd.Parameters.AddWithValue("@kelas", kelas);
cmd.Parameters.AddWithValue("@tanggal", date);
int inserResult = cmd.ExecuteNonQuery();
if (inserResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Gagal");
}
koneksi.koneksiDB.Close();
}
}
}
private void radButtonSimpan_Click(object sender, EventArgs e)
{
DateTime date = DateTime.Now;
string noSurat = textBoxNoSurat.Text;
string lampiran = textBoxLampiran.Text;
string perihal = textBoxPerihal.Text;
string jenis = comboBoxJenis.Text;
string pengirim = textBoxPengirim.Text;
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string insert = "insert into tsurat(id_tu,no_surat,lampiran,perihal,jenis,pengirim,tanggal) values (@id,@no_surat,@lampiran,@perihal,@jenis,@pengirim,@tanggal)";
MySqlCommand cmd = new MySqlCommand(insert, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", int.Parse(idTU));
cmd.Parameters.AddWithValue("@no_surat", noSurat);
cmd.Parameters.AddWithValue("@lampiran", lampiran);
cmd.Parameters.AddWithValue("@perihal", perihal);
cmd.Parameters.AddWithValue("@jenis", jenis);
cmd.Parameters.AddWithValue("@pengirim", pengirim);
cmd.Parameters.AddWithValue("@tanggal", date);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Gagal");
}
koneksi.koneksiDB.Close();
}
}
private void BindDataSiswa()
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string select = "select nis as NIS, nama as Nama, kelas as Kelas from tsiswa";
MySqlCommand cmd = new MySqlCommand(select, koneksi.koneksiDB);
MySqlDataReader reader = cmd.ExecuteReader();
table = new DataTable();
table.Load(reader);
radGridSiswa.DataSource = table;
koneksi.koneksiDB.Close();
}
}
private void BindDataSiswa()
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string select = "select nis as NIS, nama as Nama, kelas as Kelas from tsiswa";
MySqlCommand cmd = new MySqlCommand(select, koneksi.koneksiDB);
MySqlDataReader reader = cmd.ExecuteReader();
table = new DataTable();
table.Load(reader);
radGridSiswa.DataSource = table;
koneksi.koneksiDB.Close();
}
}
private void radButtonUbah_Click(object sender, EventArgs e)
{
string noSurat = textBoxNoSurat.Text;
string lampiran = textBoxLampiran.Text;
string perihal = textBoxPerihal.Text;
string jenis = comboBoxJenis.Text;
string pengirim = textBoxPengirim.Text;
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string ubah = "update tsurat set no_surat = @no_surat, lampiran = @lampiran, perihal = @perihal, jenis = @jenis, pengirim = @pengirim where id_surat = @id";
MySqlCommand cmd = new MySqlCommand(ubah, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", int.Parse(id));
cmd.Parameters.AddWithValue("@no_surat", noSurat);
cmd.Parameters.AddWithValue("@lampiran", lampiran);
cmd.Parameters.AddWithValue("@perihal", perihal);
cmd.Parameters.AddWithValue("@jenis", jenis);
cmd.Parameters.AddWithValue("@pengirim", pengirim);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
}
}
private void radButtonTambah_Click(object sender, EventArgs e)
{
DateTime date = DateTime.Now;
string strDate = date.ToString("dd-MM-yyyy");
string jumlah = textJumlah.Text;
string tanggal = strDate;
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string insert = "insert into ttabungan(nis,jumlah,tanggal,id_tu) values (@nis,@jumlah,@tanggal,@id_tu)";
MySqlCommand cmd = new MySqlCommand(insert, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", int.Parse(id));
cmd.Parameters.AddWithValue("@jumlah", int.Parse(jumlah));
cmd.Parameters.AddWithValue("@tanggal", tanggal);
cmd.Parameters.AddWithValue("@id_tu", int.Parse(idTU));
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
Total();
this.Close();
}
else
{
MessageBox.Show("Gagal");
}
koneksi.koneksiDB.Close();
}
}
private void Total()
{
if (statusTotalTabungan(int.Parse(id)) == true)
{
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string ubah = "update ttotal set total = (select sum(jumlah) from ttabungan where nis = @nis) where nis = @nis";
MySqlCommand cmd = new MySqlCommand(ubah, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", int.Parse(id));
int insertResult = cmd.ExecuteNonQuery();
koneksi.koneksiDB.Close();
}
}
else
{
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string insert = "insert into ttotal(nis,total) values (@nis,(select sum(jumlah) from ttabungan where nis = @nis))";
MySqlCommand cmd = new MySqlCommand(insert, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", int.Parse(id));
int insertResult = cmd.ExecuteNonQuery();
koneksi.koneksiDB.Close();
}
}
}
private void radButtonTambah_Click(object sender, EventArgs e)
{
DateTime date = DateTime.Now;
string tanggal = date.ToString("dd-MM-yyyy");
string id = textBoxID.Text;
string nama = textBoxNama.Text;
string password = textBoxPassword.Text;
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string insert = "insert into ttu (id_tu,nama,password,tanggal) values (@id, @nama, @password, @tanggal)";
MySqlCommand cmd = new MySqlCommand(insert, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", id);
cmd.Parameters.AddWithValue("@nama", nama);
cmd.Parameters.AddWithValue("@password", password);
cmd.Parameters.AddWithValue("@tanggal", tanggal);
int inserResult = cmd.ExecuteNonQuery();
if (inserResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Gagal");
}
koneksi.koneksiDB.Close();
}
}
//
//// Akhir Navigasi Laporan
//
//
//Akhir Navigasi
//
//
//Data Tata Usaha
//
private void BindDataTU()
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string select = "select id_tu as 'ID Tata Usaha', nama as Nama, date_format(tanggal,'%d-%m-%Y') as 'Tanggal Daftar' from ttu";
MySqlCommand cmd = new MySqlCommand(select, koneksi.koneksiDB);
MySqlDataReader reader = cmd.ExecuteReader();
table = new DataTable();
table.Load(reader);
radGridTu.DataSource = table;
koneksi.koneksiDB.Close();
}
}
private void radButtonSimpan_Click(object sender, EventArgs e)
{
DateTime date = DateTime.Now;
string tanggal = date.ToString("dd-MM-yyyy");
string nis = textBoxNIS.Text;
string nama = textBoxNama.Text;
string kelas = comboBoxKelas.Text;
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string insert = "insert into tsiswa (nis,nama,kelas,tanggal) values (@nis, @nama, @kelas, @tanggal)";
MySqlCommand cmd = new MySqlCommand(insert, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", nis);
cmd.Parameters.AddWithValue("@nama", nama);
cmd.Parameters.AddWithValue("@kelas", kelas);
cmd.Parameters.AddWithValue("@tanggal", tanggal);
int inserResult = cmd.ExecuteNonQuery();
if (inserResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Gagal");
}
koneksi.koneksiDB.Close();
}
}
private Boolean statusID(string id)
{
id = id.ToUpper();
//SqlConnection connection = new SqlConnection(strConnection);
//connection.Open();
koneksi = new Koneksi();
koneksi.koneksiDB.Open();
string select = "SELECT id_tu from ttu";
MySqlCommand cmd = new MySqlCommand(select, koneksi.koneksiDB);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
if ((reader.GetString(0).ToString().ToUpper() == id))
{
return(true);
}
}
koneksi.koneksiDB.Close();
return(false);
}
private void radButtonUbah_Click(object sender, EventArgs e)
{
string jumlahUbah = textJumlah.Text;
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string ubah = "update ttabungan set jumlah = @jumlahUbah where id_tabung = @id";
string update = "update ttotal set total = (total - @jumlah) + @jumlahUbah where nis = @id";
MySqlCommand cmd = new MySqlCommand(ubah, koneksi.koneksiDB);
MySqlCommand cmd1 = new MySqlCommand(update, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", int.Parse(id));
cmd.Parameters.AddWithValue("@jumlahUbah", int.Parse(jumlahUbah));
cmd1.Parameters.AddWithValue("@id", int.Parse(nis));
cmd1.Parameters.AddWithValue("@jumlahUbah", int.Parse(jumlahUbah));
cmd1.Parameters.AddWithValue("@jumlah", int.Parse(jumlah));
int insertResult = cmd.ExecuteNonQuery();
cmd1.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
}
}
//
//Akhir Data Tabungan Keluar
//
//
//Tabungan Total
//
private void BindDataTotalTabungan()
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string select = "select sis.nis as NIS, sis.nama as Nama, sis.kelas as Kelas, tab.total as Total from ttotal as tab " +
"join tsiswa as sis on(sis.nis = tab.nis)";
MySqlCommand cmd = new MySqlCommand(select, koneksi.koneksiDB);
MySqlDataReader reader = cmd.ExecuteReader();
table = new DataTable();
table.Load(reader);
radGridTabunganSaldo.DataSource = table;
koneksi.koneksiDB.Close();
}
}
private void BindDataTotalPendaftaran()
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string select = "select sum(jumlah) as 'Total Uang Pendaftaran' from tdaftar";
MySqlCommand cmd = new MySqlCommand(select, koneksi.koneksiDB);
MySqlDataReader reader = cmd.ExecuteReader();
table = new DataTable();
table.Load(reader);
radGridView1.DataSource = table;
koneksi.koneksiDB.Close();
}
}
private void BindDataTotalPembayaran()
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string select = "select sum(total) as 'Total Pembayaran' from tpembayaran";
MySqlCommand cmd = new MySqlCommand(select, koneksi.koneksiDB);
MySqlDataReader reader = cmd.ExecuteReader();
table = new DataTable();
table.Load(reader);
radGridView1.DataSource = table;
koneksi.koneksiDB.Close();
}
}
private void radButtonTambah_Click(object sender, EventArgs e)
{
DateTime date = DateTime.Now;
string jumlah = textJumlah.Text;
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string insert = "insert into ttabungan(nis,jumlah,tanggal,id_tu) values (@nis,@jumlah,@tanggal,@id_tu)";
MySqlCommand cmd = new MySqlCommand(insert, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", int.Parse(id));
cmd.Parameters.AddWithValue("@jumlah", int.Parse(jumlah));
cmd.Parameters.AddWithValue("@tanggal", date);
cmd.Parameters.AddWithValue("@id_tu", int.Parse(idTU));
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
Total();
this.Close();
}
else
{
MessageBox.Show("Gagal");
}
koneksi.koneksiDB.Close();
}
}
private void BindDataTotalTabunganKeluar()
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string select = "select sum(jumlah) as Total from ttabungankeluar where nis = @nis";
MySqlCommand cmd = new MySqlCommand(select, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", nis);
MySqlDataReader reader = cmd.ExecuteReader();
table = new DataTable();
table.Load(reader);
radGridView1.DataSource = table;
koneksi.koneksiDB.Close();
}
}
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();
}
}
private void radButtonUbah_Click(object sender, EventArgs e)
{
string noSurat = textBoxNoSurat.Text;
string lampiran = textBoxLampiran.Text;
string perihal = textBoxPerihal.Text;
string jenis = comboBoxJenis.Text;
string pengirim = textBoxPengirim.Text;
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string ubah = "update tsurat set no_surat = @no_surat, lampiran = @lampiran, perihal = @perihal, jenis = @jenis, pengirim = @pengirim where id_surat = @id";
MySqlCommand cmd = new MySqlCommand(ubah, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", int.Parse(id));
cmd.Parameters.AddWithValue("@no_surat", noSurat);
cmd.Parameters.AddWithValue("@lampiran", lampiran);
cmd.Parameters.AddWithValue("@perihal", perihal);
cmd.Parameters.AddWithValue("@jenis", jenis);
cmd.Parameters.AddWithValue("@pengirim", pengirim);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
}
}
private void radButtonTambah_Click(object sender, EventArgs e)
{
DateTime date = DateTime.Now;
string jenis = comboJenis.Text;
string jumlah = labelJumlah.Text;
if (comboJenis.Text == "Daftar Baru" && (kelas == "2" || kelas == "3" || kelas == "4" || kelas == "5" || kelas == "6"))
{
MessageBox.Show("Kelas " + kelas + " tidak bisa daftar baru", "Pesan Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
if (comboJenis.Text == "Daftar Baru")
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string insert = "insert into tdaftar(nis,jenis,jumlah,tanggal,id_tu) values (@nis,@jenis,@jumlah,@tanggal,@id_tu)";
MySqlCommand cmd = new MySqlCommand(insert, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", int.Parse(id));
cmd.Parameters.AddWithValue("@jenis", jenis);
cmd.Parameters.AddWithValue("@jumlah", int.Parse(jumlah));
cmd.Parameters.AddWithValue("@tanggal", date);
cmd.Parameters.AddWithValue("@id_tu", int.Parse(idTU));
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Gagal");
}
koneksi.koneksiDB.Close();
}
}
else if (comboJenis.Text == "Daftar Ulang" && radCheckAuto.Checked == true)
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string insert = "insert into tdaftar(nis,jenis,jumlah,tanggal,id_tu) values (@nis,@jenis,@jumlah,@tanggal,@id_tu)";
string update = "update tsiswa set kelas = kelas + 1 where nis = @nis";
MySqlCommand cmd = new MySqlCommand(insert, koneksi.koneksiDB);
MySqlCommand cmdi = new MySqlCommand(update, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", int.Parse(id));
cmd.Parameters.AddWithValue("@jenis", jenis);
cmd.Parameters.AddWithValue("@jumlah", int.Parse(jumlah));
cmd.Parameters.AddWithValue("@tanggal", date);
cmd.Parameters.AddWithValue("@id_tu", int.Parse(idTU));
cmdi.Parameters.AddWithValue("@nis", int.Parse(id));
int insertResult = cmd.ExecuteNonQuery();
cmdi.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Gagal");
}
koneksi.koneksiDB.Close();
}
}
else if (comboJenis.Text == "Daftar Ulang" && radCheckAuto.Checked == false)
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string insert = "insert into tdaftar(nis,jenis,jumlah,tanggal,id_tu) values (@nis,@jenis,@jumlah,@tanggal,@id_tu)";
string update = "update tsiswa set kelas = @kelas where nis = @nis";
MySqlCommand cmd = new MySqlCommand(insert, koneksi.koneksiDB);
MySqlCommand cmdi = new MySqlCommand(update, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", int.Parse(id));
cmd.Parameters.AddWithValue("@jenis", jenis);
cmd.Parameters.AddWithValue("@jumlah", int.Parse(jumlah));
cmd.Parameters.AddWithValue("@tanggal", date);
cmd.Parameters.AddWithValue("@id_tu", int.Parse(idTU));
cmdi.Parameters.AddWithValue("@nis", int.Parse(id));
cmdi.Parameters.AddWithValue("@kelas", int.Parse(comboBoxKelas.Text));
int insertResult = cmd.ExecuteNonQuery();
cmdi.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Gagal");
}
koneksi.koneksiDB.Close();
}
}
}
//
////Akhir Tombol Tambah
//
//
////Tombol Hapus
//
private void radButtonHapus_Click(object sender, EventArgs e)
{
if (tombol == "siswa")
{
string namaHapus = nama;
string title = "Pesan Konfirmasi";
string messsage = "Anda yakin data dengan nama " + namaHapus.Trim() + " akan dihapus ?";
DialogResult result = MessageBox.Show(messsage, title, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (result != DialogResult.OK)
{
return;
}
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string delete = "delete from tsiswa where nis = @nis";
MySqlCommand cmd = new MySqlCommand(delete, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", id);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
BindDataSiswa();
}
}
else if (tombol == "pembayaran")
{
string namaHapus = nama;
string title = "Pesan Konfirmasi";
string messsage = "Anda yakin data dengan nama " + namaHapus.Trim() + " akan dihapus ?";
DialogResult result = MessageBox.Show(messsage, title, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (result != DialogResult.OK)
{
return;
}
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string delete = "delete from tpembayaran where id_pembayaran = @id";
MySqlCommand cmd = new MySqlCommand(delete, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", idtab);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
BindDataPembayaran();
}
}
else if (tombol == "surat")
{
string surat = noSurat;
string title = "Pesan Konfirmasi";
string messsage = "Anda yakin data dengan No Surat " + surat.Trim() + " akan dihapus ?";
DialogResult result = MessageBox.Show(messsage, title, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (result != DialogResult.OK)
{
return;
}
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string delete = "delete from tsurat where id_surat = @id";
MySqlCommand cmd = new MySqlCommand(delete, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", id);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
BindDataSurat();
}
}
else if (tombol == "pendaftaran")
{
string namaHapus = nama;
string title = "Pesan Konfirmasi";
string messsage = "Anda yakin data dengan nama " + namaHapus.Trim() + " akan dihapus ?";
DialogResult result = MessageBox.Show(messsage, title, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (result != DialogResult.OK)
{
return;
}
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string delete = "delete from tdaftar where id_daftar = @id";
MySqlCommand cmd = new MySqlCommand(delete, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", idtab);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
BindDataDaftar();
}
}
else if (tombol == "tabungan")
{
string namaHapus = nama;
string title = "Pesan Konfirmasi";
string messsage = "Anda yakin data dengan nama " + namaHapus.Trim() + " akan dihapus ?";
DialogResult result = MessageBox.Show(messsage, title, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (result != DialogResult.OK)
{
return;
}
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string delete = "delete from ttabungan where id_tabung = @id";
string update = "update ttotal set total = total - @jumlah where nis = @id";
MySqlCommand cmd = new MySqlCommand(delete, koneksi.koneksiDB);
MySqlCommand cmdi = new MySqlCommand(update, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", idtab);
cmdi.Parameters.AddWithValue("@id", idtab);
cmdi.Parameters.AddWithValue("@jumlah", jumlah);
int insertResult = cmd.ExecuteNonQuery();
cmdi.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
BindDataTabungan();
}
}
else if (tombol == "tabungankeluar")
{
string namaHapus = nama;
string title = "Pesan Konfirmasi";
string messsage = "Anda yakin data dengan nama " + namaHapus.Trim() + " akan dihapus ?";
DialogResult result = MessageBox.Show(messsage, title, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (result != DialogResult.OK)
{
return;
}
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string delete = "delete from ttabungankeluar where id_tabung_keluar = @id";
MySqlCommand cmd = new MySqlCommand(delete, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", idtab);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
BindDataTabunganKeluar();
}
}
}
private void BindDataTotalTabungan()
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string select = "select total as Total from ttotal where nis = @nis";
MySqlCommand cmd = new MySqlCommand(select, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", nis);
MySqlDataReader reader = cmd.ExecuteReader();
table = new DataTable();
table.Load(reader);
radGridView1.DataSource = table;
koneksi.koneksiDB.Close();
}
}
private void radButtonUbah_Click(object sender, EventArgs e)
{
string cathering = checkBoxCathering.Text;
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string ubah = "update tpembayaran set cathering = @cathering, bulan = @bulan where id_pembayaran = @id";
MySqlCommand cmd = new MySqlCommand(ubah, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", int.Parse(id));
cmd.Parameters.AddWithValue("@cathering", cathering);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
this.Close();
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
}
}
//
//Akhir Data Siswa
//
//
//Data Pembayaran
//
private void BindDataPembayaran()
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string select = "select pem.id_pembayaran as ID, pem.nis as NIS, sis.nama as Nama, sis.kelas as Kelas, " +
"pem.spp as SPP, pem.cathering as Cathering, pem.marching_band as 'Marching Band', pem.bulan as Bulan , " +
"pem.total as Total, pem.tanggal as 'Tanggal Bayar', tu.nama as 'Nama TU' " +
"from tpembayaran as pem " +
"join tsiswa as sis on(pem.nis = sis.nis)" +
"join ttu as tu on(pem.id_tu = tu.id_tu)";
MySqlCommand cmd = new MySqlCommand(select, koneksi.koneksiDB);
MySqlDataReader reader = cmd.ExecuteReader();
table = new DataTable();
table.Load(reader);
radGridPembayaran.DataSource = table;
koneksi.koneksiDB.Close();
}
}
private void Total()
{
if (statusTotalTabungan(int.Parse(id)) == true)
{
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string ubah = "update ttotal set total = (select sum(jumlah) from ttabungan where nis = @nis) where nis = @nis";
MySqlCommand cmd = new MySqlCommand(ubah, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", int.Parse(id));
int insertResult = cmd.ExecuteNonQuery();
koneksi.koneksiDB.Close();
}
}
else
{
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string insert = "insert into ttotal(nis,total) values (@nis,(select sum(jumlah) from ttabungan where nis = @nis))";
MySqlCommand cmd = new MySqlCommand(insert, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", int.Parse(id));
int insertResult = cmd.ExecuteNonQuery();
koneksi.koneksiDB.Close();
}
}
}
//
////Akhir Tombol Refresh
//
//
////Tombol Hapus
//
private void radButtonHapus_Click(object sender, EventArgs e)
{
if (tombol == "tu")
{
string namaHapus = nama;
string title = "Pesan Konfirmasi";
string messsage = "Anda yakin data dengan nama " + namaHapus.Trim() + " akan dihapus ?";
DialogResult result = MessageBox.Show(messsage, title, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (result != DialogResult.OK)
{
return;
}
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string delete = "delete from ttu where id_tu = @id";
MySqlCommand cmd = new MySqlCommand(delete, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", id);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
BindDataTU();
}
}
else if (tombol == "siswa")
{
string namaHapus = nama;
string title = "Pesan Konfirmasi";
string messsage = "Anda yakin data dengan nama " + namaHapus.Trim() + " akan dihapus ?";
DialogResult result = MessageBox.Show(messsage, title, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (result != DialogResult.OK)
{
return;
}
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string delete = "delete from tsiswa where nis = @nis";
MySqlCommand cmd = new MySqlCommand(delete, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@nis", id);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
BindDataSiswa();
}
}
else if (tombol == "pembayaran")
{
string namaHapus = nama;
string title = "Pesan Konfirmasi";
string messsage = "Anda yakin data dengan nama " + namaHapus.Trim() + " akan dihapus ?";
DialogResult result = MessageBox.Show(messsage, title, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (result != DialogResult.OK)
{
return;
}
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string delete = "delete from tpembayaran where id_pembayaran = @id";
MySqlCommand cmd = new MySqlCommand(delete, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", idtab);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
BindDataPembayaran();
}
}
else if (tombol == "surat")
{
string surat = noSurat;
string title = "Pesan Konfirmasi";
string messsage = "Anda yakin data dengan No Surat " + surat.Trim() + " akan dihapus ?";
DialogResult result = MessageBox.Show(messsage, title, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (result != DialogResult.OK)
{
return;
}
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string delete = "delete from tsurat where id_surat = @id";
MySqlCommand cmd = new MySqlCommand(delete, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", id);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
BindDataSurat();
}
}
else if (tombol == "pendaftaran")
{
string namaHapus = nama;
string title = "Pesan Konfirmasi";
string messsage = "Anda yakin data dengan nama " + namaHapus.Trim() + " akan dihapus ?";
DialogResult result = MessageBox.Show(messsage, title, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (result != DialogResult.OK)
{
return;
}
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string delete = "delete from tdaftar where id_daftar = @id";
MySqlCommand cmd = new MySqlCommand(delete, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", idtab);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
BindDataDaftar();
}
}
else if (tombol == "tabungan")
{
string namaHapus = nama;
string title = "Pesan Konfirmasi";
string messsage = "Anda yakin data dengan nama " + namaHapus.Trim() + " akan dihapus ?";
DialogResult result = MessageBox.Show(messsage, title, MessageBoxButtons.OKCancel, MessageBoxIcon.Warning);
if (result != DialogResult.OK)
{
return;
}
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string delete = "delete from ttabungan where id_tabung = @id";
MySqlCommand cmd = new MySqlCommand(delete, koneksi.koneksiDB);
cmd.Parameters.AddWithValue("@id", idtab);
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
MessageBox.Show("Sukses");
}
else
{
MessageBox.Show("Failed");
}
koneksi.koneksiDB.Close();
BindDataTabungan();
}
}
}
//
//// Akhir Navigasi Tabungan Total
//
//
//Akhir Navigasi
//
//
//Data Tata Usaha
//
private void BindDataTU()
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string select = "select id_tu as 'ID Tata Usaha', nama as Nama, password as Password, tanggal as 'Tanggal Daftar' from ttu";
MySqlCommand cmd = new MySqlCommand(select, koneksi.koneksiDB);
MySqlDataReader reader = cmd.ExecuteReader();
table = new DataTable();
table.Load(reader);
radGridTu.DataSource = table;
koneksi.koneksiDB.Close();
}
}
//
//Akhir Data Tabungan
//
//
//Tabungan Total
//
private void BindDataTotalTabungan()
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string select = "select sis.nis as NIS, sis.nama as Nama, sis.kelas as Kelas, tab.total as Total from ttotal as tab "+
"join tsiswa as sis on(sis.nis = tab.nis)";
MySqlCommand cmd = new MySqlCommand(select, koneksi.koneksiDB);
MySqlDataReader reader = cmd.ExecuteReader();
table = new DataTable();
table.Load(reader);
radGridTabunganSaldo.DataSource = table;
koneksi.koneksiDB.Close();
}
}
//
//Akhir Data Tabungan
//
//
//Data Tabungan
//
private void BindDataTabunganKeluar()
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string select = "select tab.id_tabung_keluar as ID, tab.nis as NIS, sis.nama as Nama, sis.kelas as Kelas, " +
"tab.jumlah as Jumlah, tab.tanggal as Tanggal, tu.nama as 'Nama TU' " +
"from ttabungankeluar as tab " +
"join tsiswa as sis on(sis.nis = tab.nis) " +
"join ttu as tu on(tu.id_tu = tab.id_tu)";
MySqlCommand cmd = new MySqlCommand(select, koneksi.koneksiDB);
MySqlDataReader reader = cmd.ExecuteReader();
table = new DataTable();
table.Load(reader);
radGridTabunganKeluar.DataSource = table;
koneksi.koneksiDB.Close();
}
}
//
//Akhir Data Pembayaran
//
//
//Data Surat
//
private void BindDataSurat()
{
//SqlConnection connection = new SqlConnection(strConnection);
koneksi = new Koneksi();
using (koneksi.koneksiDB)
{
koneksi.koneksiDB.Open();
string select = "select surat.id_surat as ID, tu.nama as 'Nama TU', surat.no_surat as 'No Surat', surat.lampiran as Lampiran, " +
"surat.perihal as Perihal, surat.jenis as Jenis, surat.tanggal as Tanggal, " +
"surat.pengirim as Pengirim " +
"from tsurat as surat " +
"join ttu as tu on(surat.id_tu = tu.id_tu)";
MySqlCommand cmd = new MySqlCommand(select, koneksi.koneksiDB);
MySqlDataReader reader = cmd.ExecuteReader();
table = new DataTable();
table.Load(reader);
radGridSurat.DataSource = table;
koneksi.koneksiDB.Close();
}
}
