public void AddMediaTrack(MediaTrackerModel track) { var existsSql = string.Format("select * from mediatracker where mediaid={0} and contentid={1} and propertyid={2}", track.MediaId, track.ContentId, track.PropertyId); using (var conn = new SqlConnection(DbConnString)) { try { conn.Open(); var sqlCommand = new SqlCommand(existsSql, conn); var rdr = sqlCommand.ExecuteReader(); var exists = rdr.HasRows; rdr.Close(); if (exists) return; var insertSql = string.Format( "insert into mediatracker (mediaid,contentid,propertyid) values ({0},{1},{2})", track.MediaId, track.ContentId, track.PropertyId); var comm = new SqlCommand(insertSql, conn); comm.ExecuteNonQuery(); conn.Close(); } catch (SqlException e) { LogHelper.Error<SqlException>(e.Message, e); } } }
public void AddMediaTrack(MediaTrackerModel track) { try { var query = _context.Query<MediaTrackerModel>( string.Format("select * from MediaTracker where MediaId={0} and ContentId={1} and PropertyId={2}", track.MediaId, track.ContentId, track.PropertyId)); if (query.Any()) return; _context.Insert("MediaTracker", "Id", track); } catch (Exception ex) { LogHelper.Error<Exception>(ex.Message, ex); } }
/// <summary> /// Creates database entry for media track /// </summary> /// <param name="model">The MediaTrackerModel</param> /// <param name="content">The umbraco content item</param> /// <param name="property">The Umbraco property being tracked</param> private void CreateMediaRecord(MediaTrackerModel model, IContent content, Property property) { DbProvider.AddMediaTrack(model); if (_verbose) { var media = ApplicationContext.Current.Services.MediaService.GetById(model.MediaId); LogHelper.Info<MediaTrackerHandler>( string.Format( "The media item '{0}' is now being tracked in the property '{1}' on the page '{2}'", media.Name, property.Alias, content.Name)); } }