Beispiel #1
0
        public GetAllGeneralFees GetAllGeneralFees(int yearlyMaintenanceId)
        {
            IEnumerable <GetGeneralFeesResponse> data;
            GetAllGeneralFees getAllGeneralFees = new GetAllGeneralFees();

            data = (from yearlyFee in _ObjContext.YearlyMaintainenceFee
                    where yearlyFee.IsDeleted == false &&
                    yearlyFee.YearlyMaintainenceId == yearlyMaintenanceId &&
                    yearlyFee.FeeType == "GeneralFee"
                    select new GetGeneralFeesResponse
            {
                YearlyMaintenanceFeeId = yearlyFee.YearlyMaintainenceFeeId,
                FeeType = yearlyFee.FeeName,
                TimeFrame = yearlyFee.TimeFrame,
                Amount = yearlyFee.Amount,
                Active = yearlyFee.IsActive
            });
            if (data.Count() != 0)
            {
                getAllGeneralFees.getGeneralFeesResponses = data.ToList();
            }
            return(getAllGeneralFees);
        }
Beispiel #2
0
        public GetAllGeneralFees GetAllGeneralFees(int yearlyMaintenanceId)
        {
            IEnumerable <GetGeneralFees> data;
            List <GetGeneralFees>        getGeneralFees    = new List <GetGeneralFees>();
            GetAllGeneralFees            getAllGeneralFees = new GetAllGeneralFees();

            int adCategoryId = GetCategoryId("FeeType");

            data = (from yearlyFee in _ObjContext.YearlyMaintainenceFee
                    join feeType in _ObjContext.GlobalCodes on yearlyFee.FeeTypeId equals feeType.GlobalCodeId
                    where yearlyFee.IsActive == true && yearlyFee.IsDeleted == false &&
                    yearlyFee.YearlyMaintainenceId == yearlyMaintenanceId &&
                    feeType.CategoryId == adCategoryId
                    select new GetGeneralFees
            {
                YearlyMaintenanceFeeId = yearlyFee.YearlyMaintainenceFeeId,
                FeeTypeId = feeType.GlobalCodeId,
                FeeType = feeType.CodeName,
                PreEntryFee = yearlyFee.PreEntryFee,
                PostEntryFee = yearlyFee.PostEntryFee,
                Amount = yearlyFee.Amount,
                Active = yearlyFee.IsActive
            });
            if (data.Count() != 0)
            {
                getGeneralFees = data.ToList();
                List <GetGeneralFeesResponse> getAllGeneral = new List <GetGeneralFeesResponse>();
                for (int i = 0; i <= getGeneralFees.Count() - 1; i++)
                {
                    GetGeneralFeesResponse getGeneralFeesResponse;

                    if (getGeneralFees[i].PreEntryFee != 0)
                    {
                        getGeneralFeesResponse = new GetGeneralFeesResponse();
                        getGeneralFeesResponse.YearlyMaintenanceFeeId = getGeneralFees[i].YearlyMaintenanceFeeId;
                        getGeneralFeesResponse.TimeFrame = "Pre";
                        getGeneralFeesResponse.FeeTypeId = getGeneralFees[i].FeeTypeId;
                        getGeneralFeesResponse.FeeType   = getGeneralFees[i].FeeType;
                        getGeneralFeesResponse.Amount    = getGeneralFees[i].PreEntryFee;
                        getGeneralFeesResponse.Active    = getGeneralFees[i].Active;
                        getAllGeneral.Add(getGeneralFeesResponse);
                    }
                    if (getGeneralFees[i].PostEntryFee != 0)
                    {
                        getGeneralFeesResponse = new GetGeneralFeesResponse();
                        getGeneralFeesResponse.YearlyMaintenanceFeeId = getGeneralFees[i].YearlyMaintenanceFeeId;
                        getGeneralFeesResponse.TimeFrame = "Post";
                        getGeneralFeesResponse.FeeTypeId = getGeneralFees[i].FeeTypeId;
                        getGeneralFeesResponse.FeeType   = getGeneralFees[i].FeeType;
                        getGeneralFeesResponse.Amount    = getGeneralFees[i].PostEntryFee;
                        getGeneralFeesResponse.Active    = getGeneralFees[i].Active;
                        getAllGeneral.Add(getGeneralFeesResponse);
                    }

                    if (getGeneralFees[i].PreEntryFee == 0 && getGeneralFees[i].PostEntryFee == 0)
                    {
                        if (getGeneralFees[i].Amount != 0)
                        {
                            getGeneralFeesResponse = new GetGeneralFeesResponse();
                            getGeneralFeesResponse.YearlyMaintenanceFeeId = getGeneralFees[i].YearlyMaintenanceFeeId;
                            getGeneralFeesResponse.TimeFrame = "";
                            getGeneralFeesResponse.FeeTypeId = getGeneralFees[i].FeeTypeId;
                            getGeneralFeesResponse.FeeType   = getGeneralFees[i].FeeType;
                            getGeneralFeesResponse.Amount    = getGeneralFees[i].Amount;
                            getGeneralFeesResponse.Active    = getGeneralFees[i].Active;
                            getAllGeneral.Add(getGeneralFeesResponse);
                        }
                    }
                }
                getAllGeneralFees.getGeneralFeesResponses = getAllGeneral;
            }
            return(getAllGeneralFees);
        }