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