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();
}
}
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 void AddSportFederation(string data)
{
data = data.Replace("\n", "&");
data = data.Replace("\r", "");
List <string> dataList = data.Split('&').ToList();
foreach (string item in dataList)
{
SportFederation sportFederation = new SportFederation();
string[] list = item.Split(',');
if (list.Count() < 2)
{
continue;
}
string nameSport = list[0];
string country = list[1];
var search = from c in db.SportFederations
where
c.NameSportString == nameSport && c.Country == country
select c;
if (search.Count() == 0)
{
sportFederation.NameSport = list[0].ParseEnum <NameSport>();
sportFederation.Country = list[1];
sportFederation.FoundationDate = list[2];
sportFederation.NamePresident = list[3];
Sport sport = new Sport();
var searchS = from c in db.Sports
where c.NameSportString == nameSport
select c;
if (searchS.Count() > 0)
{
sport = searchS.First();
}
else
{
continue;
}
sportFederation.SportId = sport.SportId;
sportFederation.Sport = sport;
db.SportFederations.Add(sportFederation);
db.SaveChanges();
}
}
}
public ActionResult DeleteConfirmed(int id)
{
try
{
SportFederation sportFederation = db.SportFederations.Find(id);
db.SportFederations.Remove(sportFederation);
db.SaveChanges();
return(RedirectToAction("Index"));
}
catch (Exception e)
{
ViewBag.Error = e.Message;
return(View("Error"));
}
}
// GET: SportFederations/Details/5
public ActionResult Details(int?id)
{
try
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SportFederation sportFederation = db.SportFederations.Find(id);
if (sportFederation == null)
{
return(HttpNotFound());
}
return(View(sportFederation));
}
catch (Exception e)
{
ViewBag.Error = e.Message;
return(View("Error"));
}
}
// GET: SportFederations/Edit/5
public ActionResult Edit(int?id)
{
try
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SportFederation sportFederation = db.SportFederations.Find(id);
if (sportFederation == null)
{
return(HttpNotFound());
}
ViewBag.SportId = new SelectList(db.Sports, "SportId", "NameSportString", sportFederation.SportId);
return(View(sportFederation));
}
catch (Exception e)
{
ViewBag.Error = e.Message;
return(View("Error"));
}
}
public ActionResult Edit([Bind(Include = "SportFederationId,NameSportString,Country,FoundationDate,NamePresident,SportId")] SportFederation sportFederation)
{
try
{
if (string.IsNullOrEmpty(sportFederation.Country))
{
ModelState.AddModelError("Country", "Enter Country or Federation");
}
if (ModelState.IsValid)
{
db.Entry(sportFederation).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.SportId = new SelectList(db.Sports, "SportId", "NameSportString", sportFederation.SportId);
return(View(sportFederation));
}
catch (Exception e)
{
ViewBag.Error = e.Message;
return(View("Error"));
}
}
public async Task HandleAsync(CreateFederation command, ICorrelationContext context)
{
var federation = new SportFederation(command.Id, command.Name);
await _federationsRepository.AddAsync(federation);
}
public async Task UpdateAsync(SportFederation federation) => await _repository.UpdateAsync(federation);
public async Task AddAsync(SportFederation federation) => await _repository.AddAsync(federation);
