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