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