public CoubDto FormatCoubLinks(CoubDto coubDto)
{
var result = new CoubDto
{
Id = coubDto.Id
};
if (coubDto.VideoLink != null)
result.VideoLink = FormatVideoLink(coubDto.VideoLink);
if (coubDto.AudioLink != null)
result.AudioLink = FormatAudioLink(coubDto.AudioLink);
if (coubDto.ImageLink != null)
result.ImageLink = FormatImageLink(coubDto.ImageLink);
return result;
}
public void InsertCoub(CoubDto dto)
{
const string idParam = "@IdParam";
const string audioLinkParam = "@AudioLinkParam";
const string videoLinkParam = "@VideoLinkParam";
const string imageLinkParam = "@ImageLinkParam";
const string queryTemplate = @"INSERT INTO [Coub] (Id, AudioLink, VideoLink, ImageLink) VALUES ({0}, {1}, {2}, {3});";
var query = string.Format(queryTemplate, idParam, audioLinkParam, videoLinkParam, imageLinkParam);
using (var dbConnection = new SqlConnection(ConnectionString))
{
var parameters = new DynamicParameters();
parameters.Add(idParam, dto.Id, DbType.AnsiString);
parameters.Add(audioLinkParam, dto.AudioLink, DbType.AnsiString);
parameters.Add(videoLinkParam, dto.VideoLink, DbType.AnsiString);
parameters.Add(imageLinkParam, dto.ImageLink, DbType.AnsiString);
dbConnection.Execute(query, parameters);
}
}
public CoubDto FormatCoubLinks(CoubDto coubDto)
{
return coubDto;
}
