public static string Country(string countryName)
{
checkData = CheckDataIsNotEmpty(countryName, "Country");
if (checkData != "Ok")
{
return(checkData);
}
try
{
using (soccerContext context = new soccerContext())
{
Country country = new Country
{
ui = Guid.NewGuid(),
Name = countryName,
};
context.Countries.Add(country);
context.SaveChanges();
return($"Country: {country.Name} is add to data!");
}
}
catch (Exception)
{
return($"There is problem to add Competition {countryName} ");
}
}
public static string Town(string townName, string countryName)
{
checkData = CheckDataIsNotEmpty(townName, "Town");
if (checkData != "Ok")
{
return(checkData);
}
try
{
using (soccerContext context = new soccerContext())
{
var country = context.Countries.FirstOrDefault(c => c.Name == countryName);
Town town = new Town
{
ui = Guid.NewGuid(),
Country_ui = country.ui,
Name = townName
};
context.Towns.Add(town);
context.SaveChanges();
return($"Town: {town.Name} is add to data!");
}
}
catch (Exception)
{
return($"There is problem to add Town {townName} ");
}
}
public void Execute()
{
Game game = new Game
{
ui = Guid.NewGuid()
};
using (soccerContext context = new soccerContext())
{
Guid competitionGuid = new Guid(this.competition);
Guid homeTeamGuid = new Guid(this.homeTeam);
Guid awayTeamGuid = new Guid(this.awayTeam);
Competition competitionData = context.Competitions.FirstOrDefault(c => c.ui == competitionGuid);
Team teamHomeData = context.Teams.FirstOrDefault(t => t.ui == homeTeamGuid);
Team teamAwayData = context.Teams.FirstOrDefault(t => t.ui == awayTeamGuid);
game.Competition_ui = competitionData.ui;
game.HomeTeam_ui = teamHomeData.ui;
game.AwayTeam_ui = teamAwayData.ui;
game.HomeTeamGoals = homeTeamGoals;
game.AwayTeamGoals = awayTeamGoals;
game.Date = dateOfGame.Date;
try
{
context.Games.Add(game);
context.SaveChanges();
}
catch (Exception)
{
throw new ArgumentException("There is problem with Games Import!");
}
}
}
public void Execute()
{
int number = (int)((EnumColor)Enum.Parse(typeof(EnumColor), this.colourName));
Colour colour = new Colour
{
Name = number
};
Guid guid = Guid.NewGuid();
colour.ui = guid;
try
{
using (soccerContext context = new soccerContext())
{
context.Colours.Add(colour);
context.SaveChanges();
}
}
catch (Exception)
{
throw new ArgumentException("There is such colour in data");
}
}
public void GetCountriesSelectOptions()
{
using (soccerContext context = new soccerContext())
{
Dictionary <Guid, string> countries = context.Countries.Select(c => new { c.ui, c.Name }).ToDictionary(c => c.ui, c => c.Name);
foreach (var country in countries)
{
Response.Write(String.Format(@"<option val=""{0}"">{1}</option>", country.Key, country.Value));
}
}
}
public static object DropDownCountries()
{
using (soccerContext context = new soccerContext())
{
// Make the dropDown List of Counries names from Data
List <Country> competitions = context.Countries.OrderBy(c => c.Name).ToList();
var objList = (new[] { new { Text = "" } }).ToList();
foreach (var competition in competitions)
{
objList.Add(new { Text = competition.Name });
}
objList = objList.Skip(1).ToList();
return(objList);
}
}
protected void Page_Load(object sender, EventArgs e)
{
using (soccerContext context = new soccerContext())
{
//Competitions Drop Down
string valueCompetition = DropDownListCompetitions.SelectedValue;
this.newCompetitionValue = valueCompetition;
DropDownListCompetitions.DataSource = context.Competitions.OrderBy(c => c.Name).ToList();
DropDownListCompetitions.DataTextField = "name";
DropDownListCompetitions.DataValueField = "ui";
DropDownListCompetitions.DataBind();
DropDownListCompetitions.Items.Insert(0, new ListItem(String.Empty, String.Empty));
}
}
public void Execute()
{
Town town = new Town
{
Name = name,
ui = Guid.NewGuid()
};
soccerContext context = new soccerContext();
try
{
Country country = context.Countries.FirstOrDefault(c => c.Name == countryName);
country.Towns.Add(town);//Add town to this country
town.Country_ui = country.ui;
context.SaveChanges();
}
catch (Exception)
{
throw new System.InvalidOperationException("There is such town in data");
}
}
public void Execute()
{
Competition competition = new Competition
{
ui = Guid.NewGuid(),
Name = competitionName
};
try
{
using (soccerContext context = new soccerContext())
{
context.Competitions.Add(competition);
context.SaveChanges();
}
//Working!
}
catch (Exception)
{
throw new ArgumentException("There is such Competition name!");
}
}
public void Execute()
{
Team team = new Team
{
Name = teamName,
ui = Guid.NewGuid()
};
using (soccerContext context = new soccerContext())
{
Competition competition = context.Competitions.FirstOrDefault(c => c.Name == competitionName);
//competition.Teams.Add(team);
Town town = context.Towns.FirstOrDefault(t => t.Name == townName);
//town.Teams.Add(team);
team.Competition_ui = competition.ui;
team.Town_ui = town.ui;
int idFirst = int.Parse(primaryColour);
int idSecond = int.Parse(secondaryColour);
Colour colourOne = context.Colours.FirstOrDefault(c => c.Name == idFirst);
Colour colourTwo = context.Colours.FirstOrDefault(c => c.Name == idSecond);
team.Colour = colourOne;
team.Colour1 = colourTwo;
try
{
context.Teams.Add(team);
context.SaveChanges();
}
catch (Exception)
{
throw new ArgumentException("There is such team in data");
}
}
}
public static string getWhileLoopData(string competitionUi)
{
string htmlStr = "";
List <Team> teams = new List <Team>();
List <Game> games = new List <Game>();
Guid guidCompetition = new Guid(competitionUi);
using (soccerContext context = new soccerContext())
{
// List of teams in that competition
Competition competition = context.Competitions.FirstOrDefault(c => c.ui == guidCompetition);
if (competition != null)
{
teams = context.Teams.Where(t => t.Competition.ui == guidCompetition).ToList(); //List of teams in this Competition
games = context.Games.Where(g => g.Competition_ui == competition.ui).ToList(); //List of games in this competition
}
}
Dictionary <Team, List <Game> > teamGames = new Dictionary <Team, List <Game> >();
Dictionary <Team, List <int> > teamPoints = new Dictionary <Team, List <int> >();
int points = 0;
string teamName = "";
int wins = 0;
int draws = 0;
int loses = 0;
int scoredGoals = 0;
int receivedGoals = 0;
string goalDifference = "";
foreach (var team in teams)
{
teamGames.Add(team, new List <Game>()); //add key Team
teamPoints.Add(team, new List <int>()); //Add team with zero points
teamName = team.Name;
foreach (var game in games)
{
if (game.HomeTeam_ui == team.ui) //find is the team playing in this game and its home team
{
scoredGoals += game.HomeTeamGoals; // add scored Goals
receivedGoals += game.AwayTeamGoals; //add received Goals
if (game.HomeTeamGoals > game.AwayTeamGoals) //Our team is winner we give 3 points
{
points += 3;
wins += 1;
}
else if (game.HomeTeamGoals == game.AwayTeamGoals)//Draw 1 points
{
points += 1;
draws += 1;
}
else if (game.HomeTeamGoals < game.AwayTeamGoals)//Team lose 0 points , one loose
{
loses += 1;
}
}
else if (game.AwayTeam_ui == team.ui) //find is the team playing in this game and its away team
{
scoredGoals += game.AwayTeamGoals; // add scored Goals
receivedGoals += game.HomeTeamGoals; //add received Goals
if (game.HomeTeamGoals < game.AwayTeamGoals) //Our team is winner we give 3 points
{
points += 3;
wins += 1;
}
else if (game.HomeTeamGoals == game.AwayTeamGoals)//Draw 1 points
{
points += 1;
draws += 1;
}
else if (game.HomeTeamGoals > game.AwayTeamGoals)//Team lose 0 points , one loose
{
loses += 1;
}
}
}
teamPoints[team].Add(points);
teamPoints[team].Add(wins);
teamPoints[team].Add(draws);
teamPoints[team].Add(loses);
teamPoints[team].Add(scoredGoals);
teamPoints[team].Add(receivedGoals);
points = 0;
wins = 0;
draws = 0;
loses = 0;
scoredGoals = 0;
receivedGoals = 0;
}
int possition = 1;
foreach (var team in teamPoints.OrderByDescending(t => t.Value[0]))
{
goalDifference = (team.Value[4] + "/" + team.Value[5] + "(" + (team.Value[4] - team.Value[5]) + ")").ToString();
htmlStr += "<tr><td>" + possition + "</td><td>" + team.Key.Name + "</td><td>" + team.Value[1] +
"</td><td>" + team.Value[2] + "</td><td>" + team.Value[3] + "</td><td>" + goalDifference + "</td><td>" + team.Value[0] + "</td><tr>";
possition++;
}
return(htmlStr);
}
protected void Page_Load(object sender, EventArgs e)
{
using (soccerContext context = new soccerContext())
{
countries = context.Countries.Select(c => new { c.ui, c.Name }).ToDictionary(c => c.ui, c => c.Name);
}
//Make the dropDown List from Enum Class order by colour name
DropDownListPrimaryKitColour.DataSource = Enumeration.GetAll <EnumColor>().OrderBy(c => c.Value);
DropDownListPrimaryKitColour.DataTextField = "Value";
DropDownListPrimaryKitColour.DataValueField = "Key";
//Make the dropDown List from Enum Class order by colour name
DropDownListSecondaryKitColour.DataSource = Enumeration.GetAll <EnumColor>().OrderBy(c => c.Value);
DropDownListSecondaryKitColour.DataTextField = "Value";
DropDownListSecondaryKitColour.DataValueField = "Key";
DropDownListPrimaryKitColour.DataBind();
DropDownListSecondaryKitColour.DataBind();
using (soccerContext context = new soccerContext())
{
//Make the dropDown List from Competitions Data
DropDownCompetitions.DataSource = context.Competitions.OrderBy(c => c.Name).ToList();
DropDownCompetitions.DataTextField = "name";
DropDownCompetitions.DataBind();
//Make the dropDown List from Town Data
DropDownTowns.DataSource = context.Towns.OrderBy(c => c.Name).ToList();
DropDownTowns.DataTextField = "name";
DropDownTowns.DataBind();
//Get The new Team Name and import it to data
}
//if (Request.Form.Count > 0)
//{
// string nameOfTeam = Request.Form["team"];
// string[] controls = Request.Form.AllKeys.Reverse().Take(5).ToArray();
// if (nameOfTeam != null && nameOfTeam != "")
// {
// string competition = Request.Form["ctl00$MainContent$DropDownCompetitions"];
// string town = Request.Form["ctl00$MainContent$DropDownTowns"];
// //there can be the same primary and secondary kit colour
// string primaryKitColour = Request.Form["ctl00$MainContent$DropDownListPrimaryKitColour"];
// string secondaryKitColour = Request.Form["ctl00$MainContent$DropDownListSecondaryKitColour"];
// if (primaryKitColour==secondaryKitColour)
// {
// throw new ArgumentException("Primary kit colour and secondary kit colour can not be the same");
// }
// //ToDO if Any is blanc like Select Competition or Select Town Throw Exeption
// string[] dataArgs = new string[] { nameOfTeam, competition, town, primaryKitColour, secondaryKitColour };
// CommandDispatcher commandDispatcher = new CommandDispatcher("team", dataArgs);
// }
// else
// {
// throw new ArgumentException("The Team Name is null or Empty");//ToDo this is not for here
// }
//}
}