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));
}
}
