public IEnumerable <Season> GetSeasons()
{
try
{
using (var db = new SpeedOddsContext())
{
var query = db.Seasons.OrderByDescending(x => x.EndYear).ThenByDescending(x => x.StartYear).ToList();
if (query != null)
{
return(query);
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error getting Seasons from BD -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(null);
}
}
public bool CreateSeason(int sy, int ey)
{
try
{
using (var db = new SpeedOddsContext())
{
Season season = new Season()
{
Name = "Época " + sy.ToString() + "/ " + ey.ToString(),
StartYear = sy,
EndYear = ey,
CreateDate = DateTime.Now
};
db.Seasons.Add(season);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine("Error creating new season -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(false);
}
}
public IEnumerable <Competition> GetCompetitions()
{
try
{
using (var db = new SpeedOddsContext())
{
var query = db.Competitions.OrderBy(x => x.Name).ToList();
if (query != null)
{
return(query);
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error getting Competitions from BD -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(null);
}
}
public bool ChangeFavoriteValue(int teamId, bool newVal)
{
try
{
using (var db = new SpeedOddsContext())
{
var team = db.Teams.Where(x => x.TeamId == teamId).FirstOrDefault();
if (team != null)
{
team.IsFavorite = newVal;
db.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine("Error changing favorite team from BD -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(false);
}
}
public string GetCompetitionSeasonName(int competitionId)
{
string output = "";
try
{
using (var db = new SpeedOddsContext())
{
var season = (from c in db.Competitions
join s in db.Seasons on c.SeasonId equals s.SeasonId
where c.CompetitionId == competitionId
select new { s.Name }).FirstOrDefault();
if (season != null)
{
output = season.Name;
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error getting competition season name from BD -> " + ex.ToString());
Console.WriteLine(ex.Message);
}
return(output);
}
public bool InsertOrUpdateTimeGoals(ObservableCollection <TimeGoalsModel> dados)
{
if (dados == null || dados != null ? dados.Count() < 1 : true)
{
return(false);
}
try
{
using (var db = new SpeedOddsContext())
{
foreach (var item in dados)
{
if (item.TimeGoalsId.HasValue)
{
//Update
var timeGoal = db.TimeGoals.Where(t => t.TimeGoalsId == item.TimeGoalsId).FirstOrDefault();
if (timeGoal != null)
{
timeGoal.Goal15 = item.Goal15;
timeGoal.Goal30 = item.Goal30;
timeGoal.Goal45 = item.Goal45;
timeGoal.Goal60 = item.Goal60;
timeGoal.Goal75 = item.Goal75;
timeGoal.Goal90 = item.Goal90;
db.SaveChanges();
}
}
else
{
//Create
TimeGoal timeGoal = new TimeGoal()
{
CompetitionId = item.CompetitionId.Value,
TeamId = item.TeamId.Value,
Goal15 = item.Goal15,
Goal30 = item.Goal30,
Goal45 = item.Goal45,
Goal60 = item.Goal60,
Goal75 = item.Goal75,
Goal90 = item.Goal90
};
db.TimeGoals.Add(timeGoal);
db.SaveChanges();
}
}
}
return(true);
}
catch (Exception ex)
{
Console.WriteLine("Error saving TimeGoals in BD -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(false);
}
}
public IEnumerable <TimeGoal> GetTimeGoalsByCompetition(int compId)
{
try
{
using (var db = new SpeedOddsContext())
{
var query = db.TimeGoals.Where(t => t.CompetitionId == compId)
.OrderBy(x => x.TeamId)
.ToList();
if (query != null)
{
return(query);
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error getting TimeGoals by competition from BD -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(null);
}
}
public bool CreateTeam(string name, int competitionId, bool isFavorite)
{
try
{
using (var db = new SpeedOddsContext())
{
Team team = new Team()
{
Name = name.Trim(),
CompetitionId = competitionId,
IsFavorite = isFavorite,
CreateDate = DateTime.Now
};
db.Teams.Add(team);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine("Error creating new team -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(false);
}
}
public bool RemoveTeam(int teamId)
{
try
{
using (var db = new SpeedOddsContext())
{
var team = db.Teams.Where(x => x.TeamId == teamId).FirstOrDefault();
if (team != null)
{
db.Teams.Remove(team);
db.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine("Error removing team from BD -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(false);
}
}
public IEnumerable <Team> GetCompetitionTeams(int competitionId)
{
try
{
using (var db = new SpeedOddsContext())
{
var query = db.Teams
.Where(x => x.CompetitionId == competitionId)
.OrderBy(x => x.Name).ThenBy(x => x.CreateDate).ToList();
if (query != null)
{
return(query);
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error getting competition Teams from BD -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(null);
}
}
public bool CreateCompetition(string name, int seasonId)
{
try
{
using (var db = new SpeedOddsContext())
{
Competition comp = new Competition()
{
Name = name.Trim(),
SeasonId = seasonId,
CreateDate = DateTime.Now
};
db.Competitions.Add(comp);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
Console.WriteLine("Error creating new competition -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(false);
}
}
public bool RemoveCompetition(int competitionId)
{
try
{
using (var db = new SpeedOddsContext())
{
var comp = db.Competitions.Where(x => x.CompetitionId == competitionId).FirstOrDefault();
if (comp != null)
{
db.Competitions.Remove(comp);
db.SaveChanges();
return(true);
}
return(false);
}
}
catch (Exception ex)
{
Console.WriteLine("Error removing competition from BD -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(false);
}
}
public bool CanDeleteById(int teamId)
{
try
{
using (var db = new SpeedOddsContext())
{
return(!db.Matches.Where(m => m.HomeTeamId == teamId || m.AwayTeamId == teamId).Any());
}
}
catch (Exception ex)
{
Console.WriteLine("Error checking teams in matches from BD -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(false);
}
}
public bool AlreadyExistsTeam(string name, int competitionId)
{
try
{
using (var db = new SpeedOddsContext())
{
return(db.Teams.Where(t => t.Name == name && t.CompetitionId == competitionId).Any());
}
}
catch (Exception ex)
{
Console.WriteLine("Error checking team -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(true);
}
}
public bool AlreadyExistsCompetition(string name, int seasonId)
{
try
{
using (var db = new SpeedOddsContext())
{
return(db.Competitions.Where(c => c.Name == name.Trim() && c.SeasonId == seasonId).Any());
}
}
catch (Exception ex)
{
Console.WriteLine("Error checking competition -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(true);
}
}
public bool AlreadyExistsSeason(int sy, int ey)
{
try
{
using (var db = new SpeedOddsContext())
{
return(db.Seasons.Where(s => s.StartYear == sy && s.EndYear == ey).Any());
}
}
catch (Exception ex)
{
Console.WriteLine("Error checking season -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(true);
}
}
public bool CanDeleteById(int competitionId)
{
try
{
using (var db = new SpeedOddsContext())
{
return(!db.Teams.Where(t => t.CompetitionId == competitionId).Any());
}
}
catch (Exception ex)
{
Console.WriteLine("Error checking competitions in teams from BD -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(false);
}
}
public int GetTeamsNumber()
{
int nTeams = 0;
try
{
using (var db = new SpeedOddsContext())
{
nTeams = db.Teams.Count();
}
}
catch (Exception ex)
{
Console.WriteLine("Error counting teams -> " + ex.ToString());
Console.WriteLine(ex.Message);
}
return(nTeams);
}
public int GetCompetitionsNumber()
{
int nCompetitions = 0;
try
{
using (var db = new SpeedOddsContext())
{
nCompetitions = db.Competitions.Count();
}
}
catch (Exception ex)
{
Console.WriteLine("Error counting competitions -> " + ex.ToString());
Console.WriteLine(ex.Message);
}
return(nCompetitions);
}
public Tuple <IEnumerable <Team>, int> GetFilteredTeams(string filterVal, int?compId, bool?isFav)
{
try
{
using (var db = new SpeedOddsContext())
{
var query = db.Teams.OrderBy(x => x.Name).ThenBy(x => x.CreateDate).ToList();
if (!String.IsNullOrWhiteSpace(filterVal))
{
query = query.Where(x => x.Name.IndexOf(filterVal, StringComparison.OrdinalIgnoreCase) != -1).ToList();
}
if (compId.HasValue)
{
query = query.Where(x => x.CompetitionId == compId.Value).ToList();
}
if (isFav.HasValue)
{
query = query.Where(x => x.IsFavorite == isFav.Value).ToList();
}
if (query != null)
{
return(new Tuple <IEnumerable <Team>, int>(query, query.Count()));
}
else
{
return(null);
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error getting filtered Teams from BD -> " + ex.ToString());
Console.WriteLine(ex.Message);
return(null);
}
}
public string GetTeamName(int teamId)
{
try
{
using (var db = new SpeedOddsContext())
{
var team = db.Teams.Where(x => x.TeamId == teamId).FirstOrDefault();
if (team != null)
{
return(team.Name);
}
return("");
}
}
catch (Exception ex)
{
Console.WriteLine("Error getting team from BD -> " + ex.ToString());
Console.WriteLine(ex.Message);
return("");
}
}
public string GetSeasonName(int seasonId)
{
string output = "";
try
{
using (var db = new SpeedOddsContext())
{
var season = db.Seasons.Where(x => x.SeasonId == seasonId).FirstOrDefault();
if (season != null)
{
output = season.Name;
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error getting season name from BD -> " + ex.ToString());
Console.WriteLine(ex.Message);
}
return(output);
}
public string GetCompetitionName(int competitionId)
{
string output = "";
try
{
using (var db = new SpeedOddsContext())
{
var comp = db.Competitions.Where(x => x.CompetitionId == competitionId).FirstOrDefault();
if (comp != null)
{
output = comp.Name;
}
}
}
catch (Exception ex)
{
Console.WriteLine("Error getting competition name from BD -> " + ex.ToString());
Console.WriteLine(ex.Message);
}
return(output);
}
