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 long InsertMedia(Content media) { InitDB(); long functionResult = 0; try { Content newMedia = new Content(); newMedia.Contenttype = media.Contenttype; newMedia.Filesize = media.Filesize; newMedia.Filelocation = media.Filelocation; newMedia.Description = media.Description; newMedia.Importdate = media.Importdate; newMedia.Metadata1 = media.Metadata1; newMedia.Metadata2 = media.Metadata2; newMedia.Metadata3 = media.Metadata3; newMedia.Metadata4 = media.Metadata4; newMedia.Metadata5 = media.Metadata5; newMedia.Metadata6 = media.Metadata6; newMedia.Metadata7 = media.Metadata7; newMedia.Metadata8 = media.Metadata8; newMedia.Metadata9 = media.Metadata9; newMedia.Name = media.Name; newMedia.Snapshot = media.Snapshot; newMedia.Uploadstatus = -1; try { newMedia.Save(); //SerializeContentCollection(); functionResult = (long)newMedia.Id; } catch (Exception ex) { functionResult = 0; } } catch (Exception ex) { } 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; }