public AdminController(BettingContext context) { _matchRepository = new MatchRepository(context); _teamRepository = new TeamRepository(context); _sportRepository = new SportRepository(context); _ticketRepository = new TicketRepository(context); }
public async Task <IActionResult> PostAsync([FromBody] Sport sport) { var sportRep = new SportRepository(_db); var result = await sportRep.SaveSport(sport); return(NoContent()); }
private void PopulateEventComboBox() { SqlCeConnection Connection = DataBaseConnection.Instance.Connection; EventViewComboBox.Items.Clear(); SqlCeCommand cmd = Connection.CreateCommand(); cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT * FROM Event"; cmd.ExecuteNonQuery(); DataTable dt = new DataTable(); SqlCeDataAdapter da = new SqlCeDataAdapter(cmd); da.Fill(dt); foreach (DataRow dr in dt.Rows) { int team1 = Int16.Parse(dr["Team_Id"].ToString()); int team2 = Int16.Parse(dr["Team_Id1"].ToString()); int game1 = Int16.Parse(dr["Game_type_Id"].ToString()); int sport1 = Int16.Parse(dr["Sport_Id"].ToString()); int leage1 = Int16.Parse(dr["League_Id"].ToString()); string team11 = TeamRepository.GetTeamNameById(team1); string team22 = TeamRepository.GetTeamNameById(team2); string game11 = GameTypeRepository.GetGameTypeMarkById(game1); string sport11 = SportRepository.GetSportNameById(sport1); string league11 = LeagueRepository.GetLeagueNameById(leage1); EventViewComboBox.Items.Add(sport11 + " - " + league11 + " - " + team11 + " - " + team22 + " - " + dr["Time"].ToString() + " - " + game11 + " - " + dr["Quota"].ToString() + "KM "); } EventViewComboBox.SelectedIndex = 0; }
public TeamManagerController( SportRepository sportRepository, TeamRepository teamRepository, AthleteRepository athleteRepository) { this.sportRepository = sportRepository; this.teamRepository = teamRepository; this.athleteRepository = athleteRepository; }
public void TestInit() { contextFactory = GetContextFactory(); repo = new SportRepository(contextFactory); boca = CreateBocaTeam(); river = CreateTeamThatBelongsInTheB(); futbol = CreateFutbolTeam(); rugby = CreateRugbyTeam(); repo.Add(futbol); repo.Add(rugby); }
private void SaveButton_Click(object sender, EventArgs e) { if (NameSportTextBox.Text == "") { MessageBox.Show("Unesite vrstu sport!!!"); } else { string text = NameSportTextBox.Text; SportRepository.AddSport(text); } }
public async void DoesSportExist_addSportReturnFalse() { var sport = SportGenerator.Create(); using (var context = new booking_facilitiesContext(contextOptions)) { context.Database.EnsureCreated(); var repository = new SportRepository(context); await repository.AddAsync(sport); Assert.False(repository.DoesSportExist(sport.SportName + ' ')); } }
public async void SportIdExists_ReturnTrue() { var sport = SportGenerator.Create(); using (var context = new booking_facilitiesContext(contextOptions)) { context.Database.EnsureCreated(); var repository = new SportRepository(context); await repository.AddAsync(sport); Assert.True(repository.SportIdExists(sport.SportId)); } }
public WebPortalUnitOfWork(DbConnectionString webPortalConnectionString) { Dapper.DefaultTypeMap.MatchNamesWithUnderscores = true; _webPortalConnectionString = webPortalConnectionString; MatchRepository = new MatchRepository(_webPortalConnectionString); SportRepository = new SportRepository(_webPortalConnectionString); TeamRepository = new TeamRepository(_webPortalConnectionString); PlayerRepository = new PlayerRepository(_webPortalConnectionString); ScrapingInformationRepository = new ScrapingInformationRepository(_webPortalConnectionString); ProviderRepository = new ProviderRepository(_webPortalConnectionString); PlayerOverUnderRepository = new PlayerOverUnderRepository(_webPortalConnectionString); PlayerHeadToHeadRepository = new PlayerHeadToHeadRepository(_webPortalConnectionString); TempTableToTestRepository = new TempTableToTestRepository(_webPortalConnectionString); }
public async void AddAsync_AddAsyncToConext() { var sport = SportGenerator.Create(); using (var context = new booking_facilitiesContext(contextOptions)) { context.Database.EnsureCreated(); var repository = new SportRepository(context); await repository.AddAsync(sport); Assert.Equal(1, await context.Sport.CountAsync()); Assert.Equal(sport, await context.Sport.SingleAsync()); } }
private void SaveButton_Click(object sender, EventArgs e) { SqlCeConnection Connection = DataBaseConnection.Instance.Connection; try { if (QuotaTextBox.Text == "") { MessageBox.Show("Uneste iznos kvote!"); } else if (EventDateTimePicker.Text == "") { MessageBox.Show("Unesite vrijeme dogadjaja!"); } else { int SportID = SportRepository.GetIdByNameSport(SportIDComboBox.Text); int TeamID = TeamRepository.GetIdByNameTeam(TeamIDComboBox.Text); int LeagueID = LeagueRepository.GetIdByNameLeague(LeagueIDComboBox.Text); int GameTypeID = GameTypeRepository.GetIdByNameGameType(GameTypeIDComboBox.Text); int TeamID1 = TeamRepository.GetIdByNameTeam(TeamID1ComboBox.Text); SqlCeCommand command1 = new SqlCeCommand("INSERT INTO Event (Sport_Id, Team_Id, Time, League_Id, Game_type_Id, Quota, Team_Id1) VALUES" + " ('" + SportID + "', '" + TeamID + "', '" + EventDateTimePicker.Value.Date.ToString("yyyy-MM-dd") + "', '" + LeagueID + "', '" + GameTypeID + "', '" + QuotaTextBox.Text + "', '" + TeamID1 + "'); ", Connection); /*SqlCeCommand command1 = new SqlCeCommand(@"INSERT INTO Event (Sport_Id, Team_Id, Time, League_Id, Game_type_Id, Quota, Team_Id1) VALUES (@sportId, @teamId, @time, @leagueId, @gameTypeId, @quota, @teamId1)", Connection); * command1.Parameters.AddWithValue("@sportId", SportID); * command1.Parameters.AddWithValue("@teamId", TeamID); * command1.Parameters.AddWithValue("@time", DateTime.Now.Date.ToString()); * command1.Parameters.AddWithValue("@leagueId", LeagueID); * command1.Parameters.AddWithValue("@gameTypeId", GameTypeID); * command1.Parameters.AddWithValue("@quota", QuotaTextBox.Text); * command1.Parameters.AddWithValue("@teamId1", TeamID1);*/ command1.ExecuteNonQuery(); MessageBox.Show("Unos je uspio!"); QuotaTextBox.Clear(); QuotaTextBox.Focus(); } } catch (Exception ex) { MessageBox.Show("Unos nije uspio! \r Greska: " + ex.Message); return; } }
public async Task <Sport> UpdateAsync(int id, Sport Sport) { SportRepository sportRepository = new SportRepository(_db); var results = await sportRepository.UpdateSport(Sport); if (results > 0) { Message = "Sport successfully updated"; } else { Message = "Something went wrong"; } return(Sport); }
public async void GetAllAsync_ReturnsAllFromContext() { var expectedSports = SportGenerator.CreateList(); using (var context = new booking_facilitiesContext(contextOptions)) { context.Database.EnsureCreated(); context.Sport.AddRange(expectedSports); context.SaveChanges(); Assert.Equal(expectedSports.Count, await context.Sport.CountAsync()); var repository = new SportRepository(context); var resources = repository.GetAllAsync(); Assert.IsAssignableFrom <IQueryable <Sport> >(resources); Assert.Equal(expectedSports, resources); } }
internal static void StatisticsForEachSport() //KLART { var cRep = new SportRepository(); var stats = cRep.SportStatisticsAsync(); var mRep = new ContestantRepository(); var stat = mRep.GetAllAsync(); var totalContestants = 0; foreach (var x in stats.Result) { int contestants = x.Contestants.Count; totalContestants += contestants; } Console.WriteLine("Statistics for each Sport: \n"); foreach (var y in stats.Result) { int male = 0; int female = 0; int sportid = y.Id; int x = y.Contestants.Count; int contests = y.Contests.Count(); int match = 0; double percent = x * 100 / totalContestants; foreach (var z in stat.Result.Where(s => s.Gender.StartsWith("male") && s.SportId == sportid)) { male = z.FirstName.Count(); } foreach (var z in stat.Result.Where(s => s.Gender.StartsWith("female") && s.SportId == sportid)) { female = z.FirstName.Count(); } foreach (var z in stat.Result.Where(s => s.SportId == sportid)) { match = z.Matches.Count(); } Console.WriteLine("{0} has {1} % of the participants", y.SportName, percent); Console.WriteLine("{0} has {1} male and {2} female contestants. ", y.SportName, male, female); Console.WriteLine("{0} has {1} contests. ", y.SportName, contests); Console.WriteLine("{0} has {1} scheduled matches.\n ", y.SportName, match); } }
private void DeleteSportButton_Click(object sender, EventArgs e) { SqlCeConnection Connection = DataBaseConnection.Instance.Connection; DialogResult dr = MessageBox.Show("Da li želite da izbrišete ?", "Brisanje", MessageBoxButtons.YesNo, MessageBoxIcon.Warning); if (dr == DialogResult.Yes) { string name = SportViewComboBox.SelectedItem.ToString(); SportRepository.DeleteDataSport(name); SportViewComboBox.Items.Remove(SportViewComboBox.SelectedItem); } else if (dr == DialogResult.No) { } }
public async void DeleteAsync_DeleteFromContext() { var sport = SportGenerator.Create(); using (var context = new booking_facilitiesContext(contextOptions)) { var repository = new SportRepository(context); context.Database.EnsureCreated(); context.Sport.Add(sport); context.SaveChanges(); Assert.Equal(1, await context.Sport.CountAsync()); await repository.DeleteAsync(sport); Assert.Equal(0, await context.Sport.CountAsync()); } }
public async void UpdateAsync_UpdatesInContext() { var sport = SportGenerator.Create(); using (var context = new booking_facilitiesContext(contextOptions)) { context.Database.EnsureCreated(); context.Sport.Add(sport); context.SaveChanges(); var repository = new SportRepository(context); var newSport = await repository.GetByIdAsync(sport.SportId); newSport.SportName = "Hockey"; await repository.UpdateAsync(newSport); Assert.Equal(1, await context.Sport.CountAsync()); Assert.Equal(newSport, await context.Sport.SingleAsync()); } }
public async void GetByIdAsync_ReturnsCorrectItems() { var list = SportGenerator.CreateList(5); var expected = list[2]; using (var context = new booking_facilitiesContext(contextOptions)) { context.Database.EnsureCreated(); context.Sport.AddRange(list); await context.SaveChangesAsync(); Assert.True(true); Assert.Equal(list.Count, await context.Sport.CountAsync()); var repository = new SportRepository(context); var sport = await repository.GetByIdAsync(expected.SportId); Assert.IsType <Sport>(sport); Assert.Equal(expected, sport); } }
public void ShouldGetAllSports() { var options = new DbContextOptionsBuilder <ASMembershipContext>() .UseInMemoryDatabase("ShouldGetAllSports") .Options; var sports = GetTestSports(); using (var context = new ASMembershipContext(options)) { context.Sports.AddRange(sports); context.SaveChanges(); } using (var context = new ASMembershipContext(options)) { var sportRepository = new SportRepository(context); var result = sportRepository.GetAll(); Assert.Equal(sports.Count, result.Count); } }
public MatchesController(BettingContext context) { _matchRepository = new MatchRepository(context); _sportRepository = new SportRepository(context); }
public AthleteController(AthleteRepository athleteRepository, SportRepository sportRepository) { _athleteRepository = athleteRepository; _sportRepository = sportRepository; }
public void Delete(int id) { var SportRep = new SportRepository(_db); var Result = SportRep.DeleteSport(id); }
// Lägger till Basic data samt till one to many tabeller. // För övrigt gäller samma kommentarer som till metoden under. internal static void AddBasicData(string olympicModel, string contestantFirstName, string contestantLastName, int age, string gender, string country, string sport, string contestName, string refereeName) //KLAR { int sportID = 0; int countryID = 0; int contestID = 0; int refereeID = 0; int contestantID = 0; var conRep = new ContestantRepository(); var conId = conRep.FindBy(m => m.FirstName.Equals(contestantFirstName) && m.LastName.Equals(contestantLastName)); foreach (var c in conId) { contestantID = c.Id; } var cRep = new CountryRepository(); var cId = cRep.FindBy(m => m.CountryName.StartsWith(country)); foreach (var c in cId) { countryID = c.Id; } var sRep = new SportRepository(); var sId = sRep.FindBy(m => m.SportName.Equals(sport)); foreach (var c in sId) { sportID = c.Id; } var coRep = new ContestRepository(); var coId = coRep.FindBy(m => m.ContestName.Equals(contestName)); foreach (var c in coId) { contestID = c.Id; } var reRep = new RefereeRepository(); var reId = reRep.FindBy(m => m.Name.Equals(refereeName)); foreach (var c in reId) { refereeID = c.Id; } try { if (olympicModel == "Country" && countryID == 0) { var addCountry = new CountryRepository(); addCountry.Add(new Country { CountryName = country }); addCountry.Save(); } } catch { Console.WriteLine("{0} already exists in db.", olympicModel); } try { if (olympicModel == "Sport" && sportID == 0) { var addSport = new SportRepository(); addSport.Add(new Sport { SportName = sport }); addSport.Save(); } } catch { Console.WriteLine("{0} already exists in db.", olympicModel); } try { if (olympicModel == "Contest" && contestID == 0 && sportID != 0) { var addContest = new ContestRepository(); addContest.Add(new Contest { ContestName = contestName, SportId = sportID }); addContest.Save(); } else if (olympicModel == "Contest" && contestID != 0) { Console.WriteLine("{0} already exists in db.", olympicModel); } } catch { Console.WriteLine("{0} is not added yet. You have to register OlympicModel: {1}, first.", olympicModel, sport); } try { if (olympicModel == "Contestant" && contestantID == 0 && sportID != 0 && countryID != 0) { var addContestant = new ContestantRepository(); addContestant.Add(new Contestant { FirstName = contestantFirstName, LastName = contestantLastName, Age = age, CountryId = countryID, Gender = gender, SportId = sportID }); addContestant.Save(); } else if (olympicModel == "Contestant" && contestantID != 0) { Console.WriteLine("{0} already exists in db.", olympicModel); } } catch { Console.WriteLine("This sport or country is not added yet. Select OlympicModel: Sport/Country, first."); } try { if (olympicModel == "Referee" && refereeID == 0 && countryID != 0) { var addReferee = new RefereeRepository(); addReferee.Add(new Referee { Name = refereeName, CountryId = countryID }); addReferee.Save(); Console.WriteLine("Data is now added!"); } } catch { Console.WriteLine("This country is not added yet. Select OlympicModel: Country, first."); Console.ReadKey(); } if (olympicModel == "Match") { Console.WriteLine("This method doesen't work for many to many. Select AddManyToMany(), instead."); } }
public SportController() { _sportRepository = new SportRepository(); }
public SportController(SportRepository sportRepository) { _sportRepository = sportRepository; }
public SportController(SportRepository repository) { this.repository = repository; }
//Tar bort ett id och dess barn. Förutom i två tabeller, där jag gjorde fel i migreringen och inte lyckades rätta till det. // Se kommentarer på rad 81 i OlympicContext. internal static void DeleteBasicData(string olympicModel, string contestantFirstName, string contestantLastName, string country, string sport, string contestName, string refereeName) { var mRep = new MatchRepository(); if (olympicModel == "Country") { try // Denna nödlösning för jag misslyckades att ändra Restict till Cascade i min sista migration. { var cRep = new CountryRepository(); var co = cRep.FindBy(c => c.CountryName == country); cRep.DeleteRange(co); cRep.Save(); return; } catch { var match = mRep.FindBy(m => m.Contestant.Country.CountryName.Equals(country)); foreach (var x in match) { Console.WriteLine("Match with keyvaluepairs: " + x.ContestId + " - " + x.ContestantId + " has to be deleted first."); } return; } } if (olympicModel == "Sport") { var cRep = new SportRepository(); var co = cRep.FindBy(c => c.SportName == sport); cRep.DeleteRange(co); cRep.Save(); return; } if (olympicModel == "Referee") { var cRep = new RefereeRepository(); var co = cRep.FindBy(c => c.Name == refereeName); cRep.DeleteRange(co); cRep.Save(); return; } if (olympicModel == "Contest") { var cRep = new ContestRepository(); var co = cRep.FindBy(c => c.ContestName == contestName); cRep.DeleteRange(co); cRep.Save(); return; } if (olympicModel == "Contestant") { try // Denna nödlösning för jag misslyckades att ändra Restict till Cascade i min sista migration. (Tror jag i alla fall) { var cRep = new ContestantRepository(); var co = cRep.FindBy(c => c.FirstName == contestantFirstName && c.LastName == contestantLastName); cRep.DeleteRange(co); cRep.Save(); return; } catch { var match = mRep.FindBy(m => m.Contestant.FirstName.Equals(contestantFirstName) && m.Contestant.LastName.Equals(contestantLastName)); foreach (var x in match) { Console.WriteLine("Match with keyvaluepairs: " + x.ContestId + " - " + x.ContestantId + " has to be deleted first."); } return; } } else { System.Console.WriteLine("{0} does not exist in database.", olympicModel); } }
//Uppdaterar data i grundtabeller och one to many. Använder consolen i brist på web. internal static void UpdateBasicData(string parameter) //KLAR { var spRep = new SportRepository(); var alls = spRep.GetAll(); var coRep = new CountryRepository(); var allc = coRep.GetAll(); if (parameter == "Contestant") { var mRep = new ContestantRepository(); var all = mRep.GetAll(); foreach (var x in all) { Console.WriteLine("Id " + x.Id + ":\t" + "FirstName: " + x.FirstName + "\t" + "LastName: " + x.LastName + "\t" + "Age " + x.Age + "\t" + "Gender " + x.Gender + "\t" + "CountryId " + x.CountryId + "\t" + "SportId " + x.SportId); } int id = UpdateId(); var change = mRep.FindBy(m => m.Id.Equals(id)); foreach (var x in change) { Console.Write("Enter new FirstName: "); x.FirstName = Console.ReadLine(); Console.Write("Enter new LastName: "); x.LastName = Console.ReadLine(); Console.Write("Enter new Age: "); x.Age = int.Parse(Console.ReadLine()); Console.Write("Enter new Gender (male/female): "); x.Gender = Console.ReadLine(); foreach (var y in allc) { Console.WriteLine(y.Id + " = " + y.CountryName); } Console.Write("Enter new CountryId: "); x.CountryId = int.Parse(Console.ReadLine()); foreach (var y in alls) { Console.WriteLine(y.Id + " = " + y.SportName); } Console.Write("Enter new SportId: "); x.SportId = int.Parse(Console.ReadLine()); mRep.Update(x); mRep.Save(); } } if (parameter == "Contest") { var mRep = new ContestRepository(); var all = mRep.GetAll(); foreach (var x in all) { Console.WriteLine("Id " + x.Id + ":\t" + "ContestName: " + x.ContestName + "\t\t" + "SportId " + x.SportId); } int id = UpdateId(); var change = mRep.FindBy(m => m.Id.Equals(id)); foreach (var x in change) { Console.Write("Enter new ContestName: "); x.ContestName = Console.ReadLine(); foreach (var y in alls) { Console.WriteLine(y.Id + " = " + y.SportName); } Console.Write("Enter new SportId: "); x.SportId = int.Parse(Console.ReadLine()); mRep.Update(x); mRep.Save(); } } if (parameter == "Sport") { foreach (var x in alls) { Console.WriteLine("Id " + x.Id + ":\t" + "SportName: " + x.SportName); } int id = UpdateId(); var change = spRep.FindBy(m => m.Id.Equals(id)); foreach (var x in change) { Console.Write("Enter new SportName: "); x.SportName = Console.ReadLine(); spRep.Update(x); spRep.Save(); } } if (parameter == "Country") { foreach (var x in allc) { Console.WriteLine("Id " + x.Id + ":\t" + "CountryName " + x.CountryName + "\t\t" + "Gold " + x.Gold + "\t" + "Silver " + x.Silver + "\t" + "Bronze " + x.Bronze); } int id = UpdateId(); var change = coRep.FindBy(m => m.Id.Equals(id)); foreach (var x in change) { Console.Write("Enter new CountryName: "); x.CountryName = Console.ReadLine(); Console.Write("Enter new Gold: "); x.Gold = int.Parse(Console.ReadLine()); Console.Write("Enter new Silver: "); x.Silver = int.Parse(Console.ReadLine()); Console.Write("Enter new Bronze: "); x.Bronze = int.Parse(Console.ReadLine()); coRep.Update(x); coRep.Save(); } } if (parameter == "Referee") { var mRep = new RefereeRepository(); var all = mRep.GetAll(); foreach (var x in all) { Console.WriteLine("Id " + x.Id + ":\t" + "Name: " + x.Name + "\t\t" + "CountryId " + x.CountryId); } int id = UpdateId(); var change = mRep.FindBy(m => m.Id.Equals(id)); foreach (var x in change) { Console.Write("Enter new Name: "); x.Name = Console.ReadLine(); foreach (var y in allc) { Console.WriteLine(y.Id + " = " + y.CountryName); } Console.Write("Enter new CountryId: "); x.CountryId = int.Parse(Console.ReadLine()); mRep.Update(x); mRep.Save(); } } }