public HttpResponseMessage Add(JobPostingAddRequest model) { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState)); } ItemResponse <int> response = new ItemResponse <int>(); response.Item = _jobPostingService.Insert(model); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
private static void MapCommonParameters(JobPostingAddRequest model, SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@CompanyId", model.CompanyId); paramCollection.AddWithValue("@PositionName", model.PositionName); paramCollection.AddWithValue("@StreetAddress", model.StreetAddress ?? String.Empty); paramCollection.AddWithValue("@City", model.City ?? String.Empty); paramCollection.AddWithValue("@StateProvinceId", model.StateProvinceId); paramCollection.AddWithValue("@CountryId", model.CountryId); paramCollection.AddWithValue("@Compensation", model.Compensation); paramCollection.AddWithValue("@CompensationRateId", model.CompensationRateId); paramCollection.AddWithValue("@FullPartId", model.FullPartId); paramCollection.AddWithValue("@ContractPermanentId", model.ContractPermanentId); paramCollection.AddWithValue("@ExperienceLevelId", model.ExperienceLevelId); paramCollection.AddWithValue("@Description", model.Description ?? String.Empty); paramCollection.AddWithValue("@Responsibilities", model.Responsibilities ?? String.Empty); paramCollection.AddWithValue("@Requirements", model.Requirements ?? String.Empty); paramCollection.AddWithValue("@ContactInformation", model.ContactInformation ?? String.Empty); paramCollection.AddWithValue("@Latitude", model.Latitude); paramCollection.AddWithValue("@Longitude", model.Longitude); paramCollection.AddWithValue("@JobPostingStatusId", model.JobPostingStatusId); DataTable JobTagIdArray = new DataTable(); JobTagIdArray.Columns.Add("JobTagId", typeof(Int32)); if (model.JobTagIds != null) { for (int i = 0; i < model.JobTagIds.Count; i++) { JobTagIdArray.Rows.Add(model.JobTagIds[i]); } } SqlParameter JobTagIdTable = new SqlParameter(); JobTagIdTable.ParameterName = "@JobPostingJobTagIds"; JobTagIdTable.SqlDbType = System.Data.SqlDbType.Structured; JobTagIdTable.Value = JobTagIdArray; paramCollection.Add(JobTagIdTable); }
public int Insert(JobPostingAddRequest model) { int id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.JobPosting_Insert", inputParamMapper : delegate(SqlParameterCollection paramCollection) { MapCommonParameters(model, paramCollection); paramCollection.AddWithValue("@UserIdCreated", UserService.GetCurrentUserId()); SqlParameter p = new SqlParameter("@Id", SqlDbType.Int); p.Direction = ParameterDirection.Output; paramCollection.Add(p); }, returnParameters : delegate(SqlParameterCollection param) { Int32.TryParse(param["@Id"].Value.ToString(), out id); } ); return(id); }