public void SetRotation(string strPicture, int iRotation) { // Continue only if it's a picture files if (!Util.Utils.IsPicture(strPicture)) { return; } string strSQL = ""; try { string strPic = strPicture; DatabaseUtility.RemoveInvalidChars(ref strPic); long lPicId = AddPicture(strPicture, iRotation); if (lPicId >= 0) { strSQL = String.Format("update tblPicture set iRotation={0} where strFile like '{1}'", iRotation, strPic); SqlServerUtility.ExecuteNonQuery(_connection, strSQL); } } catch (Exception ex) { Log.Error("MediaPortal.Picture.Database exception err:{0} stack:{1}", ex.Message, ex.StackTrace); } }
public void DeletePicture(string strPicture) { string strSQL = ""; try { string strPic = strPicture; DatabaseUtility.RemoveInvalidChars(ref strPic); strSQL = String.Format("delete from tblPicture where strFile like '{0}'", strPic); SqlServerUtility.ExecuteNonQuery(_connection, strSQL); } catch (Exception ex) { Log.Error("MediaPortal.Picture.Database exception deleting picture err:{0} stack:{1}", ex.Message, ex.StackTrace); } }
public void DeleteFolderSetting(string path, string Key, bool withPath) { if (path == null) { return; } if (path == string.Empty) { return; } if (Key == null) { return; } if (Key == string.Empty) { return; } try { string pathFiltered = Utils.RemoveTrailingSlash(path); string keyFiltered = Key; DatabaseUtility.RemoveInvalidChars(ref pathFiltered); DatabaseUtility.RemoveInvalidChars(ref keyFiltered); int PathId = AddPath(pathFiltered); if (PathId < 0) { return; } string strSQL = String.Format("delete from tblFolderSetting where idPath={0} and tagName ='{1}'", PathId, keyFiltered); SqlServerUtility.ExecuteNonQuery(_connection, strSQL); if (withPath) { strSQL = String.Format("delete from tblPath where idPath={0}", PathId); SqlServerUtility.ExecuteNonQuery(_connection, strSQL); } } catch (Exception ex) { Log.Error(ex); } }