private void GetButton_Click(object sender, EventArgs e) { // TODO: This line of code loads data into the 'dataSet11.TabelLaporan' table. You can move, or remove it, as needed. TabelLaporanTableAdapter adapter = new TabelLaporanTableAdapter(); DataTable dt = adapter.GetDataBy((int)comboBox1.SelectedValue, dateTimePicker1.Text); if (dt.Rows.Count > 0) { //jika ada data DataTable dt_new = adapter.GetDataBy((int)comboBox1.SelectedValue, dateTimePicker1.Text); dataGridView1.DataSource = dt_new; } else { //jika tdk ada data DataSiswaTableAdapter dataSiswa = new DataSiswaTableAdapter(); DataTable data_siswa = dataSiswa.GetDataByIDKelas((int)comboBox1.SelectedValue); foreach (DataRow row in data_siswa.Rows) { //menambah Record Laporan tiap siswa adapter.InsertQuery((int)row[0], (int)comboBox1.SelectedValue, dateTimePicker1.Text, "", row[1].ToString(), comboBox1.Text); } DataTable dt_new = adapter.GetDataBy((int)comboBox1.SelectedValue, dateTimePicker1.Text); dataGridView1.DataSource = dt_new; } }
private void HapusButton_Click(object sender, EventArgs e) { TabelLaporanTableAdapter adapter = new TabelLaporanTableAdapter(); foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.Cells[1].Value != null) { adapter.UpdateQuery("", row.Cells[0].Value.ToString(), (int)comboBox1.SelectedValue, dateTimePicker1.Text); } } DataTable dt_new = adapter.GetDataBy((int)comboBox1.SelectedValue, dateTimePicker1.Text); dataGridView1.DataSource = dt_new; }
private void Getbutton1_Click(object sender, EventArgs e) { //get data DataSiswaTableAdapter dataSiswa = new DataSiswaTableAdapter(); DataTable data_siswa = dataSiswa.GetDataByIDKelas((int)comboBox1.SelectedValue); TabelLaporanTableAdapter ada = new TabelLaporanTableAdapter(); int Hadir = 0, Absen = 0, Terlambat = 0, Ijin = 0; //loop foreach (DataRow row in data_siswa.Rows) { //hitung kehadiran Hadir = (int)ada.GetDataByReport(dateTimePicker2.Value.Month, row[1].ToString(), "hadir").Rows[0][6]; //hitung absen Absen = (int)ada.GetDataByReport(dateTimePicker2.Value.Month, row[1].ToString(), "absen").Rows[0][6]; //hitung terlambat Terlambat = (int)ada.GetDataByReport(dateTimePicker2.Value.Month, row[1].ToString(), "terlambat").Rows[0][6]; //Ijin Ijin = (int)ada.GetDataByReport(dateTimePicker2.Value.Month, row[1].ToString(), "ijin").Rows[0][6]; ListViewItem litem = new ListViewItem(); litem.Text = row[1].ToString(); litem.SubItems.Add(Hadir.ToString()); litem.SubItems.Add(Absen.ToString()); litem.SubItems.Add(Terlambat.ToString()); litem.SubItems.Add(Ijin.ToString()); listView1.Items.Add(litem); } //tambahkan }