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