//QUANDO ESCOLHER OPÇÃO COMBOBOX
private void comboBox_DropDownClosed(object sender, EventArgs e)
{
//pega o nome selecionado
string nome = comboBox.SelectedItem.ToString();
MySqlDataReader usuario = userDal.Select();
while (usuario.Read())
{
if ((Convert.ToString(usuario["username"]) == nome))
{
score.IdUser = Convert.ToInt32(usuario["idUser"]);
//image.Source = (BitmapImage)Application.Current.FindResource("fundo2.jpg");
//image.Source = (BitmapImage)Application.Current.Resources["C:/Users/House/Documents/Visual Studio 2015/Projects/JogoPalavras 3 -funcionando/View/fundo2.jpg"];
//image.Source = new BitmapImage(new Uri("pack://application:/Images/Tiles/fundo2.jpg"));
if (score.IdUser == 1)
{
var uri = new Uri("pack://application:,,,/Diego.jpg");
var bitmap = new BitmapImage(uri);
image.Source = bitmap;
}
else if (score.IdUser == 2)
{
var uri = new Uri("pack://application:,,,/Renata.jpg");
var bitmap = new BitmapImage(uri);
image.Source = bitmap;
}
else if (score.IdUser == 3)
{
var uri = new Uri("pack://application:,,,/Silvio.jpg");
var bitmap = new BitmapImage(uri);
image.Source = bitmap;
}
else
{
var uri = new Uri("pack://application:,,,/interrogacao.jpg");
var bitmap = new BitmapImage(uri);
image.Source = bitmap;
}
}
}
/*
* MySqlDataReader ponto = scoreDal.Select(score);
* while (ponto.Read())
* {
* txtPontos.Text = Convert.ToString(ponto["score"]);
* }
*/
int ponto = scoreDal.SelectPontos(score);
txtPontos.Text = Convert.ToString(ponto);
}
public void pontuacao()
{
UserDal userDal = new UserDal();
ScoresDal scoreDal = new ScoresDal();
ScoresInformation score = new ScoresInformation();
//busca usuário pelo nome
MySqlDataReader usuario = userDal.Select();
while (usuario.Read())
{
if ((Convert.ToString(usuario["username"]) == this.usuario))
{
score.IdUser = Convert.ToInt32(usuario["idUser"]);
}
}
//busca ponto pelo id
int ponto = scoreDal.SelectPontos(score);
//busca ponto da média
int pontoMedia = scoreDal.SelectPontosMedia(score);
//tamanho da progressbar dinammico
if (pontoMedia >= ponto)
{
pbMedia.Maximum = pontoMedia * 1.30;
pbUsuario.Maximum = pontoMedia * 1.30;
}
else
{
pbMedia.Maximum = ponto * 1.30;
pbUsuario.Maximum = ponto * 1.30;
}
//animação da progressbar
txtPontoUsuario.Text = Convert.ToString(ponto);
txtUsuario.Text = this.usuario;
Duration dur = new Duration(TimeSpan.FromSeconds(10));
DoubleAnimation ani = new DoubleAnimation(ponto, dur);
pbUsuario.BeginAnimation(ProgressBar.ValueProperty, ani);
//animação da progressbar
txtPontoMedia.Text = Convert.ToString(pontoMedia);
Duration durMedia = new Duration(TimeSpan.FromSeconds(10));
DoubleAnimation aniMedia = new DoubleAnimation(pontoMedia, durMedia);
pbMedia.BeginAnimation(ProgressBar.ValueProperty, aniMedia);
}
private void loadProgressbar()
{
ScoresInformation user = new ScoresInformation();
//user.IdUser = idUser;
ScoresDal scoreDal = new ScoresDal();
/*
* MySqlDataReader pontos = score.Select();
*
* int i = 0;
* int[] valor = new int[3];
* while (pontos.Read())
* {
* valor[i] = Convert.ToInt32(pontos["score"]);
* i++;
* }
*/
int i = 0;
int[] valor = new int[3];
for (i = 0; i < 3; i++)
{
user.IdUser = i + 1;
valor[i] = scoreDal.SelectPontos(user);
}
Duration dur = new Duration(TimeSpan.FromSeconds(10));
DoubleAnimation ani = new DoubleAnimation(valor[0], dur);
pb1.BeginAnimation(ProgressBar.ValueProperty, ani);
Duration dur2 = new Duration(TimeSpan.FromSeconds(10));
DoubleAnimation ani2 = new DoubleAnimation(valor[1], dur2);
pb2.BeginAnimation(ProgressBar.ValueProperty, ani2);
Duration dur3 = new Duration(TimeSpan.FromSeconds(10));
DoubleAnimation ani3 = new DoubleAnimation(valor[2], dur3);
pb3.BeginAnimation(ProgressBar.ValueProperty, ani3);
lbl1.Content = valor[0];
lbl2.Content = valor[1];
lbl3.Content = valor[2];
//IMAGENS
var uri = new Uri("pack://application:,,,/Diego.jpg");
var bitmap = new BitmapImage(uri);
image1.Source = bitmap;
var uri2 = new Uri("pack://application:,,,/Silvio.jpg");
var bitmap2 = new BitmapImage(uri2);
image2.Source = bitmap2;
var uri3 = new Uri("pack://application:,,,/Renata.jpg");
var bitmap3 = new BitmapImage(uri3);
image3.Source = bitmap3;
}