Example #1
0
        /// <summary>
        /// FetchTAnswer2Question
        /// </summary>
        /// <param name="hseQuestionId"></param>
        /// <param name="hseAnswerItemId"></param>
        /// <param name="curDate"></param>
        /// <param name="entryDataNationalId"></param>
        /// <returns></returns>
        public static IList <Answer2QuestionClass> FetchTAnswer2Question(int hseQuestionId, int hseAnswerItemId, string curDate, string entryDataNationalId)
        {
            IList <Answer2QuestionClass> answer2QuestionClasses = null;
            var predicateTAnswer2Question = PredicateBuilder.True <TAnswer2Question>();
            IGenericRepository <TAnswer2Question, Answer2QuestionClass> TAnswerItemRepository = new ObjectClass.TAnswer2QuestionRepository();

            if (hseQuestionId != 0)
            {
                predicateTAnswer2Question = predicateTAnswer2Question.And(c => c.HSE_QuestionId == hseQuestionId);
            }

            if (hseAnswerItemId != 0)
            {
                predicateTAnswer2Question = predicateTAnswer2Question.And(c => c.HSE_AnswerItemId == hseAnswerItemId);
            }

            if (curDate != "")
            {
                predicateTAnswer2Question = predicateTAnswer2Question.And(c => c.EntryDataDate == curDate);
            }

            if (entryDataNationalId != "")
            {
                predicateTAnswer2Question = predicateTAnswer2Question.And(c => c.EntryDataNationalId == entryDataNationalId);
            }

            answer2QuestionClasses = TAnswerItemRepository.FindBy(predicateTAnswer2Question, true).Item2.ToList();

            return(answer2QuestionClasses);
        }
Example #2
0
        /// <summary>
        ///
        /// </summary>
        /// <param name="hseQuestionId"></param>
        /// <param name="hseAnswerItemId"></param>
        /// <param name="curDate"></param>
        /// <param name="curTime"></param>
        /// <param name="entryDataNationalId"></param>
        /// <returns></returns>
        public static short SaveTTAnswer2Question(int[] hseQuestionId, int[] hseAnswerItemId, string curDate, string curTime, string entryDataNationalId)
        {
            IGenericRepository <TAnswer2Question, Answer2QuestionClass> TAnswerItemRepository = new ObjectClass.TAnswer2QuestionRepository();
            TAnswer2Question tAnswer2Question;
            int   ind;
            short flag = 0;

            for (ind = 0; ind < hseQuestionId.Length; ind++)
            {
                tAnswer2Question = new TAnswer2Question();
                tAnswer2Question.HSE_AnswerItemId    = hseAnswerItemId[ind];
                tAnswer2Question.HSE_QuestionId      = hseQuestionId[ind];
                tAnswer2Question.EntryDataDate       = curDate;
                tAnswer2Question.EntryDataTime       = curTime;
                tAnswer2Question.EntryDataNationalId = entryDataNationalId;


                TAnswerItemRepository.Add(tAnswer2Question);
            }

            TAnswerItemRepository.Save();
            flag = 1;
            return(flag);
        }