public static List <YouTubePage> GetAll()
{
List <YouTubePage> allYouTubePages = new List <YouTubePage> {
};
MySqlConnection conn = DB.Connection();
conn.Open();
MySqlCommand cmd = conn.CreateCommand() as MySqlCommand;
cmd.CommandText = @"SELECT * FROM youtubepages;";
MySqlDataReader rdr = cmd.ExecuteReader() as MySqlDataReader;
while (rdr.Read())
{
int itemId = rdr.GetInt32(0);
string itemTitle = rdr.GetString(1);
string itemDescription = rdr.GetString(2);
string itemLink = rdr.GetString(3);
YouTubePage newYouTubePage = new YouTubePage(itemTitle, itemDescription, itemLink, itemId);
allYouTubePages.Add(newYouTubePage);
}
conn.Close();
if (conn != null)
{
conn.Dispose();
}
return(allYouTubePages);
}
public override bool Equals(System.Object otherYouTubePage)
{
if (!(otherYouTubePage is YouTubePage))
{
return(false);
}
else
{
YouTubePage newYouTubePage = (YouTubePage)otherYouTubePage;
bool idEquality = (this.Id == newYouTubePage.Id);
bool descriptionEquality = (this.Description == newYouTubePage.Description);
bool titleEquality = (this.Title == newYouTubePage.Title);
bool linkEquality = (this.Link == newYouTubePage.Link);
return(idEquality && descriptionEquality && titleEquality && linkEquality);
}
}
public void AddYouTubePage(YouTubePage YouTubePage)
{
YouTubePages.Add(YouTubePage);
}
public static YouTubePage Find(int searchId)
{
YouTubePage placeholderYouTubePage = new YouTubePage("placeholder item", "other thhing", "other thing");
return(placeholderYouTubePage);
}