internal List <DreamTeamPlayer> GetDreamTeamData(DateTime date, string teamName) { List <DreamTeamPlayer> dreamTeams = null; string dreamTeamId = string.Format("{0}_{1}", teamName, date.Date.ToString("yyyy-MM-dd")); try { using (TBCL3FantasyLeagueEntities context = new TBCL3FantasyLeagueEntities()) { try { if (context.Database.Exists()) { dreamTeams = (from t in context.DreamTeamPlayers where t.DreamTeamId.Equals(dreamTeamId) select t).ToList(); } else { throw new ApplicationException("Connectivity issues with database.Contact Admin"); } } catch (Exception ex) { throw ex; } } } catch (Exception ex) { throw ex; } return(dreamTeams); }
private List <PlayerInfo> GetPlayerNameAndValue(string teamName) { List <PlayerInfo> playerInfo = null; try { using (TBCL3FantasyLeagueEntities table = new TBCL3FantasyLeagueEntities()) { try { if (table.Database.Exists()) { playerInfo = (from t in table.Players where t.Team_Id.Equals(teamName) select new PlayerInfo() { Points = t.Points, Name = t.Name, IsGirlPlayer = t.IsGirlPlayer, Team_Id = t.Team_Id }).ToList(); } else { throw new ApplicationException("Connectivity issues with database.Contact Admin"); } } catch (Exception ex) { throw ex; } } } catch (Exception ex) { throw ex; } return(playerInfo); }
internal List <string> GetDreamTeamsByDate(DateTime date) { List <string> dreamTeams = null; try { using (TBCL3FantasyLeagueEntities context = new TBCL3FantasyLeagueEntities()) { try { if (context.Database.Exists()) { dreamTeams = (from dreamTeam in context.DreamTeams where dreamTeam.DateSubmitted.CompareTo(date) == 0 select new { TeamName = dreamTeam.TeamName, TotalScoredPoints = dreamTeam.TotalScoredPoints }).OrderByDescending(x => x.TotalScoredPoints).Select(x => x.TeamName).ToList(); } else { throw new ApplicationException("Connectivity issues with database.Contact Admin"); } } catch (Exception ex) { throw ex; } } } catch (Exception ex) { throw ex; } return(dreamTeams); }
private void DeleteCurrentTeamRecord(string dreamTeamId) { try { using (TBCL3FantasyLeagueEntities context = new TBCL3FantasyLeagueEntities()) { try { if (context.Database.Exists()) { DreamTeam dreamTeam = new DreamTeam() { DreamTeamId = dreamTeamId }; context.DreamTeams.Attach(dreamTeam); context.DreamTeams.Remove(dreamTeam); context.SaveChanges(); } else { throw new ApplicationException("Connectivity issues with database.Contact Admin"); } } catch (Exception ex) { throw ex; } } } catch (Exception ex) { throw new ApplicationException("Connectivity issues with database.Contact Admin. \n Details: " + ex.Message); } }
private IEnumerable <string> GetTeamsFromDb() { try { using (TBCL3FantasyLeagueEntities context = new TBCL3FantasyLeagueEntities()) { try { if (context.Database.Exists()) { return((from t in context.Players select t.Team_Id.Trim()).Distinct().ToList()); } else { throw new ApplicationException("Connectivity issues with database.Contact Admin"); } } catch (Exception ex) { throw ex; } } } catch (Exception ex) { throw new ApplicationException(ex.Message); } }
private void UpdateDreamTeamPlayers(string dreamTeamId, List <PlayerInfo> players) { try { using (TBCL3FantasyLeagueEntities context = new TBCL3FantasyLeagueEntities()) { try { if (context.Database.Exists()) { foreach (var item in players) { context.DreamTeamPlayers.Add(new DreamTeamPlayer() { Name = item.Name, Team_id = item.Team_Id, Points = item.Points, IsGirlplayer = item.IsGirlPlayer, runsScored = 0, noOfFours = 0, noOfSixes = 0, noOfwickets = 0, maidenOver = 0, noOfCatches = 0, stumping = 0, runoutThrow = 0, runoutCatch = 0, duck = 0, bonusOnRunsScore = 0, bonusOnWickets = 0, totalPoints = 0, DreamTeamId = dreamTeamId }); } context.SaveChanges(); } else { new ApplicationException("Connectivity issues with database.Contact Admin"); } } catch (Exception ex) { throw ex; } } } catch (Exception ex) { throw new ApplicationException("Connectivity issues with database.Contact Admin. \n Details: " + ex.Message); } }
private void UpdateDreamTeam(string dreamTeamName, string captainName, string viceCaptainName, string dreamTeamId) { DreamTeam dreamTeamObj = new DreamTeam() { TeamName = dreamTeamName, Captain = captainName, ViceCaptain = viceCaptainName, DateSubmitted = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")), DreamTeamId = dreamTeamId, MoneyPaid = false }; try { using (TBCL3FantasyLeagueEntities context = new TBCL3FantasyLeagueEntities()) { try { if (context.Database.Exists()) { context.DreamTeams.Add(dreamTeamObj); context.SaveChanges(); } else { new ApplicationException("Connectivity issues with database.Contact Admin"); } } catch (SqlException ex) { if (ex.Number == 2627) { new ApplicationException("Someone already reserved the team name today.Choose different team name"); } else { throw ex; } } catch (Exception ex) { throw ex; } } } catch (Exception ex) { throw new ApplicationException("Connectivity issues with database.Contact Admin. \n Details: " + ex.Message); } }