public async Task <IHttpActionResult> PutForAnswerQuestions(List <object> list)
{
Questionare_question_form q = new Questionare_question_form();
q.suggestion = JObject.Parse(list.Last().ToString())["suggestion"].ToString();
//add answer for each question to pre-last item (pre-last item is suggestion)
foreach (JObject item in list)
{
if (item == list.Last())
{
break;
}
q.question_list.Add(new Questionare_question_answer
{
questionare_set_id = Convert.ToInt32(item["questionare_set_id"]),
questionare_question_id = Convert.ToInt32(item["questionare_question_id"]),
answer = Convert.ToInt32(item["answer"])
});
}
object result = await datacontext.InsertQuestionAnswer(q);
if (result == null)
{
return(Ok());
}
else
{
return(BadRequest(result.ToString()));
}
}
public async Task <object> InsertQuestionAnswer(Questionare_question_form qdata)
{
DBConnector d = new DBConnector();
if (!d.SQLConnect())
{
return(WebApiApplication.CONNECTDBERRSTRING);
}
string insertintoquestionareresobj = string.Format("insert into {0} values ", Questionare_result_obj.FieldName.TABLE_NAME);
foreach (Questionare_question_answer item in qdata.question_list)
{
insertintoquestionareresobj += string.Format("({0},{1})", item.questionare_question_id, item.answer);
if (item != qdata.question_list.Last())
{
insertintoquestionareresobj += ",";
}
}
string insertintoquestionareressub = string.Format("insert into {0} values ({1},'{2}')",
Questionare_result_sub.FieldName.TABLE_NAME, qdata.question_list.First().questionare_set_id,
qdata.suggestion);
string truecasecmd = string.Format("BEGIN {0} {1} END", insertintoquestionareresobj, insertintoquestionareressub);
d.iCommand.CommandText = string.Format("if exists (select * from {0} where {1} = {2}) {3} else return ",
Questionare_set.FieldName.TABLE_NAME, Questionare_set.FieldName.QUESTIONARE_SET_ID, qdata.question_list.First().questionare_set_id,
truecasecmd);
try
{
int rowaffacted = await d.iCommand.ExecuteNonQueryAsync();
if (rowaffacted > 0)
{
return(null);
}
else
{
return("แบบสอบถามนี้ถูกลบแล้ว");
}
}
catch (Exception ex)
{
//Handle error from sql execution
return(ex.Message);
}
finally
{
//Whether it success or not it must close connection in order to end block
d.SQLDisconnect();
}
}
