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