private void RegistrationConfirmForm_Load(object sender, EventArgs e)
{
var query = (from cs in db.tbl_CalonSiswas
join p in db.tbl_Pilihans
on cs.no_pendaftaran equals p.no_pendaftaran
where cs.no_pendaftaran == no
select new { cs, p }).FirstOrDefault();
lblNoPendaftar.Text = query.cs.no_pendaftaran.ToString();
lblNamaPendaftar.Text = query.cs.nama;
var prio = (from pil in db.tbl_Pilihans
where pil.no_pendaftaran == int.Parse(lblNoPendaftar.Text)
select pil).FirstOrDefault();
var prio1 = (from jr in db.tbl_Jurusans
where jr.kode_jurusan == int.Parse(prio.prioritas1)
select jr.nama_jurusan).FirstOrDefault();
var prio2 = (from jr in db.tbl_Jurusans
where jr.kode_jurusan == int.Parse(prio.prioritas2)
select jr.nama_jurusan).FirstOrDefault();
var prio3 = (from jr in db.tbl_Jurusans
where jr.kode_jurusan == int.Parse(prio.prioritas3)
select jr.nama_jurusan).FirstOrDefault();
lblPrioritas1.Text = prio1;
lblPrioritas2.Text = prio2;
lblPrioritas3.Text = prio3;
lblUsername.Text = query.cs.no_pendaftaran.ToString();
va.getRandom(8, lblPassword);
tbl_CalonSiswa q = db.tbl_CalonSiswas.FirstOrDefault(x => x.no_pendaftaran == int.Parse(lblUsername.Text));
q.password = lblPassword.Text;
db.SubmitChanges();
}
private void PendaftaranForm_Load(object sender, EventArgs e)
{
btnDaftar.Enabled = false;
data(cbPrio1);
data(cbPrio2);
data(cbPrio3);
va.getRandom(10, lblKode);
va.getRandomInt(8);
pk = va.pk;
var query = from cs in db.tbl_CalonSiswas
where cs.no_pendaftaran == int.Parse(pk)
select cs.no_pendaftaran;
}
