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);
}
