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