public bool Get(ReceiptRequestModel receipt)
        {
            bool response;

            response = premiumRepository.Get(receipt);

            return(response);
        }
        public bool Get(ReceiptRequestModel receipt)
        {
            bool response = false;

            try
            {
                using (var imisContext = new ImisDB())
                {
                    var districtId = (from F in imisContext.TblFamilies
                                      join I in imisContext.TblInsuree on F.InsureeId equals I.InsureeId
                                      join V in imisContext.TblVillages on F.LocationId equals V.VillageId
                                      join W in imisContext.TblWards on V.WardId equals W.WardId
                                      join D in imisContext.TblDistricts on W.DistrictId equals D.DistrictId
                                      where (F.ValidityTo == null &&
                                             I.ValidityTo == null &&
                                             I.Chfid == receipt.CHFID)
                                      select D.DistrictId)
                                     .FirstOrDefault();

                    int?premiumId = (from PR in imisContext.TblPremium
                                     join PL in imisContext.TblPolicy on PR.PolicyId equals PL.PolicyId
                                     join F in imisContext.TblFamilies on PL.FamilyId equals F.FamilyId
                                     join I in imisContext.TblInsuree on F.InsureeId equals I.InsureeId
                                     join V in imisContext.TblVillages on F.LocationId equals V.VillageId
                                     join W in imisContext.TblWards on V.WardId equals W.WardId
                                     join D in imisContext.TblDistricts on W.DistrictId equals D.DistrictId
                                     where (PR.ValidityTo == null &&
                                            PL.ValidityTo == null &&
                                            F.ValidityTo == null &&
                                            I.ValidityTo == null &&
                                            D.ValidityTo == null &&
                                            PR.Receipt == receipt.ReceiptNo &&
                                            D.DistrictId == districtId)
                                     select PR.PremiumId)
                                    .FirstOrDefault();

                    if (premiumId == 0)
                    {
                        response = true;
                    }
                }

                return(response);
            }
            catch (SqlException e)
            {
                throw e;
            }
            catch (Exception e)
            {
                throw e;
            }
        }
        public IActionResult Get([FromBody] ReceiptRequestModel receipt)
        {
            bool response;

            try
            {
                response = _imisModules.GetPremiumModule().GetPremiumLogic().Get(receipt);
            }
            catch (ValidationException e)
            {
                return(BadRequest(new { error = new { message = e.Message, value = e.Value } }));
            }

            return(Ok(response));
        }
Beispiel #4
0
        public IActionResult Get([FromBody] ReceiptRequestModel receipt)
        {
            bool response;

            try
            {
                response = _imisModules.GetPremiumModule().GetPremiumLogic().Get(receipt);
            }
            catch (ValidationException e)
            {
                throw new BusinessException(e.Message);
            }

            return(Ok(response));
        }