public static List <AdvertisingOldV2> LoadAdsOldV2(MySqlConnection connection) { var result = new List <AdvertisingOldV2>(); var command = connection.CreateCommand(); command.CommandText = "SELECT * FROM tvtower.tvt_werbevertraege"; var Reader = command.ExecuteReader(); try { while (Reader.Read()) { var reader = new SQLReaderOldV2(Reader); var ad = new AdvertisingOldV2(); ad.id = reader.GetInt("id"); ad.title = reader.GetString("title"); ad.titleEnglish = reader.GetString("titleEnglish"); ad.description = reader.GetString("description"); ad.descriptionEnglish = reader.GetString("descriptionEnglish"); ad.minAudience = reader.GetInt("minAudience"); ad.minImage = reader.GetInt("minImage"); ad.repetitions = reader.GetInt("repetitions"); ad.fixedPrice = reader.GetInt("fixedPrice"); ad.fixedProfit = reader.GetInt("fixedProfit"); ad.fixedPenalty = reader.GetInt("fixedPenalty"); ad.profit = reader.GetInt("profit"); ad.penalty = reader.GetInt("penalty"); ad.targetgroup = reader.GetInt("targetgroup"); ad.duration = reader.GetInt("duration"); ad.approved = reader.GetBool("approved"); ad.creatorID = reader.GetString("creatorID"); ad.editorID = reader.GetString("editorID"); ad.custom = reader.GetBool("custom"); ad.deleted = reader.GetBool("deleted"); result.Add(ad); } } finally { if (Reader != null && !Reader.IsClosed) { Reader.Close(); } } return(result); }
public AdvertisingOldV2 LoadAd(XmlNode xmlNode, bool isFake) { var result = new AdvertisingOldV2(); 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; break; case "description": result.description = movieChild.GetElementValue(); break; case "data": result.minAudience = movieChild.GetAttributeInteger("minaudience"); result.minImage = movieChild.GetAttributeInteger("minimage"); result.repetitions = movieChild.GetAttributeInteger("repetitions"); result.profit = movieChild.GetAttributeInteger("profit"); result.penalty = movieChild.GetAttributeInteger("penalty"); result.targetgroup = movieChild.GetAttributeInteger("targetgroup"); result.duration = movieChild.GetAttributeInteger("duration"); break; } } return(result); }