partial void DeletePlayerRankings(PlayerRankings instance);
partial void UpdatePlayerRankings(PlayerRankings instance);
private static PlayerRankings InsertPlayerRankById(NPGGFFLDataContext context, int playerId)
{
var playerRankExists = context.PlayerRankings.Where(p => p.PlayerId == playerId).FirstOrDefault();
if (playerRankExists == null)
{
PlayerRankings pr = new PlayerRankings { PlayerId = playerId };
context.PlayerRankings.InsertOnSubmit(pr);
context.SubmitChanges();
return context.PlayerRankings.Where(p => p.PlayerId == playerId).FirstOrDefault();
}
else
{
return playerRankExists;
}
}
partial void InsertPlayerRankings(PlayerRankings instance);
private static void UpdatePlayerRankings()
{
try
{
NPGGFFLDataContext context = new NPGGFFLDataContext(ConfigurationManager.ConnectionStrings["NPGGFFLConnectionString"].ConnectionString);
var TriggerDate = DateTime.Now;
var seasonWeek = context.SeasonWeeks.Where(sw => sw.StartDtm <= TriggerDate && sw.EndDtm >= TriggerDate).First();
var playerRanks = NPGGFFLApi.Controllers.PlayerPoints.GetPlayerRankings(context, seasonWeek.SeasonYear, seasonWeek.SeasonTypeId);
foreach (var rank in playerRanks)
{
var playerRanksExists = context.PlayerRankings.Where(p => p.PlayerId == rank.PlayerId).FirstOrDefault();
if (playerRanksExists == null)
{
PlayerRankings pr = new PlayerRankings { PlayerId = rank.PlayerId, OverallRanking = Convert.ToInt32(rank.OverallRank), PositionalRanking = 10000, PassRanking = 10000, RushRanking = 10000 };
context.PlayerRankings.InsertOnSubmit(pr);
}
else
{
playerRanksExists.OverallRanking = Convert.ToInt32(rank.OverallRank);
}
}
context.SubmitChanges();
foreach (var position in context.Positions.Where(po => (new string[] { "QB", "RB", "WR", "TE", "DST", "PK" }).Contains(po.Name)))
{
var playerPositionRanks = NPGGFFLApi.Controllers.PlayerPoints.GetPlayerPositionalRankings(context, seasonWeek.SeasonYear, seasonWeek.SeasonTypeId, position.Name);
foreach (var rank in playerPositionRanks)
{
var playerRanksExists = context.PlayerRankings.Where(p => p.PlayerId == rank.PlayerId).FirstOrDefault();
if (playerRanksExists == null)
{
PlayerRankings pr = new PlayerRankings { PlayerId = rank.PlayerId, OverallRanking = 10000, PositionalRanking = Convert.ToInt32(rank.OverallRank), PassRanking = 10000, RushRanking = 10000 };
context.PlayerRankings.InsertOnSubmit(pr);
}
else
{
playerRanksExists.PositionalRanking = Convert.ToInt32(rank.OverallRank);
}
}
}
context.SubmitChanges();
var defensiveRanks = NPGGFFLApi.Controllers.PlayerPoints.GetDefensiveRanks(context, seasonWeek.SeasonYear, seasonWeek.SeasonTypeId);
foreach (var rank in defensiveRanks)
{
var playerRanksExists = context.PlayerRankings.Where(p => p.PlayerId == rank.PlayerId).FirstOrDefault();
if (playerRanksExists == null)
{
PlayerRankings pr = new PlayerRankings { PlayerId = rank.PlayerId, OverallRanking = 10000, PositionalRanking = 10000, PassRanking = Convert.ToInt32(rank.PassRank), RushRanking = Convert.ToInt32(rank.RushRank) };
context.PlayerRankings.InsertOnSubmit(pr);
}
else
{
playerRanksExists.PassRanking = Convert.ToInt32(rank.PassRank);
playerRanksExists.RushRanking = Convert.ToInt32(rank.RushRank);
}
}
context.SubmitChanges();
}
catch (Exception)
{
throw;
}
}
