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);
}
