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