public string Questions(int id)
{
FormModuleContext ctx = new FormModuleContext();
List <db.Entities.FormQuestionMetadata> questions = ctx.form_questions.Where(x => x.form_metadata_id == id).ToList();
if (questions == null)
{
throw new ArgumentException("Form Questions not found!");
}
var json = JsonConvert.SerializeObject(questions);
return(json);
}
public string Form(int id)
{
FormModuleContext ctx = new FormModuleContext();
var result = ctx.forms.Where(x => x.id == id).FirstOrDefault();
result.answers = ctx.form_answers.Where(x => x.form_id == result.id).ToList();
result.form_metadata = ctx.form_metadatas.Where(x => x.id == result.form_metadata_id).FirstOrDefault();
result.form_metadata.questions = ctx.form_questions.Where(x => x.form_metadata_id == result.form_metadata_id).ToList();
if (result != null)
{
return(JsonConvert.SerializeObject(result));
}
else
{
throw new ArgumentException("Form not found!");
}
}
public string Form(List<FormAnswer> answers)
{
FormModuleContext ctx = new FormModuleContext();
if(answers != null && answers.Count > 0)
{
Form form = new Form();
form.id = answers[0].form_id;
var q_id = answers[0].form_question_metadata_id;
var q = ctx.form_questions.Where(x => x.id == q_id ).FirstOrDefault();
form.form_metadata_id = q.form_metadata_id;
form.answers = answers;
ctx.forms.Add(form);
ctx.SaveChanges();
return "{ \"form_id\" : " + form.id.ToString() + " }";
}
return null;
}
public string Form(List <FormAnswer> answers)
{
FormModuleContext ctx = new FormModuleContext();
if (answers != null && answers.Count > 0)
{
Form form = new Form();
form.id = answers[0].form_id;
var q_id = answers[0].form_question_metadata_id;
var q = ctx.form_questions.Where(x => x.id == q_id).FirstOrDefault();
form.form_metadata_id = q.form_metadata_id;
form.answers = answers;
ctx.forms.Add(form);
ctx.SaveChanges();
return("{ \"form_id\" : " + form.id.ToString() + " }");
}
return(null);
}
public string Form(int id)
{
FormModuleContext ctx = new FormModuleContext();
var result = ctx.forms.Where(x => x.id == id).FirstOrDefault();
result.answers = ctx.form_answers.Where(x => x.form_id == result.id).ToList();
result.form_metadata = ctx.form_metadatas.Where(x => x.id == result.form_metadata_id).FirstOrDefault();
result.form_metadata.questions = ctx.form_questions.Where(x => x.form_metadata_id == result.form_metadata_id).ToList();
if(result != null)
{
return JsonConvert.SerializeObject(result);
}
else
{
throw new ArgumentException("Form not found!");
}
}
public string Questions(int id)
{
FormModuleContext ctx = new FormModuleContext();
List<db.Entities.FormQuestionMetadata> questions = ctx.form_questions.Where(x => x.form_metadata_id == id).ToList();
if(questions == null)
{
throw new ArgumentException("Form Questions not found!");
}
var json = JsonConvert.SerializeObject(questions);
return json;
}
