protected void JqgridTeam_RowAdding(object sender, Trirand.Web.UI.WebControls.JQGridRowAddEventArgs e)
{
if (Session["seasonid"] == null)
{
return;
}
if (Convert.ToInt32(Session["seasonid"]) == 0)
{
return;
}
using (var dc = ThaitaeDataDataContext.Create())
{
var objTeam = new Team
{
TeamName = e.RowData["TeamName"].Trim(),
TeamDesc = e.RowData["TeamDesc"].Trim(),
Active = Convert.ToByte(e.RowData["ActiveName"]),
Guid = Guid.NewGuid()
};
dc.Teams.InsertOnSubmit(objTeam);
dc.SubmitChanges();
dc.TeamSeasons.InsertOnSubmit(new TeamSeason
{
SeasonId = Convert.ToInt32(Session["seasonid"]),
TeamId = objTeam.TeamId
});
dc.SubmitChanges();
}
}
public static IEnumerable <Match> MatcheShowing(int leagueId)
{
IEnumerable <Match> matches = null;
var matchFilteredList = new List <Match>();
var dc = ThaitaeDataDataContext.Create();
var league = dc.Leagues.Single(items => items.LeagueId == leagueId);
var seasoncount = dc.Seasons.Count(items => items.LeagueId == league.LeagueId);
if (seasoncount > 0)
{
var seasons =
dc.Seasons.OrderByDescending(item => item.SeasonId).First(items => items.LeagueId == league.LeagueId);
matches =
dc.Matches.OrderByDescending(item => item.MatchDate).Where(
item => item.SeasonId == seasons.SeasonId && item.MatchDate < DateTime.Now.AddDays(1)).ToList();
foreach (var match in matches)
{
var checkNotEdited = false;
var teamMatchList = dc.TeamMatches.Where(item => item.MatchId == match.MatchId).ToList();
foreach (var teamMatch in teamMatchList)
{
if (teamMatch.TeamEdited == 0)
{
checkNotEdited = true;
}
}
if (checkNotEdited == false)
{
matchFilteredList.Add(match);
}
}
matches = matchFilteredList;
}
return(matches);
}
protected void Page_Load(object sender, EventArgs e)
{
var dc = ThaitaeDataDataContext.Create();
JqgridLeague1.DataSource = dc.Leagues.Where(item => item.LeagueType != 1 && item.LeagueType != 2);
JqgridLeague1.DataBind();
}
public void CalculatePlayerResult(Player playerInput)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var playerTeamList =
dc.Players.Where(item => item.SeasonId == playerInput.SeasonId && item.TeamId == playerInput.TeamId).ToList();
foreach (var player in playerTeamList)
{
var playerUpdate = dc.Players.Single(item => item.PlayerId == player.PlayerId);
playerUpdate.PlayerGoal =
dc.PlayerMatches.Count(
item =>
item.PlayerGoal == 1 && item.PlayerId == player.PlayerId && item.TeamId == player.TeamId && item.SeasonId == player.SeasonId);
playerUpdate.PlayerRedCard =
dc.PlayerMatches.Count(
item =>
item.PlayerRedCard == 1 && item.PlayerId == player.PlayerId && item.TeamId == player.TeamId && item.SeasonId == player.SeasonId);
playerUpdate.PlayerYellowCard =
dc.PlayerMatches.Count(
item =>
item.PlayerYellowCard == 1 && item.PlayerId == player.PlayerId && item.TeamId == player.TeamId && item.SeasonId == player.SeasonId);
dc.SubmitChanges();
}
}
}
protected void JqgridHomeTeam_DataRequesting(object sender, JQGridDataRequestEventArgs e)
{
var teamHomeMatchList = ThaitaeDataDataContext.Create().TeamMatches.Where(item => item.MatchId == Convert.ToInt32(e.ParentRowKey) && item.TeamHome == 1).ToList();
JqgridHomeTeam.DataSource = teamHomeMatchList;
JqgridHomeTeam.DataBind();
}
private void JqgridSeasonBinding(int leagueId)
{
var dc = ThaitaeDataDataContext.Create().Seasons;
var seasonList = dc.Where(item => item.LeagueId == leagueId).ToList();
JqgridSeason.DataSource = seasonList;
JqgridSeason.DataBind();
}
public static New SelectedNews(int newsId)
{
var dc = ThaitaeDataDataContext.Create();
var news = dc.News.Single(item => item.newsId == newsId);
news.picture = ConfigurationManager.AppSettings["BackendUrl"] + news.picture;
return(news);
}
private void JqgridMatchBinding(int seasonId)
{
var dc = ThaitaeDataDataContext.Create().Matches;
var matchSeasonList = dc.Where(item => item.SeasonId == seasonId).ToList();
JqgridMatch1.DataSource = matchSeasonList;
JqgridMatch1.DataBind();
}
private void JqgridFAMatchBinding()
{
var dc = ThaitaeDataDataContext.Create().FAMatches;
var faMatchList = dc.ToList();
JqgridMatch1.DataSource = faMatchList;
JqgridMatch1.DataBind();
}
public static League GetLeague(int leagueId)
{
var dc = ThaitaeDataDataContext.Create();
var league = dc.Leagues.Single(item => item.LeagueId == leagueId);
league.Picture = ConfigurationManager.AppSettings["BackendUrl"] + league.Picture;
return(league);
}
public static void Delete(Match objMatch)
{
using (var dc = ThaitaeDataDataContext.Create())
{
dc.Matches.DeleteOnSubmit(objMatch);
dc.SubmitChanges();
}
}
protected void JqgridNews_RowDeleting(object sender, Trirand.Web.UI.WebControls.JQGridRowDeleteEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var news = dc.News.Single(item => item.newsId == Convert.ToInt32(e.RowKey));
dc.News.DeleteOnSubmit(news);
dc.SubmitChanges();
}
}
protected void JqgridMatch1_RowEditing(object sender, JQGridRowEditEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var match = dc.Matches.Single(item => item.MatchId == Convert.ToInt32(e.RowKey));
match.MatchDate = Convert.ToDateTime(e.RowData["MatchDate"]);
dc.SubmitChanges();
}
}
protected void JqgridMatch1_RowDeleting(object sender, JQGridRowDeleteEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var faMatch = dc.FAMatches.Single(item => item.FAMatchId == Convert.ToInt32(e.RowKey));
dc.FAMatches.DeleteOnSubmit(faMatch);
dc.SubmitChanges();
}
}
public static List <League> GetChampionsLeagueGroupList()
{
List <League> leagueList;
using (var dc = ThaitaeDataDataContext.Create())
{
leagueList = dc.Leagues.Where(item => (item.LeagueType == 8 || item.LeagueType == 2) && item.Active == 1).ToList();
}
return(leagueList);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
var dc = ThaitaeDataDataContext.Create().FAMatches.OrderByDescending(item => item.FAMatchDate);
var faMatchList = dc.ToList();
JqgridMatch1.DataSource = faMatchList;
JqgridMatch1.DataBind();
}
}
private void JqgridTeamBinding(int seasonId)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var teamSeasonList = dc.TeamSeasons.Join(dc.Teams, teamSeason => teamSeason.TeamId, team => team.TeamId, (teamSeason, team) => new { teamSeason.SeasonId, team.TeamId, team.TeamName, team.TeamDesc, team.ActiveName, teamSeason.TeamSeasonId, teamSeason.TeamDrew, teamSeason.TeamGoalAgainst, teamSeason.TeamGoalDiff, teamSeason.TeamGoalFor, teamSeason.TeamLoss, teamSeason.TeamMatchPlayed, teamSeason.TeamPts, teamSeason.TeamWon, teamSeason.TeamYellowCard, teamSeason.TeamRedCard }).Where(teamSeason => teamSeason.SeasonId == seasonId)
.OrderByDescending(item => item.TeamPts).ThenByDescending(item => item.TeamGoalDiff).ThenByDescending(item => item.TeamGoalFor).ToList();
JqgridTeam.DataSource = teamSeasonList;
JqgridTeam.DataBind();
}
}
public static void DeleteSeason(Season objSeason)
{
using (var dc = ThaitaeDataDataContext.Create())
{
Season linqSeason = (from dataItem in dc.Seasons
where dataItem.SeasonId == objSeason.SeasonId
select dataItem).First();
dc.Seasons.DeleteOnSubmit(linqSeason);
dc.SubmitChanges();
}
}
public static TeamSeason GetChampionsLeagueFinalTeamFromGroupSeasonId(int groupSeasonId, int teamId)
{
TeamSeason team;
using (var dc = ThaitaeDataDataContext.Create())
{
team =
dc.TeamSeasons.SingleOrDefault(item => item.GroupSeasonId == groupSeasonId && item.TeamId == teamId);
}
return(team);
}
public static List <Season> GetChampionLeagueGroupSeasonList(int championsFinalSeasonId)
{
List <Season> championsGroupSeasonList;
using (var dc = ThaitaeDataDataContext.Create())
{
championsGroupSeasonList =
dc.Seasons.Where(item => item.ChampionLeagueSeasonId == championsFinalSeasonId).ToList();
}
return(championsGroupSeasonList);
}
protected void JqgridNews_RowEditing(object sender, Trirand.Web.UI.WebControls.JQGridRowEditEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var news = dc.News.Single(item => item.newsId == Convert.ToInt32(e.RowKey));
news.newsTopic = e.RowData["newsTopic"];
news.newsContent = e.RowData["newsContent"];
news.newsType = Convert.ToInt32(e.RowData["NewsTypeName"]);
dc.SubmitChanges();
}
}
protected void JqgridSeason_RowDeleting(object sender, Trirand.Web.UI.WebControls.JQGridRowDeleteEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var season = dc.Seasons.Single(item => item.SeasonId == Convert.ToInt32(e.RowKey));
var seasonGroup = dc.Seasons.Where(item => item.ChampionLeagueSeasonId == Convert.ToInt32(e.RowKey));
dc.Seasons.DeleteOnSubmit(season);
dc.Seasons.DeleteAllOnSubmit(seasonGroup);
dc.SubmitChanges();
}
}
public static IEnumerable <object> ListTeamItems(int seasonId)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var teamSeasonList = dc.TeamSeasons.Join(dc.Teams, teamSeason => teamSeason.TeamId, team => team.TeamId, (teamSeason, team) => new { teamSeason.SeasonId, team.TeamId, team.TeamName, team.TeamDesc, team.ActiveName, teamSeason.TeamSeasonId, teamSeason.TeamDrew, teamSeason.TeamGoalAgainst, teamSeason.TeamGoalDiff, teamSeason.TeamGoalFor, teamSeason.TeamLoss, teamSeason.TeamMatchPlayed, teamSeason.TeamPts, teamSeason.TeamWon }).Where(teamSeason => teamSeason.SeasonId == seasonId).ToList();
var teamList = new List <object> {
new { TeamId = 0, TeamName = "[All]" }
};
teamList.AddRange(teamSeasonList);
return(teamList);
}
}
public static IEnumerable <League> SelectNormalLeague()
{
IEnumerable <League> leagues = new List <League>();
var dc = ThaitaeDataDataContext.Create();
var leagueCount = dc.Leagues.Count();
if (leagueCount > 0)
{
leagues = dc.Leagues.Where(item => item.LeagueType == 4).ToList();
}
return(leagues);
}
public static List <TeamSeason> GetEuropaLeagueFinalTeamList(int seasonId)
{
List <TeamSeason> team;
using (var dc = ThaitaeDataDataContext.Create())
{
team = dc.TeamSeasons.Where(item => item.SeasonId == seasonId)
.OrderBy(item => item.TeamPts).ThenBy(item => item.TeamGoalDiff).ThenBy(item => item.TeamGoalFor)
.Take(2).ToList();
}
return(team);
}
protected void JqgridTeam_RowEditing(object sender, Trirand.Web.UI.WebControls.JQGridRowEditEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var teamSeason = dc.TeamSeasons.Single(item => item.TeamSeasonId == Convert.ToInt32(e.RowKey));
var team = dc.Teams.Single(item => item.TeamId == teamSeason.TeamId);
team.TeamName = e.RowData["TeamName"].Trim();
team.TeamDesc = e.RowData["TeamDesc"].Trim();
team.Active = Convert.ToByte(e.RowData["ActiveName"]);
dc.SubmitChanges();
}
}
protected void JqgridLeague1_RowEditing(object sender, Trirand.Web.UI.WebControls.JQGridRowEditEventArgs e)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var league = dc.Leagues.Single(item => item.LeagueId == Convert.ToInt32(e.RowKey));
league.LeagueName = e.RowData["LeagueName"];
league.LeagueType = Convert.ToInt32(e.RowData["LeagueTypeName"]);
league.LeagueDesc = e.RowData["LeagueDesc"];
league.Active = Convert.ToInt32(e.RowData["ActiveName"]);
dc.SubmitChanges();
}
}
public static IEnumerable <Season> ListSeasonItems(int leagueId)
{
using (var dc = ThaitaeDataDataContext.Create())
{
var seasonList = new List <Season> {
new Season {
SeasonId = 0, SeasonName = "Select Season"
}
};
seasonList.AddRange(dc.Seasons.Where(item => item.LeagueId == leagueId).ToList());
return(seasonList);
}
}
public static bool CheckGroupSeasonIsFinnish(int seasonId)
{
bool checkSesson = false;
using (var dc = ThaitaeDataDataContext.Create())
{
if (dc.TeamMatches.Count(item => item.SeasonId == seasonId) != 0)
{
checkSesson = !dc.TeamMatches.Any(item => item.SeasonId == seasonId && item.TeamEdited == 0);
}
}
return(checkSesson);
}
protected void JqgridSeason_RowAdding(object sender, Trirand.Web.UI.WebControls.JQGridRowAddEventArgs e)
{
if (Session["leagueid"] == null)
{
return;
}
if (Convert.ToInt32(Session["leagueid"]) == 0)
{
return;
}
var league = LeagueHelper.GetLeague(Convert.ToInt32(Session["leagueid"]));
using (var dc = ThaitaeDataDataContext.Create())
{
if (league.LeagueType == 1)
{
var season = new thaitae.lib.Season
{
LeagueId = Convert.ToInt32(Session["leagueid"]),
SeasonName = e.RowData["SeasonName"],
SeasonDesc = e.RowData["SeasonDesc"]
};
dc.Seasons.InsertOnSubmit(season);
dc.SubmitChanges();
var leagueList = LeagueHelper.GetChampionsLeagueGroupList();
foreach (var championGroup in leagueList)
{
var seasonGroup = new thaitae.lib.Season
{
LeagueId = championGroup.LeagueId,
SeasonName = e.RowData["SeasonName"],
SeasonDesc = e.RowData["SeasonDesc"],
ChampionLeagueSeasonId = championGroup.LeagueType == 2 ? (int?)null : season.SeasonId
};
dc.Seasons.InsertOnSubmit(seasonGroup);
}
dc.SubmitChanges();
}
else
{
dc.Seasons.InsertOnSubmit(new thaitae.lib.Season
{
LeagueId = Convert.ToInt32(Session["leagueid"]),
SeasonName = e.RowData["SeasonName"],
SeasonDesc = e.RowData["SeasonDesc"]
});
dc.SubmitChanges();
}
}
}