public static DataTable GetVideos()
{
var sql = "SELECT * FROM Arsenal_Video ORDER BY GoalYear DESC, GoalRank DESC, TeamworkRank DESC";
var ds = SqlHelper.ExecuteDataset(SQLConn.GetConnection(), CommandType.Text, sql);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
return(ds.Tables[0]);
}
public static DataTable GetPlayers()
{
var sql = "SELECT * FROM Arsenal_Player ORDER BY IsLegend, IsLoan, SquadNumber, LastName";
var ds = SqlHelper.ExecuteDataset(SQLConn.GetConnection(), CommandType.Text, sql);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
return(ds.Tables[0]);
}
public static DataTable GetMatches()
{
var sql = "SELECT * FROM Arsenal_Match ORDER BY PlayTime DESC";
var ds = SqlHelper.ExecuteDataset(SQLConn.GetConnection(), CommandType.Text, sql);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
return(ds.Tables[0]);
}
//public static DataRow GetTeamByID(Guid teamGuid)
//{
// string sql = "SELECT * FROM dbo.Arsenal_Team WHERE TeamGuid = @guid";
// DataSet ds = SqlHelper.ExecuteDataset(SQLConn.GetConnection(), CommandType.Text, sql, new SqlParameter("@guid", teamGuid));
// if (ds.Tables[0].Rows.Count == 0)
// return null;
// else
// return ds.Tables[0].Rows[0];
//}
public static DataTable GetTeams()
{
var sql = "SELECT * FROM Arsenal_Team ORDER BY TeamEnglishName";
var ds = SqlHelper.ExecuteDataset(SQLConn.GetConnection(), CommandType.Text, sql);
if (ds.Tables[0].Rows.Count == 0)
{
return(null);
}
return(ds.Tables[0]);
}
public static bool ExistRelationLeagueTeam(Guid teamGuid, Guid leagueGuid)
{
var sql = "SELECT * FROM Arsenal_RelationLeagueTeam WHERE TeamGuid = @teamGuid AND LeagueGuid = @leagueGuid";
SqlParameter[] para =
{
new SqlParameter("@teamGuid", teamGuid),
new SqlParameter("@leagueGuid", leagueGuid)
};
var ds = SqlHelper.ExecuteDataset(SQLConn.GetConnection(), CommandType.Text, sql, para);
return(ds.Tables[0].Rows.Count > 0);
}