public HttpResponseMessage JobEdit(JobUpdateRequest model, int id) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } model.Id = id; bool isSuccessful = _JobsService.UpdateJob(model); ItemResponse <bool> response = new ItemResponse <bool>(); response.Item = isSuccessful; //Activity Log Service ActivityLogRequest Activity = new ActivityLogRequest(); Activity.ActivityType = ActivityTypeId.JobUpdated; Activity.JobId = id; Activity.TargetValue = (int)JobStatus.BringgCreated; _ActivityLogService.InsertActivityToLog(model.UserId, Activity); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public bool UpdateJob(JobUpdateRequest model) { bool success = false; DataProvider.ExecuteNonQuery(GetConnection, "dbo.Jobs_Update" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Id", model.Id); paramCollection.AddWithValue("@UserId", model.UserId); paramCollection.AddWithValue("@Status", model.Status); paramCollection.AddWithValue("@JobType", model.JobType); paramCollection.AddWithValue("@Price", model.Price); paramCollection.AddWithValue("@JobRequest", model.JobRequest); paramCollection.AddWithValue("@ContactName", model.ContactName); paramCollection.AddWithValue("@Phone", model.Phone); paramCollection.AddWithValue("@SpecialInstructions", model.SpecialInstructions); paramCollection.AddWithValue("@WebsiteId", model.WebsiteId); paramCollection.AddWithValue("@ExternalJobId", model.ExternalJobId); paramCollection.AddWithValue("@ExternalCustomerId", model.ExternalCustomerId); paramCollection.AddWithValue("@PaymentNonce", model.PaymentNonce); paramCollection.AddWithValue("@BillingId", model.BillingId); }, returnParameters : delegate(SqlParameterCollection param) { success = true; }); return(success); }
public HttpResponseMessage JobEdit(JobUpdateRequest model, int id) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } model.Id = id; //JobsService jobService = new JobsService(); //can you do a get and update the payment nonce in here - you will have the job ID bool isSuccessful = _JobsService.UpdateJob(model); ItemResponse <bool> response = new ItemResponse <bool>(); response.Item = isSuccessful; //Activity Log Service - Needs to be fixed - the value for model.UserId is null ActivityLogRequest Activity = new ActivityLogRequest(); Activity.ActivityType = ActivityTypeId.JobUpdated; Activity.JobId = id; Activity.TargetValue = (int)JobStatus.BringgCreated; _ActivityLogService.InsertActivityToLog(model.UserId, Activity); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public HttpResponseMessage Update(JobUpdateRequest req) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } jobsService.Update(req); return(Request.CreateResponse(HttpStatusCode.OK, "Updated")); }
public void Update(JobUpdateRequest model) { string procName = "[dbo].[Openings_Update]"; _data.ExecuteNonQuery(procName, inputParamMapper : delegate(SqlParameterCollection col) { CommonParams(model, col); col.AddWithValue("@Id", model.Id); }, returnParameters: null); }
public void Update(JobUpdateRequest request, int userId) { string procname = "[dbo].[Jobs_Update_V2]"; _data.ExecuteNonQuery(procname , delegate(SqlParameterCollection inputCollection) { JobAddInputs(request, inputCollection); inputCollection.AddWithValue("@Id", request.Id); inputCollection.AddWithValue("@UserId", userId); }, null ); }
public HttpResponseMessage PaymentNonce(JobUpdateRequest model, int id) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } model.Id = id; bool isSuccessful = JobsService.UpdatePaymentNonce(model); ItemResponse <bool> response = new ItemResponse <bool>(); response.Item = isSuccessful; return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public HttpResponseMessage GuestPayment(CustomerPaymentRequest model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } string paymentNonce; try { paymentNonce = _BrainTreeService.GuestPayment(model); } catch (ArgumentException ex) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ex.Message)); } JobUpdateRequest jobUpdate = new JobUpdateRequest { Id = model.JobId, Phone = model.Phone, ContactName = string.Format("{0} {1}", model.FirstName, model.LastName), PaymentNonce = paymentNonce }; ActivityLogRequest Activity = new ActivityLogRequest { ActivityType = ActivityTypeId.CreatedJob, JobId = model.JobId, TargetValue = (int)JobStatus.BringgCreated }; //For guest check out we use the phone number as the userID _ActivityLogService.InsertActivityToLog(model.Phone, Activity); bool isSuccessful = _JobsService.UpdateJob(jobUpdate); ItemResponse <bool> response = new ItemResponse <bool>(); response.Item = isSuccessful; return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public ActionResult <SuccessResponse> Update(JobUpdateRequest model) { int code = 200; BaseResponse response = null; try { _service.Update(model); response = new SuccessResponse(); } catch (Exception ex) { response = new ErrorResponse($"Exception: ${ex.Message}"); } return(StatusCode(code, response)); }
public void Update(JobUpdateRequest req) { using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); SqlCommand cmd = new SqlWrapper().Wrapper("Jobs_update", con); cmd.Parameters.AddWithValue("@id", req.Id); cmd.Parameters.AddWithValue("@job_id", req.JobId); cmd.Parameters.AddWithValue("@title", req.Title); cmd.Parameters.AddWithValue("@url", req.Url); cmd.Parameters.AddWithValue("@company", req.Company); cmd.Parameters.AddWithValue("@description", req.Description); cmd.Parameters.AddWithValue("@location", req.Location); cmd.Parameters.AddWithValue("@date_applied", req.DateApplied); cmd.Parameters.AddWithValue("@archived", req.Archived); cmd.Parameters.AddWithValue("@quick_apply", req.QuickApply); cmd.ExecuteNonQuery(); } }
public ActionResult <SuccessResponse> Update(JobUpdateRequest model) { int responseCode = 200; BaseResponse responseData = null; try { _service.Update(model, _authService.GetCurrentUserId()); responseData = new SuccessResponse(); } catch (Exception exception) { responseCode = 500; responseData = new ErrorResponse(exception.Message); base.Logger.LogError(exception.ToString()); } return(StatusCode(responseCode, responseData)); }
public void Update(JobUpdateRequest req) { using (SqlConnection con = new SqlConnection(connectionString)) { con.Open(); SqlCommand cmd = ConnectionWrapper("Jobs_update", con); cmd.Parameters.AddWithValue("@id", req.Id); cmd.Parameters.AddWithValue("@title", req.Title); cmd.Parameters.AddWithValue("@link", req.Link); cmd.Parameters.AddWithValue("@company", req.Company); cmd.Parameters.AddWithValue("@description", req.Description); cmd.Parameters.AddWithValue("@location", req.Location); cmd.Parameters.AddWithValue("@post_date", req.PostDate); cmd.Parameters.AddWithValue("@date_applied", req.DateApplied ?? (object)DBNull.Value); cmd.Parameters.AddWithValue("@archived", req.Archived); cmd.ExecuteNonQuery(); } }