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();
}
}
}
