public Boolean updateSuara(Entity.EntSuara e)
        {
            status = false;
            try
            {
                query = "UPDATE tb_suara SET suara_masuk = suara_masuk-1, waktu_suara = GETDATE() WHERE nomor_calon =" + e.GetNomor() + "\r\n" +
                        "IF EXISTS(SELECT 1 FROM tb_suara WHERE nomor_calon=" + e.GetNomor() + " AND suara_masuk < 1)\r\n" +
                        "DELETE from tb_suara WHERE nomor_calon =" + e.GetNomor();
                koneksi.Open();

                command             = koneksi.CreateCommand();
                command.CommandText = query;
                command.ExecuteNonQuery();
                status = true;
                koneksi.Close();
            }
            catch (SqlException ex)
            {
                Console.WriteLine("ERROR" + ex.Message);
            }
            return(status);
        }
        public Boolean tambahSuara(Entity.EntSuara e)
        {
            status = false;
            try
            {
                query = "IF NOT EXISTS(SELECT 1 FROM tb_suara WHERE nomor_calon=" + e.GetNomor() + ")\r\n" +
                        "INSERT INTO tb_suara VALUES ('" + e.GetNomor() + "', 1, GETDATE())"
                        + "\r\nELSE\r\n" +
                        "UPDATE tb_suara SET suara_masuk=suara_masuk+1, waktu_suara = GETDATE() WHERE nomor_calon=" + e.GetNomor();

                koneksi.Open();

                command = new SqlCommand(query, koneksi);
                command.ExecuteNonQuery();
                status = true;
                koneksi.Close();
            }
            catch (SqlException ex)
            {
                Console.WriteLine("ERROR" + ex.Message);
            }
            return(status);
        }