bool AddPlayer() { using (DbDestructorStore context = new DbDestructorStore()) { if (txtFullName != null && txtNick != null && txtPrice != null && !(context.Players.Any(p => p.FullName == txtFullName.Text))) { var player = new Player { FullName = txtFullName.Text, NickName = txtNick.Text, Price = Convert.ToDecimal(txtPrice.Text), RegisterationDate = DateTime.Now, IsActive = true }; context.Players.Add(player); return(context.SaveChanges() > 0); } else if (context.Players.Any(p => p.NickName == txtNick.Text)) { MessageBox.Show("Girdiğiniz Nick Kullanımda !! "); } else { MessageBox.Show("Tüm Alanları Doldurunuz !! "); } return(true); } }
bool AddGame() { using (DbDestructorStore context = new DbDestructorStore()) { var game = new Game { Name = txtName.Text, ListPrice = Convert.ToInt32(txtListPrice.Text), Quantity = Convert.ToInt32(txtQuantity.Text), StockDate = Convert.ToDateTime(dtStockDate.Value), IsActive = true }; context.Games.Add(game); return(context.SaveChanges() > 0); } }
bool Sale() { using (DbDestructorStore context = new DbDestructorStore()) { var gameId = Convert.ToInt32(cmbGame.SelectedValue); //Combodan Al var game = context.Games.First(g => g.GameId == gameId); //Db Den Getir var sale = new Sale { PlayerId = Convert.ToInt32(cmbPlayer.SelectedValue), GameId = game.GameId, Price = game.ListPrice, Quantity = Convert.ToInt32(txtQuantity.Text), SaleDate = DateTime.Now, IsActive = true }; context.Sales.Add(sale); return(context.SaveChanges() > 0); } }