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