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 btnDaftar_Click(object sender, EventArgs e)
{
String jenkel;
if (tbKode.Text != lblKode.Text)
{
MessageBox.Show("Kode yang anda masukkan salah, silahkan coba lagi!");
return;
}
if (va.doValidation() == false)
{
return;
}
if (rbLaki.Checked == true)
{
jenkel = rbLaki.Text;
}
else
{
jenkel = rbPerempuan.Text;
}
cs = new tbl_CalonSiswa
{
no_pendaftaran = int.Parse(pk),
nama = tbNama.Text,
tgl_lahir = dtpTgllahir.Value,
alamat = rtbAlamat.Text,
email = tbEmail.Text,
jenis_kelamin = jenkel,
asal_sekolah = tbAsalsekolah.Text
};
tbl_Pilihan pl = new tbl_Pilihan
{
no_pendaftaran = int.Parse(pk),
prioritas1 = cbPrio1.SelectedValue.ToString(),
prioritas2 = cbPrio2.SelectedValue.ToString(),
prioritas3 = cbPrio3.SelectedValue.ToString()
};
db.tbl_CalonSiswas.InsertOnSubmit(cs);
db.SubmitChanges();
db.tbl_Pilihans.InsertOnSubmit(pl);
db.SubmitChanges();
this.Hide();
new RegistrationConfirmForm(cs.no_pendaftaran).Show();
}
private void btnLogin_Click(object sender, EventArgs e)
{
if (va.doValidation() == false)
{
return;
}
cs = db.tbl_CalonSiswas.FirstOrDefault(x => x.no_pendaftaran == int.Parse(tbUsername.Text) && x.password == tbPassword.Text);
st = db.tbl_Stafs.FirstOrDefault(x => x.nip == int.Parse(tbUsername.Text) && x.password == tbPassword.Text);
if (cs != null)
{
session.role = cbRole.Text;
var query = (from css in db.tbl_CalonSiswas
where css.no_pendaftaran == int.Parse(tbUsername.Text)
select css.nama).FirstOrDefault();
session.nama = query;
this.Hide();
new StudentNavigationForm().Show();
}
else if (st != null)
{
tu = db.tbl_Staf_Tus.FirstOrDefault(i => i.nip == int.Parse(tbUsername.Text));
gr = db.tbl_Gurus.FirstOrDefault(i => i.nip == int.Parse(tbUsername.Text));
if (tu != null)
{
session.role = "Staf - TU";
session.nama = tbUsername.Text;
}
else if (gr != null)
{
session.role = "Guru";
session.nama = tbUsername.Text;
}
else
{
lblError.Text = "Bukan " + cbRole.Text;
return;
}
this.Close();
new TeacherNavigationForm().Show();
}
else
{
lblError.Text = "Login Failed";
}
}
