public HttpResponseMessage PostAnswerQuestion([FromBody] AnswersQuestion answerquestion)
{
string jsonResponseText;
try
{
if (ModelState.IsValid)
{
var existingItem = _db.AnswersQuestions
.FirstOrDefault(x => x.QuestionID == answerquestion.QuestionID &&
x.AnswerID == answerquestion.AnswerID);
if (existingItem != null)
{
//item already exists we will simply update it
existingItem.Value = answerquestion.Value;
existingItem.Status = answerquestion.Status;
_db.Entry(existingItem).State = EntityState.Modified;
_db.SaveChanges();
jsonResponseText = JsonConvert.SerializeObject(existingItem);
}
else
{
//new choice
_db.AnswersQuestions.Add(answerquestion);
_db.SaveChanges();
jsonResponseText = JsonConvert.SerializeObject(answerquestion);
}
}
else
{
jsonResponseText =
"{\"status\":0,\"error\":\"Model is not valid\",\"message\":\"Model is not valid\"}";
}
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(jsonResponseText, Encoding.UTF8, "application/json");
return(response);
}
catch (Exception ex)
{
jsonResponseText =
"{\"status\":0,\"error\":\"Error trying to create the new answerQuestion\",\"message\":\"" +
ex.Message + "\"}";
var response = Request.CreateResponse(HttpStatusCode.InternalServerError);
response.Content = new StringContent(jsonResponseText, Encoding.UTF8, "application/json");
return(response);
}
}
public HttpResponseMessage DeleteAnswerQuestion([FromBody] AnswersQuestion answerquestion)
{
var jsonResponseText = "";
try
{
if (ModelState.IsValid)
{
var existingItem = _db.AnswersQuestions
.FirstOrDefault(x => x.QuestionID == answerquestion.QuestionID &&
x.AnswerID == answerquestion.AnswerID);
if (existingItem != null)
{
_db.AnswersQuestions.Remove(existingItem);
_db.SaveChanges();
jsonResponseText = "{\"status\":1,\"message\":\"Item deleted successfully\"}";
}
}
else
{
jsonResponseText =
"{\"status\":0,\"error\":\"Model is not valid\",\"message\":\"Model is not valid\"}";
}
var response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(jsonResponseText, Encoding.UTF8, "application/json");
return(response);
}
catch (Exception ex)
{
jsonResponseText =
"{\"status\":0,\"error\":\"Error trying to create the new answerQuestion\",\"message\":\"" +
ex.Message + "\"}";
var response = Request.CreateResponse(HttpStatusCode.InternalServerError);
response.Content = new StringContent(jsonResponseText, Encoding.UTF8, "application/json");
return(response);
}
}
