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 Record CreateRecord(string domainId, string subDomain, string value)
{
if (string.IsNullOrWhiteSpace(domainId))
{
throw new ArgumentNullException("domainId");
}
if (string.IsNullOrWhiteSpace(subDomain))
{
throw new ArgumentNullException("subDomain");
}
if (string.IsNullOrWhiteSpace(value))
{
throw new ArgumentNullException("value");
}
return(httpCacheClient.GetCacheData(() => {
Logger.Write("Call API:RecordCreateRequest");
RecordCreateRequest request = new RecordCreateRequest();
request.Email = email;
request.Password = password;
request.DomainId = domainId;
request.SubDomain = subDomain;
request.Value = value;
request.RecordLine = "默认";
request.RecordType = "A";
var response = request.Execute();
Logger.Write("API Complete:RecordCreateRequest");
return response.Record;
}, string.Format("record_{0}_{1}", domainId, subDomain), TimeSpan.FromDays(1)));
}
//=========================== CREATE/POST ===========================================
public async Task <AirtableCreateUpdateReplaceRecordResponse> Create(RecordCreateRequest req)
{
using (AirtableBase airtableBase = new AirtableBase(appKey, baseId))
{
var fields = new Fields();
fields.AddField("Title", req.Title);
fields.AddField("Priority", req.Priority);
fields.AddField("Status", req.Status);
fields.AddField("Due Date", req.DueDate);
AirtableCreateUpdateReplaceRecordResponse response = await airtableBase.CreateRecord(tableName, fields, true);
if (!response.Success)
{
if (response.AirtableApiError is AirtableApiException)
{
errorMessage = response.AirtableApiError.ErrorMessage;
}
else
{
errorMessage = "Unknown error";
}
// Report errorMessage
}
else
{
// Do something with your created record.
Console.WriteLine("ok");
}
return(response);
}
}
public async Task <HttpResponseMessage> Create(RecordCreateRequest req)
{
if (req == null)
{
ModelState.AddModelError("", "You did not add any body data");
}
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
AirtableCreateUpdateReplaceRecordResponse id = await airtableService.Create(req);
return(Request.CreateResponse(HttpStatusCode.OK, id));
}
/// <summary>
/// Method to create a new records and specify options for it later.
/// </summary>
/// <returns></returns>
public RecordCreateRequest CreateRequest()
{
createRequest = new RecordCreateRequest(this);
return(createRequest);
}