public Result UpdateCriterion(JobListingCriteriaEntity criterion)
/*
* Update one Answer entry
* Currently a wrapper of insert Answer as they can do both at once.
*/
{
Result result = new Result();
//TODO:
try
{
result = InsertCriterion(criterion);
return(result);
}
catch (Exception ex)
{
Logger.Log(ex);
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
public HttpResponseMessage PutCriteria_V1([FromBody] ListingCriteriaModel listingCriteriaModel)
{
var result = new Result();
//Employer vertification
object objemployer = null;
Request.Properties.TryGetValue("employer", out objemployer);
if (objemployer == null)
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, new Result(false)));
}
var employer = objemployer as EmployerEntity;
if (employer.EmployerId != listingCriteriaModel.EmmployerId)
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized, new Result(false)));
}
var timestamp = DateTime.Now;
var ListingCriteria = new List <JobListingCriteriaEntity>();
foreach (KeyValuePair <int, AnswerEntity> entry in listingCriteriaModel.Answers)
{
int aspectId = entry.Key;
AnswerEntity answer = entry.Value;
var listingCriterion = new JobListingCriteriaEntity();
listingCriterion.AspectId = aspectId;
listingCriterion.QuestionId = answer.QuestionId;
listingCriterion.AnswerId = answer.AnswerId;
listingCriterion.Value = answer.Value;
listingCriterion.LastUpdate = timestamp;
listingCriterion.JobListingId = listingCriteriaModel.JobListingId;
ListingCriteria.Add(listingCriterion);
}
result = _jobListingCriteriaManager.InsertCriteria(ListingCriteria);
if (!result.Success)
{
return(Request.CreateResponse(HttpStatusCode.BadRequest, result));
}
result.Message = " Criteria updated successfully";
return(Request.CreateResponse(HttpStatusCode.OK, result));
}
public Result InsertCriterion(JobListingCriteriaEntity criterion)
/*
* Insert one answer (one aspect) into the database
*
*/
{
Result result = new Result();
//TODO:
try
{
var con = new DapperConnectionManager();
var query = new QueryEntity();
if (criterion == null)
{
result = null;
result.Success = false;
result.Message = "Login error";
return(result);
}
query.Entity = criterion;
/* query.Entity = new { UserId = userId,
* AspectId = answer.AspectId,
* // AnswerId = answer.AnswerId,
* Value = answer.Value
*
* };*/
// check if there is any records exist if yes, update, else, insert
// Assume that Listing ID and AspectID are enforced at the controller
query.Query = @"
BEGIN TRAN
IF EXISTS (SELECT * FROM dbo.JobListingCriteria WHERE JobListingId = @JobListingId and AspectId = @AspectId )
BEGIN
UPDATE dbo.JobListingCriteria SET Value = @Value , QuestionId = @QuestionId, AnswerId = @AnswerId , LastUpdate= @LastUpdate
WHERE JobListingId = @JobListingId and AspectId = @AspectId
END
ELSE
BEGIN
INSERT INTO dbo.JobListingCriteria (JobListingId, AspectId, Value, QuestionId, AnswerId, LastUpdate )
VALUES(@JobListingId, @AspectId, @Value, @QuestionId, @AnswerId, @LastUpdate)
END
COMMIT TRAN
";
result = con.ExecuteQuery <UsersQuizzesEntity>(query);
return(result);
}
catch (Exception ex)
{
Logger.Log(ex);
result.Success = false;
result.Message = ex.Message;
}
return(result);
}
