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