public HttpResponseMessage Create(JobsCreateModel model) { if (model == null) { ModelState.AddModelError("", "You did not send any data!"); } if (!ModelState.IsValid) { return(Request.CreateErrorResponse( HttpStatusCode.BadRequest, ModelState )); } IJobsService jobsService = new JobsService(); int id = jobsService.Create(model); return(Request.CreateResponse(HttpStatusCode.Created, id)); }
public int Create(JobsCreateModel model) { using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); SqlCommand cmd = con.CreateCommand(); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "JobsTable_Create"; cmd.Parameters.AddWithValue("@Company", model.Company); cmd.Parameters.AddWithValue("@Position", model.Position); cmd.Parameters.AddWithValue("@DateApplied", model.DateApplied); cmd.Parameters.AddWithValue("@Website", model.Website); cmd.Parameters.AddWithValue("@FollowUp", model.FollowUp); cmd.Parameters.Add("@Id", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); return((int)cmd.Parameters["@Id"].Value); } }
int Create(JobsCreateModel model);