private void Btndetail1_Click(object sender, EventArgs e)
{
var mess = MessageBox.Show("Pilih " + labelNama.Text, "Yakin?", MessageBoxButtons.YesNo);
if (mess == DialogResult.Yes)
{
kandidat kandidat = new kandidat();
kandidat = db.kandidats.Single(x => x.id == frmPilihan.id);
kandidat.Suara += 1;
db.SubmitChanges();
Pemilih pemil = new Pemilih();
pemil = db.Pemilihs.Single(x => x.id == loginPemilih.id_pemilih);
if (pemil.status == "belum")
{
pemil.status = lblkelas.Text;
db.SubmitChanges();
frmPilihan piliha = new frmPilihan();
piliha.Show();
this.Close();
}
else if (pemil.status == "10" || pemil.status == "11")
{
pemil.status = "sudah";
db.SubmitChanges();
loginPemilih login = new loginPemilih();
login.Show();
this.Close();
}
}
}
private void Button4_Click(object sender, EventArgs e)
{
Pemilih pemil = new Pemilih();
pemil = db.Pemilihs.Single(x => x.id == id);
db.Pemilihs.DeleteOnSubmit(pemil);
db.SubmitChanges();
loadAll();
}
private void Button2_Click(object sender, EventArgs e)
{
Random rnd = new Random();
string[] coupon = new string[1];
for (int i = 0; i < coupon.Length; i++)
{
coupon[i] = GenerateCoupon(10, rnd);
}
Console.WriteLine(String.Join(Environment.NewLine, coupon));
Pemilih pemil = new Pemilih();
pemil.kodePemilih = String.Join(Environment.NewLine, coupon);
pemil.status = "belum";
db.Pemilihs.InsertOnSubmit(pemil);
db.SubmitChanges();
loadAll();
}
private void FrmPilihan_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'pilketosDataSet1.kandidat' table. You can move, or remove it, as needed.
this.kandidatTableAdapter.Fill(this.pilketosDataSet1.kandidat);
kandidat kand = new kandidat();
panel4.Enabled = true;
panel5.Enabled = true;
Pemilih pemil = new Pemilih();
pemil = db.Pemilihs.Single(x => x.id == loginPemilih.id_pemilih);
if (pemil.status == "10")
{
panel5.Enabled = false;
}
else if (pemil.status == "11")
{
panel4.Enabled = false;
}
int j = 0, k = 0;
for (int i = 0; i < dataGridView1.RowCount; i++)
{
if (dataGridView1.Rows[i].Cells[6].Value.ToString() == "10")
{
id_kandidat_10[j] = Convert.ToInt32(dataGridView1.Rows[i].Cells[0].Value);
j++;
}
else if (dataGridView1.Rows[i].Cells[6].Value.ToString() == "11")
{
id_kandidat_11[k] = Convert.ToInt32(dataGridView1.Rows[i].Cells[0].Value);
k++;
}
}
if (id_kandidat_10[0] != 0)
{
kand = db.kandidats.Single(x => x.id == id_kandidat_10[0]);
labelNama1.Text = kand.Nama;
byte[] img = new byte[0];
img = kand.Foto.ToArray();
MemoryStream ms = new MemoryStream(img);
foto1.Image = Image.FromStream(ms);
}
if (id_kandidat_10[1] != 0)
{
kand = db.kandidats.Single(x => x.id == id_kandidat_10[id10_2 - 1]);
LabelNama2.Text = kand.Nama;
byte[] img = new byte[0];
img = kand.Foto.ToArray();
MemoryStream ms = new MemoryStream(img);
foto2.Image = Image.FromStream(ms);
}
if (id_kandidat_10[2] != 0)
{
kand = db.kandidats.Single(x => x.id == id_kandidat_10[id10_3 - 1]);
labelnama3.Text = kand.Nama;
byte[] img = new byte[0];
img = kand.Foto.ToArray();
MemoryStream ms = new MemoryStream(img);
Foto3.Image = Image.FromStream(ms);
}
if (id_kandidat_10[id10_4 - 1] != 0)
{
kand = db.kandidats.Single(x => x.id == id_kandidat_10[id10_4 - 1]);
labelnama4.Text = kand.Nama;
byte[] img = new byte[0];
img = kand.Foto.ToArray();
MemoryStream ms = new MemoryStream(img);
foto4.Image = Image.FromStream(ms);
}
if (id_kandidat_11[id11_1 - 1] != 0)
{
kand = db.kandidats.Single(x => x.id == id_kandidat_11[id11_1 - 1]);
labelnama5.Text = kand.Nama;
byte[] img = new byte[0];
img = kand.Foto.ToArray();
MemoryStream ms = new MemoryStream(img);
foto5.Image = Image.FromStream(ms);
}
if (id_kandidat_11[id11_2 - 1] != 0)
{
kand = db.kandidats.Single(x => x.id == id_kandidat_11[id11_2 - 1]);
labelnama6.Text = kand.Nama;
byte[] img = new byte[0];
img = kand.Foto.ToArray();
MemoryStream ms = new MemoryStream(img);
foto6.Image = Image.FromStream(ms);
}
if (id_kandidat_11[id11_3 - 1] != 0)
{
kand = db.kandidats.Single(x => x.id == id_kandidat_11[id11_3 - 1]);
labelnama7.Text = kand.Nama;
byte[] img = new byte[0];
img = kand.Foto.ToArray();
MemoryStream ms = new MemoryStream(img);
foto7.Image = Image.FromStream(ms);
}
if (id_kandidat_11[id11_4 - 1] != 0)
{
kand = db.kandidats.Single(x => x.id == id_kandidat_11[id11_4 - 1]);
labelnama8.Text = kand.Nama;
byte[] img = new byte[0];
img = kand.Foto.ToArray();
MemoryStream ms = new MemoryStream(img);
foto8.Image = Image.FromStream(ms);
}
}
partial void DeletePemilih(Pemilih instance);
partial void UpdatePemilih(Pemilih instance);
partial void InsertPemilih(Pemilih instance);