public void PlayerRegister(string fullName, string userName, string password, decimal money, string sex, byte[] image) { using (var db = new PlayerEntities()) { var query = db.Players.Where(p => p.Username == userName); // if there aren't players with that username Any allows register if (!query.Any()) { var player = new Player { FullName = fullName, Username = userName, Password = password, Money = money, Sex = sex, Image = image }; db.Players.Add(player); db.SaveChanges(); } else { MessageBox.Show("This username is taken, choose another one!", "Oops!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } }
public Player GetCurrentPlayer() { using (var db = new PlayerEntities()) { Player player = db.Players.SingleOrDefault(p => p.Username == currentPlayerUsername); return(player); } }
public void PlayerDeleteAccount() { using (var db = new PlayerEntities()) { Player player = db.Players.SingleOrDefault(p => p.Username == currentPlayerUsername); db.Players.Remove(player); db.SaveChanges(); } }
public void PlayerPasswordChange(string password) { using (var db = new PlayerEntities()) { Player player = db.Players.SingleOrDefault(p => p.Username == currentPlayerUsername); player.Password = password; db.SaveChanges(); } }
public void PlayerMoney(decimal money, decimal loan) { using (var db = new PlayerEntities()) { var player = db.Players.SingleOrDefault(p => p.Username == currentPlayerUsername); player.Money = money; player.Loan = loan; db.SaveChanges(); } }
public MemoryStream ConvertByteToImage() { using (var db = new PlayerEntities()) { var player = db.Players.SingleOrDefault(p => p.Username == currentPlayerUsername); byte[] image = player.Image; var ms = new MemoryStream(image); return(ms); } }
private void FormRanglist_Load(object sender, EventArgs e) { using (var db = new PlayerEntities()) { var players = db.Players.OrderByDescending(p => p.Money).Take(10); foreach (var player in players) { lbHighScoreRanglist.Items.Add($"{player.Username} ---> {player.Money:C2}"); } } }
public void PlayerRestartAccount() { using (var db = new PlayerEntities()) { Player player = db.Players.SingleOrDefault(p => p.Username == currentPlayerUsername); player.Money = 0; player.Gold = 0; player.Petrol = 0; player.Bitcoin = 0; player.Antiques = 0; player.Shares = 0; player.Technologies = 0; db.SaveChanges(); } }
public IQueryable <Player> PlayerLogin(string userName, string password) { using (var db = new PlayerEntities()) { var query = db.Players.Where(p => p.Username == userName && p.Password == password); if (!query.Any()) { return(null); } else { currentPlayerUsername = userName; return(query); } } }
private void btnSaveGame_Click(object sender, EventArgs e) { using (var db = new PlayerEntities()) { var player = db.Players.SingleOrDefault(p => p.Username == PlayerManager.currentPlayerUsername); player.Money = decimal.Parse(lblMoneyGame.Text); player.Gold = long.Parse(lblGoldGame.Text); player.Petrol = long.Parse(lblPetrolGame.Text); player.Bitcoin = long.Parse(lblBitcoinGame.Text); player.Technologies = long.Parse(lblTechnologiesGame.Text); player.Antiques = long.Parse(lblAntiquesGame.Text); player.Shares = long.Parse(lblSharesGame.Text); db.SaveChanges(); FormGame.ActiveForm.Dispose(); FormProfile frmP = new FormProfile(); frmP.ShowDialog(); } }
public void PlayerImageChange(PictureBox pictureBox) { using (var db = new PlayerEntities()) { var player = db.Players.SingleOrDefault(p => p.Username == currentPlayerUsername); using (var dialog = new OpenFileDialog() { Filter = "PNG|*.png|JPG|*.jpg|GIF|*.gif", Title = "Please select a photo", Multiselect = false }) { if (dialog.ShowDialog() == DialogResult.OK) { pictureBox.ImageLocation = dialog.FileName; string imagePath = pictureBox.ImageLocation; byte[] image = ConvertImageToByte(imagePath); player.Image = image; db.SaveChanges(); } } } }