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 Btnhapus_Click(object sender, EventArgs e)
        {
            var mess = MessageBox.Show("Yakin hapus", "", MessageBoxButtons.YesNo);

            if (mess == DialogResult.Yes)
            {
                kandidat kand = new kandidat();
                kand = db.kandidats.Single(x => x.id == id);
                db.kandidats.DeleteOnSubmit(kand);
                db.SubmitChanges();
                loadAll();
            }
        }
 private void Btnedit_Click(object sender, EventArgs e)
 {
     if (txtNama.Text != "" && txtvisi.Text != "" && txtMisi.Text != "" && foto.Image != null && comboBox1.Text != "")
     {
         kandidat kand = new kandidat();
         kand       = db.kandidats.Single(x => x.id == id);
         kand.Kelas = comboBox1.Text;
         kand.Nama  = txtNama.Text;
         kand.Visi  = txtvisi.Text;
         kand.Misi  = txtMisi.Text;
         MemoryStream ms = new MemoryStream();
         foto.Image.Save(ms, foto.Image.RawFormat);
         byte[] img = ms.ToArray();
         kand.Foto = img;
         db.SubmitChanges();
         loadAll();
     }
 }
        private void HasilPemilihan_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();

            PanelMenu.Visible = false;
            PanelMenu.BringToFront();
            for (int i = 0; i < dataGridView1.RowCount; i++)
            {
                if (dataGridView1.Rows[i].Cells[6].Value.ToString() == "10")
                {
                    this.chart1.Series["Suara"].Points.AddXY(dataGridView1.Rows[i].Cells[1].Value.ToString(), Convert.ToInt32(dataGridView1.Rows[i].Cells[5].Value));
                }
                else if (dataGridView1.Rows[i].Cells[6].Value.ToString() == "11")
                {
                    this.chart2.Series["Suara"].Points.AddXY(dataGridView1.Rows[i].Cells[1].Value.ToString(), Convert.ToInt32(dataGridView1.Rows[i].Cells[5].Value));
                }
            }
        }
Example #5
0
        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 Deletekandidat(kandidat instance);
 partial void Updatekandidat(kandidat instance);
 partial void Insertkandidat(kandidat instance);