private void FrmTambahJadwalPraktikan_Load(object sender, EventArgs e) { var service = new IadmClient( ); var periode = service.viewPeriode().FirstOrDefault( x => service.ServerTime() >= x.awalSemester && service.ServerTime() <= x.akhirSemester); var data = new jadwal_umum( ) { id_periode = periode.id_periode }; gridControl1.DataSource = service.ViewJadwalUmum(data).Select(x => new { HARI = x.hari, SHIFT = x.fk_jadwalUmum_Shift.id_shift, WAKTU = string.Format("{0:HH:mm} - {1:HH:mm}", x.fk_jadwalUmum_Shift.mulai, x.fk_jadwalUmum_Shift.selesai), PRAKTIKUM = x.fk_jadwalUmum_matakuliah.mata_kuliah, KELAS = x.fk_jadwalUmum_kelas.Kelas }); // add checkbox and enable multi select rows gridView1.OptionsSelection.MultiSelect = true; gridView1.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect; // disable focused row and move column for (var i = 0; i < gridView1.Columns.Count; i++) { gridView1.Columns[i].OptionsColumn.AllowFocus = false; gridView1.Columns[i].OptionsColumn.AllowMove = false; } }
private void simpleButton1_Click(object sender, EventArgs e) { var service = new IadmClient(); var periode = service.viewPeriode().ToList() .FirstOrDefault(x => x.awalSemester <service.ServerTime() && x.akhirSemester> service.ServerTime()); var praktikum = comboBoxEdit4.SelectedItem.ToString(); var shift = comboBoxEdit3.SelectedItem.ToString(); var periodeID = new jadwal_umum() { id_periode = periode.id_periode }; var jadwal = service.ViewJadwalUmum(periodeID).ToList() .FirstOrDefault(x => x.fk_jadwalUmum_Shift.id_shift == shift && x.fk_jadwalUmum_matakuliah.mata_kuliah == praktikum && x.hari == comboBoxEdit2.SelectedItem.ToString()); bool errorMessage = false; try { List <jadwalStaff> j = new List <jadwalStaff>(); var data = new jadwalStaff() { staff = new Staff() { id_staff = comboBoxEdit1.SelectedItem.ToString() }, jadwal_umum = new jadwal_umum() { id_jadwal_umum = jadwal.id_jadwal_umum } }; j.Add(data); service.AddJadwalStaffAsisten(j.ToArray()); service.Close(); } catch (Exception) { errorMessage = true; XtraMessageBox.Show("Tidak ada praktikum " + praktikum + " shift " + shift + " hari " + comboBoxEdit2.SelectedItem.ToString()); } if (errorMessage == false) { Close(); } }
private void TambahJadwalPraktikan(object sender, EventArgs e) { var service = new IadmClient( ); var jadwal = new List <jadwalPraktikan>( ); var values = gridView1.GetSelectedRows( ); var periode = service.viewPeriode( ).FirstOrDefault( x => service.ServerTime() >= x.awalSemester && service.ServerTime() <= x.akhirSemester); var data = new jadwal_umum( ) { id_periode = periode.id_periode }; var listjadwal = new List <jadwalPraktikan>( ); for (var i = 0; i < values.Count( ); i++) { var shift = gridView1.GetRowCellValue(values[i], gridView1.Columns[1]).ToString( ); var hari = gridView1.GetRowCellValue(values[i], gridView1.Columns[0]).ToString( ); var matkul = gridView1.GetRowCellValue(values[i], gridView1.Columns[3]).ToString( ); var id = service.ViewJadwalUmum(data).FirstOrDefault(x => (x.fk_jadwalUmum_Shift.id_shift == shift && x.hari == hari) && x.fk_jadwalUmum_matakuliah.mata_kuliah == matkul); var jadwalpraktikan = new jadwalPraktikan( ) { nrp = simpleLabelItem1.Text, id_jadwal_umum = new jadwal_umum( ) { id_jadwal_umum = id.id_jadwal_umum } }; listjadwal.Add(jadwalpraktikan); } try { service.AddJadwalPraktikan(listjadwal.ToArray( )); } catch (Exception) { XtraMessageBox.Show("Tidak ada jadwal"); } Close( ); }
private void Simpan(object sender, EventArgs e) { var service = new IadmClient(); var jadwal = new List <jadwal_umum>(); var idPeriode = service.viewPeriode().FirstOrDefault( q => q.awalSemester.ToString("yyyy") == comboBoxEdit2.SelectedItem.ToString().Substring(0, 4) && q.akhirSemester.ToString("yyyy") == comboBoxEdit2.SelectedItem.ToString().Substring(5, 4) && q.semester == comboBoxEdit1.SelectedItem.ToString()); if (idPeriode == null) { XtraMessageBox.Show( $"Semester {comboBoxEdit1.SelectedItem} Periode {comboBoxEdit2.SelectedItem} belum ada"); } else { //ambil data dari tabel for (var i = 0; i < gridView1.RowCount; i++) { DataRow row = gridView1.GetDataRow(i); if (row[3].ToString() == string.Empty || row[4].ToString() == string.Empty) { continue; } var idKelas = service.GetKelas().FirstOrDefault(q => q.Kelas == row[4].ToString()); var kdMk = service.GetMatKul().FirstOrDefault(q => q.mata_kuliah == row[3].ToString()); Debug.Assert(idKelas != null, "idKelas != null"); Debug.Assert(kdMk != null, "kdMk != null"); var listJadwal = new jadwal_umum() { hari = row[0].ToString(), id_kelas = idKelas.id_kelas, id_periode = idPeriode.id_periode, id_shift = row[1].ToString(), kode_mk = kdMk.kode_mk }; jadwal.Add(listJadwal); } //ubah List<jadwal_umum> ke jadwal_umum[] var jadd = new jadwal_umum[jadwal.Count]; for (var i = 0; i < jadwal.Count; i++) { var jadum = new jadwal_umum() { hari = jadwal[i].hari, id_kelas = jadwal[i].id_kelas, id_periode = jadwal[i].id_periode, id_shift = jadwal[i].id_shift, kode_mk = jadwal[i].kode_mk }; jadd[i] = jadum; } var errorMessage = false; try { service.InsertJadwal(jadd); } catch (Exception) { errorMessage = true; //XtraMessageBox.Show(error.ToString()); XtraMessageBox.Show("Tidak ada jadwal yg ditambahkan"); } if (errorMessage == false) { Close(); } } }