public Boolean ApplyLoopContentCollection(LoopContentCollection contentForZone)
{
InitDB();
try
{
LoopContentCollection lcc = new LoopContentCollection();
lcc.LoadAll();
foreach (var item in lcc)
{
foreach (var zoneitem in contentForZone)
{
if (zoneitem.Loopid == item.Loopid && zoneitem.Zoneid == item.Zoneid)
{
LoopContent lc = new LoopContent();
lc.LoadByPrimaryKey((Int32)item.Id);
lc.MarkAsDeleted();
lc.Save();
}
}
}
foreach (LoopContent item in contentForZone)
{
Console.WriteLine(DateTime.Now.ToShortTimeString()+" "+"--> "+item.Medianame);
LoopContent nlc = new LoopContent();
nlc.Mediaid = item.Mediaid;
nlc.Medianame = item.Medianame;
nlc.Loopname = item.Loopname;
nlc.Loopid = item.Loopid;
nlc.Zoneid = item.Zoneid;
nlc.Zonename = item.Zonename;
nlc.Templateid = item.Templateid;
nlc.Templatename = item.Templatename;
nlc.Order = item.Order;
nlc.Save();
}
}
catch (Exception ex)
{
Console.WriteLine(DateTime.Now.ToShortTimeString()+" "+ex.Message);
}
//SerializeLoopContentCollection();
AddUpdateDelta("loop");
return true;
}
private void SerializeLoopContentCollection()
{
try
{
LoopContentCollection loopcc = new LoopContentCollection();
loopcc.LoadAll();
LoopContent[] arrOfLoopContent = loopcc.ToArray();
string FileName = @"c:\content\media\xml\allloopcontent.xml";
using (FileStream fs = new FileStream(FileName, FileMode.Create))
{
XmlSerializer ser = new XmlSerializer(typeof(LoopContent[]));
ser.Serialize(fs, arrOfLoopContent);
fs.Flush();
fs.Close();
}
}
catch (Exception ex)
{
}
}