public ActionResult Create([Bind(Include = "Id,Date,Winner,Loser,RefereePoints")] Battle battle) { if (ModelState.IsValid) { _db.Battles.Add(battle); _db.SaveChanges(); return(RedirectToAction("Index")); } return(View(battle)); }
public void AddStadium(string name, string address, string city) { using (context = new ChampionshipContext()) { Stadium stadium = context.Stadia .FirstOrDefault(s => s.Name == name && s.Address.Street == address && s.Address.City.Name == city); if (stadium == null) { stadium = new Stadium { Name = name }; City cityStadium = context.Cities.FirstOrDefault(c => c.Name == city); if (cityStadium == null) { cityStadium = new City { Name = city }; context.Cities.Add(cityStadium); } Address addressStadium = context.Addresses.FirstOrDefault(a => a.Street == address); if (addressStadium == null) { addressStadium = new Address { Street = address, City = cityStadium }; context.Addresses.Add(addressStadium); } stadium.Address = addressStadium; context.Stadia.Add(stadium); context.SaveChanges(); } } }
public void AddTeam(string name, int year, int numberPlayers, string cityFrom) { using (context = new ChampionshipContext()) { Team team = context.Teams .Where(t => t.Name == name && t.Year.Value == year && t.City.Name == cityFrom) .FirstOrDefault(); if (team == null) { team = new Team { Name = name, NumberPlayers = numberPlayers }; Year yearTeam = context.Years.FirstOrDefault(y => y.Value == year); if (yearTeam == null) { yearTeam = new Year { Value = year }; context.Years.Add(yearTeam); } City cityTeam = context.Cities.FirstOrDefault(c => c.Name == cityFrom); if (cityTeam == null) { cityTeam = new City { Name = cityFrom }; context.Cities.Add(cityTeam); } team.Year = yearTeam; team.City = cityTeam; context.Teams.Add(team); context.SaveChanges(); } } }
public void AddChampionship(string name, DateTime start, DateTime finish, string type) { using (context = new ChampionshipContext()) { Championship championship = context.Championships .FirstOrDefault(c => c.Name == name && c.StartDate == start && c.FinishDate == finish && c.Type.Name == type); if (championship == null) { championship = new Championship { Name = name, StartDate = start, FinishDate = finish }; Entities.Type typeCup = context.Types.FirstOrDefault(t => t.Name == type); if (typeCup == null) { typeCup = new Entities.Type { Name = type }; context.Types.Add(typeCup); } championship.Type = typeCup; context.Championships.Add(championship); context.SaveChanges(); } } }
public void AddScore(int idGame, string score) { using (context = new ChampionshipContext()) { Game game = context.Games.Find(idGame); game.Score = score; context.SaveChanges(); } }
static void Main(string[] args) { using (var ctx = new ChampionshipContext()) { Player player = new Player() { PlayerName = "Awesome Gamer", PlayerEnrollmentDate = DateTime.Now}; ctx.Player.Add(player); ctx.SaveChanges(); } }
public string Create([Bind(Exclude = "Id")] Battle obj) { string msg; try { if (ModelState.IsValid) { _db.Battles.Add(obj); _db.SaveChanges(); msg = "Saved Successfully"; } else { msg = "Validation data not successful"; } } catch (Exception ex) { msg = "Error occured:" + ex.Message; } return(msg); }
static void Main(string[] args) { using (var ctx = new ChampionshipContext()) { Player player = new Player() { FirstName = "Zlatan", LastName = "Ibrahimovic", Position = "Center", Technique = "Dribbler", Number = 10, PlayerEnrollmentDate = DateTime.Now }; ctx.Players.Add(player); ctx.SaveChanges(); } Console.WriteLine("User Added Complete"); Console.ReadLine(); }
public void SettleTeamToHotel(string teamName, int teamYear, string teamCity, string hotelName, string hotelAddress, string cityName) { using (context = new ChampionshipContext()) { Team team = context.Teams .FirstOrDefault(t => t.Name == teamName && t.Year.Value == teamYear && t.City.Name == teamCity); if (team != null) { Hotel hotel = context.Hotels.FirstOrDefault(h => h.Name == hotelName && h.Address.Street == hotelAddress); if (hotel == null) { hotel = new Hotel { Name = hotelName }; Address address = context.Addresses.FirstOrDefault(a => a.Street == hotelAddress); if (address == null) { address = new Address { Street = hotelAddress }; City city = context.Cities.FirstOrDefault(c => c.Name == cityName); if (city == null) { city = new City { Name = cityName }; context.Cities.Add(city); } address.City = city; context.Addresses.Add(address); } hotel.Address = address; context.Hotels.Add(hotel); } team.Hotel = hotel; context.SaveChanges(); } } }
public void AddGame(DateTime date, DateTime time, TimeSpan span, string teamsName1, string teamsName2, int teamsYear1, int teamsYear2, string teamsCity1, string teamsCity2, string stadiumName, string cupName) { using (context = new ChampionshipContext()) { Game game = context.Games .FirstOrDefault(g => g.Date == date && g.Time == time && g.FirstTeam.Name == teamsName1 && g.SecondTeam.Name == teamsName2); if (game == null) { game = new Game { Date = date, Time = time, Duration = span }; Stadium stadium = context.Stadia.FirstOrDefault(s => s.Name == stadiumName); Championship championship = context.Championships.FirstOrDefault(c => c.Name == cupName); Team firstTeam = context.Teams .FirstOrDefault(t => t.Name == teamsName1 && t.Year.Value == teamsYear1 && t.City.Name == teamsCity1); Team secondTeam = context.Teams .FirstOrDefault(t => t.Name == teamsName2 && t.Year.Value == teamsYear2 && t.City.Name == teamsCity2); if (stadium != null && championship != null && firstTeam != null && secondTeam != null) { bool isAvailableNumberFirstGame = firstTeam.FirstGames.Where(g => g.Date == date) .Union(firstTeam.SecondGames.Where(g => g.Date == date)) .Count() < 2; bool isAvailableNumberSecondGame = secondTeam.FirstGames.Where(g => g.Date == date) .Union(secondTeam.SecondGames.Where(g => g.Date == date)) .Count() < 2; if (isAvailableNumberFirstGame && isAvailableNumberSecondGame) { game.Stadium = stadium; game.Championship = championship; game.FirstTeam = firstTeam; game.SecondTeam = secondTeam; context.Games.Add(game); context.SaveChanges(); } } } } }