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 void CariPraktikan(ComboBoxEdit comboBoxEdit1, ComboBoxEdit comboBoxEdit2, GridControl gridcontrol, GridView gridview)
{
try
{
var service = new IadmClient();
comboBoxEdit1.SelectedIndex = 0;
comboBoxEdit2.SelectedIndex = 0;
var nmAngkatan = comboBoxEdit1.SelectedItem.ToString();
var nmJurusan = comboBoxEdit2.SelectedItem.ToString();
var angkatan = service.GetAngkatan().FirstOrDefault(q => q.TahunAngkatan == nmAngkatan);
var jurusan = service.GetJurusan().FirstOrDefault(q => q.NamaJurusan == nmJurusan);
praktikan data = new praktikan()
{
angkatan = new angkatan()
{
KodeAngkatan = angkatan?.KodeAngkatan
},
jurusan = new jurusan()
{
KodeJurusan = jurusan?.KodeJurusan
}
};
gridcontrol.DataSource =
service.GetPraktikan(data)
.Select(
x =>
new
{
x.Foto,
x.NRP,
x.Nama,
KodeAngkatan = x.angkatan.KodeAngkatan,
KodeJurusan = x.jurusan.KodeJurusan
})
.ToList();
gridview.RowHeight = 60;
gridview.Columns["Foto"].Width = 70;
gridview.Columns["NRP"].Width = 150;
gridview.Columns["NRP"].Caption = @"NO MAHASISWA";
gridview.Columns["Foto"].Caption = @"FOTO";
gridview.Columns["Nama"].Caption = @"NAMA";
gridview.Columns["KodeAngkatan"].Caption = @"ANGKATAN";
gridview.Columns["KodeJurusan"].Caption = @"JURUSAN";
for (int i = 0; i < gridview.Columns.Count; i++)
{
gridview.Columns[i].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
}
service.Close();
}
catch (Exception)
{
//XtraMessageBox.Show(err.ToString());
//XtraMessageBox.Show("data pencarian tidak lengkap");
throw;
}
}
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);
}
private void simpleButton1_Click(object sender, EventArgs e)
{
try
{
if (textEdit1.Text.Length != 4)
{
XtraMessageBox.Show("Format Tahun Salah !");
}
else
{
var service = new IadmClient( );
var data = new angkatan( )
{
KodeAngkatan = textEdit1.Text.Substring(2, 2),
TahunAngkatan = textEdit1.Text.Substring(0, 4)
};
service.TambahAngaktan(data);
listBoxControl1.Items.Add(textEdit1.Text);
service.Close();
}
}
catch (Exception)
{
XtraMessageBox.Show("Format Tahun Salah !");
}
}
private void simpleButton1_Click(object sender, EventArgs e)
{
var error = false;
try
{
var service = new IadmClient();
var data = new Users()
{
username = id, password = textEdit1.Text
};
service.EditPassword(data);
service.Close();
}
catch (Exception)
{
error = true;
XtraMessageBox.Show("ada kesalahan");
}
if (error == false)
{
Close();
}
}
private void GetTahunAngkatan()
{
listBoxControl1.Items.Clear();
var service = new IadmClient();
var angkatan = service.GetAngkatan().Select(x => x.TahunAngkatan).ToList();
listBoxControl1.Items.AddRange(angkatan.ToArray());
service.Close();
}
private void simpleButton2_Click(object sender, EventArgs e)
{
var service = new IadmClient();
var data = new angkatan()
{
TahunAngkatan = listBoxControl1.SelectedItem.ToString()
};
service.HapusAngkatan(data);
service.Close();
GetTahunAngkatan();
}
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 simpleButton3_Click(object sender, EventArgs e)
{
var sheet = listBoxControl1.SelectedItem.ToString().Replace("'", Empty);
var data = ExcelToDataTable(_dialog.FileName, sheet);
var praktikan = new praktikan[data.Rows.Count];
var jur = Empty;
var angk = Empty;
for (var i = 0; i < data.Rows.Count; i++)
{
var nrpmhs = data.Rows[i][0].ToString();
var biodata = new praktikan()
{
NRP = data.Rows[i][0].ToString(),
Nama = data.Rows[i][1].ToString(),
jurusan = new jurusan()
{
KodeJurusan = Concat(nrpmhs[0], nrpmhs[1], nrpmhs[2])
},
angkatan = new angkatan()
{
KodeAngkatan = Concat(nrpmhs[3], nrpmhs[4])
},
Foto = ImageToByteArray(pictureEdit1.Image)
};
praktikan[i] = biodata;
jur = Concat(nrpmhs[0], nrpmhs[1], nrpmhs[2]);
angk = Concat(nrpmhs[3], nrpmhs[4]);
}
try
{
var service = new IadmClient();
var jurusan = service.GetJurusan().FirstOrDefault(q => q.KodeJurusan == jur);
var angkatan = service.GetAngkatan().FirstOrDefault(q => q.KodeAngkatan == angk);
var j = jurusan?.KodeJurusan;
var a = angkatan?.KodeAngkatan;
if (j == jur && a == angk)
{
service.InsertMultiplePraktikan(praktikan);
}
service.Close();
Close();
}
catch (Exception error)
{
XtraMessageBox.Show(error.ToString());
XtraMessageBox.Show("Gagal import data mahasiswa.");
}
}
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 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();
}
}
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();
}
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();
}
public static string PostLogin(string username, string password)
{
try
{
IadmClient service = new IadmClient();
List <akun> data = new List <akun>();
akun user = new akun()
{
Username = username,
Password = password
};
string roles = service.GetLogin(user).TrimEnd();
service.Close();
return(roles);
}
catch (Exception)
{
throw;
}
}
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 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( );
}
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;
}
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();
}
}
}
