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