// 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."); } }