public string UpdateLeague(League _league)
{
using (SPORT_LINK_DBDataContext db = new SPORT_LINK_DBDataContext())
{
try
{
var query = (from res in db.LEAGUEs where res.League_Id.Equals(_league.ID) select res);
if (query.Count() != 0)
{
LEAGUE toinsert = query.Single();
toinsert.Name = _league.Name;
toinsert.WinningPrice = _league.Price;
toinsert.Description = _league.Desc;
toinsert.sDate = _league.sDate;
toinsert.eDate = _league.eDate;
db.SubmitChanges();
return("success");
}
else
{
return("failed: No Such team exist");
}
}
catch (Exception)
{
return("failed");
}
};
}
public bool CreateLeagueTeams(Team _teams)
{
try
{
using (SPORT_LINK_DBDataContext db = new SPORT_LINK_DBDataContext())
{
var query = from team in db.SPORTs where team.Name.ToLower().Equals(_teams.Name.ToLower()) select team;
SPORT teams = new SPORT();
LEAGUE leagues = new LEAGUE();
if (query.Count() != 0)
{
teams = query.Single();
var leagueQuery = from league in db.LEAGUEs where league.Name.ToLower().Equals(_teams.LeagueName.ToLower()) select league;
if (leagueQuery.Count() != 0)
{
leagues = leagueQuery.Single();
var insertQuery = from team in db.SPORT_LEAGUEs
where team.League_Id.Equals(leagues.League_Id) &&
team.Sport_Id.Equals(teams.Sport_Id)
select team;
if (insertQuery.Count() == 0) //Insert to DB
{
SPORT_LEAGUE toinsert = new SPORT_LEAGUE();
toinsert.League_Id = leagues.League_Id;
toinsert.Sport_Id = teams.Sport_Id;
toinsert.LeagueName = leagues.Name;
toinsert.TeamName = teams.Name;
toinsert.TeamAverage = 0;
db.SPORT_LEAGUEs.InsertOnSubmit(toinsert);
db.SubmitChanges();
return(true);
}
else
{
return(false);
}
}
else
{
return(false);
}
}
else
{
return(false);
}
};
}
catch (Exception)
{
return(false);
}
}
public int CreateLeague(League _league)
{
try
{
using (SPORT_LINK_DBDataContext db = new SPORT_LINK_DBDataContext())
{
var query = (from res in db.LEAGUEs where res.UserId.Equals(_league.foreignID) && res.Name.Equals(_league.Name) select res);
if (query.Count() == 0) //AddTeam
{
LEAGUE toinsert = new LEAGUE();
toinsert.Name = _league.Name;
toinsert.WinningPrice = _league.Price;
toinsert.Description = _league.Desc;
toinsert.Category = _league.Category;
toinsert.sDate = _league.sDate;
toinsert.eDate = _league.eDate;
toinsert.UserId = _league.foreignID;
toinsert.NumTeams = _league.NumTeams;
db.LEAGUEs.InsertOnSubmit(toinsert);
db.SubmitChanges();
}
};
using (SPORT_LINK_DBDataContext db = new SPORT_LINK_DBDataContext())
{
var queryID = (from results in db.LEAGUEs where results.UserId.Equals(_league.foreignID) && results.Name.Equals(_league.Name) select results);
LEAGUE res = queryID.Single();
int ID = res.League_Id;
return(ID);
};
}
catch (Exception)
{
return(-1);
}
}
