public Boolean InsertOrUpdateTicker(Content ticker)
{
InitDB();
Boolean functionResult = false;
Content tickerFound = new Content();
Boolean updateTicker = false;
try
{
tickerFound.LoadByPrimaryKey((long)ticker.Id);
if (tickerFound.Name.Length > 0) updateTicker = true;
}
catch (Exception ex)
{
updateTicker = false;
}
if (updateTicker)
{ //update all ticker data
tickerFound.Name = ticker.Name;
tickerFound.Contenttype = ticker.Contenttype;
tickerFound.Description = ticker.Description;
tickerFound.Filelocation = "";
tickerFound.Filesize = 0;
tickerFound.Metadata1 = ticker.Metadata1;
tickerFound.Metadata2 = ticker.Metadata2;
tickerFound.Metadata3 = ticker.Metadata3;
tickerFound.Metadata4 = ticker.Metadata4;
tickerFound.Metadata5 = ticker.Metadata5;
Console.WriteLine(DateTime.Now.ToShortTimeString()+" "+"TICKER SPEED=" + ticker.Metadata5);
tickerFound.Metadata6 = ticker.Metadata6;
tickerFound.Metadata7 = ticker.Metadata7;
tickerFound.Metadata8 = ticker.Metadata8;
tickerFound.Metadata9 = ticker.Metadata9;
tickerFound.Snapshot = ticker.Snapshot;
tickerFound.Importdate = (DateTime)DateTime.Now;
tickerFound.Save();
functionResult = true;
}
else
{
//insert new tickerFound
Content newTicker = new Content();
newTicker.Name = ticker.Name;
newTicker.Description = ticker.Description;
newTicker.Contenttype = ticker.Contenttype;
newTicker.Filelocation = "";
newTicker.Filesize = 0;
newTicker.Metadata1 = ticker.Metadata1;
newTicker.Metadata2 = ticker.Metadata2;
newTicker.Metadata3 = ticker.Metadata3;
newTicker.Metadata4 = ticker.Metadata4;
newTicker.Metadata5 = ticker.Metadata5;
newTicker.Metadata6 = ticker.Metadata6;
newTicker.Metadata7 = ticker.Metadata7;
newTicker.Metadata8 = ticker.Metadata8;
newTicker.Metadata9 = ticker.Metadata9;
newTicker.Snapshot = ticker.Snapshot;
newTicker.Importdate = (DateTime)DateTime.Now;
newTicker.Save();
functionResult = true;
}
AddUpdateDelta("ticker");
return functionResult;
}
public Boolean RemoveMedia(Content _content)
{
InitDB();
try
{
Content deleteContent = new Content();
deleteContent.LoadByPrimaryKey((long)_content.Id);
deleteContent.MarkAsDeleted();
deleteContent.Save();
return true;
}
catch (Exception ex)
{
return false;
}
//SerializeContentCollection();
AddUpdateDelta("content");
}
public Boolean RemoveTicker(Content _content)
{
InitDB();
Content deleteContent = new Content();
deleteContent.LoadByPrimaryKey((long)_content.Id);
deleteContent.MarkAsDeleted();
deleteContent.Save();
AddUpdateDelta("ticker");
return true;
}
public long ChangeMedia(Content mediaName)
{
InitDB();
Template newTemplate = new Template();
Content newMedia = new Content();
newMedia.LoadByPrimaryKey((long)mediaName.Id);
newMedia.Contenttype = mediaName.Contenttype;
newMedia.Metadata1 = mediaName.Metadata1;
newMedia.Metadata2 = mediaName.Metadata2;
newMedia.Metadata3 = mediaName.Metadata3;
newMedia.Metadata4 = mediaName.Metadata4;
newMedia.Metadata5 = mediaName.Metadata5;
newMedia.Metadata6 = mediaName.Metadata6;
newMedia.Metadata7 = mediaName.Metadata7;
newMedia.Metadata8 = mediaName.Metadata8;
newMedia.Metadata9 = mediaName.Metadata9;
newMedia.Importdate = mediaName.Importdate;
newMedia.Filesize = mediaName.Filesize;
newMedia.Filelocation = mediaName.Filelocation;
newMedia.Description = mediaName.Description;
newMedia.Name = mediaName.Name;
newMedia.Snapshot = mediaName.Snapshot;
newMedia.Uploadstatus = mediaName.Uploadstatus;
long functionResult = 0;
try
{
newMedia.Save();
//SerializeContentCollection();
functionResult = (long)newMedia.Id;
}
catch (Exception ex)
{
functionResult = 0;
}
AddUpdateDelta("content");
return functionResult;
}
