public LoanPeriodicSchedule[] GetLoanPeriodicScheduleDistinctRefNo()
        {
            return(ExecuteFaultHandledOperation(() =>
            {
                var groupNames = new List <string>()
                {
                    GROUP_ADMINISTRATOR, GROUP_USER
                };
                AllowAccessToOperation(SOLUTION_NAME, groupNames);

                ILoanPeriodicScheduleRepository loanPeriodicScheduleRepository = _DataRepositoryFactory.GetDataRepository <ILoanPeriodicScheduleRepository>();

                IEnumerable <LoanPeriodicSchedule> loanPeriodicSchedules = loanPeriodicScheduleRepository.Get().ToArray();

                return loanPeriodicSchedules.ToArray();
            }));
        }
        public LoanPeriodicSchedule[] GetLoanPeriodicSchedulebyRefNo(string refNo)
        {
            return(ExecuteFaultHandledOperation(() =>
            {
                var groupNames = new List <string>()
                {
                    GROUP_ADMINISTRATOR, GROUP_USER
                };
                AllowAccessToOperation(SOLUTION_NAME, groupNames);

                ILoanPeriodicScheduleRepository loanPeriodicScheduleMapRepository = _DataRepositoryFactory.GetDataRepository <ILoanPeriodicScheduleRepository>();

                LoanPeriodicSchedule[] loanPeriodicScheduleEntity = loanPeriodicScheduleMapRepository.Get().Where(c => c.RefNo == refNo).OrderBy(c => c.Num_Pmt).ToArray();
                if (loanPeriodicScheduleEntity == null)
                {
                    NotFoundException ex = new NotFoundException(string.Format("LoanPeriodicSchedule with ID of {0} is not in database", refNo));
                    throw new FaultException <NotFoundException>(ex, ex.Message);
                }

                return loanPeriodicScheduleEntity;
            }));
        }