public static int CreateSubmission(SubmissionCreateRequest application)
{
int id;
string connectionString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand command = new SqlCommand("dbo.Submission_Insert", connection))
{
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameterCollection parameterCollection = command.Parameters;
parameterCollection.AddWithValue("@ListingId", application.ListingId);
parameterCollection.AddWithValue("@SeekerId", application.SeekerId);
parameterCollection.AddWithValue("@ResumeUrl", application.ResumeUrl);
parameterCollection.AddWithValue("@videoUrl", application.VideoUrl);
SqlParameter idParameter = new SqlParameter("@SubmissionId", SqlDbType.Int);
idParameter.Direction = ParameterDirection.Output;
parameterCollection.Add(idParameter);
connection.Open();
command.ExecuteNonQuery();
int.TryParse(idParameter.Value.ToString(), out id);
}
}
return(id);
}
public HttpResponseMessage CreateSubmission(SubmissionCreateRequest submission)
{
ItemResponse <int> response = new ItemResponse <int>();
response.Item = SubmissionService.CreateSubmission(submission);
return(Request.CreateResponse(HttpStatusCode.OK, response));
}
