public NewsOldV2 LoadNewsBase(XmlNode xmlNode, bool isFake) { var result = new NewsOldV2(); result.id = TempIdCounter++; foreach (XmlLinkedNode movieChild in xmlNode.ChildNodes) { switch (movieChild.Name) { case "title": //if ( isFake ) // result.titleFake = movieChild.GetElementValue(); //else result.title = movieChild.GetElementValue(); break; case "description": result.description = movieChild.GetElementValue(); break; case "data": result.genre = movieChild.GetAttributeInteger("genre"); result.price = movieChild.GetAttributeInteger("price"); result.topicality = movieChild.GetAttributeInteger("topicality"); break; } } return(result); }
public List <NewsOldV2> LoadNews(XmlNode xmlNode, bool isFake) { var result = new List <NewsOldV2>(); NewsOldV2 currentNews = LoadNewsBase(xmlNode, isFake); result.Add(currentNews); foreach (XmlLinkedNode movieChild in xmlNode.ChildNodes) { switch (movieChild.Name) { case "episode": var episode = LoadNewsBase(movieChild, isFake); episode.episode = movieChild.GetAttributeInteger("number"); episode.parentID = currentNews.id; result.Add(episode); break; } } return(result); }
public static List <NewsOldV2> LoadNewsOldV2(MySqlConnection connection) { var result = new List <NewsOldV2>(); var command = connection.CreateCommand(); command.CommandText = "SELECT * FROM tvtower.tvt_nachrichten"; var Reader = command.ExecuteReader(); try { while (Reader.Read()) { var reader = new SQLReaderOldV2(Reader); var news = new NewsOldV2(); news.id = reader.GetInt("id"); //news.title = reader.GetString("title"); //news.titleEnglish = reader.GetString("titleEnglish"); //news.description = reader.GetString("description"); //news.descriptionEnglish = reader.GetString("descriptionEnglish"); news.genre = reader.GetInt("genre"); news.price = reader.GetInt("price"); news.topicality = reader.GetInt("topicality"); news.parentID = reader.GetInt("parentID"); news.approved = reader.GetBool("approved"); news.creatorID = reader.GetString("creatorID"); news.editorID = reader.GetString("editorID"); news.episode = reader.GetInt("episode"); result.Add(news); } } finally { if (Reader != null && !Reader.IsClosed) { Reader.Close(); } } command = connection.CreateCommand(); command.CommandText = "SELECT * FROM tvtower.tvt_nachrichten_lang"; Reader = command.ExecuteReader(); try { while (Reader.Read()) { var reader = new SQLReaderOldV2(Reader); var id = reader.GetInt("news_id"); var news = result.FirstOrDefault(x => x.id == id); if (news != null) { news.title = reader.GetString("title"); news.description = reader.GetString("text"); } } } finally { if (Reader != null && !Reader.IsClosed) { Reader.Close(); } } return(result); }