public async Task <VideoComment> Insert(VideoComment videoComment)
{
#region Generate SqlParameters
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(_dbManager.CreateInputParameter("@VideoMediaID", videoComment.VideoMedia.ID));
sqlParameters.Add(_dbManager.CreateInputParameter("@Content", videoComment.Content));
sqlParameters.Add(_dbManager.CreateInputParameter("@UploadDate", videoComment.UploadDate));
SqlParameter ouputParameterId = _dbManager.CreateOutputParameter("@ID", SqlDbType.Int);
sqlParameters.Add(ouputParameterId);
#endregion
await _dbManager.Insert(storedProcedure : "usp_VideoComments_Insert", sqlParameters : sqlParameters);
videoComment.ID = (int)ouputParameterId.Value;
return(videoComment);
}
public async Task <VideoMedia> Insert(VideoMedia videoMedia)
{
#region Generate SqlParameters
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(_dbManager.CreateInputParameter("@HashedID", videoMedia.HashedID));
sqlParameters.Add(_dbManager.CreateInputParameter("@Title", videoMedia.Title));
sqlParameters.Add(_dbManager.CreateInputParameter("@Color", videoMedia.Color));
sqlParameters.Add(_dbManager.CreateInputParameter("@ThumbnailUrl", videoMedia.ThumbnailUrl));
SqlParameter ouputParameterId = _dbManager.CreateOutputParameter("@ID", SqlDbType.Int);
sqlParameters.Add(ouputParameterId);
#endregion
await _dbManager.Insert(storedProcedure : "usp_VideoMedias_Insert", sqlParameters : sqlParameters);
videoMedia.ID = (int)ouputParameterId.Value;
return(videoMedia);
}
