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