public List <Answer_Components_Exploded_ForJSON> GetOverrideQuestions(int assessmentId, int question_id, int Component_Symbol_Id) { List <Answer_Components_Exploded_ForJSON> rlist = new List <Answer_Components_Exploded_ForJSON>(); using (CSET_Context context = new CSET_Context()) { List <usp_getExplodedComponent> questionlist = null; context.LoadStoredProc("[dbo].[usp_getExplodedComponent]") .WithSqlParam("assessment_id", _assessmentId) .ExecuteStoredProc((handler) => { questionlist = handler.ReadToList <usp_getExplodedComponent>().Where(c => c.Question_Id == question_id && c.Component_Symbol_Id == Component_Symbol_Id).ToList(); }); IQueryable <Answer_Components> answeredQuestionList = context.Answer_Components.Where(a => a.Assessment_Id == assessmentId && a.Question_Or_Requirement_Id == question_id); foreach (var question in questionlist.ToList()) { Answer_Components_Exploded_ForJSON tmp = null; tmp = TinyMapper.Map <Answer_Components_Exploded_ForJSON>(question); tmp.Component_GUID = question.Component_GUID.ToString(); rlist.Add(tmp); } return(rlist); } }
public List <Answer_Components_Exploded_ForJSON> GetOverrideQuestions(int assessmentId, int question_id, int Component_Symbol_Id) { List <Answer_Components_Exploded_ForJSON> rlist = new List <Answer_Components_Exploded_ForJSON>(); using (CSET_Context context = new CSET_Context()) { IQueryable <Answer_Components_Exploded> questionlist = from a in context.Answer_Components_Exploded where a.Assessment_Id == assessmentId && a.Question_Id == question_id && a.Component_Symbol_Id == Component_Symbol_Id select a; IQueryable <Answer_Components> answeredQuestionList = context.Answer_Components.Where(a => a.Assessment_Id == assessmentId && a.Question_Or_Requirement_Id == question_id); foreach (var question in questionlist.ToList()) { Answer_Components_Exploded_ForJSON tmp = null; tmp = TinyMapper.Map <Answer_Components_Exploded_ForJSON>(question); tmp.Component_GUID = question.Component_GUID.ToString(); rlist.Add(tmp); } return(rlist); } }