/// <summary>
/// Create a new MediaProrgess record
/// </summary>
/// <param name="progress"></param>
/// <returns></returns>
public async Task <MediaItemProgress> InsertMediaProgress(MediaItemProgress progress)
{
progress.Id = (await ConnectionManager.QueryAsync <int>(@"
insert into MediaItemProgress(profileId, mediaItemId, progressSecondsBegin,progressSecondsEnd, dateBegin, dateEnd)
values(@profileId, @mediaItemId, @progressSecondsBegin, @progressSecondsEnd, @dateBegin, @dateEnd);
select last_insert_id();
", progress)).FirstOrDefault();
return(progress);
}
/// <summary>
/// Replace a MediaItemProgress record in the database with the record provided
/// </summary>
/// <param name="progress"></param>
/// <returns></returns>
public async Task ReplaceMediaProgress(MediaItemProgress progress)
{
await ConnectionManager.ExecuteAsync(@"
update MediaItemProgress
set
profileId=@profileId,
mediaItemId=@mediaItemId,
progressSecondsBegin=@progressSecondsBegin,
progressSecondsEnd=@progressSecondsEnd,
dateBegin=@dateBegin,
dateEnd=@dateEnd
where id=@id
", progress);
}
