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; } }
public static int PeriodeId(ComboBoxEdit comboBoxEdits) { var service = new IadmClient(); var s = new string[3]; var combobox = comboBoxEdits.SelectedItem.ToString(); if (combobox[5] != ' ') { s[0] = "Ganjil"; s[1] = combobox.Substring(7, 4); s[2] = combobox.Substring(12, 4); } else { s[0] = "Genap"; s[1] = combobox.Substring(6, 4); s[2] = combobox.Substring(11, 4); } var p = service.viewPeriode().FirstOrDefault(x => x.semester == s[0] && x.awalSemester.ToString("yyyy") == s[1] && x.akhirSemester.ToString("yyyy") == s[2]); return(p.id_periode); }
public static void ComboBoxEditAdd(string option, ComboBoxEdit comboBoxEdit) { var service = new IadmClient(); comboBoxEdit.Properties.Items.Clear(); if (option == "Jurusan") { var jurusan = service.GetJurusan(); for (var i = 0; i < jurusan.Count(); i++) // Add Jurusan { comboBoxEdit.Properties.Items.Add(jurusan[i].NamaJurusan); } } if (option == "Angkatan") { var angkatan = service.GetAngkatan(); for (var i = 0; i < angkatan.Count(); i++) // Add Angkatan { comboBoxEdit.Properties.Items.Add(angkatan[i].TahunAngkatan); } } if (option == "Periode") { var periode = service.viewPeriode() .Select( z => new { start = z.awalSemester.ToString("yyyy"), finish = z.akhirSemester.ToString("yyyy") }) .Distinct() .ToList(); for (int i = 0; i < periode.Count(); i++) { comboBoxEdit.Properties.Items.Add($"{periode[i].start:yyyy}/{periode[i].finish:yyyy}"); } } if (option == "Semester") { var semester = service.viewPeriode().Select(z => z.semester).Distinct().ToList(); for (var i = 0; i < semester.Count(); i++) { comboBoxEdit.Properties.Items.Add(semester[i]); } } comboBoxEdit.SelectedIndex = 0; service.Close(); }
public static void AddPeriode(ComboBoxEdit comboBoxEdits) { comboBoxEdits.Properties.Items.Clear(); var service = new IadmClient(); comboBoxEdits.Properties.Items.AddRange(service.viewPeriode().Select(x => x.semester + " " + x.awalSemester.ToString("yyyy") + "/" + x.akhirSemester.ToString("yyyy")) .ToList()); comboBoxEdits.SelectedIndex = 0; service.Close(); }
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 Form4_Load(object sender, EventArgs e) { // Format tgl indonesia DateFormatCultureInfo(dateEdit1, dateEdit2); // IadmClient service = new IadmClient(); // gridControl1.DataSource = service.viewPeriode().Select(x => new { semester = $"{x.semester} {x.awalSemester.ToString("yyyy")}/{x.akhirSemester.ToString("yyyy")}", awalSemester = x.awalSemester.ToString("dd MMMM yyyy", new CultureInfo("id-ID")), akhirSemester = x.akhirSemester.ToString("dd MMMM yyyy", new CultureInfo("id-ID")), }).ToList(); service.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 AddPeriode(object sender, EventArgs e) { DateTime mulai = dateEdit1.DateTime; DateTime selesai = dateEdit2.DateTime; string a = comboBoxEdit1.SelectedItem.ToString(); IadmClient service = new IadmClient(); periode data = new periode() { semester = a, awalSemester = mulai, akhirSemester = selesai }; service.addPeriode(data); gridControl1.DataSource = service.viewPeriode().Select(x => new { semester = $"{x.semester} {x.awalSemester.ToString("yyyy")}/{x.akhirSemester.ToString("yyyy")}", awalSemester = x.awalSemester.ToString("dd MMMM yyyy", new CultureInfo("id-ID")), akhirSemester = x.akhirSemester.ToString("dd MMMM yyyy", new CultureInfo("id-ID")) }).ToList(); service.Close(); }
private void simpleButton2_Click(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 jadwalPraktikan( ) { nrp = nrppraktikan, id_jadwal_umum = new jadwal_umum( ) { id_periode = periode.id_periode } }; try { service.DeleteJadwalPraktikan(data); } catch (Exception) { XtraMessageBox.Show("Error"); } 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(); } } }