public LyricsCreateResponse Create(RecordCreateRequest request)
{
var response = new LyricsCreateResponse();
var signedURL = GeneratePreSignedURL(request.File, request.ContentType); //get signedURL to update resumeUrl in S3
var slicedUrl = SignedUrlWithNoExpire(request.File);
using (var conn = new SqlConnection(connString))
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = "S3Audio_Insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", request.UserId);
cmd.Parameters.AddWithValue("@BeatUrl", request.BeatUrl);
cmd.Parameters.AddWithValue("@S3SignedUrl", slicedUrl);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
response.LyricId = Convert.ToInt32(reader["AudioId"]);
response.SignedUrl = signedURL;
}
reader.Close();
}
conn.Close();
}
return(response);
}
public LyricsCreateResponse Create(LyricsCreateRequest request)
{
var response = new LyricsCreateResponse();
var slicedUrl = SignedUrlWithNoExpire(request.File);
var sqlService = new SqlService();
sqlService.AddParameter("@Lyrics", request.Lyrics);
sqlService.AddParameter("@Votes", 0);
sqlService.AddParameter("@UserId", request.UserId);
sqlService.AddParameter("@S3SignedUrl", slicedUrl);
sqlService.AddParameter("@BeatId", request.BeatId);
int id = Convert.ToInt32(sqlService.ExecuteScalar("Lyrics_Insert"));
var signedURL = GeneratePreSignedURL(id.ToString(), request.ContentType); //get signedURL to update resumeUrl in S3
response.LyricId = id;
response.SignedUrl = signedURL;
return(response);
}
