private void TambahJadwalAsisten_Load(object sender, EventArgs e) { var service = new IadmClient(); var asisten = service.getStaffID().ToList(); var praktikum = service.GetMatKul().ToList(); for (var i = 0; i < asisten.Count(); i++) { comboBoxEdit1.Properties.Items.Add(asisten[i].id_staff); } for (var i = 0; i < praktikum.Count(); i++) { comboBoxEdit4.Properties.Items.Add(praktikum[i].mata_kuliah); } }
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(); } } }
private void Form3_Load(object sender, EventArgs e) { var service = new IadmClient(); var jadwal = new DataTable(); jadwal.Columns.Add("Hari", typeof(string)); jadwal.Columns.Add("Shit", typeof(string)); jadwal.Columns.Add("jam", typeof(string)); jadwal.Columns.Add("Praktikum", typeof(string)); jadwal.Columns.Add("Kelas", typeof(string)); string[] hari = { "Senin", "Selasa", "Rabu", "Kamis", "Jumat" }; string[] shift = { "I", "II", "III", "IV" }; string[] jam = { "08:00 - 09:40", "09:50 - 11:30", "11:40 - 13:20", "13:30 - 15:10" }; foreach (string t in hari) { for (var s = 0; s < shift.Length; s++) { jadwal.Rows.Add(t, shift[s], jam[s], null, null); } } gridControl1.DataSource = jadwal; gridView1.OptionsView.AllowCellMerge = true; gridView1.Columns["Praktikum"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False; gridView1.Columns["Kelas"].OptionsColumn.AllowMerge = DevExpress.Utils.DefaultBoolean.False; gridControl1.ForceInitialize(); var cmbbxPraktikum = new RepositoryItemComboBox() { TextEditStyle = TextEditStyles.DisableTextEditor }; var cmbbxMk = new RepositoryItemComboBox() { TextEditStyle = TextEditStyles.DisableTextEditor }; var mk = service.GetMatKul(); var praktikum = new string[mk.Length]; for (var i = 0; i < mk.Length; i++) { praktikum[i] = mk[i].mata_kuliah; } cmbbxPraktikum.Items.AddRange(praktikum); var kls = service.GetKelas(); var kelas = new string[kls.Length]; var count = kls.Length; for (var i = 0; i < count; i++) { kelas[i] = kls[i].Kelas; } cmbbxMk.Items.AddRange(kelas); gridControl1.RepositoryItems.Add(cmbbxPraktikum); gridControl1.RepositoryItems.Add(cmbbxMk); gridView1.Columns["Praktikum"].ColumnEdit = cmbbxPraktikum; gridView1.Columns["Kelas"].ColumnEdit = cmbbxMk; }