public static List<Card> GetAllCards()
{
String query = "SELECT * FROM cards;";
DBCore dbconnection = new DBCore();
DataTable dtCards = dbconnection.ExecuteQuery(query);
return ConvertTableToList(dtCards);
}
public static List<Keyword> GetLatestKeywords()
{
String query = "SELECT id, name, text, hasxvalue, guid, version FROM keywordabilities AS allkeywords WHERE version in (SELECT MAX(version) FROM keywordabilities WHERE guid = allkeywords.guid);";
DBCore dbconnection = new DBCore();
DataTable dtResults = dbconnection.ExecuteQuery(query);
return ConvertTableToKeywordList(dtResults);
}
public static List<Keyword> GetAllVersionsofKeyword(string keywordID)
{
String query = String.Format("SELECT id, name, text, hasxvalue, guid, version FROM keywordabilities WHERE guid = '{0}';", keywordID);
DBCore dbconnection = new DBCore();
DataTable dtResults = dbconnection.ExecuteQuery(query);
return ConvertTableToKeywordList(dtResults);
}
public static List<KeywordInstance> GetAbilitiesForCard(int cardID)
{
String query = "SELECT id, name, text, hasxvalue, guid, version, xvalue FROM keywordabilites INNER JOIN cardabilities WHERE id IN (SELECT keywordid FROM cardabilities WHERE cardid = {0});";
DBCore dbconnection = new DBCore();
DataTable dtResults = dbconnection.ExecuteQuery(query);
return ConvertTableToInstanceList(dtResults);
}
public static List<Card> GetAllLatestCards()
{
String query = @"SELECT * FROM cards AS allcards
WHERE version = (SELECT MAX(version) FROM cards WHERE guid = allcards.guid);";
DBCore dbconnection = new DBCore();
DataTable dtCards = dbconnection.ExecuteQuery(query);
return ConvertTableToList(dtCards);
}
public static List<Card> GetAllVersionsFromGUID(String guid)
{
String query = "SELECT * FROM cards WHERE guid={0} ORDER BY version ASC;";
DBCore dbConnection = new DBCore();
DataTable dtResult = dbConnection.ExecuteQuery(query);
List<Card> allVersions = new List<Card>();
foreach (DataRow cardRow in dtResult.Rows)
{
allVersions.Add(ConvertRowToCard(cardRow));
}
return allVersions;
}
public static Card GetLatestVersionFromGUID(String id)
{
String query = String.Format("SELECT * FROM cards WHERE guid='{0}' AND version in (SELECT MAX(version) FROM cards WHERE guid='{0}');", id);
DBCore dbConnection = new DBCore();
DataTable dtResult = dbConnection.ExecuteQuery(query);
if (dtResult == null || dtResult.Rows.Count == 0)
{
return null;
}
else
{
return ConvertRowToCard(dtResult.Rows[0]);
}
}
public static Keyword GetLatestVersionofKeywordbyID(string keywordID)
{
String query = "SELECT id, name, text, hasxvalue, guid, version FROM keywordabilities AS allkeywords WHERE id = '{0}' AND version in (SELECT MAX(version) FROM keywordabilities WHERE guid = allkeywords.guid);";
DBCore dbconnection = new DBCore();
DataTable dtResults = dbconnection.ExecuteQuery(query);
List<Keyword> results = ConvertTableToKeywordList(dtResults);
if (results == null || results.Count == 0)
{
return null;
}
else
{
return results[0];
}
}