private void CreateFederationSeason(Match match)
{
SportFederation spFed = new SportFederation();
string country = match.Country;
string nameSport = match.NameSportString;
var searchSF = from c in db.SportFederations
where c.NameSportString == nameSport &&
c.Country == country
select c;
if (searchSF.Count() > 0)
{
FederationSeason fedSeason = new FederationSeason();
spFed = searchSF.First();
fedSeason.NameTournament = LeagueName.Name(match.Country + match.NameSport.ToString() + match.Tournament.ToString());
fedSeason.Season = match.Season;
fedSeason.SportFederation = spFed;
fedSeason.SportFederationId = spFed.SportFederationId;
fedSeason.Tournament = match.Tournament;
fedSeason.Matches = new List <Match>();
db.FederationSeasons.Add(fedSeason);
db.SaveChanges();
}
}
private TeamSeason CreateTeamSeason(Match match, string NameTeam)
{
TeamSeason teamSeason = new TeamSeason();
string nameTeam = "";
if (NameTeam == "home")
{
nameTeam = match.HomeTeam;
}
else
{
nameTeam = match.AwayTeam;
}
string nameSport = match.NameSport.ToString();
string country = match.Country;
string name = nameTeam;
var search = from c in db.Teams
where
(c.Country == country || country == "UEFA") &&
c.NameSportString == nameSport &&
c.Name == name
select c;
string season = match.Season.ToString();
string tournament = match.Tournament.ToString();
var searchFS = from c in db.FederationSeasons
where
c.SportFederation.Country == country &&
c.SportFederation.NameSportString == nameSport &&
c.SeasonString == season &&
c.TournamentString == tournament
select c;
if (search.Count() > 0 && searchFS.Count() > 0)
{
Team team = search.First();
FederationSeason fedSeason = searchFS.First();
teamSeason.NameTeam = nameTeam;
teamSeason.Season = match.Season;
teamSeason.FederationSeasonId = fedSeason.FederationSeasonId;
teamSeason.FederationSeason = fedSeason;
teamSeason.Team = team;
teamSeason.TeamId = team.TeamId;
db.TeamSeasons.Add(teamSeason);
db.SaveChanges();
}
else
{
return(null);
}
return(teamSeason);
}
public void AddFederationSeason(string data)
{
data = data.Replace("\n", "&");
data = data.Replace("\r", "");
List <string> dataList = data.Split('&').ToList();
foreach (string item in dataList)
{
FederationSeason federationSeason = new FederationSeason();
string[] list = item.Split(',');
if (list.Count() < 5)
{
continue;
}
string nameSport = list[0];
string country = list[1];
string season = Enum.Format(typeof(Season), Convert.ToInt32(list[4]), "G");
var search = from c in db.FederationSeasons
where
c.SportFederation.NameSportString == nameSport &&
c.SportFederation.Country == country &&
c.SeasonString == season
select c;
if (search.Count() == 0)
{
federationSeason.Tournament = list[2].ParseEnum <Tournament>();
federationSeason.NameTournament = list[3];
federationSeason.Season = list[4].ParseEnum <Season>();
string countryF = list[1];
string nameSportF = list[0];
SportFederation sportFed = new SportFederation();
var searchSF = from c in db.SportFederations
where c.Country == countryF &&
c.NameSportString == nameSportF
select c;
if (searchSF.Count() > 0)
{
sportFed = searchSF.First();
}
else
{
continue;
}
federationSeason.SportFederationId = sportFed.SportFederationId;
federationSeason.SportFederation = sportFed;
db.FederationSeasons.Add(federationSeason);
db.SaveChanges();
}
}
}
public ActionResult DeleteConfirmed(int id)
{
try
{
FederationSeason federationSeason = db.FederationSeasons.Find(id);
db.FederationSeasons.Remove(federationSeason);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception e)
{
ViewBag.Error = e.Message;
return(View("Error"));
}
}
public ActionResult Edit([Bind(Include = "FederationSeasonId,TournamentString,NameTournament,SeasonString,SportFederationId")] FederationSeason federationSeason)
{
try
{
if (ModelState.IsValid)
{
db.Entry(federationSeason).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SportFederationId = new SelectList(db.SportFederations, "SportFederationId", "NameSportString", federationSeason.SportFederationId);
return(View(federationSeason));
}
catch (Exception e)
{
ViewBag.Error = e.Message;
return(View("Error"));
}
}
// GET: FederationSeasons/Details/5
public ActionResult Details(int?id)
{
try
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FederationSeason federationSeason = db.FederationSeasons.Find(id);
if (federationSeason == null)
{
return(HttpNotFound());
}
return(View(federationSeason));
}
catch (Exception e)
{
ViewBag.Error = e.Message;
return(View("Error"));
}
}
// GET: FederationSeasons/Edit/5
public ActionResult Edit(int?id)
{
try
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
FederationSeason federationSeason = db.FederationSeasons.Find(id);
if (federationSeason == null)
{
return(HttpNotFound());
}
ViewBag.SportFederationId = new SelectList(db.SportFederations, "SportFederationId", "NameSportString", federationSeason.SportFederationId);
return(View(federationSeason));
}
catch (Exception e)
{
ViewBag.Error = e.Message;
return(View("Error"));
}
}
public void AddTeamSeason(string data)
{
data = data.Replace("\n", "&");
data = data.Replace("\r", "");
List <string> dataList = data.Split('&').ToList();
foreach (string item in dataList)
{
TeamSeason teamSeason = new TeamSeason();
string[] list = item.Split(',');
if (list.Count() < 15)
{
continue;
}
string nameSport = list[0];
string name = list[4];
var search = from c in db.Teams
where
c.NameSportString == nameSport &&
c.Name == name
select c;
Team team = new Team();
if (search.Count() < 1)
{
continue;
}
else
{
team = search.First();
}
string season = Enum.Format(typeof(Season), Convert.ToInt32(list[3]), "G");
string country = list[1];
string tournament = list[2];
var searchFS = from c in db.FederationSeasons
where
c.SportFederation.Country == country &&
c.SportFederation.NameSportString == nameSport &&
c.SeasonString == season &&
c.TournamentString == tournament
select c;
FederationSeason fedSeason = new FederationSeason();
if (searchFS.Count() > 0)
{
fedSeason = searchFS.First();
}
else
{
continue;
}
teamSeason.Draw = Convert.ToInt32(list[7]);
teamSeason.FederationSeason = fedSeason;
teamSeason.FederationSeasonId = fedSeason.FederationSeasonId;
teamSeason.GoalAgainst = Convert.ToInt32(list[10]);
teamSeason.Goals = Convert.ToInt32(list[9]);
teamSeason.HomeDraw = Convert.ToInt32(list[14]);
teamSeason.HomeGoalAgainst = Convert.ToInt32(list[17]);
teamSeason.HomeGoals = Convert.ToInt32(list[16]);
teamSeason.HomeLose = Convert.ToInt32(list[15]);
teamSeason.HomePlayed = Convert.ToInt32(list[12]);
teamSeason.HomePoint = Convert.ToInt32(list[18]);
teamSeason.HomeWin = Convert.ToInt32(list[13]);
teamSeason.Lose = Convert.ToInt32(list[8]);
teamSeason.NameTeam = team.Name;
teamSeason.Played = Convert.ToInt32(list[5]);
teamSeason.Point = Convert.ToInt32(list[11]);
teamSeason.Season = season.ParseEnum <Season>();
teamSeason.Team = team;
teamSeason.TeamId = team.TeamId;
teamSeason.Win = Convert.ToInt32(list[6]);
db.TeamSeasons.Add(teamSeason);
team.TeamSeasons.Add(teamSeason);
db.Entry(team).State = EntityState.Modified;
fedSeason.TeamSeasons.Add(teamSeason);
db.Entry(fedSeason).State = EntityState.Modified;
}
}
public void AddMatch(string data)
{
data = data.Replace("\n", "&");
data = data.Replace("\r", "");
List <string> dataList = data.Split('&').ToList();
foreach (string item in dataList)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
if (item == null || item == "")
{
return;
}
string[] itemList = item.Split('|');
Match match = new Match();
string[] list = itemList[0].Split(',');
string nameSportM = list[0];
string homeTeamM = list[5];
string awayTeamM = list[6];
string dateM = list[4];
var search = from c in db.Matches
where c.NameSportString == nameSportM &&
c.HomeTeam == homeTeamM &&
c.AwayTeam == awayTeamM &&
c.Date == dateM
select c;
if (search.Count() > 0)
{
continue;
}
match.NameSport = list[0].ParseEnum <NameSport>();
match.Country = list[1];
string season = Enum.Format(typeof(Season), Convert.ToInt32(list[3]), "G");
match.Season = season.ParseEnum <Season>();
match.Tournament = list[2].ParseEnum <Tournament>();
match.Date = list[4];
match.HomeTeam = list[5];
match.AwayTeam = list[6];
match.HomeTeamGoal = Convert.ToInt32(list[7]);
match.AwayTeamGoal = Convert.ToInt32(list[8]);
if (list.Count() > 10)
{
match.Tour = list[10];
}
if (list[9] == "A")
{
match.HomeTeamResult = Result.Lose;
match.AwayTeamResult = Result.Win;
}
else if (list[9] == "D")
{
match.HomeTeamResult = Result.Draw;
match.AwayTeamResult = Result.Draw;
}
else if (list[9] == "H")
{
match.HomeTeamResult = Result.Win;
match.AwayTeamResult = Result.Lose;
}
if (itemList.Count() > 1)
{
if (itemList[1].Split(',').ToList()[0] != "")
{
match.ListHomePlayers = itemList[1].Split(',').ToList();
}
}
if (itemList.Count() > 2)
{
List <string> player = new List <string>();
player = itemList[2].Split(',').ToList();
if (player[0] != "")
{
match.ListAwayPlayers = new List <string>();
match.ListAwayPlayers.AddRange(player);
}
}
if (itemList.Count() == 5)
{
if (itemList[3].Split(',').ToList()[0] != "")
{
match.ListTimeLineHome = itemList[3].Split(',').ToList();
}
if (itemList[4].Split(',').ToList()[0] != "")
{
match.ListTimeLineAway = itemList[4].Split(',').ToList();
}
}
// Federation Season
FederationSeason fedSeason = new FederationSeason();
string countryFS = match.Country;
string nameSportFS = match.NameSportString;
string seasonFS = season;
var searchFS = from c in db.FederationSeasons
where
c.SportFederation.Country == countryFS &&
c.SportFederation.NameSportString == nameSportFS &&
c.SeasonString == seasonFS
select c;
if (searchFS.Count() == 0)
{
CreateFederationSeason(match);
}
// Team Home
TeamSeason homeTeam = HomeTeam(ref match);
// Team Away
TeamSeason awayTeam = AwayTeam(ref match);
if (searchFS.Count() > 0)
{
fedSeason = searchFS.First();
fedSeason.Matches.Add(match);
db.Entry(fedSeason).State = EntityState.Modified;
db.SaveChanges();
}
// PlayerSeason
MatchAddPlayerSeason(match, homeTeam, match.ListHomePlayers, match.ListTimeLineHome);
MatchAddPlayerSeason(match, awayTeam, match.ListAwayPlayers, match.ListTimeLineAway);
transaction.Commit();
}
catch (Exception)
{
transaction.Rollback();
myException.Message = item;
throw;
}
}
}
db.SaveChanges();
db.Dispose();
db = new DatabaseContext();
}
