bool BuyGame(Sale sales) { using (DbSaleStore salecontext = new DbSaleStore()) { var player = salecontext.Players.Where(p => p.IsActive == true).First(); var game = salecontext.Games.Where(g => g.GameName == cboGame.SelectedItem.ToString()).First(); if (player.PlayerAccount >= game.GamePrice) { sales = new Sale() { GameId = game.GameId, PlayerId = player.PlayerId, BuyMoney = game.GamePrice }; var updatecontext = salecontext.Players.Where(p => p.IsActive == true).First(); updatecontext.PlayerAccount = player.PlayerAccount - game.GamePrice; salecontext.SaveChanges(); } else { lblBuyReport.Text = "Bu Oyun İçin Yeterli Paranız Yoktur! "; } } return(true); }
void ShowGame() { using (DbSaleStore salecontext = new DbSaleStore()) { dvgShowGame.DataSource = null; dvgShowGame.DataSource = salecontext.Games.Select(g => new { GameId = g.GameId, GameName = g.GameName, GamePrice = g.GamePrice }).ToList(); } }
void GetGame() { using (DbSaleStore salecontext = new DbSaleStore()) { cboGame.DataSource = salecontext.Games.ToList(); cboGame.DisplayMember = "GameName"; cboGame.ValueMember = "GameId"; } }
protected override void OnFormClosing(FormClosingEventArgs e) { using (DbSaleStore salecontext = new DbSaleStore()) { var updatecontext = salecontext.Players.First(p => p.IsActive == true); updatecontext.IsActive = false; salecontext.SaveChanges(); } }
void AddGame(Game games) { using (DbSaleStore salecontext = new DbSaleStore()) { if (salecontext.Games.Any(g => g.GameName == txtAddGameName.Text)) { MessageBox.Show("Bu oyun zaten var !", "Uyarı "); } else { salecontext.Games.Add(games); salecontext.SaveChanges(); } } }
private void btnRegisterPlayer_Click(object sender, EventArgs e) { Player playerlist = new Player() { PlayerName = txtRegisterName.Text, PlayerMail = txtRegisterMail.Text, Password = txtRegisterPassword.Text, PlayerAccount = Convert.ToDecimal(txtRegisterCoin.Text), RegistrationDate = DateTime.Now, IsActive = true }; using (DbSaleStore salecontext = new DbSaleStore()) { salecontext.Players.Add(playerlist); salecontext.SaveChanges(); } }
void ShowPlayer() { using (DbSaleStore salecontext = new DbSaleStore()) { dgvShowPlayer.DataSource = null; dgvShowPlayer.DataSource = salecontext.Players.Select(p => new { OyuncuNo = p.PlayerId, İsmi = p.PlayerName, KayıtTarihi = p.RegistrationDate, Hesabı = p.PlayerAccount }).ToList(); dgvShowPlayer.Columns[0].HeaderText = "No"; dgvShowPlayer.Columns[1].HeaderText = "İsim"; dgvShowPlayer.Columns[2].HeaderText = "Kayıt Tarihi"; dgvShowPlayer.Columns[3].HeaderText = "Bakiye"; } }
void SortbyPrice() { dgvGamePrice.DataSource = null; using (DbSaleStore salecontext = new DbSaleStore()) { if (cbSortCondition.SelectedItem.ToString() == "Ucuz") { dgvGamePrice.DataSource = salecontext.Games.Select(g => new { GamePrice = g.GamePrice, GameName = g.GameName }).OrderBy(g => g.GamePrice).ToList(); } else { dgvGamePrice.DataSource = salecontext.Games.Select(g => new { GamePrice = g.GamePrice, GameName = g.GameName }).OrderByDescending(g => g.GamePrice).ToList(); } } dgvGamePrice.Columns[0].HeaderText = "Fiyat"; dgvGamePrice.Columns[1].HeaderText = "Oyun"; }
bool PlayerControl() { using (DbSaleStore salecontext = new DbSaleStore()) { if (salecontext.Players.Any(p => p.PlayerName == txtLoginName.Text) && salecontext.Players.Any(p => p.Password == txtLoginPassword.Text)) { var updatingcontext = salecontext.Players.First(p => p.PlayerName == txtLoginName.Text); updatingcontext.IsActive = true; txtLoginName.Text = string.Empty; txtLoginPassword.Text = string.Empty; salecontext.SaveChanges(); MessageBox.Show("Hesabınıza başarılı şekilde bağlandınız ."); frmPlayer formplayer = new frmPlayer(); formplayer.ShowDialog(); } else if (AdminControl()) { frmAdmin formadmin = new frmAdmin(); MessageBox.Show("Yönetici Girişi Yaptınız ! "); formadmin.ShowDialog(); txtLoginName.Text = string.Empty; txtLoginPassword.Text = string.Empty; } else { MessageBox.Show("Kullanıcı Adı veya Şifre Hatalı! "); txtLoginName.Text = string.Empty; txtLoginPassword.Text = string.Empty; } } return(true); }