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