public void TestWhereEntity()
        {
            var subPaymentHTs = SubPaymentHTs
                                .Where(w => w.GROUP_REQUEST_NO == "999999560900000001" &&
                                       (w.STATUS != null && w.STATUS == "P"));

            Assert.AreEqual(subPaymentHTs.Count(), 2);
        }
        private IEnumerable <AG_IAS_SUBPAYMENT_H_T> GetSubPaymentHead(AG_IAS_PAYMENT_G_T paymentGT)
        {
            IEnumerable <AG_IAS_SUBPAYMENT_H_T> subPaymentHTs = SubPaymentHTs
                                                                .Where(w => w.GROUP_REQUEST_NO == paymentGT.GROUP_REQUEST_NO &&
                                                                       (w.STATUS != null && w.STATUS == "P") &&
                                                                       (
                                                                           w.PETITION_TYPE_CODE == "11" ||
                                                                           w.PETITION_TYPE_CODE == "13" ||
                                                                           w.PETITION_TYPE_CODE == "14" ||
                                                                           w.PETITION_TYPE_CODE == "15" ||
                                                                           w.PETITION_TYPE_CODE == "16" ||
                                                                           w.PETITION_TYPE_CODE == "17" ||
                                                                           w.PETITION_TYPE_CODE == "18"
                                                                       )
                                                                       ).ToList();

            return(subPaymentHTs);
        }