private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text != "" && textBox2.Text != "")
{
string squery = "SELECT * FROM voter WHERE uname = '" + textBox1.Text + "' AND pw = '" + textBox2.Text + "' ";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
msc = new MySqlCommand(squery, con);
mda.SelectCommand = msc;
mda.SelectCommand = msc;
DataTable dt1 = new DataTable();
mda.Fill(dt1);
if (dt1.Rows.Count == 1)
{
vid = Convert.ToInt32(dt1.Rows[0][0]);
eid = Convert.ToInt32(dt1.Rows[0][4]);
string str1 = "SELECT `voteid` FROM `vote` WHERE vid = '" + vid + "' AND eid = '" + eid + "'";
if (con.State == ConnectionState.Closed)
{
con.Open();
}
msc = new MySqlCommand(str1, con);
DataTable dt2 = new DataTable();
mda.SelectCommand = msc;
mda.Fill(dt2);
if (dt2.Rows.Count >= 1)
{
MessageBox.Show("You have already voted..");
textBox1.Text = "";
textBox2.Text = "";
}
else
{
MessageBox.Show("You can Vote..");
this.Hide();
var v = new Voting();
v.Closed += (s, args) => this.Close();
v.Show();
}
}
else
{
MessageBox.Show("Please Check your Username and Password");
}
con.Close();
msc.Parameters.Clear();
}
else
{
MessageBox.Show("Please fill all fields.");
}
}
private void AssignUsers(object sender, RoutedEventArgs e)
{
if (VotingsList.SelectedIndex != -1)
{
Voting Vote = AllVotings[VotingsList.SelectedIndex];
AssignedUsers window = new AssignedUsers(Vote.VoteNum);
window.Owner = Window.GetWindow(this);
window.ShowDialog();
if (!(window.result).Equals("true"))
{
System.Windows.MessageBox.Show("Error! " + window.result);
}
}
}
private void EditVoting(object sender, RoutedEventArgs e)
{
if (VotingsList.SelectedIndex != -1)
{
Voting Vote = AllVotings[VotingsList.SelectedIndex];
EditVoting window = new EditVoting(Vote);
window.Owner = Window.GetWindow(this);
window.ShowDialog();
if (!(window.result).Equals("true"))
{
System.Windows.MessageBox.Show("Error! " + window.result);
}
else
{
VotingsLoading(sender, e);
}
VotingsList.SelectedIndex = 0;
}
}
private void RemoveVoting(object sender, RoutedEventArgs e)
{
if (VotingsList.SelectedIndex != -1)
{
MessageBoxResult messageBoxResult = System.Windows.MessageBox.Show("Are you sure you want to delete this election?", null, System.Windows.MessageBoxButton.YesNo);
if (messageBoxResult == MessageBoxResult.Yes)
{
Voting Vote = AllVotings[VotingsList.SelectedIndex];
string answer = new Server().RemoveVoting(Vote.VoteNum);
if (!answer.Equals("true"))
{
System.Windows.MessageBox.Show("Error! " + answer);
}
else
{
VotingsLoading(sender, e);
}
VotingsList.SelectedIndex = 0;
}
}
}
private void VotingsListBox_Click(object sender, SelectionChangedEventArgs e)
{
if (VotingsList.SelectedIndex != -1)
{
GroupBox1.Visibility = Visibility.Visible;
GroupBox2.Visibility = Visibility.Hidden;
VotingInformation.IsSelected = true;
Voting Vote = FilteredVotings[VotingsList.SelectedIndex];
VotingTitle.Text = Vote.VoteName;
VotingDescript.Text = Vote.VoteDescription;
VotingStartDate.Text = Vote.Start.ToString("dd/MM/yyyy"); //yyyy-MM-dd
VotingFinishDate.Text = Vote.Finish.ToString("dd/MM/yyyy");
VotingStartTime.Text = " " + Vote.Start.Hour.ToString("D2") + " " + Vote.Start.Minute.ToString("D2"); // 08 05
VotingFinishTime.Text = " " + Vote.Finish.Hour.ToString("D2") + " " + Vote.Finish.Minute.ToString("D2");
if (Vote.AvailableVoting())
{
DeleteVoting.Visibility = Visibility.Hidden;
}
else
{
DeleteVoting.Visibility = Visibility.Visible;
}
if (Vote.FutureVoting())
{
EditVote.Visibility = Visibility.Visible;
EditAssignedUsers.Visibility = Visibility.Visible;
EditCustomers.Visibility = Visibility.Visible;
}
else
{
EditVote.Visibility = Visibility.Hidden;
EditAssignedUsers.Visibility = Visibility.Hidden;
EditCustomers.Visibility = Visibility.Hidden;
}
//showColumnChart(Vote.VoteNum);
// showCandidates(Vote.VoteNum);
if (AvailableVoting(Vote.Start, Vote.Finish))
{
VotingResults.IsEnabled = false;
Timer = Vote.Finish;
TimerLabel.Foreground = new SolidColorBrush(Colors.Green);
}
else if (!PastVoting(Vote.Finish))
{
VotingResults.IsEnabled = false;
Timer = Vote.Start;
TimerLabel.Foreground = new SolidColorBrush(Colors.LightBlue);
}
else
{
VotingResults.IsEnabled = true;
Timer = new DateTime(0);
TimerLabel.Foreground = new SolidColorBrush(Colors.Red);
}
DispatcherTimer dispatcher = new DispatcherTimer();
dispatcher.Tick += new EventHandler(dispatcherTick);
dispatcher.Interval = new TimeSpan(0, 0, 1);
dispatcher.Start();
showResults(Vote.VoteNum);
}
//else System.Windows.MessageBox.Show(Convert.ToString("Bad"));
}