public AdminWin(CloudGameR_DBDataContext CGameR)
{
this.CGameR = CGameR;
taContactType = new ContactTypeDataSetTableAdapters.TipoContactoTableAdapter();
taUser = new UserDataSetTableAdapters.UtilizadorTableAdapter();
InitializeComponent();
}
public NewUser(CloudGameR_DBDataContext CGameR)
{
InitializeComponent();
this.CGameR = CGameR;
UserData = new UserDataSet();
taUser = new UserDataSetTableAdapters.UtilizadorTableAdapter();
taUserManager = new UserDataSetTableAdapters.TableAdapterManager();
CountryData = new CountryDataSet();
taPais = new CountryDataSetTableAdapters.PaisTableAdapter();
taManager = new CountryDataSetTableAdapters.TableAdapterManager();
usernameOk = false;
}
private void LoadSettings(string username)
{
try
{
var paises = from p in CGameR.Pais
select new
{
p.Nome,
p.Pais_ID,
};
this.cmbCountry.ItemsSource = paises.ToList();
var users = from u in CGameR.Utilizadors
where u.Username.ToLower() == username.ToLower()
select new
{
UserName = u.Username,
Name = u.Nome,
Address = u.Morada,
CountryID = u.Pais_ID,
Password = u.Pass,
};
if (users.Count() > 0)
{
var user = users.ToList()[0];
this.lblUserNick.Content = user.UserName;
this.lblUserName.Content = user.Name;
this.txtAddress.Text = user.Address;
this.cmbCountry.SelectedValue = user.CountryID;
this.txtCurrent.Password = user.Password;
}
CloudGameR.UserDataSetTableAdapters.UtilizadorTableAdapter taUser = new UserDataSetTableAdapters.UtilizadorTableAdapter();
var jogos = from jogo in CGameR.Jogos
where jogo.Nome == taUser.GetMostPlayedGameBy(username)
select new
{
Name = jogo.Nome,
Genre = jogo.Genero,
Picture = jogo.Capa_Endereco,
ReleaseDate = jogo.Data_Lancamento,
};
if (jogos.Count() > 0)
{
var jogo = jogos.ToList()[0];
this.grFavoriteGame.GameName = jogo.Name;
this.grFavoriteGame.GameGenre = jogo.Genre.Genero1;
this.grFavoriteGame.GamePicture = jogo.Picture;
this.grFavoriteGame.GameReleaseDate = jogo.ReleaseDate;
}
this.lblNumerOfGames.Content = taUser.GetNumGamesOf(username);
this.lblTotalHoursPlayed.Content = taUser.GetTotalHorasPlayedBy(username);
taUser.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString(), Title + " - Loading User Settings.", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
private new void Close()
{
UserData = null;
taUser = null;
taUserManager = null;
CountryData = null;
taPais = null;
taManager = null;
base.Close();
}
