public Boolean RemoveCSMediaLoop(CSMedialoop medialoop) { InitDB(); try { //THIS WILL PURGE THE MEDIA FROM THE CSMEDIA TABLE medialoop.MarkAsDeleted(); medialoop.Save(); Console.WriteLine(DateTime.Now.ToShortTimeString()+" "+"Media Loop deleted ok"); } catch (Exception ex) { Console.WriteLine(DateTime.Now.ToShortTimeString()+" "+"Error deleting media loop"); return false; } return true; }
public Boolean InsertUpdateCSMediaLoop(CSMedialoop loop) { InitDB(); //Screen newScreen = new Screen(); CSMedialoop newLoop = new CSMedialoop(); try { newLoop.Query.Where( newLoop.Query.Loopname.IsNotNull() && newLoop.Query.Mediafilename.IsNotNull() && newLoop.Query.Mediafilename.ToLower().Equal(loop.Mediafilename.ToLower()) ); } catch (Exception) { } Boolean thereIsNoExistingID = false; try { if (loop.Id > 0) { thereIsNoExistingID = false; } else { thereIsNoExistingID = true; } } catch (Exception) { thereIsNoExistingID = true; } Boolean functionResult = false; try { if (newLoop.Query.Load() && thereIsNoExistingID == false) //Do an update { Console.WriteLine(DateTime.Now.ToShortTimeString()+" "+"Updating MediaLoop Item"); newLoop.Order = loop.Order; newLoop.Mediatype = loop.Mediatype; newLoop.Loopname = loop.Loopname; newLoop.Save(); functionResult = true; Console.WriteLine(DateTime.Now.ToShortTimeString()+" "+"Updated MediaLoop item OK"); } else //Do update { Console.WriteLine(DateTime.Now.ToShortTimeString()+" "+"Inserting New MediaLoop Item"); newLoop = new CSMedialoop(); newLoop.Mediatype = loop.Mediatype; newLoop.Mediafilename = loop.Mediafilename; newLoop.Order = loop.Order; newLoop.Loopname = loop.Loopname; newLoop.Save(); functionResult = true; Console.WriteLine(DateTime.Now.ToShortTimeString()+" "+"Inserting New MediaLoop Item OK"); } } catch (Exception ex) { Console.WriteLine(DateTime.Now.ToShortTimeString()+" "+"Error during MediaLoop Item insert/update:"); Console.WriteLine(DateTime.Now.ToShortTimeString()+" "+"Message: " + ex.Message); functionResult = false; } return functionResult; }