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